Re: Mystery File
This WebDNA talk-list message is from 2005
It keeps the original formatting.
numero = 62046
interpreted = N
texte = gary, thanks for the dbQuickview, but for some reason i could not get it work. i did look through the DB, and there were no records with a space for the value of NEWSDATE. in fact, i created a new DB, Flushed the DBs, updated the TPLs and i still have the Mystery File. --rupert On May 22, 2005, at 12:56 AM, Gary Krockover wrote: > If one of your records has a space for the value of NEWSDATE, but > no value, the search as you have it will still return that as a > result since it is not blank. However, your record would be > written as you're seeing it - .html > > Change your search to: > [search db=news.db&neNEWSDATEdatarq=[blank]&NEWSDATEtype=date] to > return only records that are formatted as a date (and not just a > space - assuming that field is formatted as dates). > > To check your database, a tool that might help would be the > dbQuickview that I wrote: > http://www.garykrockover.com/dbquickview/ > > Put as your search of news.db: > > [search db=news.db&neNEWSDATEdatarq=[blank]] (as you have it now) > and you may see your bad record. Change the search as I have it > and that bad record should be omitted from the results (again > assuming that is the problem). > > GJK > > At 04:55 PM 5/21/2005, you wrote: > >> hey all, >> >> the code below first writes an HTML file, >> then creates an HTML page with a list of all HTML files in that >> directory. >> >> however, i get a Mystery file [.html] listed which doesn't exit on >> the server. >> >> i have changed the code around but still can't seem to get rid of it. >> >> possibly this mystery is my misunderstanding. >> >> enlightenment welcome. >> >> thanks, >> >> --rupert >> >> >>
>> All NEWS Directory Website Pages listed here >> >> File Name: open. . . . ..html >> >> File Name: open. . . . .04-21-2005.html >> >> File Name: open. . . . .05-25-2004.html >> >> File Name: open. . . . .10-11-2004.html >> >> >> >> -----begin code >> --------------------------------------------------------------------- >> --- --- >> [search db=news.db&neNEWSDATEdata=[blank]] >> [founditems] >> [writefile file=../testwrite/news/[grep search= $&replace=] >> [NEWSDATE].html[/grep]] >> >> ....... >> [/writefile] >> [/founditems] >> [/search] >> >> [showif [action]!] >> >> ....... All NEWS Directory Website Pages listed here >> >> [table name=filesort&fields=filename][!] >> [/!][listfiles path=../testwrite/news/] [grep search= $&replace=] >> [FILENAME][/grep] >> [/listfiles][/table] [search table=filesort&neFILENAMEdata=[blank] >> &asFILENAMEsort=1] [founditems] [showif [FileName]^.html] File >> Name: <..htm>open. . . . . [FileName] >> >> [/showif] [/founditems] [/search] ....... >> [/showif] >> -----end code >> --------------------------------------------------------------------- >> --- >> -- >> > > > ------------------------------------------------------------- > 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://webdna.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://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
gary, thanks for the dbQuickview, but for some reason i could not get it work. i did look through the DB, and there were no records with a space for the value of NEWSDATE. in fact, i created a new DB, Flushed the DBs, updated the TPLs and i still have the Mystery File. --rupert On May 22, 2005, at 12:56 AM, Gary Krockover wrote: > If one of your records has a space for the value of NEWSDATE, but > no value, the search as you have it will still return that as a > result since it is not blank. However, your record would be > written as you're seeing it - .html > > Change your search to: > [search db=news.db&neNEWSDATEdatarq=[blank]&NEWSDATEtype=date] to > return only records that are formatted as a date (and not just a > space - assuming that field is formatted as dates). > > To check your database, a tool that might help would be the > dbQuickview that I wrote: > http://www.garykrockover.com/dbquickview/ > > Put as your search of news.db: > > [search db=news.db&neNEWSDATEdatarq=[blank]] (as you have it now) > and you may see your bad record. Change the search as I have it > and that bad record should be omitted from the results (again > assuming that is the problem). > > GJK > > At 04:55 PM 5/21/2005, you wrote: > >> hey all, >> >> the code below first writes an HTML file, >> then creates an HTML page with a list of all HTML files in that >> directory. >> >> however, i get a Mystery file [.html] listed which doesn't exit on >> the server. >> >> i have changed the code around but still can't seem to get rid of it. >> >> possibly this mystery is my misunderstanding. >> >> enlightenment welcome. >> >> thanks, >> >> --rupert >> >> >> >> All NEWS Directory Website Pages listed here >> >> File Name: open. . . . ..html >> >> File Name: open. . . . .04-21-2005.html >> >> File Name: open. . . . .05-25-2004.html >> >> File Name: open. . . . .10-11-2004.html >> >> >> >> -----begin code >> --------------------------------------------------------------------- >> --- --- >> [search db=news.db&neNEWSDATEdata=[blank]] >> [founditems] >> [writefile file=../testwrite/news/[grep search= $&replace=] >> [NEWSDATE].html[/grep]] >> >> ....... >> [/writefile] >> [/founditems] >> [/search] >> >> [showif [action]!] >> >> ....... All NEWS Directory Website Pages listed here >> >> [table name=filesort&fields=filename][!] >> [/!][listfiles path=../testwrite/news/] [grep search= $&replace=] >> [FILENAME][/grep] >> [/listfiles][/table] [search table=filesort&neFILENAMEdata=[blank] >> &asFILENAMEsort=1] [founditems] [showif [FileName]^.html] File >> Name: <..htm>open. . . . . [FileName] >> >> [/showif] [/founditems] [/search] ....... >> [/showif] >> -----end code >> --------------------------------------------------------------------- >> --- >> -- >> > > > ------------------------------------------------------------- > 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://webdna.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://webdna.smithmicro.com/
rupert ravens
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:
IP Address Ranges in a Database. (2003)
For those of you not on the WebCatalog Beta... (1997)
Webcat2, WebCommerce, Mod 10 etc. (1997)
Nesting format tags (1997)
Sku numbers (1997)
Sorting via date (2002)
adding time (2003)
Help Wanted (2005)
Locking up with WebCatalog... (1997)
Showif, Hideif reverse logic ? (1997)
Case statement (2003)
select multiple 2 more cents (1997)
[delete] problem (1997)
WebCat2: Formulas.db question (1997)
Cleaner URLs (2003)
Webcat causing crashes left and right! (1997)
emailer w/F2 (1997)
RE: WebCat and image maps (1997)
Showif ~ Netscape : Showif ~ MSIE (2001)
creating files dynamically (2002)