If you're just getting started, I would suggest validating the SQL in Access before
trying to put it into perl.
IS NULL and IS NOT NULL statements should not be enclosed in quotes. SQL wildcards are
represented with the percent symbol. I assume you were searching for strings starting
with 0. No
All,
Below is the script I'm working on - the idea is to query an Access DB, load
the data into a hash, and write the contents of the hash to a text file.
I have a couple questions:, 1) am I doing the hash load correctly, and 2)
how would I write the contents to a text file? I'm pretty new to Per
Sisyphus <[EMAIL PROTECTED]> wrote on 01/17/2004 05:54:22 PM:
>
> I see there's a ppd for DBD::Pg at http://www.soulcage.net/ppds/
>
> I'm guessing it's for perl 5.8, too, as it was put up on 6 Jan 2004 -
> but I don't know for sure.
>
Nope, it's for 5.6.
All,
To follow up, this query resolved the ODBC error:
SELECT Junk1, Junk2, Junk3, Junk4, Junk5, Junk6, Junk7
FROM Junk
WHERE
Junk1 Is Not Null AND
Junk2 LIKE '0*' AND
Junk3 Is Not Null AND
Junk4 LIKE '0*'
Bruce,
Thanks for your input.
I've tried using AND or commas to separate the column values in the query,
and I keep getting the 'missing operator' error. Since operators are
included in the syntax I'm using, I'm not sure if I'm merely writing bad
syntax, or if there's a fine point about nesting S
