RE: pricing continued
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 21097
interpreted = N
texte = Yes, since this isn't in production yet, I have one of my forms set toalways flush the databases. Also, the price line in the formulas.db is notthe last line. I modified the tearoom formulas.db, and have made sure thatthere is a
at the end of the line. Could the problem be that I modifythe file on a PC and then ftp it over to a MAC? -----Original Message----- From: PCS Technical Support [SMTP:support2@smithmicro.com] Sent: Tuesday, November 17, 1998 4:09 PM To: WebDNA-Talk@smithmicro.com Subject: Re: pricing continued >I'm still trying to get Webcatalog to provide me with pricing basedon the >customer ID, and I think that I have it narrowed down to notfinding my >formulas.db for some reason. For example, when I place the code: >[lookup db=price1.db&lookinfield=SKU&value=[SKU]&returnfield=price] >in my results.tpl, it displays the price I want. However, when Iset my >formulas.db as follows I get 0.00 returned for the price in mycart.tpl: >price [lookupdb=price1.db&lookinfield=SKU&value=[SKU]&returnfield=price] After you modified the Formulas.db, did you tell WebCatalog to flushits databases so it can reload the new one from disk? And is there are carriage return after the end of the line...WebCatalog can't see thelast line of a database if the last byte of the file is not a carriagereturn. Technical Support | ==== eCommerce and Beyond ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Yes, since this isn't in production yet, I have one of my forms set toalways flush the databases. Also, the price line in the formulas.db is notthe last line. I modified the tearoom formulas.db, and have made sure thatthere is a at the end of the line. Could the problem be that I modifythe file on a PC and then ftp it over to a MAC? -----Original Message----- From: PCS Technical Support [SMTP:support2@smithmicro.com] Sent: Tuesday, November 17, 1998 4:09 PM To: WebDNA-Talk@smithmicro.com Subject: Re: pricing continued >I'm still trying to get Webcatalog to provide me with pricing basedon the >customer ID, and I think that I have it narrowed down to notfinding my >formulas.db for some reason. For example, when I place the code: >[lookup db=price1.db&lookinfield=SKU&value=[SKU]&returnfield=price] >in my results.tpl, it displays the price I want. However, when Iset my >formulas.db as follows I get 0.00 returned for the price in mycart.tpl: >price [lookupdb=price1.db&lookinfield=SKU&value=[SKU]&returnfield=price] After you modified the formulas.db, did you tell WebCatalog to flushits databases so it can reload the new one from disk? And is there are carriage return after the end of the line...WebCatalog can't see thelast line of a database if the last byte of the file is not a carriagereturn. Technical Support | ==== eCommerce and Beyond ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
Puchalski, Steve
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:
Don't do this! (was: Crashing Type 3) (1999)
How fast is your server? (2002)
PCS Frames-Default page is solution! (1997)
Heads up, cookies *may* be outlawed in Europe (2001)
are we ready to fix random sort? - Or did that already happen? (2000)
trouble updating records in database (1998)
pop up menu's (1998)
Mail Server Needed. (1998)
Bug when including a db file ... ? (2000)
form crasehes server (1997)
WebCat2: Items xx to xx shown, etc. (1997)
Error Log.db --however (1997)
Append..... doesn't (2000)
Need a better [elapsedtime] (2000)
[WriteFile] problems (1997)
WC Database Format (1997)
ShowNext truncating passed variable?? (1997)
[shell] (2000)
notification solutions (1997)
Switching to Linux (2000)