RE: ODBC question

[mr_ayo]

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') ");

[mr_ayo]

Man I always do that! Stupid stupid.

Your assignments should read:


$val1 = mySQLQuote(1,1);
$val2 = mySQLQuote('1',3);