hi,
just tried to put this in the bug tracker on the website, and it wouldn't
let me (it kept saying all the fields were empty...really, they weren't),
so, i figurerd here was as good a place as any...
product: witango dev studio 5.5.3 on mac os x 10.2.8
summary: 5.5 beta adds extraneous quote-chars to search actions with
custom columns
description: with a taf file created using 5.0 (or tango2000), if i have a
custom-column in a search action, the xml that is generated has some extra
quote (") marks.
reproduced: every time
steps: using an oci connection (don't know if this is important)
1. make a taf in 5.0 with a search action that contains a custom column. i
have always used a concatenated string.
1a. run this using 5.0 server on mac os x...all ok
2. open this taf in 5.5 and make a change to force a save (i have changed
the sort order of the search..and then changed it back)
2a. run this new file on same server...oops
actual results: when the search action is performed, i get...
Error
An error occurred while processing your request:
File: scottlocal.taf
Position: RecordList
Class: DBMS
Main Error Number: 972
ORA-00972: identifier is too long
File: scottlocal.taf
Position: RecordList
Class: Internal
Main Error Number: -101
General error during data source operation.
File: scottlocal.taf
Position: RecordList
Class: Internal
Main Error Number: -101
General error during data source operation.
expected results: the search
additional info:
i'm using the scott/tiger database as setup by the install as an
example...i discovered this when using 5.5 to modify my real live taf
files.
my custom column is defined as...
to_char(scott.emp.deptno)||' '||to_char(scott.emp.empno)
in 5.0, the xml which is produced is...
<ColumnName><![CDATA[to_char(scott.emp.deptno)||'
'||to_char(scott.emp.empno)]]></ColumnName>
in 5.5 the xml is...
<ColumnName><![CDATA[to_char(scott."emp.deptno)||'
'||to_char(scott.emp.empno)"]]></ColumnName>
the same extra "s appear in the sort section as well (i figure, if you fix
one, you'll fix both...)
i can send you two taf files if you need them (but re-creating the problem
is easy)
cheers,
russell
--------------------------------------------------------------
Russell Stephany
Lead Developer, Information Technology
Australian Graduate School of Management
UNSW SYDNEY NSW 2052
Australia
Tel: +61 2 9931-9263
Fax: +61 2 9931-9349
Email: [EMAIL PROTECTED]
Web: http://www.agsm.edu.au
The Australian Graduate School of Management
is a School of both The University of Sydney
& The University of New South Wales.
CRICOS Provider Number: 00098G
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
