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


in reply to Re: bind_col() and the SQL query
in thread bind_col() and the SQL query

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

Replies are listed 'Best First'.
Re^3: bind_col() and the SQL query
by runrig (Abbot) on Apr 17, 2013 at 21:22 UTC
    "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.

Re^3: bind_col() and the SQL query
by NetWallah (Canon) on Apr 18, 2013 at 04:24 UTC
    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