I am not up on my MS Access database sql but i would check to see if ms access supports the like condition in the where clause...
On Tue, 2002-11-05 at 18:49, Don Hicks wrote: > I'm writing an SQL query in a php 4.0 script. The query pulls data from an > MS Access '97 database through an ODBC connection. > > I'm having difficulties creating a condition using "LIKE". > > If I write the following expression, the query works: > > $Query=" > SELECT FieldName1, FieldName2 > FROM TableName > WHERE FieldName1 = '$CriterionRecord' > "; > > But, if I change the Where statement from "=" to "LIKE", the query no longer > works, and I can't figure out why. (Could it be punctuation?) Here's an > example: > > $Query=" > SELECT FieldName1, FieldName2 > FROM TableName > WHERE FieldName1 LIKE '$CriterionRecord' > "; > > The criterion record is actually chosen in another form and passed through > to this script. The criterion record may be a complete record, or it may be > a partial record with a wildcard, but the "LIKE" script is not working in > either case. > > Does anyone have any experience with this they could share with me? > > Sincerely, > Don Hicks > Portland, OR > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- .: B i g D o g :. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
