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:
Re:2nd WebCatalog2 Feature Request (1996)
Emailer compatibility..... (1998)
Case statement (2003)
[WebDNA] New list (2008)
Out of the woodwork (2007)
group searching problem (2002)
PCS Emailer's role ? (1997)
Web Catalog 2 demo (1997)
[WebDNA] using ^ within [showif] and [hideif] (2015)
Nested [xxx] contexts & Bad Suffix (1998)
Welcome Back (was) Newbie Question (1999)
Multiple prices (1997)
Bug Report, maybe (1997)
database freeze (1997)
PIXO with cometsite ... and/or other plugins (1998)
WebCatalog for LinuxPPC/SusePPC? (2000)
MacOS alias identification? (1998)
Does [Sendmail] create html? (2002)
Problems passing [SKU] with $Replace in 2.0 (1997)
OLD ORDERS (1998)