Pagination problem

Wonding if anyone knows how to solve this:

The problem that I have with Pagination, is the the url that Dreamweaver
creates ...

When pagination script first loads, it returns:
www.msite.com/view.php?pageNum_rsMyQuery=0
This represents the 1st page (currently on the first page)

When I click the Next link, the next page that loads displays:
www.msite.com/view.php?pageNum_rsMyQuery=1
This represents the 2nd page (currently on the 2nd page)

So the results that are being returned are correct. Its just the url that
seems out of step with the data that is being displayed. What do I need to do
so that I can get it to behave such that:

When pagination script first loads, it returns:
www.msite.com/view.php?pageNum_rsMyQuery=1
This represents the 1st page (currently on the first page)

etc.

Has anyone else ever wondered whe dreamweaver operates this way????
??????

thanks
Jay

It's not DW that operates this way, it's how things work with zero-based
numbering. The first element in this case is element zero, and so on, as
you describe.

--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
==================


"2009Jay" <webforumsuser (AT) macromedia (DOT) com> wrote

Wonding if anyone knows how to solve this:

The problem that I have with Pagination, is the the url that Dreamweaver
creates ...

When pagination script first loads, it returns:
www.msite.com/view.php?pageNum_rsMyQuery=0
This represents the 1st page (currently on the first page)

When I click the Next link, the next page that loads displays:
www.msite.com/view.php?pageNum_rsMyQuery=1
This represents the 2nd page (currently on the 2nd page)

So the results that are being returned are correct. Its just the url that
seems out of step with the data that is being displayed. What do I need to
do
so that I can get it to behave such that:

When pagination script first loads, it returns:
www.msite.com/view.php?pageNum_rsMyQuery=1
This represents the 1st page (currently on the first page)

etc.

Has anyone else ever wondered whe dreamweaver operates this way????
??????

thanks
Jay

Thanks Murry

I understand, and suspected that this was the case.

But is there a workaround?

Most sites with pagination employed on them, do not have "page3" in the url
when they are really displaying results from page2!? So just wondering how they
do it, and if some workaround can be used within Dreamweaver.

You gotta admit - the dreamweaver 'solution' is not really completely
intuitive/ideal --- ie. "page3" url vs page2 results.

Cheers
Jay

But is there a workaround?

Why even bother?

Most sites with pagination employed on them, do not have "page3" in the
url
when they are really displaying results from page2!?

Show me one, please.

You gotta admit - the dreamweaver 'solution' is not really completely
intuitive/ideal --- ie. "page3" url vs page2 results.

It's not a DW "solution". It's real life. This is not a system cooked up
by DW. It's just the way you do it.

--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
==================


"2009Jay" <webforumsuser (AT) macromedia (DOT) com> wrote

Thanks Murry

I understand, and suspected that this was the case.

But is there a workaround?

Most sites with pagination employed on them, do not have "page3" in the
url
when they are really displaying results from page2!? So just wondering how
they
do it, and if some workaround can be used within Dreamweaver.

You gotta admit - the dreamweaver 'solution' is not really completely
intuitive/ideal --- ie. "page3" url vs page2 results.

Cheers
Jay

Murray *ACE* wrote:

But is there a workaround?

Why even bother?

Most sites with pagination employed on them, do not have "page3" in
the url
when they are really displaying results from page2!?

Show me one, please.

I have created custom pagination using the above. It uses ASP/MSSQL with
a stored procedure to do the pagination. It was more efficient to return
just the number or records rather than the entire recordset and then
page through them. I don't think PHP/MySQL has this same issue.

Dooza

hey Murry Ace ...

check out:
http://www.phpfreaks.com/tutorial/basic-pagination/page1

(quick search on google: pagination, php)

Page 1 in the nav links selected .... Page 1 in the url !!!! seems VERY
intuitive to me.

Now Im really interested to see why DW doesnt do something equally as
intuitive? For such a hard core app, it seems slightly deficient in this area?

2009Jay wrote:

hey Murry Ace ...

check out:
http://www.phpfreaks.com/tutorial/basic-pagination/page1

(quick search on google: pagination, php)

Page 1 in the nav links selected .... Page 1 in the url !!!! seems VERY
intuitive to me.

Now Im really interested to see why DW doesnt do something equally as
intuitive? For such a hard core app, it seems slightly deficient in this area?

The server behaviours haven't been upgraded or looked at since DW8.02,
and they really do need a good overhaul. If you think Adobe should
address any particular problem suggest it here:
http://www.adobe.com/cfusion/mmform/index.cfm?name=wishform

Dooza
--
Posting Guidelines
http://www.adobe.com/support/forums/guidelines.html
How To Ask Smart Questions
http://www.catb.org/esr/faqs/smart-questions.html
How To Report A Bug To Adobe
http://www.adobe.com/cfusion/mmform/index.cfm?name=wishform

Cheers Dooza ... will do that.

However, back to my original question ...

Does anyone know of a Dreamweaver workaround to cope with this deficiency (or
until Server Bahaviours are finally updated)?

Cheers
Jay

2009Jay posted in macromedia.dreamweaver

Cheers Dooza ... will do that.

However, back to my original question ...

Does anyone know of a Dreamweaver workaround to cope with this
deficiency (or until Server Bahaviours are finally updated)?

It is not a deficiency. It is how computers count. If you prefer to use
a different number then you can edit the PHP generated by the
behaviors. They may not work /within/ DW after editing, but will give
you the desired effect.

Probably just a matter of adding 1 to the link parameter and
subtracting 1 from its value in the $_GET array - at least where it
gets used in a query. I'm not familiar with those behaviors, so you may
need to tweak a minimum or maximum value, too.


--
Mark A. Boyd
Keep-On-Learnin'