Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic

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?

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

How do I use this? | Other CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (3)
As of 2016-08-31 01:29 GMT
Find Nodes?
    Voting Booth?
    The best thing I ever won in a lottery was:

    Results (426 votes). Check out past polls.