Re: Providing hard copy of database to client

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 14123
interpreted = N
texte = >We have a client who adds and removes items from a database remotely and >who also has items removed automatically with a WebCatalog order. > >What would be a good method for him to be able to select a link on a page >which would then: > >1) Sort the database >2) Write it to a tab-delimited text file >3) Provide him a link to download the fileI'd create an embedded search context that has an [AppendFile] inside of it that dumps out the desired text, like so:[WriteFile datadump.txt]Here's the latest! [/WriteFile][Search db=products.db&neSKUdata=0&SKUsort=1&SKUsdir=as] [FoundItems] [AppendFile datadump.txt][SKU],[Title],[Description],[Price] [/AppendFile] [/FoundItems]Look at the file I just wroteGrant Hulbert, V.P. Engineering | ==== eCommerce for the Rest of Us ==== Pacific Coast Software | WebCatalog, WebMerchant 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster San Diego, CA 92128 | SiteGuard 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com Associated Messages, from the most recent to the oldest:

    
  1. Re: Providing hard copy of database to client (Grant Hulbert 1997)
  2. Providing hard copy of database to client (Ed Trefzger 1997)
>We have a client who adds and removes items from a database remotely and >who also has items removed automatically with a WebCatalog order. > >What would be a good method for him to be able to select a link on a page >which would then: > >1) Sort the database >2) Write it to a tab-delimited text file >3) Provide him a link to download the fileI'd create an embedded search context that has an [appendfile] inside of it that dumps out the desired text, like so:[WriteFile datadump.txt]Here's the latest! [/WriteFile][Search db=products.db&neSKUdata=0&SKUsort=1&SKUsdir=as] [founditems] [AppendFile datadump.txt][SKU],[Title],[Description],[Price] [/AppendFile] [/FoundItems]Look at the file I just wroteGrant Hulbert, V.P. Engineering | ==== eCommerce for the Rest of Us ==== Pacific Coast Software | WebCatalog, WebMerchant 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster San Diego, CA 92128 | SiteGuard 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com Grant Hulbert

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:

Separate SSL Server (1997) Million product store (2003) catagories (1997) Not really WebCat (1997) [WebDNA] Encryptng a password (2016) Re:2nd WebCatalog2 Feature Request (1996) Return records from another (1997) Everyone: List Traffic (was [include ...] behavior) (1997) [Search] on Remote Database (2000) [Fwd: Email Format] (1998) WebCatalog NT beta 18 problem (1997) WebCatalog can't find database (1997) Re:quit command on NT (1997) Finding max value for a field (1997) WebCat2b15MacPlugin - [protect] (1997) [WebDNA] PayPal IPN (was: paypal FINALLY!!!!) (2009) Multiple Ad databases? (1997) Trouble with formula.db (1997) Converting Esiting Html Table Forms to WebCat (1997) How to put the Trademark Symbol (%99) in Sendmail? (2003)