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, WebMerchant11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMasterSan Diego, CA 92128 | SiteGuard619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com
Associated Messages, from the most recent to the oldest:
>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, WebMerchant11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMasterSan Diego, CA 92128 | SiteGuard619/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)