On Friday, April 19, 2002, at 07:18 AM, bernabe diaz wrote:
> Hi everyone,
> could somebody help me with the following problem:
> i have a code something like that
> my $variable = CGI->param('NAME');
> #making connection to database
> .................................
> my $variable_ =$dbh->quote($variable);
> .........
>
> $sth = ->$dbh->prepare(" SELECT something FROM some_table WHERE some_key=
> $variable_")
> ............
i think you need to put single quotes around $variable_.
$sth = ->$dbh->prepare(" SELECT something FROM some_table WHERE some_key=
'$variable_' ");
> then when I try to pass $variable_ to a SQL statment the value of
> $variable_ was not passed
> so i can't fetch information fro the database.
> when i give the string to the SELECT statement directly every thing is
> fine, is working, that's why
> I consider that it is a problem of interpolation of the variable .
> could anybody help me
> Thanks,
> BD
>
>
> -- To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
