Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change
 
PerlMonks  

RE: ODBC question

by mr_ayo (Beadle)
on May 10, 2000 at 20:56 UTC ( #11009=note: print w/replies, xml ) Need Help??


in reply to ODBC question

Yea, there's a way around this.
sub mySQLQuote { my ($value,$maxlen) = @_; $value =~ s/\'/\'\'/g; $value = substring($value,1,$maxlen); return $value; } val1 = mySQLQuote(1); $val2 = mySQLQuote("'"); $db->Sql("INSERT INTO Comment ( Field1, Field2 )VALUES ('$val1', '$val +2') ");

Replies are listed 'Best First'.
RE: RE: ODBC question
by mr_ayo (Beadle) on May 10, 2000 at 22:04 UTC
    Man I always do that! Stupid stupid.

    Your assignments should read:
    $val1 = mySQLQuote(1,1); $val2 = mySQLQuote('1',3);

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://11009]
help
Chatterbox?
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (5)
As of 2016-12-10 15:03 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    On a regular basis, I'm most likely to spy upon:













    Results (163 votes). Check out past polls.