thx for all the replies.
> are you locking the insert statement?
yes, apparantly (see error msg below)
> How can you be sure both insert statements are arriving at the
> same time and are correct in syntax?
ah, hmmm, ah, like ... hmmm...ah, I dunno :>
"damnit jim, I'm a designer, not a developer."
> What exactly happens to the second insert statement?
Nothing server side. By nothing I mean that it doesn't get recorded in the
db.
> Does it give an ODBC error or does it just not get inserted? (Should have
sent it with my first post)
The error msg is below
ODBC Error Code S1000 (General error)
ODBC driver could not update; "currently locked by user 'admin' on machine
'BTEC_NJIIS'
"The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (50:4) to (50:62)....
-- glm
----------------------------------------------------------------------------
----------------------------------------------------
This message is for the named person's use only. It may contain
confidential, proprietary or legally
privileged information. No confidentiality or privilege is waived or lost by
any mistransmission. If
you receive this message in error, please immediately delete it and all
copies of it from your
system, destroy any hard copies of it and notify the sender. You must not,
directly or indirectly,
use, disclose, distribute, print, or copy any part of this message if you
are not the intended
recipient.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
