|
Home > Archive > FrontPage Server Extensions for Windows > August 2004 > Need Help Tweaking Database Connection to Text File
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Need Help Tweaking Database Connection to Text File
|
|
| Kristen Wagner 2004-08-14, 7:47 am |
| Hi,
Am working with white paper "How to Send Form Results to a Database and an
E-Mail Address and Use the File Upload Component Simultaneously," and I've
got an issue with setting up the connection to the form_results.txt file.
According to the directions for setting up form.htm (the page used to gather
information from the user and upload the file), the File Results are
supposed to go to form_results.txt, which has been defined as a container
for a comma-delimited text. However, on the Form Properties>Options>File
Results tab, when I change the File Format in the drop-down list to Text
Database using comma as a separator, FrontPage changes the name of the file
to form_results.csv, and when I change the file extension back to .txt per
the directions, FrontPage changes the File Format to Formatted Text. Data
written to the file is not comma-delimited, therefore, and the transfer of
that data to the Access database can't occur.
Help!
TIA.
| |
| Thomas A. Rowe 2004-08-14, 5:48 pm |
| Let FP name the file as it wants, .csv, if you want comma-delimited text.
--
========================================
======
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
========================================
======
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp
"Kristen Wagner" <kwagner@twcny.rr.com> wrote in message
news:OWDbMgfgEHA.3632@TK2MSFTNGP09.phx.gbl...
> Hi,
>
> Am working with white paper "How to Send Form Results to a Database and an
> E-Mail Address and Use the File Upload Component Simultaneously," and I've
> got an issue with setting up the connection to the form_results.txt file.
> According to the directions for setting up form.htm (the page used to gather
> information from the user and upload the file), the File Results are
> supposed to go to form_results.txt, which has been defined as a container
> for a comma-delimited text. However, on the Form Properties>Options>File
> Results tab, when I change the File Format in the drop-down list to Text
> Database using comma as a separator, FrontPage changes the name of the file
> to form_results.csv, and when I change the file extension back to .txt per
> the directions, FrontPage changes the File Format to Formatted Text. Data
> written to the file is not comma-delimited, therefore, and the transfer of
> that data to the Access database can't occur.
>
> Help!
>
> TIA.
>
>
| |
| Kristen Wagner 2004-08-14, 5:48 pm |
| Thanks....I'll give it a go.
"Thomas A. Rowe" <tarowe@mvps.org> wrote in message
news:%235N5WrigEHA.140@TK2MSFTNGP12.phx.gbl...
> Let FP name the file as it wants, .csv, if you want comma-delimited text.
>
> --
> ========================================
======
> Thomas A. Rowe (Microsoft MVP - FrontPage)
> WEBMASTER Resources(tm)
> http://www.ycoln-resources.com
> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
> ========================================
======
> To assist you in getting the best answers for FrontPage support see:
> http://www.net-sites.com/sitebuilder/newsgroups.asp
>
> "Kristen Wagner" <kwagner@twcny.rr.com> wrote in message
> news:OWDbMgfgEHA.3632@TK2MSFTNGP09.phx.gbl...
an[vbcol=seagreen]
I've[vbcol=seagreen]
file.[vbcol=seagreen]
gather[vbcol=seagreen]
container[vbcol=seagreen]
file[vbcol=seagreen]
per[vbcol=seagreen]
Data[vbcol=seagreen]
of[vbcol=seagreen]
>
>
|
|
|
|
|