This is brilliant! Just look how long it is! Ha ha ha ha ha ha

[John Rivers]

http://www.15seconds.com/Issue/030812.htm?voteresult=1

poor guy worked his heart out, just to make a page control

and then they published it

ha ha ha ha ha

to "help" others

ha ha ha ha ha ha

just imagine the face of a newbie looking at that mountain of code

apparently he researched how to do it in books

my god i would love to watch this guy tie his shoelaces

it must take hours and involve lots of complex mathematics

ha ha ha ha

maybe the poor guy's hourly rate is so low he has to overcomplicate
everything just to pay the rent

ha ha ha ha

imagine him working through the night
"i'll make the best page control, ever!"

i've got it! he hates newbies ... so he publishes ridiculous
articles to demoralise them and drain their energy

doesn't tell them that a generic page control is just 10 lines
of code that a monkey could write HE'S EVIL

extract from his article:

"Effectivel y showing code so it confuses newbies is a main objective
in writing almost all my web articles. Showing 20 lines of code in an
article is unbearable but showing 10,000 certainly can be helpful.
Writing good code, is a commonly employed solution, that I do not
recommend."

[VB Programmer]

Can you post 10 sample lines of code to do this? Just wondering what it
would look like from your vantage pt.

Thanks!

"John Rivers" <fi*****@btinte rnet.com> wrote in message
news:11******** *************@z 14g2000cwz.goog legroups.com...

http://www.15seconds.com/Issue/030812.htm?voteresult=1

poor guy worked his heart out, just to make a page control

and then they published it

ha ha ha ha ha

to "help" others

ha ha ha ha ha ha

just imagine the face of a newbie looking at that mountain of code

apparently he researched how to do it in books

my god i would love to watch this guy tie his shoelaces

it must take hours and involve lots of complex mathematics

ha ha ha ha

maybe the poor guy's hourly rate is so low he has to overcomplicate
everything just to pay the rent

ha ha ha ha

imagine him working through the night
"i'll make the best page control, ever!"

i've got it! he hates newbies ... so he publishes ridiculous
articles to demoralise them and drain their energy

doesn't tell them that a generic page control is just 10 lines
of code that a monkey could write HE'S EVIL

extract from his article:

"Effectivel y showing code so it confuses newbies is a main objective
in writing almost all my web articles. Showing 20 lines of code in an
article is unbearable but showing 10,000 certainly can be helpful.
Writing good code, is a commonly employed solution, that I do not
recommend."

[John Timney \(ASP.NET MVP\)]

If it wasn't a good article it would not have made it onto 15seconds.
Credit to Tomasz for giving something back to the community.

Regards

John Timney
ASP.NET MVP
Microsoft Regional Director

"John Rivers" <fi*****@btinte rnet.com> wrote in message
news:11******** *************@z 14g2000cwz.goog legroups.com...

http://www.15seconds.com/Issue/030812.htm?voteresult=1

poor guy worked his heart out, just to make a page control

and then they published it

ha ha ha ha ha

to "help" others

ha ha ha ha ha ha

just imagine the face of a newbie looking at that mountain of code

apparently he researched how to do it in books

my god i would love to watch this guy tie his shoelaces

it must take hours and involve lots of complex mathematics

ha ha ha ha

maybe the poor guy's hourly rate is so low he has to overcomplicate
everything just to pay the rent

ha ha ha ha

imagine him working through the night
"i'll make the best page control, ever!"

i've got it! he hates newbies ... so he publishes ridiculous
articles to demoralise them and drain their energy

doesn't tell them that a generic page control is just 10 lines
of code that a monkey could write HE'S EVIL

extract from his article:

"Effectivel y showing code so it confuses newbies is a main objective
in writing almost all my web articles. Showing 20 lines of code in an
article is unbearable but showing 10,000 certainly can be helpful.
Writing good code, is a commonly employed solution, that I do not
recommend."

[John Rivers]

with pleasure,

