[Phplib-users] ODBC wildcard vs. sql wildcard
Brought to you by:
nhruby,
richardarcher
From: <at...@ne...> - 2002-08-13 19:56:08
|
Okay, so I'm using phplib in conjunction with ms access (through ODBC) and I want to be able to query the database using the "LIKE". For example ... BugIDs LIKE '%7%'; The problem is, for ms access, the wildcard character is *, not %. So I used ...BugIDs LIKE '*7*'; Even though this query works in the database itself, the results are not displayed on the web... Is there a way for me to use the wildcard and be able to perform the requred search? $t = new Table; $t -> heading = "on"; $t->show_results($db); What am I missing? |