Beefy Boxes and Bandwidth Generously Provided by pair Networks
laziness, impatience, and hubris
 
PerlMonks  

Re: bind_col() and the SQL query

by runrig (Abbot)
on Apr 17, 2013 at 18:04 UTC ( #1029189=note: print w/ replies, xml ) Need Help??


in reply to bind_col() and the SQL query

In the first query, you're selecting 12 columns and binding 12 columns. In the second query, you're only selecting 10 columns, but binding 12.


Comment on Re: bind_col() and the SQL query
Re^2: bind_col() and the SQL query
by Hans Castorp (Acolyte) on Apr 17, 2013 at 18:18 UTC

    Thank you--yes, sorry, I forgot to say that I have tried to delete the bind_cols that I don't need anymore--requestor and moretrash--but although that keeps it from throwing an error, the script does not work. (No data is put in the table.)

    I apologize--this may be too in-depth and specific to our library to ask here. :-}

      "put in the table"? But you're selecting data...not putting it in a table...

        Yes, as I wrote initially, this selects data and puts it in a table.

      You have added a new constraint to your query:
      and LOCATION.LOCATION_ID in (<list>)
      Does your data meet this criteria ?

                   "I'm fairly sure if they took porn off the Internet, there'd only be one website left, and it'd be called 'Bring Back the Porn!'"
              -- Dr. Cox, Scrubs

    Log In?
    Username:
    Password:

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

    How do I use this? | Other CB clients
    Other Users?
    Others taking refuge in the Monastery: (14)
    As of 2014-07-23 12:02 GMT
    Sections?
    Information?
    Find Nodes?
    Leftovers?
      Voting Booth?

      My favorite superfluous repetitious redundant duplicative phrase is:









      Results (140 votes), past polls