Re: Serious bug writing to a database ...

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 41788
interpreted = N
texte = The problem occurs when writing to the db, not when retrieving from the db. Replace puts the data into a field that does not match the field name in the replace context. >Ken, I believe something related came up a while back and Scott >knows about it. >We did a series of tests where if you had a db like: > >ID CAT_ID NAME >2 1 FRED >1 1 JOHN > >your database, and you did a search like: > >[search db=testdb.db&eqCAT_IDdatarq=1&eqIDdatarq=1] >[founditems][name] [/founditems] >[/search] > >It should return just JOHN, right.? >It doesn't. It returns both Fred and John. > >Scott, is this fixed in version 5? > >thanks, >Donovan > > > > >Kenneth Grome wrote: > >> I found a serious bug in webcat. It writes data to the wrong db >> field sometimes! >> >> My form has a resumeEmail field, but my db has a resumeEmail1 >> field -- and these field names are NOT the same. Nevertheless, >> webcat writes the form field value to the resumeEmail1. >> >> This is bad because webcat should never write data to any db field >> unless the field names match exactly. And in this case they do not >> match, which leads me to the conclusion that this is a bug. >> >> Sincerely, >> Kenneth Grome >> >> > >-- > ------------------------------------------------------------------------ > > ------------------------------------------------------------------------ > ><><> Donovan Brooke <><>->ï > ------------------------------------------------------------------------ > > ------------------------------------------------------------------------ > > >------------------------------------------------------------- >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/Sincerely, Kenneth Grome--------------------------------------------------- WebDNA Professional Training and Development Center 175 J. Llorente Street +63 (32) 255-6921 Cebu City, Cebu 6000 kengrome@webdna.net Philippines http://www.webdna.net ---------------------------------------------------------------------------------------------------------------- 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: Serious bug writing to a database ... (Kenneth Grome 2002)
  2. Re: Serious bug writing to a database ... (Scott Anderson 2002)
  3. Re: Serious bug writing to a database ... (Dale Therio 2002)
  4. Re: Serious bug writing to a database ... (Donovan 2002)
  5. Re: Serious bug writing to a database ... (dsmith7 2002)
  6. Re: Serious bug writing to a database ... (Kenneth Grome 2002)
  7. Re: Serious bug writing to a database ... (Bob Minor 2002)
  8. Re: Serious bug writing to a database ... (Donovan 2002)
  9. Re: Serious bug writing to a database ... (Andrew Simpson 2002)
  10. Re: Serious bug writing to a database ... (Alain Russell 2002)
  11. Serious bug writing to a database ... (Kenneth Grome 2002)
The problem occurs when writing to the db, not when retrieving from the db. Replace puts the data into a field that does not match the field name in the replace context. >Ken, I believe something related came up a while back and Scott >knows about it. >We did a series of tests where if you had a db like: > >ID CAT_ID NAME >2 1 FRED >1 1 JOHN > >your database, and you did a search like: > >[search db=testdb.db&eqCAT_IDdatarq=1&eqIDdatarq=1] >[founditems][name] [/founditems] >[/search] > >It should return just JOHN, right.? >It doesn't. It returns both Fred and John. > >Scott, is this fixed in version 5? > >thanks, >Donovan > > > > >Kenneth Grome wrote: > >> I found a serious bug in webcat. It writes data to the wrong db >> field sometimes! >> >> My form has a resumeEmail field, but my db has a resumeEmail1 >> field -- and these field names are NOT the same. Nevertheless, >> webcat writes the form field value to the resumeEmail1. >> >> This is bad because webcat should never write data to any db field >> unless the field names match exactly. And in this case they do not >> match, which leads me to the conclusion that this is a bug. >> >> Sincerely, >> Kenneth Grome >> >> > >-- > ------------------------------------------------------------------------ > > ------------------------------------------------------------------------ > ><><> Donovan Brooke <><>->ï > ------------------------------------------------------------------------ > > ------------------------------------------------------------------------ > > >------------------------------------------------------------- >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/Sincerely, Kenneth Grome--------------------------------------------------- WebDNA Professional Training and Development Center 175 J. Llorente Street +63 (32) 255-6921 Cebu City, Cebu 6000 kengrome@webdna.net Philippines http://www.webdna.net ---------------------------------------------------------------------------------------------------------------- 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/ 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:

WebMerchant 1.6 and SHTML (1997) emails sent twice (2001) Problems appending to database (1997) [format xs] freeze (1997) XML WebDNA Problems (2000) Exists? (1997) using cookies to prevent access (2000) textarea input truncated at 255 chars (1999) WC2b15 - [HTMLx]...[/HTMLx] problems (1997) HELP..Changing Price after adding to cart. (1999) Can't find templaes (1997) where to put code (1998) OT: 800x600 (2003) I try hard to think positively (1998) Webcat/Webmerchant (1998) PSC recommends what date format yr 2000??? (1997) Root Folder problems cont. (1998) WebCat2b15MacPlugin - showing [math] (1997) Summing a field full of numbers ... (1997) OT: Kerio Mail Server (2005)