this is exactly ten lines of code (exluding the function declaration
and html stuff)

excuse the classicasp, i had it handy

Function PageControl(Pag eNumber, PageCount)
Const PropName = "PageNumber "
%><table width="100%" cellpadding="4" cellspacing="0"
bgcolor="#EEEEE E">
<!---->
<tr>
<td nowrap><%="Page " & PageNumber & " of " & PageCount%></td>
<td align="right" nowrap><b><%
Dim URL
URL = ThisPage & StripQueryStrin g(Request.Query String, PropName)
If PageNumber > 1 Then
%>[<a href="<%=HTML(U RL & QPX(PropName, 1))%>">First</a>]
[<a href="<%=HTML(U RL & QPX(PropName, PageNumber - 1))%>">Prev</a>]<%
Else
%><span style="color:#C CCCCC">[First]
[Prev]</span><%
End If
%>&nbsp;<%
If PageNumber < PageCount Then
%>[<a href="<%=HTML(U RL & QPX(PropName, PageNumber + 1))%>">Next</a>]
[<a href="<%=HTML(U RL & QPX(PropName, PageCount))%>"> Last</a>]<%
Else
%><span style="color:#C CCCCC">[Next]
[Last]</span><%
End If
%></b></td>
</tr>
<!---->
</table><%
End Function

(HTML is convenience function to save typing Server.HTMLEnco de etc.)
(QPX is shorthand for Server.URLEncod e(name) & "+" &
Server.URLEncod e(value) & "&")
(StripQueryStri ng returns the given querystring minus the given
parameter)

and of course i would have done the paging logic in a stored procedure
rather than repeatedly transferring piles of data about for no reason
like that idiotic "datagrid" control does

which i can show you here:

CREATE proc spTestCursorPag ination
@start int
, @size int
as
--
declare CRS cursor scroll read_only for select recordid from junk
(tablock) order by recordid
declare @index int
declare @recordid int
--
create table #temp (
orderid int primary key identity
, recordid int
)
set nocount on
set @index = 0
open CRS
--
while @index < @size
begin
if @index = 0
fetch absolute @start from CRS into @recordid
else
fetch next from CRS into @recordid
insert into #temp with (tablockx) (recordid) values (@recordid)
set @index = @index + 1
end
--
close CRS
deallocate CRS
--
select junk.* from junk (tablock)
inner join #temp (tablock)
on junk.recordid = #temp.recordid
order by #temp.orderid
--(end)
and i didn't need to read a book to do that
i just used my brain and 20 minutes

plus if you test my solution on a db of 10,000,000
records it will run faster than his junk with 10,000
records and use much less ram and cpu and network resources

www.15seconds.com is useful but most of the articles are total tripe

welcome to the layer cake son


VB Programmer wrote:

Can you post 10 sample lines of code to do this? Just wondering what it
would look like from your vantage pt.

Thanks!

"John Rivers" <fi*****@btinte rnet.com> wrote in message
news:11******** *************@z 14g2000cwz.goog legroups.com...

http://www.15seconds.com/Issue/030812.htm?voteresult=1

poor guy worked his heart out, just to make a page control

and then they published it

ha ha ha ha ha

to "help" others

ha ha ha ha ha ha

just imagine the face of a newbie looking at that mountain of code

apparently he researched how to do it in books

my god i would love to watch this guy tie his shoelaces

it must take hours and involve lots of complex mathematics

ha ha ha ha

maybe the poor guy's hourly rate is so low he has to overcomplicate
everything just to pay the rent

ha ha ha ha

imagine him working through the night
"i'll make the best page control, ever!"

i've got it! he hates newbies ... so he publishes ridiculous
articles to demoralise them and drain their energy

doesn't tell them that a generic page control is just 10 lines
of code that a monkey could write HE'S EVIL

extract from his article:

"Effectivel y showing code so it confuses newbies is a main objective
in writing almost all my web articles. Showing 20 lines of code in an
article is unbearable but showing 10,000 certainly can be helpful.
Writing good code, is a commonly employed solution, that I do not
recommend."

