Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical
 
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?
Replies are listed 'Best First'.
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 surveying the Monastery: (13)
As of 2015-07-07 18:43 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (93 votes), past polls