cannot get where clause to work
From: David McDivitt (x12code_at_yahoo.com)
Date: 10/01/03
- Next message: David McDivitt: "cannot get where clause to work"
- Previous message: Ron Savage: "Re: Q: Any module implementing vendor-independent 'create table...'?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Tue, 30 Sep 2003 18:33:24 -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: David McDivitt: "cannot get where clause to work"
- Previous message: Ron Savage: "Re: Q: Any module implementing vendor-independent 'create table...'?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
