Re: Numbers and Numbers and Me
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 25296
interpreted = N
texte = >Is there a way that web catalog/web dna can generate non-random, or >pre-defined sequential set customer numbers via a form? I won't be >needing a shopping cart and I need numbers generated that aren't order >numbers or cart numbers.If you want sequential numbers based on the current numbers in the customer.db, start with this:[search db=customers.db&necustomerIDdatarq=[blank]&max=1&decustomerIDsort=1&customerIDtype=num] [founditems] [append db=customers.db]customerID=[text show=t]newID=[math][customerID]+1[/math][/text][/append] [/founditems] [/search]The above code create a new record for the current customer in the customers.db, with the customerID value one greater than the highest previous value in the db. It also sets the text variable newID to that value so you can use the following search to retrieve this new record and populate a replace form with the retrieved values:[search db=customers.db&eqcustomerIDdatarq=[newID]&max=1]================================ Kenneth Grome, WebDNA Consultant 808-737-6499, http://webdna.net ================================------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to
.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
Associated Messages, from the most recent to the oldest:
>Is there a way that web catalog/web dna can generate non-random, or >pre-defined sequential set customer numbers via a form? I won't be >needing a shopping cart and I need numbers generated that aren't order >numbers or cart numbers.If you want sequential numbers based on the current numbers in the customer.db, start with this:[search db=customers.db&necustomerIDdatarq=[blank]&max=1&decustomerIDsort=1&customerIDtype=num] [founditems] [append db=customers.db]customerID=[text show=t]newID=[math][customerID]+1[/math][/text][/append] [/founditems] [/search]The above code create a new record for the current customer in the customers.db, with the customerID value one greater than the highest previous value in the db. It also sets the text variable newID to that value so you can use the following search to retrieve this new record and populate a replace form with the retrieved values:[search db=customers.db&eqcustomerIDdatarq=[newID]&max=1]================================ Kenneth Grome, WebDNA Consultant 808-737-6499, http://webdna.net ================================------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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
Kenneth Grome
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:
2 easy questions re: [showif] and [sendmail] (1997)
can WC render sites out? (1997)
Where is f2? (1997)
Forwarding Orders Via Email (1998)
Using Applescript to process WebCatalog functions (1998)
WC2.0 Memory Requirements (1997)
Sku numbers (1997)
New public beta available (1997)
default value from Lookup (was Grant, please help me) (1997)
Multi Colonns (1998)
SiteEdit Pro Update Announcement (1997)
WebDNA on Linux (2005)
Shownext never shows next...still (1997)
many-to-one problem (1998)
SERIAL NUMBER PROBLEM *AGAIN*!!! (1998)
Error Log.db --however (1997)
required fields (1999)
email program problem (1998)
Security Issues and WebCommerce Solution (1997)
[TaxableTotal] - not working with AOL and IE (1997)