Re: Bareword "DBI::SQL_INTEGER" not allowed while "strict subs"

2005-12-11 Thread michael . peppler
One way to solve it is to do: use DBI qw(:sql_types); Michael Extranet [EMAIL PROTECTED] - 12/12/2005 00:45 To:dbi-users cc: Subject:Bareword "DBI::SQL_INTEGER" not allowed while "strict subs" I am new to DBI, Perl, and SQL and I am currently trying to piece together a group of

RE: Bareword "DBI::SQL_INTEGER" not allowed while "strict subs"

2005-12-11 Thread Ted Behling
It's hard to say exactly why that's happening without seeing a snippet of your code, but try using: DBI::SQL_INTEGER() In other words, add the () at the end. -Original Message- From: Patrick Danley [mailto:[EMAIL PROTECTED] Sent: Sunday, December 11, 2005 6:45 PM To: dbi-users@p

Bareword "DBI::SQL_INTEGER" not allowed while "strict subs"

2005-12-11 Thread Patrick Danley
I am new to DBI, Perl, and SQL and I am currently trying to piece together a group of bioinformatic programs. In running the database element of the package, I recieve a number of : Bareword "DBI::SQL_INTEGER" not allowed while "strict subs" in use errors (a full listing of the error is pa

Re: select placeholder

2005-12-11 Thread John
John wrote: Ian Harisay wrote: Try "SELECT * FROM a1 WHERE custnum = ?" Thank you Ian and Ted That is not the problem, I had previously used a single "=" and went to "==" when it didn't work, tried again this morning - still doesn't work. SQLite documentation says either is acceptable. A

Re: select placeholder

2005-12-11 Thread John
Ian Harisay wrote: Try "SELECT * FROM a1 WHERE custnum = ?" Thank you Ian and Ted That is not the problem, I had previously used a single "=" and went to "==" when it didn't work, tried again this morning - still doesn't work. SQLite documentation says either is acceptable. A little more i

RE: select placeholder

2005-12-11 Thread Ian Harisay
Try "SELECT * FROM a1 WHERE custnum = ?" -Original Message- From: John [mailto:[EMAIL PROTECTED] Sent: Saturday, December 10, 2005 10:40 PM To: dbi-users@perl.org Subject: select placeholder Hi Can anyone see the error in the following code. It has to do with the placeholder in the sel

RE: select placeholder

2005-12-11 Thread Ted Behling
Where you say "WHERE custnum == ?", there ought to be only one equals sign. Ted Behling -Original Message- From: John [mailto:[EMAIL PROTECTED] Sent: Sunday, December 11, 2005 12:40 AM To: dbi-users@perl.org Subject: select placeholder Hi Can anyone see the error in the following code.