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

Re^2: bind_col() and the SQL query

by Hans Castorp (Acolyte)
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. :-}


Comment on Re^2: bind_col() and the SQL query
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 (Abbot) 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?
    Username:
    Password:

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

    How do I use this? | Other CB clients
    Other Users?
    Others lurking in the Monastery: (10)
    As of 2014-07-30 09:14 GMT
    Sections?
    Information?
    Find Nodes?
    Leftovers?
      Voting Booth?

      My favorite superfluous repetitious redundant duplicative phrase is:









      Results (230 votes), past polls