T
Trillian
I'm running FP2002 and have an .asp web using an Access database.
Last night, out of the blue, every database results page showed this error:
Microsoft VBScript runtime error '800a0005'
Invalid procedure call or argument: 'Mid'
/_fpclass/fpdbrgn1.inc, line 269
(it appears to be a section stripping out quote marks - this is not
something I've included or changed.)
Once a value is selected from a query-filled dropdown, the error goes away
and the db results are displayed properly. But on entrance to any of those
pages the error displays.
The date on this file and on fpdbrgn2.inc were both yesterday's date, as was
the fbdblib.inc file. I don't know if these dates change everytime the web is
uploaded, but I did not run a Windows or Microsoft program update. I publish
the website almost daily as I'm constantly adding new graphic images and
other data changes.
Important item: I know the fbdblib file was updated yesterday as I've
changed code there to place paragraph breaks in displayed Access memo fields
and they no longer displayed. This happened once before when I ran an Office
update and I had to reinsert the changed code. I fixed this code again and it
fixed the memo field display but had nothing to do with the error.
How do I fix the above? Is it something that can be taken care of by
inserting a default value? I don't have a default value in the database
results and I don't want to display anything until the user selects something
from the dropdown.
Last night, out of the blue, every database results page showed this error:
Microsoft VBScript runtime error '800a0005'
Invalid procedure call or argument: 'Mid'
/_fpclass/fpdbrgn1.inc, line 269
(it appears to be a section stripping out quote marks - this is not
something I've included or changed.)
Once a value is selected from a query-filled dropdown, the error goes away
and the db results are displayed properly. But on entrance to any of those
pages the error displays.
The date on this file and on fpdbrgn2.inc were both yesterday's date, as was
the fbdblib.inc file. I don't know if these dates change everytime the web is
uploaded, but I did not run a Windows or Microsoft program update. I publish
the website almost daily as I'm constantly adding new graphic images and
other data changes.
Important item: I know the fbdblib file was updated yesterday as I've
changed code there to place paragraph breaks in displayed Access memo fields
and they no longer displayed. This happened once before when I ran an Office
update and I had to reinsert the changed code. I fixed this code again and it
fixed the memo field display but had nothing to do with the error.
How do I fix the above? Is it something that can be taken care of by
inserting a default value? I don't have a default value in the database
results and I don't want to display anything until the user selects something
from the dropdown.