Database Update Buttons

S

SS

Hi

When creating a form to be able to update it automatically puts the arrows
at the bottom but they seem to be the wrong way around ie you have to press
to go back one and < to go forward one.
Click to expand...

Can anyone one work out in the script what I have to change to make it more
logical so that the person presses < to go back and > to go forward.

<!--webbot bot="DatabaseRegionEnd" startspan b-tableformat="FALSE"

b-menuformat="FALSE" u-dbrgn2="../../../_fpclass/fpdbrgn2.inc"

i-groupsize="1" clientside tag="BODY"

local_preview="&lt;table border=0
width=&quot;100%&quot;&gt;&lt;tr&gt;&lt;td bgcolor=&quot;#FFFF00&quot;
align=&quot;center&quot;&gt;&lt;font color=&quot;#000000&quot;&gt;End of
Database Results region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&lt;TR&gt;&lt;TD
ALIGN=LEFT VALIGN=MIDDLE&gt;&lt;FORM&gt;&lt;NOBR&gt;&lt;INPUT TYPE=Button
VALUE=&quot; |&lt; &quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot; &lt;
&quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot; &gt; &quot;&gt;&lt;INPUT
TYPE=Button VALUE=&quot; &gt;| &quot;&gt;
[1/1]&lt;/NOBR&gt;&lt;/FORM&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;"

preview="&lt;table border=0 width=&quot;100%&quot;&gt;&lt;tr&gt;&lt;td
bgcolor=&quot;#FFFF00&quot; align=&quot;left&quot;&gt;&lt;font
color=&quot;#000000&quot;&gt;This is the end of a Database Results
region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&lt;TR&gt;&lt;TD ALIGN=LEFT
VALIGN=MIDDLE&gt;&lt;NOBR&gt;&lt;INPUT TYPE=Button VALUE=&quot; |&lt;
&quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot; &lt; &quot;&gt;&lt;INPUT
TYPE=Button VALUE=&quot; &gt; &quot;&gt;&lt;INPUT TYPE=Button
VALUE=&quot; &gt;| &quot;&gt;
[1/1]&lt;/NOBR&gt;&lt;BR&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;" --><!--#in
clude file="../../../_fpclass/fpdbrgn2.inc"-->

<!--webbot bot="DatabaseRegionEnd" endspan i-CheckSum="9297" -->



Any help would be great thanks Shona.
 
K

Kathleen Anderson [MVP - FrontPage]

That shouldn't be happening - is this live on the web where we can see it?

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/



SS said:
Hi

When creating a form to be able to update it automatically puts the
arrows at the bottom but they seem to be the wrong way around ie you
have to press
to go back one and < to go forward one.
Click to expand...

Can anyone one work out in the script what I have to change to make
it more logical so that the person presses < to go back and > to go
forward.

<!--webbot bot="DatabaseRegionEnd" startspan b-tableformat="FALSE"

b-menuformat="FALSE" u-dbrgn2="../../../_fpclass/fpdbrgn2.inc"

i-groupsize="1" clientside tag="BODY"

local_preview="&lt;table border=0
width=&quot;100%&quot;&gt;&lt;tr&gt;&lt;td bgcolor=&quot;#FFFF00&quot;
align=&quot;center&quot;&gt;&lt;font color=&quot;#000000&quot;&gt;End
of Database Results
region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&lt;TR&gt;&lt;TD ALIGN=LEFT
VALIGN=MIDDLE&gt;&lt;FORM&gt;&lt;NOBR&gt;&lt;INPUT TYPE=Button
VALUE=&quot; |&lt; &quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot;
&lt; &quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot; &gt;
&quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot; &gt;| &quot;&gt;
[1/1]&lt;/NOBR&gt;&lt;/FORM&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;"

preview="&lt;table border=0
width=&quot;100%&quot;&gt;&lt;tr&gt;&lt;td
bgcolor=&quot;#FFFF00&quot; align=&quot;left&quot;&gt;&lt;font
color=&quot;#000000&quot;&gt;This is the end of a Database Results
region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&lt;TR&gt;&lt;TD ALIGN=LEFT
VALIGN=MIDDLE&gt;&lt;NOBR&gt;&lt;INPUT TYPE=Button VALUE=&quot;
|&lt; &quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot; &lt;
&quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot; &gt;
&quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot; &gt;| &quot;&gt;
[1/1]&lt;/NOBR&gt;&lt;BR&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;"
--><!--#in clude file="../../../_fpclass/fpdbrgn2.inc"-->

<!--webbot bot="DatabaseRegionEnd" endspan i-CheckSum="9297" -->



Any help would be great thanks Shona.
Click to expand...
 
S

Stefan B Rusynko

When you say backwards it is relative to the way your DB is sorted and called (if sorted in reverse order)
- the button are scrolling thru the records in the sequence in your DB or any sort applied in the DBRW



