Re: Serious bug writing to a database ...
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 41790
interpreted = N
texte = are you gonna show us the code or what? On Monday, July 22, 2002, at 11:00 AM, Kenneth Grome wrote:> 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 digest@talk.smithmicro.com> > Web Archive of this list is at: http://search.smithmicro.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:
are you gonna show us the code or what? On Monday, July 22, 2002, at 11:00 AM, Kenneth Grome wrote:> 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 digest@talk.smithmicro.com> > Web Archive of this list is at: http://search.smithmicro.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/
dsmith7
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:
GuestBook example (1997)
Defualt folder locations (2004)
Email Newsletters (2003)
[WebDNA] Question about server performance ... (2008)
WebCat2 beta 11 - new prefs ... (1997)
A question on sub-categories (1997)
Emailer (1997)
Re:quit command on NT (1997)
[WebDNA] WebDNA 7 (2011)
Absolute path (2003)
[WebDNA] Stop & Start WebDNA Remotely (2011)
More on the email templates (1997)
Date field search needs ... (1998)
[WebDNA] test (2008)
Frames and WebCat (1997)
maybe even an easier plan to satisfy need for solid tech support? (2000)
WebMerchant & Online CC Auths (1999)
OK, here goes... (1997)
UK credit card info follow-up (1997)
WC Database Format (1997)