Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?

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 '.

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 (Chancellor) 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?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://875176]
[Discipulus]: good morning nuns and monks!

How do I use this? | Other CB clients
Other Users?
Others about the Monastery: (6)
As of 2018-06-25 07:10 GMT
Find Nodes?
    Voting Booth?
    Should cpanminus be part of the standard Perl release?

    Results (126 votes). Check out past polls.