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:

[Webcat 2]Next (1997) Multiple Merchant Accounts? (1997) [WebDNA] Talklist Archive & Twitter (2009) Date search and sendmail (1997) WC2b15 File Corruption (1997) WebCat2b12--[searchstring] bug (1997) Text Variabels Not Passed To Include (2002) RE: [WebDNA] calling a webDNA tmpl from PHP? (2008) SiteEdit Pro Update Announcement (1997) Close_Wait Issue (2004) Backwards list behavior ... (1997) Firesite cache vs webcat cache (1997) Passing Cart variable to subdirectory files? (1997) 2.0Beta Command Ref (can't find this instruction) (1997) PR: WebCatalog Affiliates Program Announced -- Share the revenue for promoting WebCatalog (2000) Help! WebCat2 bug (1997) notification solutions (1997) What changes does $purchase make? (1998) tcpconnect - username/password (2005) target=_blank and form variables (1997)