Date:         Wed, 31 Jan 2001 11:38:35 -0500
Reply-To:     don.henderson@US.PWCGLOBAL.COM
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         don.henderson@US.PWCGLOBAL.COM
Subject:      Re: multiple queries on a htmsql page
Content-type: text/plain; charset=us-ascii

Oops. Note the correction. Should say "is embedded" and not "is not
embedded"

-don





Don Henderson/MCS/Price Waterhouse@Americas-US@LISTSERV.UGA.EDU> on
01/31/2001 11:14:58 AM

Please respond to Don Henderson/MCS/Price Waterhouse@Americas-US

Sent by:  "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>

To:   SAS-L@LISTSERV.UGA.EDU
cc:
Subject:  Re: multiple queries on a htmsql page


Is the second query in the same {QUERY} section? Or is it in a different
{QUERY} section?

If it is in the same {QUERY} section as the first submitted query, make
sure the second query is not embedded inside the {NOROWS} section. The
                                          ===================
should be "is embedded"

contents of the {EACHROW} section are executed for each returned row. And
if there are no returned rows, none of the contents are processed.
Furthermore, if the query returns no results nothing after the {SQL}
section is processed If you need the queries embedded this way, you might
need to use a {NOROWS} section. If no data are returned, the {NOROWS}
section is processed. If rows are returned, {NOROWS} is bypassed.

See:

http://www.sas.com/rnd/web/intrnet/htmSQL/syntax.html#query

and check out the example at the end of this section of the page (just
before the SQL section)

-don





Niels Stout <n.stout@HETNET.NL> on 01/31/2001 10:47:06 AM

Please respond to Niels Stout <n.stout@HETNET.NL>
To:   SAS-L@LISTSERV.UGA.EDU
cc:
Subject:  multiple queries on a htmsql page



Hi,

I'm working on a project where we use a htmsql page with two independent
queries on it. If both queries return rows all works fine, but if the first
query does not return any rows the second query is not executed. Has anyone
experienced similar problems?

Thanks,

Niels


----------------------------------------------------------------
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material.  Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited.   If you received
this in error, please contact the sender and delete the material from any
computer.


----------------------------------------------------------------
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material.  Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited.   If you received
this in error, please contact the sender and delete the material from any
computer.