Re: What would be sweet is
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 54450
interpreted = N
texte = Actually, what I have been considering is a new WebDNA admin pref that readssomething like:eCommerce use SQL TRUE/FALSEIf set to true, all existing WebDNA ecommerce tags and contexts (including[cart]) would use a SQL database (using our new native SQL code). Eachsandbox would have its own setting.Each store would have its own SQL conf file for SQL settings; host,username, password, database, etc... Or perhaps just a reference to a WebDNAglobal registered SQL database, that is automatically 'mounted' when WebDNAstarts up.The goal being that no template changes would be required to switch to SQLfor the ecommerce stuff.-----Original Message-----From: Bob Minor [mailto:bob@cybermill.com]Sent: Tuesday, November 25, 2003 3:54 PMTo: WebDNA TalkSubject: What would be sweet isNew context tags that work with sql.[SQLOrderfile dsn=orders.....]this would return data from the headers table in the orders database[Name][grandtotal][SQLLineItems] This would look up the table orderlineitems in the orders database[/SQLLineItems][/SQLOrderFile][SQLAddLineItems dsn=orders]sku=[sku][/SQLaddlineitems]This would simplify upgrading to a SQL system! Can you get this done by 2 weeks before SuperBowl? I may have 2 teams on the ticket and the volume will require I have load balancing and I would love to have it all tie into a sql database. ;)PS I will deal with creating the database!Robert MinorDirector of Internet Services------------------------------------------------------------Cybermill Communicationshttp://www.cybermill.com http://www.merchantmaker.comProviding Ecommerce and interactive website development andhosting services on Macintosh, Windows NT, *nix, and AS/400.Complete ddos proof hosting solutions and network services.-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list
.To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail toWeb Archive of this list is at: http://webdna.smithmicro.com/-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Actually, what I have been considering is a new WebDNA admin pref that readssomething like:eCommerce use SQL TRUE/FALSEIf set to true, all existing WebDNA ecommerce tags and contexts (including[cart]) would use a SQL database (using our new native SQL code). Eachsandbox would have its own setting.Each store would have its own SQL conf file for SQL settings; host,username, password, database, etc... Or perhaps just a reference to a WebDNAglobal registered SQL database, that is automatically 'mounted' when WebDNAstarts up.The goal being that no template changes would be required to switch to SQLfor the ecommerce stuff.-----Original Message-----From: Bob Minor [mailto:bob@cybermill.com]Sent: Tuesday, November 25, 2003 3:54 PMTo: WebDNA TalkSubject: What would be sweet isNew context tags that work with sql.[SQLOrderfile dsn=orders.....]this would return data from the headers table in the orders database[Name][grandtotal][SQLLineItems] This would look up the table orderlineitems in the orders database[/SQLLineItems][/SQLOrderFile][SQLAddLineItems dsn=orders]sku=[sku][/SQLaddlineitems]This would simplify upgrading to a SQL system! Can you get this done by 2 weeks before SuperBowl? I may have 2 teams on the ticket and the volume will require I have load balancing and I would love to have it all tie into a sql database. ;)PS I will deal with creating the database!Robert MinorDirector of Internet Services------------------------------------------------------------Cybermill Communicationshttp://www.cybermill.com http://www.merchantmaker.comProviding Ecommerce and interactive website development andhosting services on Macintosh, Windows NT, *nix, and AS/400.Complete ddos proof hosting solutions and network services.-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail toWeb Archive of this list is at: http://webdna.smithmicro.com/-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Scott Anderson
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:
WebCatalog NT beta 18 problem (1997)
Too Much Rootbeer Free Offer (1997)
Generating unique SKU from [cart] - Still Stumped... (1997)
[WebDNA] client request (2010)
Store Builder Weirdness (1999)
Serving images from databases (1998)
Opening 'order file'. (1999)
WebCat2b13MacPlugIn - [include] (1997)
[OT] Friday Time Waster (2003)
WCf2 and nested tags (1997)
WebCat2 - [format thousands] (1997)
[WebDNA] Some code inside a large loops fail ... but why? (2010)
Creating comums (1998)
SiteEdit Pro Update Announcement (1997)
Grep (2003)
Using Currencies other than Dollars (1997)
WebCat2 - storing unformatted date data? (1997)
A workaround for handling date range search in yyyy/mm/dd form (1997)
unable to launch acgi in WebCat (1997)
WebCatalog & Mac OS X (client) vs. Redhat Linux (2001)