Gossamer Forum
Home : Products : DBMan : Installation :

"List All" problem

Quote Reply
"List All" problem
Hello All,

I'm new to this database and have used JPDeni's DBMan configurator to initially setup my database. Everythings works great except for the "List All" link. I keep getting an Error indicating there was no data inputted. However, when I use the view button I can called up anything I wish. I would very much appreiciate help in fixing this problem.

Thanks so much,

Keith Saylor
Quote Reply
Re: "List All" problem In reply to
Hi Sun,

I'm sure this is a simply problem that I'm just overlooking. Thank you so much for offering your help! :-)
Here are the URL to the files you requested:

db.cgi=http://www.Northbirding.com/dbman/db.txt

html.pl=http://www.Northbirding.com/dbman/html.txt

default.cfg=http://www.Northbirding.com/dbman/default.txt

Thanks again for your help,

Keith
Quote Reply
Re: "List All" problem In reply to
Hi Keith:

If you could post the URL where I can take a look at your db.cgi, html.pl and default.cfg, maybe I can take a look at it and see what has gone wrong.

Cheers
Sun
Quote Reply
Re: "List All" problem In reply to
Hi Keith:

Found your problem. Change the appropriate lines in the default.cfg to this: (it does not like the "#" character at all)

%db_def = (
'Record' => [ 0, 'numer', 5, 255, 1, '', '\d{1}'],
'Species Sighted' => [ 1, 'alpha', 40, 255, 1, '', ''],
'Birder Name' => [ 2, 'alpha', 40, 255, 1, '', ''],
'Email' => [ 3, 'alpha', 40, 255, 1, '', '.+@.+..+'],
'County' => [ 4, 'alpha', 40, 255, 1, '', ''],
'Location' => [ 5, 'alpha', 40, 255, 1, '', ''],
'Classification' => [ 6, 'alpha', 0, 28, 1, '', ''],
'Review List Status' => [ 7, 'alpha', 0, 10, 1, '', ''],
'Date' => [ 8, 'date', 10, 255, 1, &get_date(), ''],
'Number Sighted' => [ 9, 'numer', 5, 255, 1, '', '\d{1}']
);

# The column name for the database key. Can be any column, but it must be unique!
# You can't have two records with the same key value!
$db_key = 'Record';

Make sure you don't forget changing $db_key too.

Hope that helps
Sun

------------------
-------------------- Gossamer Threads Inc. ----------------------
Sun Djaja Email: sun@gossamer-threads.com
Internet Consultant
http://www.gossamer-threads.com

Quote Reply
Re: "List All" problem In reply to
Hi Sun,

I worked!! Thank yo so much for your help!
I apologize for taking so long to respond I've been out of town.

Thanks again,

Keith Saylor :-)