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:
[SearchString] problem with [search] context (1997)
Only charge card when product shipped ? (1997)
practicing safe queries.. (2000)
Ampersand Character (&) (1997)
Integration with SQL (1997)
[thisurl] (2004)
AE aware WebCatalog.acgi? (1997)
Include a big block of text (1997)
Pirated WebCat? NOT... (2003)
Mail Server Needed. (1998)
WebCat2: Master Counter snippet (1997)
slowness (1998)
Extended [ConvertChars] (1997)
math a various prices (1997)
emailer (1997)
OT: Limit on # of Pulldown entries (1997)
Include (2000)
auto adding SKUs w/DB helper (1998)
[authenticate] (1999)
Error & Problem (1997)