are you locking the insert statement?
Mark Smyth
Macromedia Certified ColdFusion Developer
Systems Union eBusiness Solutions
01865 880800
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
-----Original Message-----
From: Gilbert Midonnet [mailto:[EMAIL PROTECTED]]
Sent: 05 July 2001 15:20
To: CF-Talk
Subject: access not accepting insert statement
I'm using coldfusion and access (ODBC) and having a problem. When
multiple insert statements arrive at the same time only the first insert
statement is accepted. We don't have that many users on the system
(Intranet) so it doesn't make sense to migrate from access.
Is there a way of queuing the insert statements, or any other way of solving
this problem?
Gilbert Midonnet
BrokerTec USA, LLC
(201) 209-7843
----------------------------------------------------------------------------
----------------------------------------------------
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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists