(Boo) Re: Dereference an array reference

my $slobbo = "select * from bleh where whatever = ";
...
...    
my $sth = $connection->connection->prepare($slobbo.$thangsname );
[download]

this is what placeholders were designed to do.

foreach my $var (@list)
$sql = $l_dbh->prepare("INSERT activity (activity_num) VALUES (?)");
@l_sqlparams = ($var);
$l_result=$sql->execute (@l_sqlparams) or die 'no';
[download]

see?

Comment on (Boo) Re: Dereference an array reference Select or Download Code

Replies are listed 'Best First'.
Re: (Boo) Re: Dereference an array reference by fmogavero (Monk) on Apr 19, 2001 at 18:02 UTC
This does help to clear things up. But at the same time it leaves a lot of questions. I am not trying to insert anything into the database. Where would I put the placeholder in a plain old select statement? \|\| Can you direct me to a node with the answer? Does `foreach my $var (@list);` cause `$var` to be in list context? \|\| Can you direct me to a node with a good explanation of the differences in context? Does `@l_sqlparams = ($var);` put `$var` back into an array from list context? \|\| Can you direct me to a node with an explanation?	[reply] [d/l] [select]
Re: (Boo) Re: Dereference an array reference by fmogavero (Monk) on Apr 19, 2001 at 19:24 UTC
Thank You! I wasn't understanding placeholders. Now I just have to figure out why I'm getting two error messages. 1.) disallowed implicit conversion from datatype 'varchar' to datatype 'int'. After attempted adjustment 2.) syntax error converting CHAR value 'ARRAY(XXXXXXX)' to an INT4 field	[reply]
Re: Re: (Boo) Re: Dereference an array reference by boo_radley (Parson) on Apr 19, 2001 at 19:28 UTC
It sounds like you're : stuffing non-integer values into an integer field. not deferencing the array.	[reply]


XP is just a number
	PerlMonks