http://www.perlmonks.org?node_id=1029189


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. :-}

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

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

[reply]
      You have added a new constraint to your query: 
      and LOCATION.LOCATION_ID in (<list>)

      [download]
      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

[reply]
[d/l]
    		[reply]

    In Section Seekers of Perl Wisdom