Welcome to the Monastery | |
PerlMonks |
Re^2: DBI SQL error messagesby rjberry (Novice) |
on Oct 06, 2008 at 09:14 UTC ( [id://715535]=note: print w/replies, xml ) | Need Help?? |
Thanks, you're right, I was just hoping there'd be an easier way to do it from Perl itself, if you see what I mean? Having to open Access every time is a pain (esp. as I'm not very familiar with it). Looks like that's the only error message I'll get from Perl though. I tried writing the query into Access normally and it changes it into something bizarre: INSERT INTO tblCustomer ( LastName, BranchID, FirstName, Premise, Street, District, Town, County, PostCode ) SELECT 'a' AS Expr1, 'b' AS Expr2, 'c' AS Expr3, 'd' AS Expr4, 'e' AS Expr5, 'f' AS Expr6, 'g' AS Expr7, 'h' AS Expr8, 'i' AS Expr9; The select thing seems slightly ridiculous. I wonder if that's just because the way the GUI works or whether Access databases themselves don't understand Values(). But anyway, that works. Thanks for your help.
In Section
Seekers of Perl Wisdom
|
|