Mad commas appearing in online DB

W

Wayne-I-M

Hi All

I am importing a FP database (after clients have input data) onto a simple
access database.

BUT – mad little commas are appearing in “some†of the form fields.

You can see it for yourself (fill in the forms then submit) if you view
source on the next page you will see the commas (just on some forms) – go to
the bottom of the form : hidden fields.

When filling in the text boxes on this form
http://www.folgarida.co.uk/Page_Room3_booking2.asp
The result is this
value="wayne, "
Note that there is a space after the name and “most irritating†there is a
comma.

But when filling in the same form (I have just deleted one of the tables to
make the 3rd room not there)
http://www.folgarida.co.uk/Page_Room2_booking2.asp
The result is this
value="wayne"
Note that there is no space after the name and “most important†there is no
comma.

Does anyone know where the comma is coming from. The commas will mess up
the path to the field in access (If I left them where they are)

Of course I can easily get rid of the commas and spaces on the first import
into access by adding this to the import table append

SELECT Replace([tblImportAppend ]![FieldName],",","") AS New
FROM tblImportAppend;


This would be run on the tblImportAppend (note the path is wrong on this
code as I’m using a memory stick to test this ….. E:\SkiBookingDetails.mdb

Private Sub HideImportNewButon_Click()
Dim WayneIMPfile As TableDef
For Each WayneIMPfile In CurrentDb.TableDefs
If WayneIMPfile.Name = "tblImportAppend" Then
CurrentDb.TableDefs.Delete WayneIMPfile.Name
End If
Next
DoCmd.TransferDatabase acImport, "Microsoft Access", "
E:\SkiBookingDetails.mdb ", acTable, "Results", "tblImportAppend"
DoCmd.SetWarnings False
DoCmd.OpenQuery "qryImportAppend"
DoCmd.SetWarnings True
CurrentDb.TableDefs.Delete "tblImportAppend"
Me.HideImportOnLineBookingsSubForm.Requery
End Sub


So I “can†get rid of the commas – but does anyone know “why†they would
appear.

Thank you
 
S

Stefan B Rusynko

Provide a sample of your Request.Form code from page 2
you are adding the commas in that code some how

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| Hi All
|
| I am importing a FP database (after clients have input data) onto a simple
| access database.
|
| BUT – mad little commas are appearing in “some†of the form fields.
|
| You can see it for yourself (fill in the forms then submit) if you view
| source on the next page you will see the commas (just on some forms) – go to
| the bottom of the form : hidden fields.
|
| When filling in the text boxes on this form
| http://www.folgarida.co.uk/Page_Room3_booking2.asp
| The result is this
| value="wayne, "
| Note that there is a space after the name and “most irritating†there is a
| comma.
|
| But when filling in the same form (I have just deleted one of the tables to
| make the 3rd room not there)
| http://www.folgarida.co.uk/Page_Room2_booking2.asp
| The result is this
| value="wayne"
| Note that there is no space after the name and “most important†there is no
| comma.
|
| Does anyone know where the comma is coming from. The commas will mess up
| the path to the field in access (If I left them where they are)
|
| Of course I can easily get rid of the commas and spaces on the first import
| into access by adding this to the import table append
|
| SELECT Replace([tblImportAppend ]![FieldName],",","") AS New
| FROM tblImportAppend;
|
|
| This would be run on the tblImportAppend (note the path is wrong on this
| code as I’m using a memory stick to test this ….. E:\SkiBookingDetails.mdb
|
| Private Sub HideImportNewButon_Click()
| Dim WayneIMPfile As TableDef
| For Each WayneIMPfile In CurrentDb.TableDefs
| If WayneIMPfile.Name = "tblImportAppend" Then
| CurrentDb.TableDefs.Delete WayneIMPfile.Name
| End If
| Next
| DoCmd.TransferDatabase acImport, "Microsoft Access", "
| E:\SkiBookingDetails.mdb ", acTable, "Results", "tblImportAppend"
| DoCmd.SetWarnings False
| DoCmd.OpenQuery "qryImportAppend"
| DoCmd.SetWarnings True
| CurrentDb.TableDefs.Delete "tblImportAppend"
| Me.HideImportOnLineBookingsSubForm.Requery
| End Sub
|
|
| So I “can†get rid of the commas – but does anyone know “why†they would
| appear.
|
| Thank you
|
| --
| Wayne
| Manchester, England.
|
 
W

Wayne-I-M

Thanks for your suggestion Stefan.

I will look at the difference between the 2 forms and see if I can spot
anything.

I will (again) just copy the form and then delete the extra room. The thing
that I can't understand is that I created a template for the forms that works
fine. "And" this template is OK when there are just 1 or 2 rooms - but - if
there are more than 2 rooms the commas appear.

I don't know enough about website design to work it out so I think I will go
with your suggestion and look again at the code and - if this does not work -
I will just get rid of the commas in the first import/append.

I think this is one of those thing that it's just not worth spending any
more time one - oh well

Thanks again




--
Wayne
Manchester, England.



Stefan B Rusynko said:
Provide a sample of your Request.Form code from page 2
you are adding the commas in that code some how

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| Hi All
|
| I am importing a FP database (after clients have input data) onto a simple
| access database.
|
| BUT – mad little commas are appearing in “some†of the form fields.
|
| You can see it for yourself (fill in the forms then submit) if you view
| source on the next page you will see the commas (just on some forms) – go to
| the bottom of the form : hidden fields.
|
| When filling in the text boxes on this form
| http://www.folgarida.co.uk/Page_Room3_booking2.asp
| The result is this
| value="wayne, "
| Note that there is a space after the name and “most irritating†there is a
| comma.
|
| But when filling in the same form (I have just deleted one of the tables to
| make the 3rd room not there)
| http://www.folgarida.co.uk/Page_Room2_booking2.asp
| The result is this
| value="wayne"
| Note that there is no space after the name and “most important†there is no
| comma.
|
| Does anyone know where the comma is coming from. The commas will mess up
| the path to the field in access (If I left them where they are)
|
| Of course I can easily get rid of the commas and spaces on the first import
| into access by adding this to the import table append
|
| SELECT Replace([tblImportAppend ]![FieldName],",","") AS New
| FROM tblImportAppend;
|
|
| This would be run on the tblImportAppend (note the path is wrong on this
| code as I’m using a memory stick to test this ….. E:\SkiBookingDetails.mdb
|
| Private Sub HideImportNewButon_Click()
| Dim WayneIMPfile As TableDef
| For Each WayneIMPfile In CurrentDb.TableDefs
| If WayneIMPfile.Name = "tblImportAppend" Then
| CurrentDb.TableDefs.Delete WayneIMPfile.Name
| End If
| Next
| DoCmd.TransferDatabase acImport, "Microsoft Access", "
| E:\SkiBookingDetails.mdb ", acTable, "Results", "tblImportAppend"
| DoCmd.SetWarnings False
| DoCmd.OpenQuery "qryImportAppend"
| DoCmd.SetWarnings True
| CurrentDb.TableDefs.Delete "tblImportAppend"
| Me.HideImportOnLineBookingsSubForm.Requery
| End Sub
|
|
| So I “can†get rid of the commas – but does anyone know “why†they would
| appear.
|
| Thank you
|
| --
| Wayne
| Manchester, England.
|
Click to expand...
 
R

Ronx

You have 2 fields with the same name - this will create the "name, "
scenario.

Example:
<input type="text" name="GroupLeader_FirstName" size="33"></font></td>
<input type="hidden" name="GroupLeader_FirstName" size="48"
style="font-family: Arial; font-size: 10pt" value=""><br>

Other fields are duplicated in a similar way. Within the same form, all
field names must be unique, otherwise the server will concatenate the
field contents into one field in the results, with the data separated by
commas.
 
W

Wayne-I-M

Ha Ha - Ronx - when I grow up I want to be you.

Thats it.

It works now (on our internal server - so it will when published).

I have spent days and days looking at this - solved now.

Thank you

--
Wayne
Manchester, England.



Ronx said:
You have 2 fields with the same name - this will create the "name, "
scenario.

Example:
<input type="text" name="GroupLeader_FirstName" size="33"></font></td>
<input type="hidden" name="GroupLeader_FirstName" size="48"
style="font-family: Arial; font-size: 10pt" value=""><br>

Other fields are duplicated in a similar way. Within the same form, all
field names must be unique, otherwise the server will concatenate the
field contents into one field in the results, with the data separated by
commas.
--
Ron Symonds - Microsoft MVP (FrontPage)
Reply only to group - emails will be deleted unread.

http://www.rxs-enterprises.org/fp




Hi All

I am importing a FP database (after clients have input data) onto a simple
access database.

BUT - mad little commas are appearing in "some" of the form fields.

You can see it for yourself (fill in the forms then submit) if you view
source on the next page you will see the commas (just on some forms) - go to
the bottom of the form : hidden fields.

When filling in the text boxes on this form
http://www.folgarida.co.uk/Page_Room3_booking2.asp
The result is this
value="wayne, "
Note that there is a space after the name and "most irritating" there is a
comma.

But when filling in the same form (I have just deleted one of the tables to
make the 3rd room not there)
http://www.folgarida.co.uk/Page_Room2_booking2.asp
The result is this
value="wayne"
Note that there is no space after the name and "most important" there is no
comma.

Does anyone know where the comma is coming from. The commas will mess up
the path to the field in access (If I left them where they are)

Of course I can easily get rid of the commas and spaces on the first import
into access by adding this to the import table append

SELECT Replace([tblImportAppend ]![FieldName],",","") AS New
FROM tblImportAppend;


This would be run on the tblImportAppend (note the path is wrong on this
code as I'm using a memory stick to test this ... E:\SkiBookingDetails.mdb

Private Sub HideImportNewButon_Click()
Dim WayneIMPfile As TableDef
For Each WayneIMPfile In CurrentDb.TableDefs
If WayneIMPfile.Name = "tblImportAppend" Then
CurrentDb.TableDefs.Delete WayneIMPfile.Name
End If
Next
DoCmd.TransferDatabase acImport, "Microsoft Access", "
E:\SkiBookingDetails.mdb ", acTable, "Results", "tblImportAppend"
DoCmd.SetWarnings False
DoCmd.OpenQuery "qryImportAppend"
DoCmd.SetWarnings True
CurrentDb.TableDefs.Delete "tblImportAppend"
Me.HideImportOnLineBookingsSubForm.Requery
End Sub


So I "can" get rid of the commas - but does anyone know "why" they would
appear.

Thank you
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Commas in form field results 3
Currency Formatting in Results 6
Align an image in a table top and right 3
Access 2000-Telephone dialer with commas do not work? 1
Commas in list box items 10
Concatenate without Nulls? 5
ListBoxes and Commas 1
When Produt id is typed Product description is shown: 2

Top