Gracias! That was the lynch-pin. Then I found the problem with my script. I had "DECLARE co_cursor FOR..." instead of "DECLARE co_cursor CURSOR FOR..."
-----Original Message----- From: webguy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 27, 2002 9:53 AM To: CF-Talk Subject: RE: T-SQL Change all the double-quotes to single quotes.. Silly books on line .... WG > -----Original Message----- > From: Luce, Greg [mailto:[EMAIL PROTECTED]] > Sent: 27 November 2002 14:39 > To: CF-Talk > Subject: OT: T-SQL > > > I'm trying to learn to run T-SQL scripts in Query Analyzer like I can with > Oracle in SQL Plus. In the Books Online I found a nice example of a cursor > loop running a report against the pubs db. I paste this script into Query > Analyzer and hit go and get 5 different errors. Here's the script, you can > find it in books online with keyword "cursors, Transact-SQL": http://www.fusionauthority.com/ads.cfm ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
