numero = 33769
interpreted = N
texte = Clint - [cart] is your friend; I swear this exact discussion came up last week.Use something like this: [text]sku_one=[cart]_1[/text] [text]sku_two=[cart]_2[/text] [text]sku_three=[cart]_3[/text] [text]sku_four=[cart]_4[/text]or whatever you want to name the sku's. Your formula is not guaranteedto be unique (it might be under a light load, but certainly not a heavyone). [cart] is guaranteed to be unique under any load.As for the scientific notation, you are trying to represent a number that is too large for standard number display. This would happen if you tried to do [math][cart]+1[/math] as well. [cart], though it lookslike a number, is actually a string.HTHJohn PeacockClint Davis wrote:> > I have a situation where I need to add up to 4 records to a database> with one form. So far, adding the records is the easy part. My> problem is generating unique sku's for each record.> > Submit page:> > > Thanks page:> [showif [_emailfriend1]!][append> db=../admin/rt_reminders.db]sku=[url][math][_sku]+1[/math][/url]&email> =[_emailfriend1]&date_time=[date]&show=[show]&showdate=[showdate][/app> end][/showif]> > Which gives me this sku: 2.0000627111256e+13> > QUESTION 1: Is there a problem with using a sku that looks like this?> > QUESTION 2: Just for my own knowledge, how can I get [date> %Y%m%d][time %H%M%S]+1?> > _______________________> > Clint Davis> Gray Loon Marketing Group> 812.422.9999> > cdavis@grayloon.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://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Clint - [cart] is your friend; I swear this exact discussion came up last week.Use something like this: [text]sku_one=[cart]_1[/text] [text]sku_two=[cart]_2[/text] [text]sku_three=[cart]_3[/text] [text]sku_four=[cart]_4[/text]or whatever you want to name the sku's. Your formula is not guaranteedto be unique (it might be under a light load, but certainly not a heavyone). [cart] is guaranteed to be unique under any load.As for the scientific notation, you are trying to represent a number that is too large for standard number display. This would happen if you tried to do [math][cart]+1[/math] as well. [cart], though it lookslike a number, is actually a string.HTHJohn PeacockClint Davis wrote:> > I have a situation where I need to add up to 4 records to a database> with one form. So far, adding the records is the easy part. My> problem is generating unique sku's for each record.> > Submit page:> > > Thanks page:> [showif [_emailfriend1]!][append> db=../admin/rt_reminders.db]sku=[url][math][_sku]+1[/math][/url]&email> =[_emailfriend1]&date_time=[date]&show=[show]&showdate=[showdate][/app> end][/showif]> > Which gives me this sku: 2.0000627111256e+13> > QUESTION 1: Is there a problem with using a sku that looks like this?> > QUESTION 2: Just for my own knowledge, how can I get [date> %Y%m%d][time %H%M%S]+1?> > _______________________> > Clint Davis> Gray Loon Marketing Group> 812.422.9999> > cdavis@grayloon.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://search.smithmicro.com/
John Peacock
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...