cannot get where clause to work
From: David McDivitt (x12code-del_at_del-yahoo.com)
Date: 10/01/03
- Next message: krakle: "Re: new to perl"
- Previous message: David McDivitt: "cannot get where clause to work"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Tue, 30 Sep 2003 18:37:02 -0500
I am fairly new to Perl and cannot get a where clause to work. I can get to
the database fine and create a recordset without a where clause OK. I am
using the latest version of ActivePerl on Win2000. I installed DBI and
DBD::ODBC last week with PPM. The database is MS SQL Server 7.
For debugging I am displaying the SQL statement before preparing it, and it
looks OK. I can take the exact statement displayed and paste into either MS
Access or Enterprise Manager and it works fine.
I tried several different things. The original version used LIKE, so I took
that out and used = with values I know are there. I tried double quotes
instead of single but that would not prepare. I tried qualifying all the
field names with the table name. I placed square brackets around everything.
I tried placing % (percent) inside the single quotes when using LIKE.
Nothing works. Moreover, I cannot find resolution doing a Google search.
Help would be appreciated. Thanks
- Next message: krakle: "Re: new to perl"
- Previous message: David McDivitt: "cannot get where clause to work"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
