you want to do a loop IN the stored procedure? or call a stored proc multiple times within a CFLoop?
If the latter, then yes, it's possible. If the previous, then yes, you can do loops, but the routines are a little different, and if you are looping over a recordset, then you need a cursor. As for your error, I see this one all the time... it has nothing to do with loops - it's a problem with the parameter's you've passed to the stored proc (an empty string maybe, or a string that is 1000 characters where the field can only handle 10 chars). You need to dump the values you are passing to the stored proc and make sure they're correct. Hope this helps. Shawn Grover -----Original Message----- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 1:21 PM To: CF-Talk Subject: stored procedure with cfloop? Is it possible to do a stored procedrue with a cfloop? I'm moving over queries to sp and have an update one that uses a cfloop. I tried setting it up and got the error "ODBC Error Code = 22001 (String data right truncation) [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated." Thanks, j ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists