SQL Integer Problem

Message Share Topic Printable Version Google Delicious Digg StumbleUpon Windows Live Yahoo Bookmarks reddit Facebook MySpace Newsvine Furl Topic Search Topic Options Post Reply Create New Topic

   Have a problems with looking up a database;

Works with a txt lookup but when I try and use any  numbers (INT) i get the message:

Conversion failed when converting the varchar value "item_id" to data type Int

SQL :

Select * from stock where id =  '%item_id%'

Any help?

Author	Message Share Topic Printable Version Google Delicious Digg StumbleUpon Windows Live Yahoo Bookmarks reddit Facebook MySpace Newsvine Furl Topic Search Topic Options Post Reply Create New Topic
pearshaped Members Profile Send Private Message Find Members Posts Add to Buddy List New User Joined: 27 Nov 2011 Posts: 1	Post Options Post Reply Quote pearshaped Report Post Quote Reply Topic: SQL Integer Problem Posted: 27 Nov 2011 at 3:30pm
	Have a problems with looking up a database; Works with a txt lookup but when I try and use any numbers (INT) i get the message: Conversion failed when converting the varchar value "item_id" to data type Int SQL : Select * from stock where id = '%item_id%' Any help?

Stephen Members Profile Send Private Message Find Members Posts Visit Members Homepage Add to Buddy List Admin Group Joined: 21 Oct 2005 Location: Stoke on Trent Posts: 1389	Post Options Post Reply Quote Stephen Report Post Quote Reply Posted: 28 Nov 2011 at 8:52am
	If its a numeric field then you don't put the field in quotes. e.g.: SELECT * FROM stock WHERE id = %item_id% Steve