[WebDNA] Corrupted Db that Table-Search other db's
This WebDNA talk-list message is from 2011
It keeps the original formatting.
numero = 106609
interpreted = N
texte = Hi all,Any idea, why my DB will be corrupted everytime I retrieved it?===========================UNCORRUPT DB ---index.db----===========================query4test[table name=contents&fields=query,4test][search db=2011/large.db&neMtrSndata=[blank]&MtrSnSort=1&MtrSnSumm=t][founditems][MtrSn]Y[/founditems][/search][/table][search table=Contents&neQuerydata=[blank]][founditems][query][4test][/founditems][/search]The above code cannot be verified to be working because of the saidcorruption. And it will not work (when index.db as url address) if the tag is removed.I noted that during flush (both database & page), said DB stays as itis. But only when I start to execute (calling) it inside a .tpl, thatsome lines disappear! The contents inside the file, large.db remainsunaffected.=========================CORRUPTED DB --index.db--=========================query 4test[table name=contents&fields=query,4test][search db=2011/large.db&neMtrSndata=[blank]&MtrSnSort=1&MtrSnSumm=t][founditems][MtrSn][/founditems]Or does this version (UNCORRUPT DB) now looks faulty. Because it usedto work at first, that I start recoding the db again after I found the.tpl calling the db file showed some errors. I even suspect it thatthis same corruption happened to the working version, resulting to anerror, so that I start tinkering & then noted this corruption later.The Table version below is what I desire to accomplish using a[search] inside a [table], where this issue of corruption occur. Thisone, without , just works fine. And when it isincluded, it will be corrupted.=========================TABLE -----index.db------=========================query4test[table name=contents&fields=query,4test]1234567898765Y7658432456Y[/table][search table=Contents&neQuerydata=[blank]][founditems][query][4test][/founditems][/search]Could this be RAM related? Or file extension (*.db)? Or that thing?Heres the logic for this piece:INDEX.DB extracts 1 to 2 fields from:(1) small.db - [serial](2) large.db - [MtrSN] & [Ref]-----small.db-------------------large.db----------SKUSERIALDECSKUMtrSNRefDEC11011234SMALL110198765ABCLARGE11025678SMALL110232456XYZLARGE110376584SMALL--------------------------------------------------If [query] is [4test]=Y,Then [search] [query]=[MtrSN] for [dec] datas from LARGE.DB,Else [search] [query]=[serial] for [dec] datas from SMALL.DB.--index.db---Query4test1234567898765Y7658432456Y-------------This is how it is being called to search:< form method="POST" name="search" action="results.tpl" >< input type="hidden" name="command" value="Search" >< input type="hidden" name="template" value="index.htm" >< input type="hidden" name="db" value="db/index.db" >< input id="txt1" name="eqQueryData" value="Enter Serial No."/ >< input type="submit" value="Find Test Results" >< /form >I played with "tabbing" and "carriage returns" , still to no avail.Thanks to all.Jesshttp://sgbc-cebu.comhttp://clf-cebu.comhttp://myrlepeters.bravehost.com
Associated Messages, from the most recent to the oldest:
Hi all,Any idea, why my DB will be corrupted everytime I retrieved it?===========================UNCORRUPT DB ---index.db----===========================query4test[table name=contents&fields=query,4test][search db=2011/large.db&neMtrSndata=[blank]&MtrSnSort=1&MtrSnSumm=t]
[founditems][MtrSn]Y[/founditems][/search][/table][search table=Contents&neQuerydata=[blank]]
[founditems][query][4test][/founditems][/search]The above code cannot be verified to be working because of the saidcorruption. And it will not work (when index.db as url address) if the tag is removed.I noted that during flush (both database & page), said DB stays as itis. But only when I start to execute (calling) it inside a .tpl, thatsome lines disappear! The contents inside the file, large.db remainsunaffected.=========================CORRUPTED DB --index.db--=========================query 4test[table name=contents&fields=query,4test][search db=2011/large.db&neMtrSndata=[blank]&MtrSnSort=1&MtrSnSumm=t]
[founditems][MtrSn][/founditems]Or does this version (UNCORRUPT DB) now looks faulty. Because it usedto work at first, that I start recoding the db again after I found the.tpl calling the db file showed some errors. I even suspect it thatthis same corruption happened to the working version, resulting to anerror, so that I start tinkering & then noted this corruption later.The Table version below is what I desire to accomplish using a
[search] inside a
[table], where this issue of corruption occur. Thisone, without , just works fine. And when it isincluded, it will be corrupted.=========================TABLE -----index.db------=========================query4test[table name=contents&fields=query,4test]1234567898765Y7658432456Y[/table][search table=Contents&neQuerydata=[blank]]
[founditems][query][4test][/founditems][/search]Could this be RAM related? Or file extension (*.db)? Or that thing?Heres the logic for this piece:INDEX.DB extracts 1 to 2 fields from:(1) small.db - [serial](2) large.db - [MtrSN] & [Ref]-----small.db-------------------large.db----------SKUSERIALDECSKUMtrSNRefDEC11011234SMALL110198765ABCLARGE11025678SMALL110232456XYZLARGE110376584SMALL--------------------------------------------------If [query] is [4test]=Y,Then
[search] [query]=[MtrSN] for [dec] datas from LARGE.DB,Else
[search] [query]=[serial] for [dec] datas from SMALL.DB.--index.db---Query4test1234567898765Y7658432456Y-------------This is how it is being called to search:< form method="POST" name="search" action="results.tpl" >< input type="hidden" name="command" value="Search" >< input type="hidden" name="template" value="index.htm" >< input type="hidden" name="db" value="db/index.db" >< input id="txt1" name="eqQueryData" value="Enter Serial No."/ >< input type="submit" value="Find Test Results" >< /form >I played with "tabbing" and "carriage returns" , still to no avail.Thanks to all.Jesshttp://sgbc-cebu.comhttp://clf-cebu.comhttp://myrlepeters.bravehost.com
sgbc cebu
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:
[WebDNA] sales tax on shipping (2008)
X etc.... (1999)
[WebDNA] Encrypted password issue (2009)
HTTP upload (2000)
Quitting WebMerchant ? (1997)
Interface to Quickbooks (2005)
Card clearance, problems - solutions? (1997)
FORMS: Returning a specific page (1997)
Problem (1997)
Configuring E-mail (1997)
Stopping bad HTML propagation ? (1997)
TEXTAREA and sendmail (1998)
[WebDNA] Crashing Database (2011)
Running _every_ page through WebCat ? (1997)
Error Lob.db records error message not name (1997)
Country & Ship-to address & other fields ? (1997)
Template cache problem with WC4 on Mac OS X (2000)
OK, here goes... (1997)
problems with 2 tags (1997)
NT vs Mac (1997)