PC Review


Reply
Thread Tools Rate Thread

How do I stop commas from appearing in DB when 2 form fields submi

 
 
=?Utf-8?B?RHVzdHk=?=
Guest
Posts: n/a
 
      15th Apr 2005
I have a technician workorder form that submits data to a database. To make
things easy to edit I have multiple form fields submitting data to the same
place in the database (In this case they all go to "client_issues"). When the
data is displayed back from the database frontpage automatically places a
comma in between the data submitted from the diffrent fields. This really
messes up the final page that is printed out and handed off to the client to
be signed off on.

Anyone have any ideas??
 
Reply With Quote
 
 
 
 
Thomas A. Rowe
Guest
Posts: n/a
 
      15th Apr 2005
FP does NOT do this, the ASP/VBScript does this when you submit data from multiple fields that have
the same field name.

Just create either multiple fields or use a single scrolling text box (memo field)

--
==============================================
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

"Dusty" <(E-Mail Removed)> wrote in message
news:23964FA2-1B4F-4DAF-9801-(E-Mail Removed)...
>I have a technician workorder form that submits data to a database. To make
> things easy to edit I have multiple form fields submitting data to the same
> place in the database (In this case they all go to "client_issues"). When the
> data is displayed back from the database frontpage automatically places a
> comma in between the data submitted from the diffrent fields. This really
> messes up the final page that is printed out and handed off to the client to
> be signed off on.
>
> Anyone have any ideas??



 
Reply With Quote
 
=?Utf-8?B?RHVzdHk=?=
Guest
Posts: n/a
 
      15th Apr 2005
Thanks for the response Thomas, but I would I need to have multiple fields
submitting to the same form name so how do i stop the ASP/VBScript from doing
this?

Thanks again
Dustin

"Thomas A. Rowe" wrote:

> FP does NOT do this, the ASP/VBScript does this when you submit data from multiple fields that have
> the same field name.
>
> Just create either multiple fields or use a single scrolling text box (memo field)
>
> --
> ==============================================
> 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
>
> "Dusty" <(E-Mail Removed)> wrote in message
> news:23964FA2-1B4F-4DAF-9801-(E-Mail Removed)...
> >I have a technician workorder form that submits data to a database. To make
> > things easy to edit I have multiple form fields submitting data to the same
> > place in the database (In this case they all go to "client_issues"). When the
> > data is displayed back from the database frontpage automatically places a
> > comma in between the data submitted from the diffrent fields. This really
> > messes up the final page that is printed out and handed off to the client to
> > be signed off on.
> >
> > Anyone have any ideas??

>
>
>

 
Reply With Quote
 
Thomas A. Rowe
Guest
Posts: n/a
 
      15th Apr 2005
You can't, that I am aware of.

Why do you need to have multiple fields with the same name?

--
==============================================
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

"Dusty" <(E-Mail Removed)> wrote in message
news:1427D184-CDF2-4AB0-8DF2-(E-Mail Removed)...
> Thanks for the response Thomas, but I would I need to have multiple fields
> submitting to the same form name so how do i stop the ASP/VBScript from doing
> this?
>
> Thanks again
> Dustin
>
> "Thomas A. Rowe" wrote:
>
>> FP does NOT do this, the ASP/VBScript does this when you submit data from multiple fields that
>> have
>> the same field name.
>>
>> Just create either multiple fields or use a single scrolling text box (memo field)
>>
>> --
>> ==============================================
>> 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
>>
>> "Dusty" <(E-Mail Removed)> wrote in message
>> news:23964FA2-1B4F-4DAF-9801-(E-Mail Removed)...
>> >I have a technician workorder form that submits data to a database. To make
>> > things easy to edit I have multiple form fields submitting data to the same
>> > place in the database (In this case they all go to "client_issues"). When the
>> > data is displayed back from the database frontpage automatically places a
>> > comma in between the data submitted from the diffrent fields. This really
>> > messes up the final page that is printed out and handed off to the client to
>> > be signed off on.
>> >
>> > Anyone have any ideas??

>>
>>
>>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mad commas appearing in online DB Wayne-I-M Microsoft Frontpage 4 5th Jan 2008 09:31 AM
Commas,,,,, appearing on site ? Wayne-I-M Microsoft Frontpage 7 29th Dec 2007 04:44 PM
How do I stop every e-mail form appearing twice after download =?Utf-8?B?ZmlyZW1hbjEyNQ==?= Microsoft Outlook Discussion 5 29th Mar 2005 05:56 AM
commas in form fields Leesa Microsoft Access ADP SQL Server 1 28th Aug 2003 01:23 PM
Re: text automatically appearing in form fields everywhere Windows XP Internet Explorer 0 7th Jul 2003 02:47 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:53 PM.