Thanks for help, but
I tried that way too, and it does not work.
BD
bob ackerman wrote:
>
> 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]
>>
>
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
