Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]Syntax error converting the varchar value '1,2,3 ' to a column of data type tinyint.
It works in a SQL statment but I can pass it to a store procedure
DK
>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]
