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:
international time (1997)
[showif],[refferer],[include] in errormessages.db (2002)
Pipes instead of tabs (1998)
can you reassign loop index? (1998)
[SHOWIF] (1997)
Expiration of Carts (1997)
Not really WebCat - need HTML Grider (1997)
WCf2 and nested tags (1997)
More on ShippingCost help needed (1998)
IIS Brain Dead (1998)
Generating Report Totals (1997)
WCS Newbie question (1997)
Using [Include] Context (1999)
WebCat b13 CGI -shownext- (1997)
Date field search needs ... (1998)
Re:2nd WebCatalog2 Feature Request (1996)
So many lookers, hey smith micro (2003)
ShowNext & Showif together (1999)
Adding insurance to an order, round 2 (2003)
show me your store ! (2003)