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 EagleStarNine Technologieshttp://www.smithmicro.com/ Associated Messages, from the most recent to the oldest:

RE: Clearing orders and database help! (Jim Valamier 1997)
RE: Clearing orders and database help! (Marc Eagle 1997)

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 EagleStarNine Technologieshttp://www.smithmicro.com/ Marc Eagle

DOWNLOAD WEBDNA NOW!

RE: Clearing orders and database help!

1997

Top Articles:

Related Readings: