Gary Fung a �crit :
>
> Hi,
>
> I have a Perl program using DBI. I don't know why it will cause error when I use
>"GROUP BY..." in SQL "SELECT" statements.
>
> My coding is similar as:
>
> $value2 = $dbh->prepare("SELECT page FROM $Table
>
> GROUP BY page") || die "Couldn't add record, ".$dbh->errstr();
>
> Whenever I use "GROUP BY.." , an error statement will go out :
>
> "SQL ERROR: Can't find table names in FROM clause!"
>
> Can anyboby give help to me?
>
> Thank You very much!!
>
> Regards,
>
> Gary
>
> Lonely Christmas(������)�A����P��(Twins)�A�L���D(�q�v)...
> ��In����a�n ���A�L�V��
You should use $value2 = $dbh->prepare('SELECT page FROM '."$Table".'
GROUP BY page' etc. or use quote function of dbi module
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