[Juan T. Llibre]

re:

"Effectivel y showing code so it confuses newbies is a main objective
in writing almost all my web articles. Showing 20 lines of code in an
article is unbearable but showing 10,000 certainly can be helpful.
Actual text in the article :
"Effectivel y showing data so it doesn't confuse the end user is a main
objective in developing almost all Web data presentation applications.
Showing 20 records on one page is bearable but showing 10,000
certainly can be confusing."

re: Writing good code, is a commonly employed solution, that I do not
recommend."
Actual text in the article :
"Splitting the data across several pages, or paging the data,
is a commonly employed solution to this problem."

It's simply amazing that you would stoop this low, troll!
Go be a jerk somewhere else.

Juan T. Llibre
ASP.NET MVP
http://asp.net.do/foros/
Foros de ASP.NET en Español
Ven, y hablemos de ASP.NET...
=============== =======

"John Rivers" <fi*****@btinte rnet.com> wrote in message
news:11******** *************@z 14g2000cwz.goog legroups.com... http://www.15seconds.com/Issue/030812.htm?voteresult=1

poor guy worked his heart out, just to make a page control

and then they published it

ha ha ha ha ha

to "help" others

ha ha ha ha ha ha

just imagine the face of a newbie looking at that mountain of code

apparently he researched how to do it in books

my god i would love to watch this guy tie his shoelaces

it must take hours and involve lots of complex mathematics

ha ha ha ha

maybe the poor guy's hourly rate is so low he has to overcomplicate
everything just to pay the rent

ha ha ha ha

imagine him working through the night
"i'll make the best page control, ever!"

i've got it! he hates newbies ... so he publishes ridiculous
articles to demoralise them and drain their energy

doesn't tell them that a generic page control is just 10 lines
of code that a monkey could write HE'S EVIL

extract from his article:

"Effectivel y showing code so it confuses newbies is a main objective
in writing almost all my web articles. Showing 20 lines of code in an
article is unbearable but showing 10,000 certainly can be helpful.
Writing good code, is a commonly employed solution, that I do not
recommend."

[Juan T. Llibre]

You should submit that "improvemen t" to 15Seconds.

Juan T. Llibre
ASP.NET MVP
http://asp.net.do/foros/
Foros de ASP.NET en Español
Ven, y hablemos de ASP.NET...
=============== =======

"John Rivers" <fi*****@btinte rnet.com> wrote in message
news:11******** **************@ o13g2000cwo.goo glegroups.com.. .

with pleasure,

this is exactly ten lines of code (exluding the function declaration
and html stuff)

excuse the classicasp, i had it handy

Function PageControl(Pag eNumber, PageCount)
Const PropName = "PageNumber "
%><table width="100%" cellpadding="4" cellspacing="0"
bgcolor="#EEEEE E">
<!---->
<tr>
<td nowrap><%="Page " & PageNumber & " of " & PageCount%></td>
<td align="right" nowrap><b><%
Dim URL
URL = ThisPage & StripQueryStrin g(Request.Query String, PropName)
If PageNumber > 1 Then
%>[<a href="<%=HTML(U RL & QPX(PropName, 1))%>">First</a>]
[<a href="<%=HTML(U RL & QPX(PropName, PageNumber - 1))%>">Prev</a>]<%
Else
%><span style="color:#C CCCCC">[First]
[Prev]</span><%
End If
%>&nbsp;<%
If PageNumber < PageCount Then
%>[<a href="<%=HTML(U RL & QPX(PropName, PageNumber + 1))%>">Next</a>]
[<a href="<%=HTML(U RL & QPX(PropName, PageCount))%>"> Last</a>]<%
Else
%><span style="color:#C CCCCC">[Next]
[Last]</span><%
End If
%></b></td>
</tr>
<!---->
</table><%
End Function

