Re: Renumbering Database Records

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 23686
interpreted = N
texte = >Hi, > > How can I renumber the records in a database? I have a database with a >field ID. I want to go throught the database, possibly sorting on some >other field, and number the records 1,2,3,4,... etc so I can have a >unique ID for each record. After that, for example, I can use this ID to >delete a record.The easiest way is to begin my using the sku=[cart] parameter in your append context when creating each and every new record, like this:[append db=some.db]sku=[cart]&field1=somevalue&etc...[/append]Then every record in your db will have a unique sku value, which means you can use either a [search] or a [lookup] later to retrieve the specific record you need. Or if your goal is to delete a specific record, you can use [delete db=some.db&eqskudata=something] to delete the record that has something in the sku field ... :)Sincerely, Ken Grome WebDNA Consultant Associated Messages, from the most recent to the oldest:

    
  1. Re: Renumbering Database Records (PCS Technical Support 1999)
  2. Re: Renumbering Database Records (Kenneth Grome 1999)
  3. Renumbering Database Records (Phil Marshall 1999)
>Hi, > > How can I renumber the records in a database? I have a database with a >field ID. I want to go throught the database, possibly sorting on some >other field, and number the records 1,2,3,4,... etc so I can have a >unique ID for each record. After that, for example, I can use this ID to >delete a record.The easiest way is to begin my using the sku=[cart] parameter in your append context when creating each and every new record, like this:[append db=some.db]sku=[cart]&field1=somevalue&etc...[/append]Then every record in your db will have a unique sku value, which means you can use either a [search] or a [lookup] later to retrieve the specific record you need. Or if your goal is to delete a specific record, you can use [delete db=some.db&eqskudata=something] to delete the record that has something in the sku field ... :)Sincerely, Ken Grome WebDNA Consultant 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:

How can I Add several Items into the cart at once? (1997) Here's how to kill a Butler Database. (1997) HELP WITH DATES (1997) WC Database Format (1997) Trouble with carts (2000) all records returned. (1997) how to construct a search for not this entire string? (2000) NetSplat and WebCat2 (1997) WebMerchant 1.6 and SHTML (1997) ConverChars (1999) OT: Urgent help with Windows and Javascript (2003) Help needed! (1998) WebCat2b15MacPlugin - [protect] (1997) RE: Can't get appendfile to work (1997) wc 2 pro users - sites, quotes wanted (1997) OT: corrupted images (2002) numfound=0 for a search after going into the SSL (2003) Error 11 (1996) [WebDNA] How to get the domain name? (2009) New Calendar Snippet (1998)