I found my problem.
Access can't handle multiple database calls in a single cfquery connection
Changing:
<cfquery ....>
insert into x (...)
values (...)
insert into y (...)
values (...)
</cfquery>
To:
<cfquery ....>
insert into x (...)
values (...)
</cfquery>
<cfquery ....>
insert into y (...)
values (...)
</cfquery>
did the trick.
What don't understand is why though. I thought it was enhancements to the
ODBC drivers that enable multiple queries within a single query, not the db
engine itself.
This is what I get for designing in SQL Server and trying to port to Access.
Duane
-----Original Message-----
From: Kenneth Tyler [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 02, 2000 6:08 PM
To: [EMAIL PROTECTED]
Subject: Re: Query Error
> ideas what's up here?
>
> This is working in SQL server but using Access97 or 2000 I get the
following
> error.
>
> [Microsoft][ODBC Microsoft Access 97 Driver] Missing semicolon (;) at end
of
> SQL statement
Access puts a semicolon at the end of the SELECT as in:
SELECT * FROM myTable;
Kenneth Tyler, 8th Fold, Berkeley, CA, USA
----------------------------------------------------------------------------
--
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.
------------------------------------------------------------------------------
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.
