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 Center175 J. Llorente Street +63 (32) 255-6921Cebu City, Cebu 6000 kengrome@webdna.netPhilippines 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:
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 Center175 J. Llorente Street +63 (32) 255-6921Cebu City, Cebu 6000 kengrome@webdna.netPhilippines 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)