numero = 58075
interpreted = N
texte = At 3:50 PM -0700 5/26/04, Sal wrote: >Thought someone might find this useful. > >I added a link for ChangeSku.tpl to the admin/search.tpl in storebuilder to >easily change the SKU for a product. > >[!]PUT THIS FILE IN THE DIRECTORY THAT HOLDS YOUR PRODUCTS.DB[/!] > > > >[showif [process]=T] > [Replace >db=products.db&eqTITLEdatarq=[__title]]sku=[__sku][/Replace] > The Sku is now Changed > [/showif] You're going to have problems if the TITLE field contains & or perhaps if it contains other special characters such as = . Why not just change the SKU directly? Make your select like this: and your replace like this: [Replace db=products.db&eqSKUdatarq=[__oldSKU]]sku=[url][__sku][/url][/Replace] Perhaps you didn't realize that you can actually change the field that you're using for the replace with a new value. Also you need to [url] the new SKU value since a human entering 123&456 into the form field will screw up your database. ~joe -- _______________________________________________________________ Joseph D'Andrea ~ http://www.west21.com/ ~ JoeDan@West21.com WEST21.com Internet services for the 21st Century webhosting ~ co-location ~ wireless access ~ WebCat programming ------------------------------------------------------------- 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:
Re: StoreBuilder Easily change a SKU ( Joe D'Andrea 2004)
At 3:50 PM -0700 5/26/04, Sal wrote: >Thought someone might find this useful. > >I added a link for ChangeSku.tpl to the admin/search.tpl in storebuilder to >easily change the SKU for a product. > >[!]PUT THIS FILE IN THE DIRECTORY THAT HOLDS YOUR PRODUCTS.DB[/!] > > > >[showif [process]=T] > [Replace >db=products.db&eqTITLEdatarq=[__title]]sku=[__sku][/Replace] > The Sku is now Changed > [/showif] You're going to have problems if the TITLE field contains & or perhaps if it contains other special characters such as = . Why not just change the SKU directly? Make your select like this: and your replace like this: [Replace db=products.db&eqSKUdatarq=[__oldSKU]]sku=[url][__sku][/url][/Replace] Perhaps you didn't realize that you can actually change the field that you're using for the replace with a new value. Also you need to [url] the new SKU value since a human entering 123&456 into the form field will screw up your database. ~joe -- _______________________________________________________________ Joseph D'Andrea ~ http://www.west21.com/ ~ JoeDan@West21.com WEST21.com Internet services for the 21st Century webhosting ~ co-location ~ wireless access ~ WebCat programming ------------------------------------------------------------- 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/
Joe D'Andrea
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...