Re: Paging a SQL result...
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 53235
interpreted = N
texte = 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/
Associated Messages, from the most recent to the oldest:
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/
John Hill
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:
changing banners on a page without refresh? (2000)
Upgrading old WebCat Database Files (1997)
using showpage and showcart commands (1996)
Cache headers - WebDNA 5 (2005)
Rollovers (1999)
Resume Catalog ? (1997)
WebCat2 beta 11 - new prefs ... (1997)
404 error -- but wc code executes... (2001)
upgrading (1997)
RequiredFields parameter (1998)
select multiple 2 more cents (1997)
Removing [showif] makes a big difference in speed (1997)
WebCatalog Use Question (1997)
Searching multiple Databases (1997)
FIXED: STILL not starting on bootup (2002)
cookies OSX Jaguar IE5.2 (2002)
[WebDNA] listfiles weirdness? (2018)
emailer (1997)
Add message to Order (1997)
[format xs] freeze (1997)