Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister
 
PerlMonks  

Re^2: Wrong SQL Syntax?

by moritz (Cardinal)
on Dec 03, 2010 at 13:22 UTC ( #875176=note: print w/ replies, xml ) Need Help??


in reply to Re: Wrong SQL Syntax?
in thread Wrong SQL Syntax?

... until somebody tries to enter a username that contains a '.


Comment on Re^2: Wrong SQL Syntax?
Re^3: Wrong SQL Syntax?
by herveus (Parson) on Dec 03, 2010 at 13:42 UTC
Re^3: Wrong SQL Syntax?
by kcott (Abbot) on Dec 03, 2010 at 13:47 UTC
    ... until somebody tries to enter a username that contains a '.

    No argument with that. The various responses indicating the use of placeholders (including your own) are a better general solution.

    My post was based on:

    • Frederic_S seemed to think that the quotes used in the assignment to $user_login_name would be propagated to the SELECT statement: "I thought if I pass the login_name in '' it would work ...".
    • The fact that what he was trying perhaps worked in a different language: "I'm new to perl (coming from PHP) ...".
    • The specific question asked: "... what I'm doing wrong?".
    • The code as presented which didn't indicate any user input.

    I might also point out that when I started to type up my response there where no current replies: I wasn't intending to provide a better solution or invalidate any answers that were submitted in the few minutes before my own.

    Update: Added a blockquote at the top.

    -- Ken

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others romping around the Monastery: (5)
As of 2014-07-31 03:43 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    My favorite superfluous repetitious redundant duplicative phrase is:









    Results (244 votes), past polls