>
> An error has occurred. Problem Executing search query: Error #00928:
missing
> SELECT keyword
>
> When I try to run the following SQL Statement (this is from the log file.
i
> have run this from the command line and it works find)
>
I doesn't have check the exactly correct syntax of your statement, but
basicly there is no reason why you can't do this with DBIx::Recordset. If
you have taken the statement below form the DBIx::Recordset logfile, then
this is exactly what is send to the DBI prepare function. Something with
this SQL must be wrong. Try to check the docs of your DBMS, what Error
#00928 means. Something must be different when you tried it from the command
line and when DBIx::Recordset runs it.
Sorry, I can't say much more about this
Gerald
-------------------------------------------------------------
Gerald Richter ecos electronic communication services gmbh
Internetconnect * Webserver/-design/-datenbanken * Consulting
Post: Tulpenstrasse 5 D-55276 Dienheim b. Mainz
E-Mail: [EMAIL PROTECTED] Voice: +49 6133 925131
WWW: http://www.ecos.de Fax: +49 6133 925152
-------------------------------------------------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