(HTML is convenience function to save typing Server.HTMLEnco de etc.)
(QPX is shorthand for Server.URLEncod e(name) & "+" &
Server.URLEncod e(value) & "&")
(StripQueryStri ng returns the given querystring minus the given
parameter)

and of course i would have done the paging logic in a stored procedure
rather than repeatedly transferring piles of data about for no reason
like that idiotic "datagrid" control does

which i can show you here:

CREATE proc spTestCursorPag ination
@start int
, @size int
as
--
declare CRS cursor scroll read_only for select recordid from junk
(tablock) order by recordid
declare @index int
declare @recordid int
--
create table #temp (
orderid int primary key identity
, recordid int
)
set nocount on
set @index = 0
open CRS
--
while @index < @size
begin
if @index = 0
fetch absolute @start from CRS into @recordid
else
fetch next from CRS into @recordid
insert into #temp with (tablockx) (recordid) values (@recordid)
set @index = @index + 1
end
--
close CRS
deallocate CRS
--
select junk.* from junk (tablock)
inner join #temp (tablock)
on junk.recordid = #temp.recordid
order by #temp.orderid
--(end)
and i didn't need to read a book to do that
i just used my brain and 20 minutes

plus if you test my solution on a db of 10,000,000
records it will run faster than his junk with 10,000
records and use much less ram and cpu and network resources

www.15seconds.com is useful but most of the articles are total tripe

welcome to the layer cake son


VB Programmer wrote:

Can you post 10 sample lines of code to do this? Just wondering what it
would look like from your vantage pt.

Thanks!

"John Rivers" <fi*****@btinte rnet.com> wrote in message
news:11******** *************@z 14g2000cwz.goog legroups.com...

> http://www.15seconds.com/Issue/030812.htm?voteresult=1
>
> poor guy worked his heart out, just to make a page control
>
> and then they published it
>
> ha ha ha ha ha
>
> to "help" others
>
> ha ha ha ha ha ha
>
> just imagine the face of a newbie looking at that mountain of code
>
> apparently he researched how to do it in books
>
> my god i would love to watch this guy tie his shoelaces
>
> it must take hours and involve lots of complex mathematics
>
> ha ha ha ha
>
> maybe the poor guy's hourly rate is so low he has to overcomplicate
> everything just to pay the rent
>
> ha ha ha ha
>
> imagine him working through the night
> "i'll make the best page control, ever!"
>
> i've got it! he hates newbies ... so he publishes ridiculous
> articles to demoralise them and drain their energy
>
> doesn't tell them that a generic page control is just 10 lines
> of code that a monkey could write HE'S EVIL
>
> extract from his article:
>
> "Effectivel y showing code so it confuses newbies is a main objective
> in writing almost all my web articles. Showing 20 lines of code in an
> article is unbearable but showing 10,000 certainly can be helpful.
> Writing good code, is a commonly employed solution, that I do not
> recommend."
>

[John Rivers]

I was being mean, his intentions were good, but that article should
never have been published.

And credit to me then for just showing the community a lean and high
performance approach!

You wouldn't happen to know who at Microsoft was responsible for
designing
ASPX, UserControls, HtmlControls, CustomControls and viewstate would
you?

I am sure it wasn't the same people who designed the other parts of
ASP.NET.

John Timney (ASP.NET MVP) wrote:

If it wasn't a good article it would not have made it onto 15seconds.
Credit to Tomasz for giving something back to the community.

Regards

John Timney
ASP.NET MVP
Microsoft Regional Director

"John Rivers" <fi*****@btinte rnet.com> wrote in message
news:11******** *************@z 14g2000cwz.goog legroups.com...

http://www.15seconds.com/Issue/030812.htm?voteresult=1

poor guy worked his heart out, just to make a page control

and then they published it

[Juan T. Llibre]

Hey, John, do you think that the code you posted
meets the requirements for the posted code in the article ?

1. First, Previous, Next, Last and paging buttons

