Need Help Tweaking Database Connection to Text File
Web Server forum
Back To The Forum Home!Search!Private Messaging System

Web Server Talk Web Server Talk > Web Servers reviews > FrontPage Server Extensions for Windows > Need Help Tweaking Database Connection to Text File




  Last Thread   Next Thread Next
  Show Printable Version Email this Page Subscribe to this Thread      Post New Thread    Post A Reply      

    Need Help Tweaking Database Connection to Text File  
Kristen Wagner


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
08-14-04 12:47 PM

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.







[ Post a follow-up to this message ]



    Re: Need Help Tweaking Database Connection to Text File  
Thomas A. Rowe


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
08-14-04 10: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 gath
er
> 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 fil
e
> 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.
>
>







[ Post a follow-up to this message ]



    Re: Need Help Tweaking Database Connection to Text File  
Kristen Wagner


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
08-14-04 10: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] 
>
>







[ Post a follow-up to this message ]



    Sponsored Links  




 





   All times are GMT. The time now is 09:11 AM.      Post New Thread    Post A Reply      
  Last Thread   Next Thread Next


Most Popular forums 

Forum Jump:
Rate This Thread:

Forum Rules:
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is OFF
vB code is ON
Smilies are ON
[IMG] code is OFF
 
Medical and Health forum | Computer Games Reviews | Graphics design forum

Back To The Top
Home | Usercp | Faq | Register