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.

Error on SetAction(): -1, on all my pages

2 posts in General Discussion (old) Last posting was on 2000-02-17 16:13:47.0Z
Jay S. Posted on 2000-02-16 16:54:02.0Z
Newsgroups: sybase.public.easerver
From: "Jay S." <ash477@hotmail.com>
Subject: Error on SetAction(): -1, on all my pages
Date: Wed, 16 Feb 2000 11:54:02 -0500
Lines: 43
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: 209.10.134.2
Message-ID: <347_705NA7Je$GA.223@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:28560
Article PK: 160704

I have a dw with a where clause being passed in [I'm modifying the select],
and I'm trying to get it to update -- without an 'Error on SetAction(): -1.
I thought my setselflink() was the problem:
args = "pa_partner_id='\"" + Request.QueryString("pa_partner_id") +
"\"'"
retVal = dwMine.setselflink("partner_detail.asp", args );

However I am 100% SURE that the first argument is OK, because the page
repaints after I hit 'update'.
So I can deduce that the second argument, 'args', is incorrect, or something
later in my script is incorrect. Later in my script, I do this:

ls_partner_id = Request.QueryString("pa_partner_id")
if (ls_partner_id + "" != "undefined") {
where_clause += " where partner_id = " + ls_partner_id }

When the page is first loaded and this script occurs, the above script grabs
pa_partner_id from the querystring, changes the where clause, & afterwards
retrieves correctly. But after I hit update, I wonder what happens? Is
setselflink supposed to append pa_partner_id to the querystring again? If
so, it should work. But if it is doing it some other way, then perhaps this
script is the culprit, because after an update and this script occurs again,
it again attempts to grab pa_partner_id from the querystring. It can't find
it, and the dw doesn't retrieve. Thats because my one and only retrieve
call is in an condition that looks for an argument:

if (where_clause != "")

mod = "Datawindow.Table.Select=" + quote + sql + where_clause + quote
rc = dwMine.Modify(mod) retVal = dwMine.RETRIEVE()
}

However I'm still not sure what the SetAction(): -1 means, or what
triggers it.

Is anyone successfully doing this in ASP or am I the only one? I'm having
the same problem on ALL my pages that have where clauses. Also, none of the
ASP samples on SDN address master-detail situations.

Thanks for any help and sorry for such a long message,
Jay Shohet ash477@hotmail.com


Jay S. Posted on 2000-02-17 16:13:47.0Z
Newsgroups: sybase.public.easerver
From: "Jay S." <ash477@hotmail.com>
Subject: Re: Error on SetAction(): -1, on all my pages
Date: Thu, 17 Feb 2000 11:13:47 -0500
Lines: 68
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: 209.10.134.2
Message-ID: <347_w7D#LJWe$GA.324@forums.sybase.com>
References: <347_705NA7Je$GA.223@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:28507
Article PK: 160660

Well, since I couldn't get it to work right in ASP, I just decided to use
session variables to track the arguments, and its working fine.... my pages
w/ where clauses update successfully, and I don't get back all the rows
after I update -- the page grabs the previous where clause when it
re-retrieves.

I guess what I did is the equivalent of smashing the box and going with a
circle, as opposed to thinking outside the box. Oh well, I wish I could
have figured how to do it the *right* way.

Rgds,
Jay Shohet

> I have a dw with a where clause being passed in [I'm modifying the
select],
> and I'm trying to get it to update -- without an 'Error on
SetAction(): -1.
> I thought my setselflink() was the problem:
> args = "pa_partner_id='\"" + Request.QueryString("pa_partner_id") +
> "\"'"
> retVal = dwMine.setselflink("partner_detail.asp", args );
>
> However I am 100% SURE that the first argument is OK, because the page
> repaints after I hit 'update'.
> So I can deduce that the second argument, 'args', is incorrect, or
something
> later in my script is incorrect. Later in my script, I do this:
>
> ls_partner_id = Request.QueryString("pa_partner_id")
> if (ls_partner_id + "" != "undefined") {
> where_clause += " where partner_id = " + ls_partner_id }
>
> When the page is first loaded and this script occurs, the above script
grabs
> pa_partner_id from the querystring, changes the where clause, & afterwards
> retrieves correctly. But after I hit update, I wonder what happens? Is
> setselflink supposed to append pa_partner_id to the querystring again? If
> so, it should work. But if it is doing it some other way, then perhaps
this
> script is the culprit, because after an update and this script occurs
again,
> it again attempts to grab pa_partner_id from the querystring. It can't
find
> it, and the dw doesn't retrieve. Thats because my one and only retrieve
> call is in an condition that looks for an argument:
>
> if (where_clause != "")
>
> mod = "Datawindow.Table.Select=" + quote + sql + where_clause + quote
> rc = dwMine.Modify(mod) retVal = dwMine.RETRIEVE()
> }
>
> However I'm still not sure what the SetAction(): -1 means, or what
> triggers it.
>
> Is anyone successfully doing this in ASP or am I the only one? I'm
having
> the same problem on ALL my pages that have where clauses. Also, none of
the
> ASP samples on SDN address master-detail situations.
>
> Thanks for any help and sorry for such a long message,
> Jay Shohet ash477@hotmail.com
>
>