Paging a SQL result...

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 53231
interpreted = N
texte = 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/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Paging a SQL result... ( "WebDna @" 2003)
  2. Re: Paging a SQL result... ( John Hill 2003)
  3. Re: Paging a SQL result... ( "WebDna @" 2003)
  4. Re: Paging a SQL result... ( John Hill 2003)
  5. Paging a SQL result... ( "Morten Madsen" 2003)
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/ "Morten Madsen"

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:

I'll Know If You Don't Read This (2006) Re[2]: when is failing to [URL]ize values in a comparison ri (1999) Username for Admin Group (1997) Mac 2.1b2 speed (1997) Problems with [Search] param - Mac Plugin b15 (1997) WebCat2 - Getting to the browser's username/password data (1997) Email Formatting and Encryption (1998) Hairy Shipping Monster (2006) storebuilder problems on RedHat 6.1 with webcat 3.08 (2000) Problems passing [SKU] with $Replace in 2.0 (1997) Bug or syntax error on my part? (1997) How to append text after the sign & (1997) WCS Newbie question (1997) Need formatting help (1998) dates and hex formatting (1997) delete fails (2000) Webcatalog quitting (1997) Help with Repost Data msg from form (1997) Pirated WebCat? NOT... (2003) DataBaseHelper Flawed (1997)