🚀 go-pugleaf

In article <53adhb$5cu@news.NetVision.net.il>
yossik@accentsoft.com (Yossi Konijn) wrote:

> Hi,
> 
> I've been creating a PERL program that inputs and outputs 
information
> from an Access 7.0 database via ODBC. All my SQL queries worked
> perfectly up until the moment I tried using WHERE in the statement.
> This gives my an error message about missing parameters. However, 
the
> same query from within Acess works perfectly. Any idea?
> 
> The query is -
> 
> SELECT * FROM TSCustomers WHERE PhoneNumber1 = "4104842172";
                                                 ^^^^^^^^^^^^
You need to replace the double quotes with single quotes. Your query 
should look like:
  SELECT * FROM TSCustomers WHERE PhoneNumber1 = '4104842172'
If the value is a number (as opposed to a string) you may not even 
need the quotes; I can't remember.
dave