Try putting a semicolon at the end of your SQL statements.
Though MS Access shouldn't really care.
On Fri, 28 Apr 2000, S R wrote:
> Here is what I am trying to do:
>
> <cfquery datasource="synergy" name="TakeID">
> SELECT id, busunit FROM BusinessUnit
> </cfquery>
>
>
>
> <cfloop index="i" from="1" to="#TakeID.RecordCount#">
>
>
> <cfquery datasource="synergy" name="TakeID">
> SELECT id, busunit FROM BusinessUnit
> </cfquery>
>
>
> <cfquery datasource="synergy" name="InsertStuff">
> INSERT INTO USAmw(BID)
> VALUES(#TakeID.ID#)
> WHERE Company = '#TakeID.Busunit#'
> </cfquery>
>
>
> </cfloop>
>
> I keep getting this error message which doesn't make any sense:
>
> ODBC Error Code = 37000 (Syntax error or access violation)
>
> [Microsoft][ODBC Microsoft Access Driver] Missing semicolon (;) at end of
> SQL statement.
>
>
> ________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
> ------------------------------------------------------------------------------
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
>message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
>
Tariq Ahmed - [EMAIL PROTECTED] - ICQ 6308515
TIBCO Finance Technology - Web Group - Senior Web Engineer
Work: 650-461-3472 Pager: 800-759-8888x1702632 Fax: 650-461-3003
3375 Hillview Avenue. Palo Alto, CA. 94304.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
