My data base has (",") as the delimeter and I found how to change the delimeters from , to "," but it is leaving the double quote at the beginning and at the end, when pulling up on the modify pages, which also means it wont let me search because it looks for "### instead of ###, Any ideas for me, I very confused...
Jul 10, 2000, 9:39 AM
Veteran / Moderator (3034 posts)
Jul 10, 2000, 9:39 AM
Post #2 of 3
Views: 2699
This may not have anything to do with the delimiter.
This can happen when you have two input fields on your form that have the same name. Could you please double check that this is not the case.
The FAQ below also a few causes stated, I belive under troubleshooting.
Unoffical DBMan FAQ
http://webmagic.hypermart.net/dbman/
This can happen when you have two input fields on your form that have the same name. Could you please double check that this is not the case.
The FAQ below also a few causes stated, I belive under troubleshooting.
Unoffical DBMan FAQ
http://webmagic.hypermart.net/dbman/
Jul 10, 2000, 12:12 PM
Veteran / Moderator (8669 posts)
Jul 10, 2000, 12:12 PM
Post #3 of 3
Views: 2697
Did you import a database that had the following format:
"Field1","Field2","Field3","Field4"
With DBMan, the delimiter only is inserted between the fields, so it would write your fields as
Field1","Field2","Field3","Field4
You could get around it on the modify form by adding extra coding for the first and last fields. You could also add coding to sub query which would add the " to the beginning of any searches on the first field and to the end of any searches on the last field, but it would be a problem if you were searching for partial text in the field.
Is there any way you can set up the imported file so it doesn't have quotation marks? That would be the best way to work it.
JPD
http://www.jpdeni.com/dbman/
"Field1","Field2","Field3","Field4"
With DBMan, the delimiter only is inserted between the fields, so it would write your fields as
Field1","Field2","Field3","Field4
You could get around it on the modify form by adding extra coding for the first and last fields. You could also add coding to sub query which would add the " to the beginning of any searches on the first field and to the end of any searches on the last field, but it would be a problem if you were searching for partial text in the field.
Is there any way you can set up the imported file so it doesn't have quotation marks? That would be the best way to work it.
JPD
http://www.jpdeni.com/dbman/