replacing items in a db

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 36391
interpreted = N
texte = Hi,I am having problems with replacing a line in a database with a new line. Here is the line of code in question: [replace db=/db/hits.db&eqhit_datedata=[math]{[date]}[/math]&append=T]hit_date=[math] {[date]}[/math]&[interpret][download_[index][/interpret]=[math][lookup db=/db/hits.db&lookinfield=hit_date¬found=0&returnfield=[interpret][downl oad_[index]][/interpret]&value=[math]{[date]}[/math]]+1[/math][/replace]The purpose of this is to take download stats of a number of different program we ship. So the process is a user can select a number of programs to download and based on their selection, it indexes their values. But when the line of code is read by server it actually deletes a number of the values in the table as opposed to replacing the line it is supposed to be referring to.I hope I am being clear (probably not), don't be afraid to reem me about my lack of clarity, and don't be afraid to ask more questions.Matthew Levy AEC Software, Inc. mlevy@aecsoft.com ------------------------------------------------------------- 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 Web Archive of this list is at: http://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: replacing items in a db (John Butler 2000)
  2. Re: replacing items in a db (AEC Software, Matthew Levy 2000)
  3. Re: replacing items in a db (Will Starck 2000)
  4. Re: replacing items in a db (AEC Software, Matthew Levy 2000)
  5. Re: replacing items in a db (Peter Ostry 2000)
  6. replacing items in a db (Matthew Levy 2000)
Hi,I am having problems with replacing a line in a database with a new line. Here is the line of code in question: [replace db=/db/hits.db&eqhit_datedata=[math]{[date]}[/math]&append=T]hit_date=[math] {[date]}[/math]&[interpret][download_[index][/interpret]=[math][lookup db=/db/hits.db&lookinfield=hit_date¬found=0&returnfield=[interpret][downl oad_[index]][/interpret]&value=[math]{[date]}[/math]]+1[/math][/replace]The purpose of this is to take download stats of a number of different program we ship. So the process is a user can select a number of programs to download and based on their selection, it indexes their values. But when the line of code is read by server it actually deletes a number of the values in the table as opposed to replacing the line it is supposed to be referring to.I hope I am being clear (probably not), don't be afraid to reem me about my lack of clarity, and don't be afraid to ask more questions.Matthew Levy AEC Software, Inc. mlevy@aecsoft.com ------------------------------------------------------------- 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 Web Archive of this list is at: http://search.smithmicro.com/ Matthew Levy

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:

WebCatalog for Postcards ? (1997) [WebDNA] WebDNA on W2k3 (2009) Search/sort in URL Was: GuestBook example (1997) Any Newsletters out there (1998) Default contains WEBDNA (1998) Virtual hosting and webcatNT (1997) WebCat2: Found Items syntax, etc. (1997) Search in 2 or more catalogs (1997) WebCommerce: Folder organization ? (1997) WC2b15 File Corruption (1997) Searching/sorting dates (1997) default value from Lookup (was Grant, please help me) (1997) Press Release hit the NewsWire!!! (1997) download a file (2001) no? marks in the links (2003) stats (2001) Help name our technology! (1997) Error Lob.db records error message not name (1997) Un[url]ize (1999) RE: 2nd WebCatalog2 Feature Request (1996)