2. Be sensitive to the data. If the pager is set to show 10 records
per page and only nine are shown, then the pager shouldn't be visible.
On the first page the Previous and First buttons shouldn't be shown.
On the last page the Next and the Last methods shouldn't be shown.

3. Independent of the control that's in charge of the presentation

4. The ability to handle a variety of current and future data sources

5. Easily configurable presentation to integrate with custom applications

6. Notify other controls when paging is taking place

7. Easy to use even by inexperienced Web designers

8. Provide properties to relevant paging data

The code you posted doesn't even come *close* to doing that.
Go be a jerk somewhere else.

Juan T. Llibre
ASP.NET MVP
http://asp.net.do/foros/
Foros de ASP.NET en Español
Ven, y hablemos de ASP.NET...
=============== =======

"John Rivers" <fi*****@btinte rnet.com> wrote in message
news:11******** **************@ o13g2000cwo.goo glegroups.com.. .

I was being mean, his intentions were good, but that article should
never have been published.

And credit to me then for just showing the community a lean and high
performance approach!

You wouldn't happen to know who at Microsoft was responsible for
designing
ASPX, UserControls, HtmlControls, CustomControls and viewstate would
you?

I am sure it wasn't the same people who designed the other parts of
ASP.NET.

John Timney (ASP.NET MVP) wrote:

If it wasn't a good article it would not have made it onto 15seconds.
Credit to Tomasz for giving something back to the community.

Regards

John Timney
ASP.NET MVP
Microsoft Regional Director

"John Rivers" <fi*****@btinte rnet.com> wrote in message
news:11******** *************@z 14g2000cwz.goog legroups.com...

> http://www.15seconds.com/Issue/030812.htm?voteresult=1
>
> poor guy worked his heart out, just to make a page control
>
> and then they published it
>

[Bruce Barker]

well the article covered paging with a grid, asp.net events, the standard
process controller pattern, and is plugable into a generic application.

not a bad exercise.

-- bruce (sqlwork.com)
"John Rivers" <fi*****@btinte rnet.com> wrote in message
news:11******** *************@z 14g2000cwz.goog legroups.com...

http://www.15seconds.com/Issue/030812.htm?voteresult=1

poor guy worked his heart out, just to make a page control

and then they published it

ha ha ha ha ha

to "help" others

ha ha ha ha ha ha

just imagine the face of a newbie looking at that mountain of code

apparently he researched how to do it in books

my god i would love to watch this guy tie his shoelaces

it must take hours and involve lots of complex mathematics

ha ha ha ha

maybe the poor guy's hourly rate is so low he has to overcomplicate
everything just to pay the rent

ha ha ha ha

imagine him working through the night
"i'll make the best page control, ever!"

i've got it! he hates newbies ... so he publishes ridiculous
articles to demoralise them and drain their energy

doesn't tell them that a generic page control is just 10 lines
of code that a monkey could write HE'S EVIL

extract from his article:

"Effectivel y showing code so it confuses newbies is a main objective
in writing almost all my web articles. Showing 20 lines of code in an
article is unbearable but showing 10,000 certainly can be helpful.
Writing good code, is a commonly employed solution, that I do not
recommend."

[Bruce Barker]

you don't solve the same problem. your code is not a generic plugin to be
used on any page. your html may be generic, but the driving code isn't, nor
was it included. in you model every page must implement the paging code.

also you demo rather bad sql. (using a server curor and a table lock - no
scaling this puppy). also to get the total page count, another query is
required.

-- bruce (sqlwork.com)

"John Rivers" <fi*****@btinte rnet.com> wrote in message
news:11******** **************@ o13g2000cwo.goo glegroups.com.. .

with pleasure,

this is exactly ten lines of code (exluding the function declaration
and html stuff)

excuse the classicasp, i had it handy

