Thank you very much !Now it's working!
bd.
Hanson, Robert wrote:
>I prefer using a placeholder, you don't need to quote anything that way
>which avoids mistakes.
>
>my $sth = $dbh->prepare('SELECT something FROM some_table WHERE some_key =
>?');
>$sth->execute( CGI->param('NAME') );
>
>Did you also print out the variable to prove that it does indeed contain
>some data? Do you also have the RaiseError attribute turned on to die if
>there are any SQL errors?
>
>Rob
>
>
>-----Original Message-----
>From: bernabe diaz [mailto:[EMAIL PROTECTED]]
>Subject: variable interpolation
>
>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_' ");
>>
><snip>
>
>
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
