WebDB: Why won't these 2 queries work in a report?

Hello all,
[Quoted] I'm just testing creating my own 'links' and am puzzled. I created two links with the wizards. Both links work...then to test a theory...I cut and pasted the example queries that the link got into a test report. I cut and pasted exactly from these two working links. The first one that is looking at the the 'system' table in my schema works...but, the exact query looking at the organization table...does not...gives and error...(not only that...the screen says error...but, displays nothing else...

Is there some kind of limit on the size of a select statement that WebDB can parse?

The first one that works is:

     select '<A
HREF="'||'LI_TRACKER.FORM_KELLY_SYSTEMS.SHOW?p_arg_names=_show_header&p_ arg_values=YES&p_arg_names=_rowid&p_arg_values='||WEBDB.wwv_standard_uti l.url_encode(ROWID)||'&p_arg_names=_alt_rowid&p_arg_values='||WEBDB.wwv_ standard_util.url_encode(ROWID)||'">'||SYSTEM.ROWID||'</A>'

     from LI_TRACKER.SYSTEM

The second one that fails...and leaves a blank screen is:

     select '<A
HREF="'||'LI_TRACKER.FORM_ORGANIZATIONS.SHOW?p_arg_names=_show_header&p_ arg_values=YES&p_arg_names=_rowid&p_arg_values='||WEBDB.wwv_standard_uti l.url_encode(ROWID)||'&p_arg_names=_alt_rowid&p_arg_values='||WEBDB.wwv_ standard_util.url_encode(ORGANIZATION_ID)||'">'||ORGANIZATION.ROWID||'</ A>'

     from LI_TRACKER.ORGANIZATION

Any ideas why both don't work when cut and pasted into the SQL portion of a report?

TIA!! Kelly
kgrigg_at_diamonddata.com

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Jul 18 2000 - 00:00:00 CEST