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:

Limitations on fields? Server is crashing (1997) cart ID (1998) WebCat2 Append problem (B14Macacgi) (1997) Sort Order on a page search (1997) More on the email templates (1997) unit ship cost GRRRRRRR! (2001) Loss in Form (1998) Opinion: [input] should be called [output] ... (1997) redirect with more than 256 characters (1999) Incompatibility with WebCat 3 templates ... (2000) Append..... doesn't (2000) all records returned. (1997) [TaxableTotal] - not working with AOL and IE (1997) [HIDEIF] inside [FOUNDITEM] (1997) Frames and WebCat (1997) Help! WebCat2 bug (1997) Need relative path explanation (1997) [WebDNA] [OT] hello (2012) User/pass with tcpconnect (2000) Speed Optimization - Mac (1997)