Fonnie
Posts: 3
|
| Posted: 10/22/2005, 6:43 PM |
|
My data is in an ORACLE database that I am not allowed to make changes to.
My vendor recently changed their logging procedures, so now my search page only shows what was changed prior to the database update.
I found the new table, and finally got a working UNION query that returned all of the correct fields in SQLPlus Worksheet. It returns all the fields, but only the rows from the last table referenced. Wasn't worried, the sytax check passed. Also, all was OK in Access with the query (after changing it to MS syntax)so I figured it was just a fluke of that program.
Took the SQL into CodeCharge (Studio 2.3), and set it as the datasource for a table. The syntax check passes, but when I review the results only 1 data field is returned. All of the relevant rows are returned from all 3 referenced tables. The WHERE clause is hard coded until I can resolve this problem. All but the one data field is blank, and it is not the first column listed in the SELECT.
As stated earlier, I can not add a view to the database which is what I would rather do. Also, it is impractical to offload the data to another server (MS SQL2000) to do reporting/searches.
Any ideas?
|
 |
 |
E43509
Posts: 283
|
| Posted: 10/22/2005, 7:40 PM |
|
not sure what language you are using (asp, cold fusion, ...) but you may be able to track down the problem if you output the SQL that CCS is issuing to the db (find a strSql). Then run that natively against oracle and see what you get returned. Most likely I've found CCS sometimes does some funny sql things.
|
|
|
|
|
