I've tried that in the past and gotten errors. Maybe it's just a Sybase
thing, but I had to eventually CFLOCK the whole transaction and put those
';' after each insert.
.Todd
----- Original Message -----
From: John N Westerlund <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 09, 2000 2:30 PM
Subject: Re: SQL insert question
> You can also do this
>
> <CFQUERY>
> INSERT INTO TABLE(THIS_FIELD) VALUES ('#FIELD1#')
> INSERT INTO TABLE(THIS_FIELD) VALUES ('#FIELD2#')
> INSERT INTO TABLE(THIS_FIELD) VALUES ('#FIELD3#')
> </CFQUERY>
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
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.
