Display results of SQL in an HTML Block
562165Feb 15 2007 — edited Feb 16 2007Hi there
I want to display the results of some SQL within an HTML Block. To do this I have created a hidden page item which I can then reference within the HTML Block (ie: &mypageitem.)
However I want to run a process that assigns that page item the results of a simple SQL query that returns multiple rows. If I try to do that SQL within the page item itself it only assumes the value of the first row returned. I tried to do it within a pl/sql process and looping through a cursor and assigning my page item each row of the cursor. That didnt work because I couldnt insert an HTML BR within the page item and it only seemed to return one row.
Am I going about this the wrong way? Thanks in advance for any help.
Message was edited by:
user559162