garymgordon
Programmer
Well, I have a .txt file that I am trying to create a Recordset for. I can connect to the .txt file with no problem.
Situation:
1) The .txt file is in a fixed length format.
2) ASCII format.
3) No Column Headers.
That's the basics.
The name of the table is Data.txt .
I have a Schema.ini file that is working just fine. It displays all the columns, etc.
But, when I try to create a Recordset .. I get an error due to the fact that it is putting " null " in front of the name of the file because there is no TABLE.
It is looking for:
SELECT *
FROM null.Data.txt
and of course, the file is named Data.txt not null.Data.txt.
When I go into the advanced section and remove the " null. " from the code .. everything is fine.
MY QUESTION IS ....
Is there a way to work with Dreamweaver MX that will allow it NOT to do this... meaning NOT to put " null. " in front of the file name?
What's up with this???
Help ... please.
Thanks,
Gary
Gary M. Gordon, LLC
webmaster@garymgordon.com
Certified Web Developer ::
Application Programmer
Situation:
1) The .txt file is in a fixed length format.
2) ASCII format.
3) No Column Headers.
That's the basics.
The name of the table is Data.txt .
I have a Schema.ini file that is working just fine. It displays all the columns, etc.
But, when I try to create a Recordset .. I get an error due to the fact that it is putting " null " in front of the name of the file because there is no TABLE.
It is looking for:
SELECT *
FROM null.Data.txt
and of course, the file is named Data.txt not null.Data.txt.
When I go into the advanced section and remove the " null. " from the code .. everything is fine.
MY QUESTION IS ....
Is there a way to work with Dreamweaver MX that will allow it NOT to do this... meaning NOT to put " null. " in front of the file name?
What's up with this???
Help ... please.
Thanks,
Gary
Gary M. Gordon, LLC
webmaster@garymgordon.com
Certified Web Developer ::
Application Programmer