| No I'm afraid it isn't it's on an Intranet site
|
| message | > That shouldn't be happening - is this live on the web where we can see it?
| >
| > --
| >
| > ~ Kathleen Anderson
| > Microsoft MVP - FrontPage
| > Spider Web Woman Designs
| > web: http://www.spiderwebwoman.com/resources/
| >
| >
|
|
 
S

SS

Ah thanks

Don't suppose you know how I could change the buttons though so it looks OK
to the person using them? Still wanted it sorted highest number first.

Cheers Shona
Stefan B Rusynko said:
When you say backwards it is relative to the way your DB is sorted and
Click to expand...
called (if sorted in reverse order)
- the button are scrolling thru the records in the sequence in your DB or any sort applied in the DBRW
Click to expand...
[/QUOTE]
 
S

SS

OK thanks as I want highest number first as hopefully that is the one that
the persons needs to update most of the time then Idon't think it can be
done unless it can be done in the custom query somehow which is

Update DISTINCTROW results
SET
Approve='::Approve::',Reject='::Reject::',Approve1='::Approve1::',Reject1=':
:Reject1::',
Approve2='::Approve2::',Reject2='::Reject2::',Approve3='::Approve3::',Reject
3='::Reject3::',
Approve4='::Approve4::',Reject4='::Reject4::',Approve5='::Approve5::',Reject
5='::Reject5::',
Approve6='::Approve6::',Reject6='::Reject6::',Comments='::Comments::',Commen
ts1='::Comments1::',
Comments2='::Comments2::',Comments3='::Comments3::',Comments4='::Comments4::
',Comments5='::Comments5::',
Comments6='::Comments6::'
WHERE ID=::ID::
 
M

MikeR

Shona -
The buttons are defined in the
&lt;INPUT TYPE=Button VALUE=&quot; |&lt; &quot;&gt;
statements buried in the stuff FP produced.
In straight HTML this would look like
<INPUT TYPE=Button Value="<">
to change the arrow to point the other way, the statement
would be
&lt;INPUT TYPE=Button VALUE=&quot; |&gt; &quot;&gt;

&lt; = < &gt; = >
I have no idea if you can edit web-bot code directly. I suspect not. Sort is a
display idea. The database doesn't care, and is only sorted if data is entered
sorted. I didn't see an "order by" clause in your query, but I don't use the DRW
and don't know how it works.

Hope this is of some help....
MikeR
Hi

When creating a form to be able to update it automatically puts the arrows
at the bottom but they seem to be the wrong way around ie you have to press
to go back one and < to go forward one.
Click to expand...


Can anyone one work out in the script what I have to change to make it more
logical so that the person presses < to go back and > to go forward.

<!--webbot bot="DatabaseRegionEnd" startspan b-tableformat="FALSE"

b-menuformat="FALSE" u-dbrgn2="../../../_fpclass/fpdbrgn2.inc"

i-groupsize="1" clientside tag="BODY"

local_preview="&lt;table border=0
width=&quot;100%&quot;&gt;&lt;tr&gt;&lt;td bgcolor=&quot;#FFFF00&quot;
align=&quot;center&quot;&gt;&lt;font color=&quot;#000000&quot;&gt;End of
Database Results region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&lt;TR&gt;&lt;TD
ALIGN=LEFT VALIGN=MIDDLE&gt;&lt;FORM&gt;&lt;NOBR&gt;&lt;INPUT TYPE=Button
VALUE=&quot; |&lt; &quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot; &lt;
&quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot; &gt; &quot;&gt;&lt;INPUT
TYPE=Button VALUE=&quot; &gt;| &quot;&gt;
[1/1]&lt;/NOBR&gt;&lt;/FORM&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;"

preview="&lt;table border=0 width=&quot;100%&quot;&gt;&lt;tr&gt;&lt;td
bgcolor=&quot;#FFFF00&quot; align=&quot;left&quot;&gt;&lt;font
color=&quot;#000000&quot;&gt;This is the end of a Database Results
region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&lt;TR&gt;&lt;TD ALIGN=LEFT
VALIGN=MIDDLE&gt;&lt;NOBR&gt;&lt;INPUT TYPE=Button VALUE=&quot; |&lt;
&quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot; &lt; &quot;&gt;&lt;INPUT
TYPE=Button VALUE=&quot; &gt; &quot;&gt;&lt;INPUT TYPE=Button
VALUE=&quot; &gt;| &quot;&gt;
[1/1]&lt;/NOBR&gt;&lt;BR&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;" --><!--#in
clude file="../../../_fpclass/fpdbrgn2.inc"-->

<!--webbot bot="DatabaseRegionEnd" endspan i-CheckSum="9297" -->



Any help would be great thanks Shona.
Click to expand...
 
S

SS

Thanks for that unfortunately it doesn't change looks like I will just have
to live with it!

Thanks Again
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I am trying to understand this code... 3
@ my wits end 1
any ideas why I can update one table in my database but not the other? 2
Please help, FP generated code produces a "Too few parameters. Expected1" error! 7
DRW manual code 4
Database Results Error 1
Select statement aanpassen in asp gedeelte middels variable 1
DataBase results Error continued 1

Top