Beefy Boxes and Bandwidth Generously Provided by pair Networks
We don't bite newbies here... much
 
PerlMonks  

Re: Mason & DBI driving me nuts

by jZed (Prior)
on Jul 31, 2006 at 19:06 UTC ( [id://564838]=note: print w/replies, xml ) Need Help??


in reply to Mason & DBI driving me nuts

Why do you have an undef as the first bind_column? You are binding three columns but only selecting two. What error message or undesired behaviour do you get?

Replies are listed 'Best First'.
Re^2: Mason & DBI driving me nuts
by jfroebe (Parson) on Jul 31, 2006 at 19:17 UTC

    That is the syntax of bind_columns.

    Jason L. Froebe

    Team Sybase member

    No one has seen what you have seen, and until that happens, we're all going to think that you're nuts. - Jack O'Neil, Stargate SG-1

      Um, no it is not the syntax of bind_columns. To quote the DBI docs:
      The list of references should have the same number of elements as the number of columns in the SELECT statement.
      You have three elements in the bind_columns and only two columns in your SELECT statement. You still haven't told us what the warning, error message, or unexpected behaviour is, so it's hard to guess what is going on.

      update Oops, reading further in the DBI docs, I see it does allow an ignorable undef as the first param, sorry:

      For compatibility with old scripts, the first parameter will be ignored if it is undef or a hash reference.

        Sorry, I must have an older copy of the Programming the Perl DBI book. I don't see the optional undef comment. Oh well.

        I've been able to get it working but odd that no errors were being sent to the browser. hmmmm

        Jason L. Froebe

        Team Sybase member

        No one has seen what you have seen, and until that happens, we're all going to think that you're nuts. - Jack O'Neil, Stargate SG-1

Log In?
Username:
Password:

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

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

    No recent polls found