Re: Generating and appending SKU to a db automatically
This WebDNA talk-list message is from
1998
It keeps the original formatting.
numero = 19543
interpreted = N
texte = Try adding SKUtype=num to your search parameters, so WebCat sorts the SKUs as numbers rather than alphabetically (which is causing it to think that 9 is the greatest SKU in the database) At 6:03 AM 8/21/98, Jose A. Gordo wrote: >Hello, > >I'm having a problem trying to append an automatically generated sku to a >database. BTW, I know that the best way to make sure you have unique SKU's is >by using the cart number. However, in this situation I am using webcat to >conduct a poll, and was using the SKU to track the total number of people who >responded and to calibrate the graphs so I can use the BarChart example to >display the results. This is the code I'm using for generating the sku: > >db=promo.db&geskudata=0&skusort=1&skusdir=de&max=1][founditems][math][sku]+1[/ma >th][/founditems][/search]> > >This code does seem to work up to SKU number 10, and after that it just >keeps appending 10 to the subsequent records. As always any help would be >greatly appreciated. BTW, thank you Wendell for al your help with my last >problem. > >Thanks in advance, >Jose >Content-Type: text/x-vcard; charset=us-ascii; name=vcard.vcf >Content-Transfer-Encoding: 7bit >Content-Description: Card for Jose A. Gordo >Content-Disposition: attachment; filename=vcard.vcf > >Attachment converted: 1 GB internal:vcard.vcf 1 (TEXT/R*ch) (00030561) o--------------- Dave MacLeay --+ o----------- Digital Frontier --+ o--------------- 802.253.8612 --+ o--- dave@digitalfrontier.com --+
Associated Messages, from the most recent to the oldest:
Re: Generating and appending SKU to a db automatically (Dave MacLeay 1998)
Try adding SKUtype=num to your search parameters, so WebCat sorts the SKUs as numbers rather than alphabetically (which is causing it to think that 9 is the greatest SKU in the database) At 6:03 AM 8/21/98, Jose A. Gordo wrote: >Hello, > >I'm having a problem trying to append an automatically generated sku to a >database. BTW, I know that the best way to make sure you have unique SKU's is >by using the cart number. However, in this situation I am using webcat to >conduct a poll, and was using the SKU to track the total number of people who >responded and to calibrate the graphs so I can use the BarChart example to >display the results. This is the code I'm using for generating the sku: > >db=promo.db&geskudata=0&skusort=1&skusdir=de&max=1][founditems][math][sku]+1[/ma >th][/founditems][/search]> > >This code does seem to work up to SKU number 10, and after that it just >keeps appending 10 to the subsequent records. As always any help would be >greatly appreciated. BTW, thank you Wendell for al your help with my last >problem. > >Thanks in advance, >Jose >Content-Type: text/x-vcard; charset=us-ascii; name=vcard.vcf >Content-Transfer-Encoding: 7bit >Content-Description: Card for Jose A. Gordo >Content-Disposition: attachment; filename=vcard.vcf > >Attachment converted: 1 GB internal:vcard.vcf 1 (TEXT/R*ch) (00030561) o--------------- Dave MacLeay --+ o----------- Digital Frontier --+ o--------------- 802.253.8612 --+ o--- dave@digitalfrontier.com --+
Dave MacLeay
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...