Gossamer Forum
Home : Products : DBMan : Discussions :

Problems with delimeters

Quote Reply
Problems with delimeters
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...

Quote Reply
Re: Problems with delimeters In reply to
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/
Quote Reply
Re: Problems with delimeters In reply to
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/