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:
>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:
Last Day of the Month (2005)
OT: How to convert TIFs into HTML or ASCII format? (2002)
date tag not interpreted (2000)
All quiet (2004)
Attention all list readers (1997)
Saving Text Areas with Orders (1997)
Updating checkboxes made easy !!! (1998)
credit card question (simple) (2001)
includes and cart numbers (1997)
Re2: frames & carts (1997)
OK, here goes... (1997)
Two submit buttons ? (1997)
Join us at MacWorld! - Part 2 (1998)
WCS Newbie question (1997)
Re[3]: Hiding files/images. (2000)
WebCatalog can't find database (1997)
Limitations on fields? Server is crashing (1997)
Searching multiple fields (1997)
Goodbyes (2007)
Request Time Out (1997)