Gossamer Forum
Home : Products : DBMan : Discussions :

Re: [s101] DB Search Failed

Quote Reply
Re: [s101] DB Search Failed In reply to
It looks like your db is out of order... everything is in the wrong place.

Make sure the fields in your default.db line up with your default.cfg

Name
Address
City
State
Zip

Name|Address|City|State|Zip

if there is an empty field it should look like this:

Name||City|State|Zip (notice how there's a space/placeholder for address between the two pipes)

If you have excel you can open the default.db file in excel (tell it "other delimiter" and type in the pipe in the box) then you can "see" where your fields are getting off. If you miss a space for field

Name|City|State|Zip (notice there is no placeholder for address) then your search will return records like this:

Name|City|State|Zip|Name
Address|City|State|Zip|Name

Hope this makes sense...
Subject Author Views Date
Thread DB Search Failed s101 10177 Feb 19, 2009, 6:10 PM
Thread Re: [s101] DB Search Failed
Watts 10031 Feb 20, 2009, 3:22 PM
Thread Re: [Watts] DB Search Failed
s101 10009 Feb 20, 2009, 6:20 PM
Post Re: [s101] DB Search Failed
LoisC 9981 Feb 21, 2009, 8:31 AM