finally...after much head banging...
I think the problem was a line return at the end of each line, chomp was the fix for that. Added the '?' to the select, which helped build the dynamic query. Also, the order wasn't very good, the prepare is better placed outside the loop. There's probably a better way but hope this helps someone else...
####
#Select last, first, and RESP of db users
$sql ...
rook
Last Activity: Mar 29 '06, 12:53 PM
Joined: Mar 23 '06
Location:
-
newbie question - PERL/MYSQL
Hello,
Hopefully this is the right place to post my question.
I'm trying to create a dynamic query by populating a select statement from an array. The code below is one fetchrow_array problem away from working. Unfortunately, I'm googled out and can't seem to figure out why the fetchrow_array function within the while statement doesn't run.
####
foreach $match(@match) {
...Last edited by rook; Mar 24 '06, 03:01 PM.
No activity results to display
Leave a comment: