Ok... comment out the EXEC statement and change it to PRINT @DynSQL. Then
call this SP from QueryAnalyzer and see if the query looks correct.
-Nate
-----Original Message-----
From: Fuon See Tu [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 30, 2001 6:30 PM
To: CF-Talk
Subject: RE: Stored Procedure
ive tested it, and it doesnt work. it seems that it is loking at the commas
too!!!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
