What?? what about cursors? This seems pretty easy in SQL if you ask me. -----Original Message----- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 26, 2003 4:08 PM To: CF-Talk Subject: Re: OT: SQL help
Michael Hodgdon wrote: > > Before I begin, I know this is simple and remedial in CF, but I specifically > want a SQL solution (if necessary, it can be a Transact SQL solution) > > Basically, I want to loop over a query using SQL syntax just like you would > loop over a query using <CFQUERY> or <CFLOOP QUERY> tags. That is it. > Looking for the same functionality using SQL instead of CF. > > I want to embed this functionality in a SQL script, but all the solutions I > have tried report that the request has returned more than one possible match > and errors out. Basically, SQL is treating the select as a whole object > verses looking at each row one at a time. You can't do it in SQL. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com