IF EXISTS( SELECT *
FROM MSysObjects
WHERE ParentID = ( SELECT Id
FROM MSysObjects
WHERE Name = 'productID')
AND Name = '#CFTOKEN#')
ELSE( CREATE TABLE #CFTOKEN# (
productID number,
productQty number);)
Jon,
The IF...ELSE syntax is T-SQL, i.e. what you'd use if you did it in a stored
proc. If you're doing it in CFML, you have to do the 2 SQL statements as 2
separate queries. Do a <CFIF> to test the rowcount on the SELECT query
rather
than saying IF EXISTS.
Nick
**********************************************************************
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system.
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone.
Thank you for your co-operation.
**********************************************************************
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
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.
