> Can anyone show me what is wrong with this query? I know that I
> really should use another method to put this information into the
> database (triggers or sps come to mind) but I am using dbf files
> exported out of access on a unix box to prototype the app and
> they do not support these functions.
> Here is the error
>
> ODBC Error Code = 37000 (Syntax error or access violation)
>
> [MERANT][ODBC dBase driver]Missing VALUES keyword in INSERT statement
>
> SQL = "insert into HERDING, WORKING, TOY, TERRIER, SPORTING,
> NON_SPOR, HOUND (HERDING.SHOW_ID, WORKING.SHOW_ID,
> TOY.SHOW_ID, TERRIER.SHOW_ID, SPORTING.SHOW_ID,
> NON_SPOR.SHOW_ID, HOUND.SHOW_ID) values (14, 14, 14, 14, 14, 14, 14)"
How many tables are you trying to insert into???
It works like this;
INSERT INTO myTable (field1, field2, field3)
VALUES (value1, value2, value3)
Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real world"
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**********************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
