I've been putting one SQL statement after another like the following inside
a CFQUERY for a while. Seems to work fine.
UPDATE MAX_ID_Clients SET MAX_ID_Client = MAX_ID_Client + 1
DECLARE @MAX INT
SELECT @MAX = MAX_ID_Client FROM MAX_ID_Clients
INSERT INTO ClientData(CFID,CFTOKEN)
VALUES(@MAX,#CFT#)
Is this a known feature?
Is there a limit to how many SQL statements can be combined this way?
I assume the above is equivalent to a CFTRANSACTION. Is this so?
best, paul
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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