Works in Query Analyser but not in asp

i have asp page passes between 1 , 20 id's in string
asp page update triggered. string looks like:
10023567, 1000345, 90885543211
or 1 id like:
27736458

my update stored procedure is:

update bookings
set status = 'accepted'
where bookingid in (@id)

@id string mentioned above. if there 1 id in string
the update performed if there more 1 id "cannot convert
varchar int" error.

if take string contents , use them in query analyser eg.

update bookings
set status = 'accepted'
where bookingid in (10023567, 1000345, 90885543211)

it works fine , updates correct rows, why error when
attempting in asp page?

in situations these, use response.write() statement output
sql string page can see possible errors.

have tried that?

cheers,
rob
http://robgt.com/ [tutorials , extensions]
firebox stuff: http://robgt.com/firebox
skype stuff: http://robgt.com/skype
satnav stuff: http://robgt.com/satnav

More discussions in Develop server-side applications in Dreamweaver

adobe