Re: Mystery File

This WebDNA talk-list message is from

2005


It keeps the original formatting.
numero = 62044
interpreted = N
texte = 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 Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Mystery File - Solved ( rupert ravens 2005)
  2. Re: Mystery File - Solved ( Gary Krockover 2005)
  3. Re: Mystery File ( rupert ravens 2005)
  4. Re: Mystery File - Solved ( rupert ravens 2005)
  5. Re: Mystery File ( rupert ravens 2005)
  6. Re: Mystery File ( Frank Nordberg 2005)
  7. Re: Mystery File ( Gary Krockover 2005)
  8. Re: Mystery File ( Kenneth Grome 2005)
  9. Mystery File ( rupert ravens 2005)
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 Web Archive of this list is at: http://webdna.smithmicro.com/ Gary Krockover

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:

fixed date problem (1997) Where is f2? (1997) Passing Cart variable to subdirectory files? (1997) Notepad problems - SOLVED! (1998) Hiding the URL(was Cart ID Duplication) (2001) Searchable Archives (1998) Math (1997) I have troubles to send message out (1998) Re[3]: 2nd WebCatalog2 Feature Request (1996) Cookies and webcat (1997) Running _every_ page through WebCat ? (1997) [WebDNA] User - Group - permissions (2009) Speed Admin? (Was FlushDatabases) (1997) Updating fields from different platforms (1998) How To question on setting up downloads (1997) wrong input values? (1997) What about the fixes that were promised for 5.2 ? (2004) Attn: Bug in GeneralStore example b15 (1997) SKU lookup (1997) NT [delete] (1998)