Gossamer Forum
Home : Products : DBMan : Installation :

Unusual "no records found error"

Quote Reply
Unusual "no records found error"
In my DB, I have four radio button fields. For some odd reason, when I try searching the db for one of them, it returns no records found...even though it should find something. The other three work fine. I've looked at the search query in the address bar and noticed that for some reason, it puts a "+" before this field's result. For example, in the query string it says

...&null_field=&null_field2=&first_name=&mid_name=&last_name=&roundtable=+KoreanP&order=&title=&department=&organization=&address=&city=&state=&zip=&zip4=&genphone=&directphone=&Email=&web=&specialdiet=&comments=&keyword=&mh=1&sb=---&so=ascend&view_records=View+Records

I think I have it figured out that the + isn't supposed to be there, but how do I fix this? It works perfectly fine when doing a query of the other three radio button fields.
Even stranger, when running a query of the first button in this field (Europe), it works fine. The others don't.

The DB is available on-line at www.stanleyfoundation.org/admin/index.html. (haven't created an entry page yet). guest/guest gives you viewing privledges. Any help would be appreciated.


Quote Reply
Re: Unusual "no records found error" In reply to
When looking at the coding of your search page and view the source code I noticed it displays:

<INPUT TYPE="RADIO" NAME="roundtable" VALUE="Europe"> Europe
<INPUT TYPE="RADIO" NAME="roundtable" VALUE=" KoreanP"> KoreanP
<INPUT TYPE="RADIO" NAME="roundtable" VALUE=" MidEast"> MidEast
<INPUT TYPE="RADIO" NAME="roundtable" VALUE=" SouthAsia"> SouthAsia

Notice the extra spaces such as VALUE=" KoreanP">?

Check your .cfg file and be sure you don't have extra spaces between your options.

You might have:

'roundtable' => 'Europe, KoreanP, MidEast, SouthAsia'

which should be (without spaces):

'roundtable' => 'Europe,KoreanP,MidEast,SouthAsia'

Hope this helps

Unoffical DBMan FAQ
http://webmagic.hypermart.net/dbman/