Hello,
Im pretty novice when it comes to asp and even php, sql.
However I have figured out alot in a few weeks with no help at all.
I have a slight problem with my databse and searching it..
My database consists of dog name "CH somones dog of whatever"
and some names have an apostrophe in it like "har-vel's josh's gold"
you can search the name har-vel but thats about as far as you can get without getting the notorious
Error: -2147217900
[Microsoft][ODBC Microsoft Access Driver] Syntax error in query expression '1=0 or [RegCntry] like '%'%' or [Ptitle] like '%'%' or [Dname] like '%'%' or [Potitle] like '%'%' or [Reg] like '%'%' or [Sire] like '%'%' or [Dam] like '%'%' or [Color] like '%'%' or [Sex] like '%'%' or [Dob] like '%'%' or [Callname] like '%'%' or [Owner] l'.
How would I make the program accept the apostrophe in the search query box?
"I think I will get shot on this one"
My asp experiance is limited to 1 week.
