Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Pass retrival args in PowerDynamo SQL Tags

3 posts in General Discussion (old) Last posting was on 2000-02-25 13:59:57.0Z
Roger Lou Posted on 2000-02-24 08:23:33.0Z
Newsgroups: sybase.public.easerver
Date: Thu, 24 Feb 2000 16:23:33 +0800
From: Roger Lou <cclou@mpinfo.com>
X-Mailer: Mozilla 4.61 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Pass retrival args in PowerDynamo SQL Tags
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 14
NNTP-Posting-Host: 210.242.176.77
Message-ID: <347_38B4EA85.8CBE11E8@mpinfo.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:27955
Article PK: 159647

I follow the PowerDynamo Reference book to write one SQL tag statement
contains one retrival argument. It work fine. But when I change my SQL
tag statement to contain more than one retrival argument and it fails.
For example, my SQL tag statement like following code:

<!--SQL
select lname, fname, salary
from employee
where salary > :this_salary and age > :this_age
-->

This web page return no data but only the title. How come? It's the
limitation of retrival argument? Or it's a bug?

PS: I'm using PowerDynamo 3.5.


Michael F. Nicewarner [TeamSybase] Posted on 2000-02-25 13:59:57.0Z
Newsgroups: sybase.public.easerver
From: "Michael F. Nicewarner [TeamSybase]" <mike.nicewarner@ibpinc.com>
Subject: Re: Pass retrival args in PowerDynamo SQL Tags
Date: Fri, 25 Feb 2000 07:59:57 -0600
Lines: 37
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
NNTP-Posting-Host: secure.ibpinc.com 198.133.192.2
Message-ID: <347_I7O52k5f$GA.265@forums.sybase.com>
References: <347_38B4EA85.8CBE11E8@mpinfo.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:27816
Article PK: 159167

I haven't had any problems putting basically any SQL statement into the SQL
tag in PowerDynamo. I am, however, a bit confused by your ":var" notation.
I'm used to seeing "$var" to reference a document variable.

Anyway, to get better control over the query, you could use the SCRIPT tag
and build the SQL string and submit it to the query object manually. Then
you will have access to the GetErrorCode() and GetErrorInfo() methods
directly. I have a common module that I call to check and display the error
information in a nice HTML format.

--

Michael F. Nicewarner [TeamSybase]
mailto:mike.nicewarner@ibpinc.com
http://www.datamodel.org

Roger Lou <cclou@mpinfo.com> wrote in message
news:38B4EA85.8CBE11E8@mpinfo.com...
> I follow the PowerDynamo Reference book to write one SQL tag statement
> contains one retrival argument. It work fine. But when I change my SQL
> tag statement to contain more than one retrival argument and it fails.
> For example, my SQL tag statement like following code:
>
> <!--SQL
> select lname, fname, salary
> from employee
> where salary > :this_salary and age > :this_age
> -->
>
> This web page return no data but only the title. How come? It's the
> limitation of retrival argument? Or it's a bug?
>
> PS: I'm using PowerDynamo 3.5.
>


Larry Cermak[Team Sybase] Posted on 2000-02-25 04:47:31.0Z
Newsgroups: sybase.public.easerver
From: "Larry Cermak[Team Sybase]" <lcermak@ctpartners.com>
Subject: Re: Pass retrival args in PowerDynamo SQL Tags
Date: Thu, 24 Feb 2000 22:47:31 -0600
Lines: 32
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
NNTP-Posting-Host: node49.dhcpchi.dslspeed.zyan.com 208.41.199.49
Message-ID: <347_BTEEJy0f$GA.276@forums.sybase.com>
References: <347_38B4EA85.8CBE11E8@mpinfo.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:27838
Article PK: 159545

I'm not sure,but the SQL tag has options that you can put in it on how to
act on errors. I would look at that and see if there are any database
errors.

--

Larry Cermak [Team Sybase]
Corporate Technology Partners, Inc.
www.ctpartners.com
Web DataWindow Articles
(http://sdn.sybase.com/sdn/appdev/get_doc.stm?loc=1001708)

"Roger Lou" <cclou@mpinfo.com> wrote in message
news:38B4EA85.8CBE11E8@mpinfo.com...
> I follow the PowerDynamo Reference book to write one SQL tag statement
> contains one retrival argument. It work fine. But when I change my SQL
> tag statement to contain more than one retrival argument and it fails.
> For example, my SQL tag statement like following code:
>
> <!--SQL
> select lname, fname, salary
> from employee
> where salary > :this_salary and age > :this_age
> -->
>
> This web page return no data but only the title. How come? It's the
> limitation of retrival argument? Or it's a bug?
>
> PS: I'm using PowerDynamo 3.5.
>