Re:

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 21052
interpreted = N
texte = >>I have a database with 1350 records in it , and its getting to the point >were we are having more than one user adding >records to the database. I made a field named record to give each item >there own specific number other than a sku. >but the question is , does any one now how I could make webcat search this >record field and find the last number >added (or Greatest) and then have add +1 to it when adding a new record ? >something like max+1 or something...Use this code *after* making the appropriate change to the db names *and* after removing the carriage returns in this example. I put a carriage return at the end of each line in this example to make the code easier to follow in this message:[append db=xxx.db] record= [search db=xxx.db &nerecorddatarq=[blank] &derecordsort=1 &max=1] [founditems] [math][record]+1[/math] [/founditems] [/search] [/append]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:

    
>>I have a database with 1350 records in it , and its getting to the point >were we are having more than one user adding >records to the database. I made a field named record to give each item >there own specific number other than a sku. >but the question is , does any one now how I could make webcat search this >record field and find the last number >added (or Greatest) and then have add +1 to it when adding a new record ? >something like max+1 or something...Use this code *after* making the appropriate change to the db names *and* after removing the carriage returns in this example. I put a carriage return at the end of each line in this example to make the code easier to follow in this message:[append db=xxx.db] record= [search db=xxx.db &nerecorddatarq=[blank] &derecordsort=1 &max=1] [founditems] [math][record]+1[/math] [/founditems] [/search] [/append]Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net 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:

possible, WebCat2.0 and checkboxes-restated (1997) Running 2 two WebCatalog.acgi's (1996) Deleting Orders (1997) Problems with [Applescript] (1997) The & Problem (1998) Retaining data (2003) WebCatalog can't find database (1997) [cart] how is it generated (2002) Frames and WebCat (1997) Netscape v. IE (1997) Forms Search Questions (1997) Running 2 two WebCatalog.acgi's (1996) WebCat2 - many [carts] on one template page? (1997) Balancing randomness (2000) Mac GUI editors (1997) Where's Cart Created ? (1997) rotating thumbnails (1997) if else problem (2003) Auto Wrap Text in

(2004)
is [Bankres] an internal webcat variable? (1999)