Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic
 
PerlMonks  

Re: DBI error

by gmax (Abbot)
on Dec 01, 2003 at 15:59 UTC ( [id://311290]=note: print w/replies, xml ) Need Help??


in reply to DBI error

Your error message doesn't seem to agree with what I see. Let me give you a few hints, though.

  • Your code fragment, as you posted it, compiles fine. Therefore the error should not be in these lines.
  • From a SQL point of view, your query is wrong in several places:
    • You are declaring 8 fields but you are passing only 5 values.
    • You are passing unquoted values "I00" and "I99", which will fail once your program manages to send your query to the DBMS. Perhaps that you are using "I" instead of "1"?
  • You should be better off using placeholders. See DBI Recipes for examples.
  • Your query is using multiple VALUES clauses. AFAIK, only MySQL and IBM DB2 support this syntax. If you are using another DBMS, check its docs to be sure you can do it.
  • As for your specific problem, since the error is not visible in this example, perhaps reading Before asking a database related question ... could give you some ideas.
 _  _ _  _  
(_|| | |(_|><
 _|   

Replies are listed 'Best First'.
A reply falls below the community's threshold of quality. You may see it by logging in.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://311290]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others meditating upon the Monastery: (3)
As of 2024-04-20 03:38 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found