Thanks for the reply, Isaac, I've figured out how to generate the HTML table result set using sp_makewebtask.

P

-----Original Message-----
From: Isaac Agung Nugroho
[mailto:mssqldba-ezmlmshield-x20888668.[Email address protected]
Sent: Wednesday, November 24, 2004 10:54 PM
To: LazyDBA Discussion
Subject: SUSPECT: RE: Output as HTML


Hi Paul,
Could you return the result in XML (Using FOR XML clause) and by using
transformation you display the result on the web.
You could find the FOR XML syntax in BOL.

Thanx
Isaac

(Please excuse me, english is not my native language)

-----Original Message-----
From: Schlieper Paul
[mailto:mssqldba-ezmlmshield-x82706029.[Email address protected]
Sent: Thursday, November 25, 2004 03:26
To: LazyDBA Discussion
Subject: Output as HTML

Hi all,

We need to display a result set on a web site. The result set is from a
stored proc, when the user clicks, the sproc is called, and we don't
know in advance how many rows or columns the result set will contain.

Can anyone point me in the right direction for some documentation, or
code if you have it, for such a thing? Web site is Java on WebSphere.
SQL 2K on back end.

P



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website :
http://www.LazyDBA.com To unsubscribe:
http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]






---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]



MS Sql Server LazyDBA home page