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.

Bug when adding multiple rows in HTMLdw. HELP!!!

3 posts in General Discussion (old) Last posting was on 2000-02-29 08:49:14.0Z
Adam Simmonds Posted on 2000-02-27 02:33:23.0Z
Newsgroups: sybase.public.easerver
Date: Sun, 27 Feb 2000 13:33:23 +1100
From: Adam Simmonds <asimmond@mail.usyd.edu.au>
Organization: University of Syndey
X-Mailer: Mozilla 4.7 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Bug when adding multiple rows in HTMLdw. HELP!!!
Content-Type: multipart/mixed; boundary="------------549F00C8E9AAEA374A7AF919"
Lines: 72
NNTP-Posting-Host: pc-70.sis.usyd.edu.au 129.78.248.198
Message-ID: <347_38B88CF3.46FC3738@mail.usyd.edu.au>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:27728
Article PK: 159087

Hi All
I have posted a recent message regarding the htmldw but thought I would
add again with my most recent findings. This is a bit long, but I have
extracted the context information to show what is happening in
excruiating detail <g>

After the retrieve I add one row
as_action =AppendRow
as_context =(htmldw 0)(14 )((sortString '?'))

Add second row:
as_action =AppendRow
as_context =(htmldw 10)(76 (InsertRow 9 ((1 0 '0')(2 0 '0')(3 1 )(4 1
)(5 1 )(6 1 )(7 1 )(8 1 )(9 0 '1')(10 1 )(11 1 )(12 1 )(13 1 )(14 1 )(15
1 )(16 1 )(17 1 )(18 1 )(19 1 ))))((sortString '?'))

I add data to both rows
lrge 9999
smll 0000

and update....

as_action =Update
as_context =(htmldw 11)
(143 (InsertRow 9 ((1 0 '0')(2 0 '0')(3 1 )(4 1 )(5 1 )(6 1 )(7 1 )(8 1
)(9 0 '1')(10 1 )(11 1 )(12 1 )(13 1 )(14 1 )(15 1 )(16 1 )(17 1 )(18 1
)(19 1 )))
(InsertRow 10 ((1 0 '0')(2 0 '0')(3 1 )(4 1 )(5 1 )(6 1 )(7 1 )(8 1 )(9
0 '1')(10 1 )(11 1 )(12 1 )(13 1 )(14 1 )(15 1 )(16 1 )(17 1 )(18 1 )(19
1 ))))
((ModifyRow ((3 1 )(4 1 )(5 1 )(6 1 )(7 1 )) ((7 0 '1')(10 0 'lrge')(11
0 '9999')))
(ModifyRow ((3 1 )(4 1 )(5 1 )(6 1 )(7 1 )) ((7 0 '1')(10 0 'smll')(11 0
'0000')))(row 10)(sortString '?'))

You can see that the values come through okay in the modify row sections

Now if I change the data to
Lrge 0000 and smll 9999

as_action =Update
as_context =(htmldw 0)(220
(InsertRow 9 ((1 0 '0')(2 0 '0')(3 1 )(4 1 )(5 1 )(6 1 )(7 0 '1')(8 1
)(9 0 '1')(10 0 'lrge')(11 0 '9999')(12 1 )(13 1 )(14 1 )(15 1 )(16 1
)(17 1 )(18 1 )(19 1 )))
(InsertRow 10 ((1 0 '0')(2 0 '0')(3 1 )(4 1 )(5 1 )(6 1 )(7 0 '1')(8 1
)(9 0 '1')(10 0 'smll')(11 0 '0000')(12 1 )(13 1 )(14 1 )(15 1 )(16 1
)(17 1 )(18 1 )(19 1 ))))
((ModifyRow ((3 1 )(4 1 )(5 1 )(6 1 )(7 0 '1')) ((11 0 '0000')))
(ModifyRow ((3 1 )(4 1 )(5 1 )(6 1 )(7 0 '1')) ((11 0 '9999')))(row
10)(sortString '?'))

You can see that smll 9999 was sent through with its original value of
0000 and lrge is still 9999

What is going on here, i would assume that the datawindow should be
sending the changed values and not the original values.

Rgds
Adam


Download VCard asimmond.vcf


