Index server not displaying results (random directories)

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

herders_at_yahoo.com
Date: 05/22/04 

Date: Fri, 21 May 2004 21:19:38 -0400

Hi,
The issue I am having is,
I have some .asp scripts running:
1. to display files in a certain directory with no extra parameters,
strictly the SQL statement and the directory and write DESC
    The result will be 0 for a directory with many files yet its sibling
directory with index properly. ie
        d:\somedir\someotherdir\2004\apr - this will index properly
        d:\somedir\someotherdir\2004\may - this will NOT index properly
    This script has not been changed in at least 12 months

2. to display files in a certain directory with extra parameters like '
filename like "01 04" added to the SQL and write DESC
    The result will be 0 for a directory with many files yet its sibling
directory with index properly. ie
    ie.
    d:\somedir\someotherdir\2004\apr - filename like "01 04" this will
index properly
    d:\somedir\someotherdir\2004\may - filename like "01 05" this will
NOT index properly
    the syntax for the filename may not be correct in this post as I
don't have the files in front of me
    but on the server the directories are correct, the SQL statements
are correct and the filename like .. is correct

It seems as though every month another directory suffers from this
ailment, which means I have to use alternative ways to display the
files, yet the scripts and directory structures and filenames are ALWAYS
consistent. Reboots of the server do not solve the problem.
Platform Windows NT 4.0 Service Pack 6, Active Perl, IIS 4.0 fully
Patched MDAC 2.7, Index Server 2.0 I believe whatever is the version
with NT 4.

Any ideas on what is happening or what a solution may would be greatly
appreciated.

Thanks

Jack Wayne

Relevant Pages

  • Re: creating unique index and clustered index in sql server management studio
    ... Anything more should be done thru the Generate Scripts ... Andrew J. Kelly SQL MVP ... > SQL 2000 GUI created the indexes by creating a constraint while the new ... >>> Then the changes work and the code is genereted in the scripts. ...
    (microsoft.public.sqlserver.tools)
  • Re: Help Understanding mx.ODBC Error
    ... running the scripts on old data (that these scripts were able to digest ... Greg Corradini wrote: ... But recently they continue to bail on the mycursor.execute('An SQL ... Sent from the Python - python-list mailing list archive at Nabble.com. ...
    (comp.lang.python)
  • Re: Help Understanding mx.ODBC Error
    ... Greg Corradini wrote: ... I wrote two scripts using mx.ODBC on an Access DB. ... But recently they continue to bail on the mycursor.execute('An SQL ... I used the proper parameterization with "?" ...
    (comp.lang.python)
  • Re: Help Understanding mx.ODBC Error
    ... Greg Corradini wrote: ... I wrote two scripts using mx.ODBC on an Access DB. ... But recently they continue to bail on the mycursor.execute('An SQL ... I apologize in advance if you are using parameterized queries but this message is typical of Access when it sees words it can't parse. ...
    (comp.lang.python)