Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling

Re^2: bind_col() and the SQL query

by Hans Castorp (Sexton)
on Apr 17, 2013 at 18:18 UTC ( #1029193=note: print w/replies, xml ) Need Help??

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

    Log In?

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

    How do I use this? | Other CB clients
    Other Users?
    Others surveying the Monastery: (11)
    As of 2018-10-15 22:15 GMT
    Find Nodes?
      Voting Booth?
      When I need money for a bigger acquisition, I usually ...

      Results (82 votes). Check out past polls.