Thanks for the reply, it turns out that Oracle is the database that my
application is connected to. So, Inner Join has no meaning in oracle, need
to use (+) for outer joins and inner joins are handled by using "=".
-Original Message-
From: Gerald Richter [mailto:[EMAIL PROTECTED]]
Sent:
>
> 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 stat
> I am not sure if DBIx::Recordset has its own list so I am posting here,
> please redirect me if needed.
>
No it doesn't have it's own list. Posting here or on the DBI-users list is
ok
Use undef, DBIx::Recordset will convert it to IS NULL:
$set->Select( { ORDER => "$ORDER",