Larry Cermak[Team Sybase] Posted on 2000-02-29 03:23:55.0Z
Newsgroups: sybase.public.easerver
From: "Larry Cermak[Team Sybase]" <lcermak@ctpartners.com>
Subject: Re: Bug when adding multiple rows in HTMLdw. HELP!!!
Date: Mon, 28 Feb 2000 21:23:55 -0600
Lines: 78
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: node6.dhcpchi.dslspeed.zyan.com 208.41.199.6
Message-ID: <347_iUfvMWmg$GA.201@forums.sybase.com>
References: <347_38B88CF3.46FC3738@mail.usyd.edu.au>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:27590
Article PK: 158966

What is the update characteristics of the datawindow set to? Also, is it
use update or use delete/insert?

--

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)

"Adam Simmonds" <asimmond@mail.usyd.edu.au> wrote in message
news:38B88CF3.46FC3738@mail.usyd.edu.au...
> Hi All
> I have posted a recent message regarding the htmldw but thought I would
> add again with my most recent findings. This is a bit long, but I have
> extracted the context information to show what is happening in
> excruiating detail <g>
>
> After the retrieve I add one row
> as_action =AppendRow
> as_context =(htmldw 0)(14 )((sortString '?'))
>
> Add second row:
> as_action =AppendRow
> as_context =(htmldw 10)(76 (InsertRow 9 ((1 0 '0')(2 0 '0')(3 1 )(4 1
> )(5 1 )(6 1 )(7 1 )(8 1 )(9 0 '1')(10 1 )(11 1 )(12 1 )(13 1 )(14 1 )(15
> 1 )(16 1 )(17 1 )(18 1 )(19 1 ))))((sortString '?'))
>
> I add data to both rows
> lrge 9999
> smll 0000
>
> and update....
>
> as_action =Update
> as_context =(htmldw 11)
> (143 (InsertRow 9 ((1 0 '0')(2 0 '0')(3 1 )(4 1 )(5 1 )(6 1 )(7 1 )(8 1
> )(9 0 '1')(10 1 )(11 1 )(12 1 )(13 1 )(14 1 )(15 1 )(16 1 )(17 1 )(18 1
> )(19 1 )))
> (InsertRow 10 ((1 0 '0')(2 0 '0')(3 1 )(4 1 )(5 1 )(6 1 )(7 1 )(8 1 )(9
> 0 '1')(10 1 )(11 1 )(12 1 )(13 1 )(14 1 )(15 1 )(16 1 )(17 1 )(18 1 )(19
> 1 ))))
> ((ModifyRow ((3 1 )(4 1 )(5 1 )(6 1 )(7 1 )) ((7 0 '1')(10 0 'lrge')(11
> 0 '9999')))
> (ModifyRow ((3 1 )(4 1 )(5 1 )(6 1 )(7 1 )) ((7 0 '1')(10 0 'smll')(11 0
> '0000')))(row 10)(sortString '?'))
>
> You can see that the values come through okay in the modify row sections
>
> Now if I change the data to
> Lrge 0000 and smll 9999
>
> as_action =Update
> as_context =(htmldw 0)(220
> (InsertRow 9 ((1 0 '0')(2 0 '0')(3 1 )(4 1 )(5 1 )(6 1 )(7 0 '1')(8 1
> )(9 0 '1')(10 0 'lrge')(11 0 '9999')(12 1 )(13 1 )(14 1 )(15 1 )(16 1
> )(17 1 )(18 1 )(19 1 )))
> (InsertRow 10 ((1 0 '0')(2 0 '0')(3 1 )(4 1 )(5 1 )(6 1 )(7 0 '1')(8 1
> )(9 0 '1')(10 0 'smll')(11 0 '0000')(12 1 )(13 1 )(14 1 )(15 1 )(16 1
> )(17 1 )(18 1 )(19 1 ))))
> ((ModifyRow ((3 1 )(4 1 )(5 1 )(6 1 )(7 0 '1')) ((11 0 '0000')))
> (ModifyRow ((3 1 )(4 1 )(5 1 )(6 1 )(7 0 '1')) ((11 0 '9999')))(row
> 10)(sortString '?'))
>
> You can see that smll 9999 was sent through with its original value of
> 0000 and lrge is still 9999
>
> What is going on here, i would assume that the datawindow should be
> sending the changed values and not the original values.
>
> Rgds
> Adam
>
>
>