Function PageControl(Pag eNumber, PageCount)
Const PropName = "PageNumber "
%><table width="100%" cellpadding="4" cellspacing="0"
bgcolor="#EEEEE E">
<!---->
<tr>
<td nowrap><%="Page " & PageNumber & " of " & PageCount%></td>
<td align="right" nowrap><b><%
Dim URL
URL = ThisPage & StripQueryStrin g(Request.Query String, PropName)
If PageNumber > 1 Then
%>[<a href="<%=HTML(U RL & QPX(PropName, 1))%>">First</a>]
[<a href="<%=HTML(U RL & QPX(PropName, PageNumber - 1))%>">Prev</a>]<%
Else
%><span style="color:#C CCCCC">[First]
[Prev]</span><%
End If
%>&nbsp;<%
If PageNumber < PageCount Then
%>[<a href="<%=HTML(U RL & QPX(PropName, PageNumber + 1))%>">Next</a>]
[<a href="<%=HTML(U RL & QPX(PropName, PageCount))%>"> Last</a>]<%
Else
%><span style="color:#C CCCCC">[Next]
[Last]</span><%
End If
%></b></td>
</tr>
<!---->
</table><%
End Function

(HTML is convenience function to save typing Server.HTMLEnco de etc.)
(QPX is shorthand for Server.URLEncod e(name) & "+" &
Server.URLEncod e(value) & "&")
(StripQueryStri ng returns the given querystring minus the given
parameter)

and of course i would have done the paging logic in a stored procedure
rather than repeatedly transferring piles of data about for no reason
like that idiotic "datagrid" control does

which i can show you here:

CREATE proc spTestCursorPag ination
@start int
, @size int
as
--
declare CRS cursor scroll read_only for select recordid from junk
(tablock) order by recordid
declare @index int
declare @recordid int
--
create table #temp (
orderid int primary key identity
, recordid int
)
set nocount on
set @index = 0
open CRS
--
while @index < @size
begin
if @index = 0
fetch absolute @start from CRS into @recordid
else
fetch next from CRS into @recordid
insert into #temp with (tablockx) (recordid) values (@recordid)
set @index = @index + 1
end
--
close CRS
deallocate CRS
--
select junk.* from junk (tablock)
inner join #temp (tablock)
on junk.recordid = #temp.recordid
order by #temp.orderid
--(end)
and i didn't need to read a book to do that
i just used my brain and 20 minutes

plus if you test my solution on a db of 10,000,000
records it will run faster than his junk with 10,000
records and use much less ram and cpu and network resources

www.15seconds.com is useful but most of the articles are total tripe

welcome to the layer cake son


VB Programmer wrote:

Can you post 10 sample lines of code to do this? Just wondering what it
would look like from your vantage pt.

Thanks!

"John Rivers" <fi*****@btinte rnet.com> wrote in message
news:11******** *************@z 14g2000cwz.goog legroups.com...

> http://www.15seconds.com/Issue/030812.htm?voteresult=1
>
> poor guy worked his heart out, just to make a page control
>
> and then they published it
>
> ha ha ha ha ha
>
> to "help" others
>
> ha ha ha ha ha ha
>
> just imagine the face of a newbie looking at that mountain of code
>
> apparently he researched how to do it in books
>
> my god i would love to watch this guy tie his shoelaces
>
> it must take hours and involve lots of complex mathematics
>
> ha ha ha ha
>
> maybe the poor guy's hourly rate is so low he has to overcomplicate
> everything just to pay the rent
>
> ha ha ha ha
>
> imagine him working through the night
> "i'll make the best page control, ever!"
>
> i've got it! he hates newbies ... so he publishes ridiculous
> articles to demoralise them and drain their energy
>
> doesn't tell them that a generic page control is just 10 lines
> of code that a monkey could write HE'S EVIL
>
> extract from his article:
>
> "Effectivel y showing code so it confuses newbies is a main objective
> in writing almost all my web articles. Showing 20 lines of code in an
> article is unbearable but showing 10,000 certainly can be helpful.
> Writing good code, is a commonly employed solution, that I do not
> recommend."
>