|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
ERROR:'DBI::db=HASH(0x1b172a4)->select_arrayref()
Can any one tell me what is wrong with this? I have lokked a teh tec references and I cannot see what is wrong. Can I put it together like this? I want to lift the whole row Name and collectit to use in another perl script but I cannot get past this and would it actually let me do this? It is in MySql Apache and Perl
use DBI; $DBH= DBI->connect("DBI:mysql:Guide")or die "\n ($DBI::err) : $DBI::errstr\n"; $sth= $DBH->prepare(qq{$DBH->select_arrayref() select Name from Family while(@row =$sth->fetchrow_array) { print qw($row[0]\t$row[2]\n); } }); $sth->execute(); $sth->finish(); $DBH->disconnect(); I get this message: Bla Bla DBD ::mysql::st execute failed: you have an error in your SQL syntax near 'DBI::db=HASH(0x1b172a4)->select_arrayref() select Name from Family whil' at line 1 a C:/ bla bla line 11 line 11 seems to be }); Any Ideas at all please thanks Chris |
![]() |
| Viewing: Dev Shed Forums > Databases > Database Management > ERROR:'DBI::db=HASH(0x1b172a4)->select_arrayref() |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|