Software Venture Consulting
ToMarket

FileMaker Pro downloads & Resources
FileMaker Custom Functions
FileMaker Web Viewer Examples
FileMaker Pro & Lasso Consulting
Training
FileMaker Books
FileMaker Articles
FileMaker Error Reference

Free Web Tools
Free FileMaker Tools

Personal Pages
Videos
Adventures
Links

Shopping Cart
Shopping Cart

Search:

Free Newsletter
Signup


Contact


Privacy Policy



FileMaker is a registered trademark of FileMaker, Inc. in the U.S. and other countries.

 Reference: MySQL Error 1110

Definition of Error 1110: SQLSTATE: 42000 (ER_FIELD_SPECIFIED_TWICE) Column '%s' specified twice

FileMaker Error Codes

Lasso Error Codes

MySQL Error Codes

Windows System Errors

digg this | del.icio.us this

SURVEY: Which web technology do you prefer?

PHP         Cold Fusion
JSP         J2EE
ASP/.Net         Other
Lasso          

View the results


Zipwise Zip Code Database

Download the entire US zip code database with latitude and longitude. Click here.

About this database
This is a free public resource. It is unmoderated and operates on the "public virtue" system. I hope you find it useful!

User Contributed Notes

2010-08-23 07:15:20
Themba Tjnas Ngobeni Themba.Ngobeni@gmail.com
ExBSol Technologies

The error usually caused by a SQL statement/Dynamic Sql statement that specifies a column name twice and try to create a table or view and no unique alias is identified e.g create Table Themba.ThembaTemp as Select field1,field2,field3,field1 from Themba.temp;

correct:
create Table Themba.ThembaTemp as Select field1 as 'Themba',field2,field3,field1 as 'Themba2' from Themba.temp;

This is my note and I want to edit it | Report an inappropriate comment

+ Add your own note

 

 

Click here for PHP/MySQL consulting services