martydot
|
Posted: 11/26/2002, 3:08 PM |
|
Hi,
I am pretty sure someone must have come across this before. I am running
Oracle 8.1.7 on Linux Redhat 7.3. The design is using odbc successfully,
however the code that is generated is putting double quotes around the table
name in the select statement. Oracle doesn't find the table. If I take the
same sql and log in as the same user in sqlplus, and execute the sql without
the double quoted table names, it works fine. I see for example in
Default.xml :
<Select query="SELECT * FROM "event_categories"" orderBy="">
Is this a clue ? I thought " in an html page is a substitue variable
for a double quote. Perhaps not in this case, perhaps there is somewhere
that I can specify the value of the " ?
Your advice would be greatly welcome.
Martin....
|
|
|
|