View Full Version : Help asp sql

05-13-2007, 04:33 PM
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.

05-13-2007, 05:07 PM
Then apparently it doesn't match.

`` around the column might help:

WHERE `column`='value'

05-20-2007, 12:49 PM
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?