[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:

Re: [WebDNA] Corrupted Db that Table-Search other db's (Govinda 2011) [WebDNA] Corrupted Db that Table-Search other db's (sgbc cebu 2011)

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:

Sorting Numbers (1997) Count how many items in a summ total (2003) [WebDNA] online.db deadlock: your current options ... (2011) Help! WebCat2 bug (1997) Searching multiple fields from one form field (1997) CommandSecurity? (1997) PSC recommends what date format yr 2000??? (1997) Searching for foreign chars (2004) WCS Newbie question (1997) Caching pages...again (2001) Shipping charges based on dollar level (1997) WebCatalog for Postcards ? (1997) Orderfile (2005) WebCat hosting providers? - one more option (1997) WebDNA with WebStar V (2003) Runtime (1998) PSC recommends what date format yr 2000??? (1997) format search comparison Q (2000) Multiple instances of database (2003) Multiple prices (1997)