Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight

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.

Replies are listed 'Best First'.
Re^2: bind_col() and the SQL query
by Hans Castorp (Sexton) 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?

    What's my password?
    Create A New User
    Node Status?
    node history
    Node Type: note [id://1029189]
    and all is quiet...

    How do I use this? | Other CB clients
    Other Users?
    Others romping around the Monastery: (3)
    As of 2018-01-21 01:10 GMT
    Find Nodes?
      Voting Booth?
      How did you see in the new year?

      Results (227 votes). Check out past polls.