Help asp sql

[barryrstanton]

Hay Ho
trying to access a record in sql table, can get all records using select statement but trying to search for a perticular record using select where, this cause page to fail to load.
Example1- mystr="select* from bla bla" no problems
Example2- mystr="select * from blabla where boho='somthing'" this fails!
Any help would be cooooool.
Barry

[djr33]

Then apparently it doesn't match.

`` around the column might help:

WHERE `column`='value'

[mini_minh]

i'm doing the same thing but it works for me...
maybe u have conflicting data types...
eg boho might have data type int
and ur trying to search for a char?