Adam Simmonds Posted on 2000-02-29 08:49:14.0Z
Newsgroups: sybase.public.easerver
Date: Tue, 29 Feb 2000 19:49:14 +1100
From: Adam Simmonds <asimmond@mail.usyd.edu.au>
Organization: University of Syndey
X-Mailer: Mozilla 4.7 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Bug when adding multiple rows in HTMLdw. HELP!!!
Content-Type: multipart/mixed; boundary="------------D3B27659104B9AB43B97FFAC"
Lines: 90
NNTP-Posting-Host: pc-70.sis.usyd.edu.au 129.78.248.198
Message-ID: <347_38BB880A.EE601C6D@mail.usyd.edu.au>
References: <347_38B88CF3.46FC3738@mail.usyd.edu.au> <347_iUfvMWmg$GA.201@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:27558
Article PK: 154556

Update / Key Columns
Rgds
Adam

"Larry Cermak[Team Sybase]" wrote:

> What is the update characteristics of the datawindow set to? Also, is it
> use update or use delete/insert?
>
> --
>
> 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)
>
> "Adam Simmonds" <asimmond@mail.usyd.edu.au> wrote in message
> news:38B88CF3.46FC3738@mail.usyd.edu.au...
> > Hi All
> > I have posted a recent message regarding the htmldw but thought I would
> > add again with my most recent findings. This is a bit long, but I have
> > extracted the context information to show what is happening in
> > excruiating detail <g>
> >
> > After the retrieve I add one row
> > as_action =AppendRow
> > as_context =(htmldw 0)(14 )((sortString '?'))
> >
> > Add second row:
> > as_action =AppendRow
> > as_context =(htmldw 10)(76 (InsertRow 9 ((1 0 '0')(2 0 '0')(3 1 )(4 1
> > )(5 1 )(6 1 )(7 1 )(8 1 )(9 0 '1')(10 1 )(11 1 )(12 1 )(13 1 )(14 1 )(15
> > 1 )(16 1 )(17 1 )(18 1 )(19 1 ))))((sortString '?'))
> >
> > I add data to both rows
> > lrge 9999
> > smll 0000
> >
> > and update....
> >
> > as_action =Update
> > as_context =(htmldw 11)
> > (143 (InsertRow 9 ((1 0 '0')(2 0 '0')(3 1 )(4 1 )(5 1 )(6 1 )(7 1 )(8 1
> > )(9 0 '1')(10 1 )(11 1 )(12 1 )(13 1 )(14 1 )(15 1 )(16 1 )(17 1 )(18 1
> > )(19 1 )))
> > (InsertRow 10 ((1 0 '0')(2 0 '0')(3 1 )(4 1 )(5 1 )(6 1 )(7 1 )(8 1 )(9
> > 0 '1')(10 1 )(11 1 )(12 1 )(13 1 )(14 1 )(15 1 )(16 1 )(17 1 )(18 1 )(19
> > 1 ))))
> > ((ModifyRow ((3 1 )(4 1 )(5 1 )(6 1 )(7 1 )) ((7 0 '1')(10 0 'lrge')(11
> > 0 '9999')))
> > (ModifyRow ((3 1 )(4 1 )(5 1 )(6 1 )(7 1 )) ((7 0 '1')(10 0 'smll')(11 0
> > '0000')))(row 10)(sortString '?'))
> >
> > You can see that the values come through okay in the modify row sections
> >
> > Now if I change the data to
> > Lrge 0000 and smll 9999
> >
> > as_action =Update
> > as_context =(htmldw 0)(220
> > (InsertRow 9 ((1 0 '0')(2 0 '0')(3 1 )(4 1 )(5 1 )(6 1 )(7 0 '1')(8 1
> > )(9 0 '1')(10 0 'lrge')(11 0 '9999')(12 1 )(13 1 )(14 1 )(15 1 )(16 1
> > )(17 1 )(18 1 )(19 1 )))
> > (InsertRow 10 ((1 0 '0')(2 0 '0')(3 1 )(4 1 )(5 1 )(6 1 )(7 0 '1')(8 1
> > )(9 0 '1')(10 0 'smll')(11 0 '0000')(12 1 )(13 1 )(14 1 )(15 1 )(16 1
> > )(17 1 )(18 1 )(19 1 ))))
> > ((ModifyRow ((3 1 )(4 1 )(5 1 )(6 1 )(7 0 '1')) ((11 0 '0000')))
> > (ModifyRow ((3 1 )(4 1 )(5 1 )(6 1 )(7 0 '1')) ((11 0 '9999')))(row
> > 10)(sortString '?'))
> >
> > You can see that smll 9999 was sent through with its original value of
> > 0000 and lrge is still 9999
> >
> > What is going on here, i would assume that the datawindow should be
> > sending the changed values and not the original values.
> >
> > Rgds
> > Adam
> >
> >
> >


Download VCard asimmond.vcf