RE: Clearing orders and database help!
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 13087
interpreted = N
texte = Jim ->On our catalog we get the CC # and order info manualy. >We do not use web-Merchant to process the orders. >How do we clear the orders from the folder after we are finished with them? >Can this be set into the ViewAll template as an option?Either you can just remove them from the 'Orders' file manually when you are done processing them (I'd actually recommend moving them to a 'Completed Orders' folder in case you ever need to review them), or you could write a small AppleScript that does the same thing automatically (or use the [AppleScript] context if you want to do it from a WebCatalog template.>I have a client that wants a searchable D-base set up: >the object: >Select> Location1 Select> Location2 >this is processed, and you get a distance value (value1) >(value1) is multiplied by (one of 4 values) to get a Cost >the catlalog will process it from there as normal ....Hmm.. it's mostly in how you decide to go about setting up your database. Depending on how many locations you have, you could either have the database contain records that list both locations (LA-Tokyo) and the distance between them, which would be a simple lookup but would require a lot of records, *or* you could have a database which contained records for each separate location and its coordinates (either the real longitude and latitude or some kind of x and y coordinates). For the second option, you'd have to do some playing around with the [math] context to get the distance between them (wish I'd paid a bit more attention in either Geometry or Geography classes, but I can't think of the formula offhand), but you wouldn't need as many records and it seems like this would be more flexible.Anyway, once you have the distance value, you could do a [lookup] in another database to get one of your 4 values (or just have it entered as a form variable), and use [math] again to multiply this with the distance to get your final cost.If you are planning on using this for [shipcost], you can put this same math in your formulas.db to have it calculate the shipping cost automatically.I hope this proves helpful,Marc Eagle StarNine Technologies http://www.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Jim ->On our catalog we get the CC # and order info manualy. >We do not use web-Merchant to process the orders. >How do we clear the orders from the folder after we are finished with them? >Can this be set into the ViewAll template as an option?Either you can just remove them from the 'Orders' file manually when you are done processing them (I'd actually recommend moving them to a 'Completed Orders' folder in case you ever need to review them), or you could write a small AppleScript that does the same thing automatically (or use the [AppleScript] context if you want to do it from a WebCatalog template.>I have a client that wants a searchable D-base set up: >the object: >Select> Location1 Select> Location2 >this is processed, and you get a distance value (value1) >(value1) is multiplied by (one of 4 values) to get a Cost >the catlalog will process it from there as normal ....Hmm.. it's mostly in how you decide to go about setting up your database. Depending on how many locations you have, you could either have the database contain records that list both locations (LA-Tokyo) and the distance between them, which would be a simple lookup but would require a lot of records, *or* you could have a database which contained records for each separate location and its coordinates (either the real longitude and latitude or some kind of x and y coordinates). For the second option, you'd have to do some playing around with the
[math] context to get the distance between them (wish I'd paid a bit more attention in either Geometry or Geography classes, but I can't think of the formula offhand), but you wouldn't need as many records and it seems like this would be more flexible.Anyway, once you have the distance value, you could do a
[lookup] in another database to get one of your 4 values (or just have it entered as a form variable), and use
[math] again to multiply this with the distance to get your final cost.If you are planning on using this for [shipcost], you can put this same math in your
formulas.db to have it calculate the shipping cost automatically.I hope this proves helpful,Marc Eagle StarNine Technologies http://www.smithmicro.com/
Marc Eagle
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:
Exclamation point (1997)
Apache 2.x (2003)
Ooops..Broswer Info.txt (was Web*SSL and WebCatalog) (1997)
OS X and cart directories (2003)
Formating found categories (1997)
Add more fields to an existent data base (1997)
How To question on setting up downloads (1997)
.. more on sliding discounts... (1997)
[WebDNA] Clarifying talklist emails (2020)
[WebDNA] SQLdisconnect / sqlrelease (2011)
[WebDNA] Froala Editor working with WebDNA (2016)
Multiple prices (1997)
Email notification to one of multiple vendors ? (1997)
Shipping charges depending on tax rate? (1997)
New public beta available (1997)
WebCat2b15MacPlugin - [protect] (1997)
[WebDNA] What does PHP(5) has, that Webdna hasn't (2009)
EIMS Problems (1997)
ExpireDate Zero or Greater than Today (2006)
Mime Headers for Mail (1998)