>>string, and using it as the comma seperated list
>>in an IN clause
no, you have to go to dynamic sql strings for an in clause.
http://www.sqlteam.com/item.asp?ItemID=4599 (follow to part ii, i think it had more)
though, the author came up with another approach here:
http://sqlteam.com/item.asp?ItemID=11499
-----Original Message-----
From: Thomas Chiverton
To: CF-Talk
Sent: 3/2/04 10:18 AM
Subject: Re: SQL Stored Proc
On Tuesday 02 Mar 2004 15:56 pm, Doug Kronenbergeer wrote:
> How do I pass a the string "1,2,3" so that it can be convert into the
> tinyint. Needless to sa DivisionID is a tinyint.
You can't convert something with comma's in to a number.
Having said that, your code should work, because your passing in a
string, and
using it as the comma seperated list in an IN clause - what error do you
get ?
--
Tom Chiverton
Advanced ColdFusion Programmer
Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 834900
Fax: +44 (0)1749 834901
web: www.bluefinger.com
Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple
Quay, BRISTOL. BS1 6EG.
*** This E-mail contains confidential information for the addressee
only. If you are not the intended recipient, please notify us
immediately. You should not use, disclose, distribute or copy this
communication if received in error. No binding contract will result from
this e-mail until such time as a written document is signed on behalf of
the company. BlueFinger Limited cannot accept responsibility for the
completeness or accuracy of this message as it has been transmitted over
public networks.***
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
