WHERE clause in recordset doesn't function

<i><b>Originally posted by : andrew (harrison@tiscalinet.it)</b></i><br />I don't want my users to search for products from a form using 'request.form'.In my case ,each category has its own page in which the select clause chooses only the records containing that product category:<br /><br /><%sql="select * from products where category like'%"&televisions&"%'"<br /><br />so as soon as the page is accessed from a simple link , the page should take only 'televisions' from the mdb.Right?<br />It doesn'tit takes everything from every category.<br />Why is this? Is the WHERE statement wrong?<br />HELP!!!!!!!!!!!!!!!!!!!!<br /><br />

<i><b>Originally posted by : </b></i><br /><br /><br /><br />------------<br />andrew at 3/26/2001 7:08:20 AM<br /><br />I don't want my users to search for products from a form using 'request.form'.In my case ,each category has its own page in which the select clause chooses only the records containing that product category:<br /><br /><%sql="select * from products where category like'%"&televisions&"%'"<br /><br />so as soon as the page is accessed from a simple link , the page should take only 'televisions' from the mdb.Right?<br />It doesn'tit takes everything from every category.<br />Why is this? Is the WHERE statement wrong?<br />HELP!!!!!!!!!!!!!!!!!!!!<br /><br />I was able to modify some asp code of mine to look for something like you are and had no problems. This may be a shot in the dark, but try adding some spaces like this:<br /><br />sql="select * from products where category like '%" & televisions & "%'"<br /><br /><br />