SQL Bother!!

[Anon]

Hi there,

Can anyone see anything wrong with this SQL statement:

$cur = odbc_exec( $cnx, "SELECT Name, Address, Zone, Category, Type, Description, Phone, Route, Review FROM Info where Name = \"$Outlet\"");

When I remove the:

where Name = \"$Outlet\"");

The call works ok.

I am geting this error message at the moment:

Warning: SQL error: [FileMaker][ODBC FileMaker Pro driver]Field not found: Alfredo , SQL state S0022 in SQLExecDirect in C:\Inetpub\wwwroot\CityMapper\ReqInfo.php on line 28

Any ideas what I am doing wrong

Cheers for your help

James

[twmcmahan]

try using single quotes (').

Tim
Pay For What You Use, Not What You Don't
http://www.tier1host.net

[frymaster]

try using single quotes around $Outlet