you would need to provide the SELECT query that runs your drop down to get
an answer.
Meanwhile you can speed this up dramatically by doing this instead of the
code you have below:
<cfquery datasource="ITData">
UPDATE
tblApplications
set
InOut = 1
WHERE
appID IN (#form.appID#)
</cfquery>
Bryan Love ACP
Internet Application Developer
Telecommunication Systems Inc.
[EMAIL PROTECTED]
-----Original Message-----
From: Jones, Becky [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 29, 2001 11:38 AM
To: CF-Talk
Subject: subtracting quantity
i have a form for users to check out an application. most of my
applications are a quantity of 1, so once it is checked out, it will not
show up in the drop down list of apps to check out until it is checked back
in. (i automatically set the checkout field to be yes).
but for the few apps that have a quantity of greater than one, how can i
make it so that it still shows up in the list until every single one has
been checked out?
right now my code just does this for every app checked out regardless of the
quantity
<cfloop list="#form.appID#" index="a" delimiters=",">
<cfquery datasource="ITData">
UPDATE
tblApplications
set
InOut = 1
WHERE
appID = (#a#)
</cfquery>
</cfloop>
*************************************************
This e-mail, including any attachments, is intended for the
receipt and use by the intended addressee(s), and may contain
confidential and privileged information. If you are not an intended
recipient of this e-mail, you are hereby notified that any unauthorized
use or distribution of this e-mail is strictly prohibited.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
