Re: Paging a SQL result...
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 53238
interpreted = N
texte = Why not just use the the LIMIT and offset? [!] ----------------- SET THE MAX # TO BE FOUND ------------------ [/!] [mathshow=f]maxfound=5[/math] [!] ------------------ CHECK TO SEE IF FIRST TIME VIEWING PAGE ------------------- [/!] [showif [offset]=[raw][offset][/raw]] [text]offset=0[/text] [math show=f]prev=-[maxfound][/math] [math show=f]next=+[maxfound][/math] [/showif] [showif [offset]!0] [math show=f]prev=[offset]-[maxfound][/math] [math show=f]next=[offset]+[maxfound][/math] [/showif] [!] -------------------------- THEN SET SELECT STATEMENT -------------------------- [/!] select * from FIELD ORDER BY 1 DESC LIMIT [offset],[maxfound] [!]--------------------------- NOW YOU CREATE YOUR PREV AND NEXT BUTTONS --------------------------- [/!]
Previous Next Grated this is how I do it in PHP. I have simply modified the creation of the variables to be webcat. If WebCat does not allow the LIMIT in the SQL query I do not know. I do not use SQL w/webcat. ----- Original Message ----- From: "John Hill"
To: "WebDNA Talk" Sent: Thursday, October 02, 2003 10:40 AM Subject: Re: Paging a SQL result... > The quick solution is to have [showif] or [if] statements in your [founditems] that show which rows you want. However, this means that huge result sets are still fully returned. This works just fine for smaller (a few hundred or less?) results. > > A cleaner solution would be to get SQL server to only return the rows you want. I don't believe WebCat can fetch just the specified rows, but you could probably write your own SQL or even stored procedure to do this for you. > > Contact me off list for some more specific ideas. > > John. > > >We run Webcatalog 4.5 and use MS SQL Server 2000 for the database - and it > >runs ok. > > > >But I have a problem i wish to devide a search result into pages... This is > >pretty easy when you use the Webcatalog flat files databases - there you > >could use the startat property. > > > >But when you use a SQL database things are not so simple... > > > >If you use ASP.NET, ASP or PHP there are ways to show the result in pages - > >but when you use webcatalog you have to do it in the SQL-statement (as I > >understand) > > > >I'm just curious - surely some of you guys can't manage with the "primitive" > >flat-file-db-system Webcatalog have to offer. So how have you made your > >solution to show result in pages in webdna from at sql database? > > > >Hope someone have a good solution.... > > > > > >Best regards > >Morten > > > > > > > >------------------------------------------------------------- > >This message is sent to you because you are subscribed to > > the mailing list . > >To unsubscribe, E-mail to: > >To switch to the DIGEST mode, E-mail to > >Web Archive of this list is at: http://webdna.smithmicro.com/ > > -- > > --------------------------------- > John A. Hill > Oak Hill Software > Website Development/Consulting > john@oakhillsoftware.com > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > Web Archive of this list is at: http://webdna.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Why not just use the the LIMIT and offset? [!] ----------------- SET THE MAX # TO BE FOUND ------------------ [/!] [mathshow=f]maxfound=5[/math] [!] ------------------ CHECK TO SEE IF FIRST TIME VIEWING PAGE ------------------- [/!] [showif [offset]=[raw][offset][/raw]] [text]offset=0[/text] [math show=f]prev=-[maxfound][/math] [math show=f]next=+[maxfound][/math] [/showif] [showif [offset]!0] [math show=f]prev=[offset]-[maxfound][/math] [math show=f]next=[offset]+[maxfound][/math] [/showif] [!] -------------------------- THEN SET SELECT STATEMENT -------------------------- [/!] select * from FIELD ORDER BY 1 DESC LIMIT [offset],[maxfound] [!]--------------------------- NOW YOU CREATE YOUR PREV AND NEXT BUTTONS --------------------------- [/!] [thisurl]?offset=[prev]> Previous [thisurl]?offset=[next]> Next Grated this is how I do it in PHP. I have simply modified the creation of the variables to be webcat. If WebCat does not allow the LIMIT in the SQL query I do not know. I do not use SQL w/webcat. ----- Original Message ----- From: "John Hill" To: "WebDNA Talk" Sent: Thursday, October 02, 2003 10:40 AM Subject: Re: Paging a SQL result... > The quick solution is to have [showif] or [if] statements in your [founditems] that show which rows you want. However, this means that huge result sets are still fully returned. This works just fine for smaller (a few hundred or less?) results. > > A cleaner solution would be to get SQL server to only return the rows you want. I don't believe WebCat can fetch just the specified rows, but you could probably write your own SQL or even stored procedure to do this for you. > > Contact me off list for some more specific ideas. > > John. > > >We run Webcatalog 4.5 and use MS SQL Server 2000 for the database - and it > >runs ok. > > > >But I have a problem i wish to devide a search result into pages... This is > >pretty easy when you use the Webcatalog flat files databases - there you > >could use the startat property. > > > >But when you use a SQL database things are not so simple... > > > >If you use ASP.NET, ASP or PHP there are ways to show the result in pages - > >but when you use webcatalog you have to do it in the SQL-statement (as I > >understand) > > > >I'm just curious - surely some of you guys can't manage with the "primitive" > >flat-file-db-system Webcatalog have to offer. So how have you made your > >solution to show result in pages in webdna from at sql database? > > > >Hope someone have a good solution.... > > > > > >Best regards > >Morten > > > > > > > >------------------------------------------------------------- > >This message is sent to you because you are subscribed to > > the mailing list . > >To unsubscribe, E-mail to: > >To switch to the DIGEST mode, E-mail to > >Web Archive of this list is at: http://webdna.smithmicro.com/ > > -- > > --------------------------------- > John A. Hill > Oak Hill Software > Website Development/Consulting > john@oakhillsoftware.com > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > Web Archive of this list is at: http://webdna.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
"WebDna @"
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
WebCat2b15MacPlugIn - [authenticate] not [protect] (1997)
Can you do this??? and other stuff (1997)
[AppendFile] problem (WebCat2b13 Mac .acgi) (1997)
Dates and Math - Simple Subtraction (2004)
RE: OK, here goes... (1997)
Integrated shipping (2004)
RE: Answer: WebDelivery downloads alias, not original ? (1997)
Is there a way......... (2000)
Force leading zeros (1998)
SSL and reg web* (1997)
cookies (2001)
different show next (1997)
Re:[ShowIf] and empty fields (1997)
WebCommerce: Folder organization ? (1997)
Range search (2003)
Not reading code (1997)
Summing fields (1997)
Text data with spaces in them... (1997)
Searching a field and returning the highest value (1997)
Wrapping text (1998)