numero = 21969
interpreted = N
texte = The first time they order, save their information using an [append] like so on your thankyou.tpl (or equivalent) page:[showif [Name]![lookup db=customers.db&lookInField=customerNumber&value=[customerNumber]&returnField=name¬Found=0]] [append db=customers.db]name=[name]&customerNumber=[customerNumber]&address1=[address1]&address2=[address2]&city=[city]....etc[/append] [/showif](the [showif] statement checks to make sure they are not already in the database)And then when they return, do a search on the name and customer number on the invoice page to find their information (you will need to ask for their name and customer number on the preceding page):[search db=customers.db&eqnamedatarq=[name]&eqcustomerNumberdatarq=[customerNumber]&max=1] [founditems] (then have your invoice form her like so:) etc..[/founditems] [/search]I hope this helps. John Nitai wrote: > > Thanks for your answer. > > Do you mind sharing some code, so that I can learn it? > TIA. > Sincerely, > Nitai > > >>The customer should just fill out the order form once. The next time the > >>customer would > >>like to order, he should be able to just fill out his name and customer > >>number and > >>webcatalog fills the rest of the data (this does not have to be visible to > >>the customer, but can be). > > > >>Is there a way to do it in webcatalog? > > > > Yes. > > > > Sincerely, > > Ken Grome > > 808-737-6499 > > WebDNA Solutions > > mailto:ken@webdna.net > > http://www.webdna.net > >
Associated Messages, from the most recent to the oldest:
The first time they order, save their information using an [append] like so on your thankyou.tpl (or equivalent) page:[showif [Name]![lookup db=customers.db&lookInField=customerNumber&value=[customerNumber]&returnField=name¬Found=0]] [append db=customers.db]name=[name]&customerNumber=[customerNumber]&address1=[address1]&address2=[address2]&city=[city]....etc[/append] [/showif](the [showif] statement checks to make sure they are not already in the database)And then when they return, do a search on the name and customer number on the invoice page to find their information (you will need to ask for their name and customer number on the preceding page):[search db=customers.db&eqnamedatarq=[name]&eqcustomerNumberdatarq=[customerNumber]&max=1] [founditems] (then have your invoice form her like so:) etc..[/founditems] [/search]I hope this helps. John Nitai wrote: > > Thanks for your answer. > > Do you mind sharing some code, so that I can learn it? > TIA. > Sincerely, > Nitai > > >>The customer should just fill out the order form once. The next time the > >>customer would > >>like to order, he should be able to just fill out his name and customer > >>number and > >>webcatalog fills the rest of the data (this does not have to be visible to > >>the customer, but can be). > > > >>Is there a way to do it in webcatalog? > > > > Yes. > > > > Sincerely, > > Ken Grome > > 808-737-6499 > > WebDNA Solutions > > mailto:ken@webdna.net > > http://www.webdna.net > >
John W
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...