cybercop23
IS-IT--Management
Hello all.
First of all, if this is the wrong place to ask this question please let me know.
I have an Access 97 DB and created a query that searches one of the tables. The query has a prompt on one of the fileds. I use the Save HTML feature to publish it on my IIS server on a Win2k machine. I get the .html .htx .idc files.
I place them in on my web server.
When I try to submit the query I get the following.
Datasource:Temp
Template:WebTemp_1.htx
SQLStatement:SELECT TempORDSize.Str, TempORDSize.[0to10], TempORDSize.[10to15], TempORDSize.[15to20], TempORDSize.[20to50]
+FROM TempORDSize
+WHERE (((TempORDSize.Str)=%[Enter Store]%));
Password:
Username:
This just happens to be my .IDC file contents.
What's worng? Why am I not getting the date from my database? I checked the ODBC and it seems allright.
I checked the permistion on that directory and that seemed fine too.
Any help or guide in the right direction would be much appreciated.
Thanks all.
First of all, if this is the wrong place to ask this question please let me know.
I have an Access 97 DB and created a query that searches one of the tables. The query has a prompt on one of the fileds. I use the Save HTML feature to publish it on my IIS server on a Win2k machine. I get the .html .htx .idc files.
I place them in on my web server.
When I try to submit the query I get the following.
Datasource:Temp
Template:WebTemp_1.htx
SQLStatement:SELECT TempORDSize.Str, TempORDSize.[0to10], TempORDSize.[10to15], TempORDSize.[15to20], TempORDSize.[20to50]
+FROM TempORDSize
+WHERE (((TempORDSize.Str)=%[Enter Store]%));
Password:
Username:
This just happens to be my .IDC file contents.
What's worng? Why am I not getting the date from my database? I checked the ODBC and it seems allright.
I checked the permistion on that directory and that seemed fine too.
Any help or guide in the right direction would be much appreciated.
Thanks all.