[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:
Multiple Admins through users.db (1997)
could someone please try this - it's very quick and easy (2000)
RE: [input] questions (1997)
Printing a final order (1997)
[WebDNA] v7 Stress Test and Strange Behaviour (2012)
Sort Issue? (2000)
WebDNA 5.1 is now available! (2003)
[isfile] ? (1997)
Templates in Memory (2000)
Emailer errors - repost (2000)
Re2: frames & carts (1997)
Emailer setup (1997)
triggers.db (1999)
Is using [URL] recommended even on an email address? (1999)
Pulling Captions from JPGs (2003)
Canadian Postal Codes (location-based searching) (2001)
F3 crashing server (1997)
Rép : Old & New? (2003)
Forcing a NEWCART (1997)
RE: includes and cart numbers (1997)