PDA

View Full Version : Help asp sql



barryrstanton
05-13-2007, 05: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.
Barry

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

`` around the column might help:

WHERE `column`='value'

mini_minh
05-20-2007, 01: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?