hey guys, in the WHERE part of my stored procedure in the SQL 7 database, it
has something like a.friendID IN (@funnyID)
@funnyID is declared as a varchar in the procedure. in coldfusion, the
value is passed as a Quoted value list, like '54','56','53' and so on. the
problem is, i get this SQL error when i run the coldfusion template
Syntax error converting the varchar value '181', '182', '183', '217' to a
column of data type int. why does it need to convert them to int?
i mean if the SQL was done right o the coldfusion template, then that would
be fine. why is it different now that its in the stored procedure?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
