Re: Simple perl script creates a table but no SQL results ..why?

On a seperate note you should be using placeholders in your SQL instead of embeding the variable directly.

my $sql ="SELECT Bug.ixBug, Bug.sTitle, Bug.ixBug, Bug.sTitle, Bug.ixB
+ug, Bug.sTitle FROM Bug WHERE Bug.ixBug = ?";
_connect();
my $sth =$connection->prepare($sql);
$sth->execute($args);
my @rows = $sth->fetchrow_array;
my @array = $sth->fetchrow_array;
[download]

Notice also that I added the call to execute that seems to have gotten lost. Since you are calling "fetchrow" you are only going to get the next row. Check DBI for information on how to loop over fetchrow and populate an array (or for one of the many other ways to do it. ;)

___________
Eric Hodges

Comment on Re: Simple perl script creates a table but no SQL results ..why? Download Code

Replies are listed 'Best First'.
Re^2: Simple perl script creates a table but no SQL results ..why? by yoyomonkey (Initiate) on Aug 23, 2006 at 14:01 UTC
Thank you so much eric it seems you read my mind. the program is working and can only outputs one record in a table with the syntax %FOG{idnumber}% So i would hopefully get 3 records with %FOG{234,3456,345}% . 234 , 3456 etc but it page crashes so currently it is only displaying one record with if i try %FOG{234}% it works! I will look over the DBI guide you recommended and thanks again :)	[reply]