Hi,
First of all please accept my apologies for the "newbie" questions. I have recently turned my hobby of Pub and Club reviewing into something more serious, and have installed Dbman as my database. I am experiencing some problems that I can't resolve. Any ideas??

1. I don't seem to have enough space in the HTML.pl to have all the HTML that I need. I am having to detete none essential parts of the file to make room for the actual coding I require.

2. At present the DB is part of a website, not the site itself, so to enter the DB you have to click a button, then log on, then carry out the search, add, etc. Is there an easy way to carry out a search from the main index.html page of the Site without having to go through all the log on precedure, say a seach box which can search on either Name or Location?

The site/DB can benseen at http://www.puterpotato.com/afterdark

Any help, advice, or even slaps for ignorance will be greatly appreciated.

Mark

Hi there,

I dont see why you dont have enough space in html.pl.

Secondly if you want6 to do a seach without having to log on use the command db=default
and uid=default this will give the person the permissions that you set out in the .cfg file.

so if you set default permissions in this file to view only then thats all they will be able to do if you want people to be able to add to the database then set it to allow them to add and view only, thats the great thing about dbman

If you would like an example visit http://www.thehairshop.co.uk and then try using the hairproblems page and search for fudge.

Regards

MDJ

You can put as many codes as you like in the html.pl file. A suggestion to make your html.pl more "compact" and "user-friendly", you could add some codes to insert txt files with HTML codes. If you want the codes, let me know.

In terms of linking to the search form, you could use the following URL:


In terms of making your "home page" the "search form" in DBMAN, that would be complicated.

The best thing to do is link to the search form with the URL given above from your home page.

Hope this helps.



Regards,

------------------
Eliot Lee
Founder and Editor
Anthro TECH, L.L.C
http://www.anthrotech.com/
info@anthrotech.com
==========================
Coconino Community College
http://www.coco.cc.az.us/
Web Technology
Coordinator
elee@coco.cc.az.us

Thanx for the info, i'll give it a go. I was hoping that I could have small "Search" box on the Site index page, just like the boxes at the foot of this page which you could type in City/Name and it would then go search the DB for your required citiesPubs Clubs.

I'm trying to make navigation a little easier as at the moment to access the information,
you have to visit the site, then click the Search/Join Button on the Index page, enter the DB via the Log On, click the Search/Add button again then carry out your required action. It's all a little bit long winded, and takes a lot of time to actually get to the info.

Guess I'm trying to run before I can walk ;o)

With regards to the error message in the HTML.pl, I use MS Notepad to code, and it looks like a memory problem, Notepad it appears will only allow so many characters before sending the error message "Not enough Available Memory"

Awake,

Use WordPad or EditPlus. I use WordPad, which allows me to work with large files. EditPlus is another nice text editor that works well with cgi, perl, and javascript codes.

You can add a search box to your home page. Take a look at the following web page:

www.anthrotech.com/career/

You can simply add the following codes to your home page:


Of course, you can add other hidden fields for the following form variables:

so = sort order


Change ascend to descend if you want your records to appear in descending order.

sb = sort by


Change 1 to the field number that you want to sort by in your %db_def section of your default.cfg file.

Hope this helps.

Regards,


------------------
Eliot Lee
Founder and Editor
Anthro TECH, L.L.C
http://www.anthrotech.com/
info@anthrotech.com
==========================
Coconino Community College
http://www.coco.cc.az.us/
Web Technology
Coordinator
elee@coco.cc.az.us

[This message has been edited by Eliot (edited September 26, 1999).]

[This message has been edited by Eliot (edited September 26, 1999).]

 
That will put a field for a keyword search on whatever html page you want. Be sure to change the URL in the <form action= tag and to change the

name="db" value="default">

line if your database is not called "default."

Don't use Notepad to edit the html.pl file! You can pick up a freeware script called "Programmer's File Editor" that will work very well and a shareware ($20) program called EditPlus that's even better. There are links to both programs on my site at http://www.jpdeni.com/dbman/tutorial1.html .


------------------
JPD

Whoa, it works, thanx guys, really appreciated. That takes a whole lot of button clicking out of the equation.

Thanx for the info on editors too JPD, I'll check them out.

Awake - also until you find one of the other editors - you can get around the memory problem in Notepad by using "Word Pad" in win95 or 98.

To get to it - click on the Start button and then click on "run" then type in the word "wordpad" in the provided field and then click "ok".

I do recommend that you get one of the editors JPD mentions as soon as you can - but Wordpad will do the job until you can.

Hope this helps !
------------------
donm

[This message has been edited by donm (edited September 26, 1999).]

donm,

I did suggest using WordPad in my previous Post.



Regards,

------------------
Eliot Lee
Founder and Editor
Anthro TECH, L.L.C
http://www.anthrotech.com/
info@anthrotech.com
==========================
Coconino Community College
http://www.coco.cc.az.us/
Web Technology
Coordinator
elee@coco.cc.az.us

Once again, thanks, I'll go get one of the editors as suggested, hopefully this will resolve the problems i've got. It's been infuriating as I haven't be able to put as much HTML code in the HTML.pl as I would have liked, and being a complete lost cause when it comes to any kind of script, I didn't know how to resolve it.

Nice to know that there is such good help out there for such a good database.

Cheers Guys and Gals

Mark

Try Arachnophillia

Its great for cgi and pearl and it's FREE

download it from www.downloads.com

MDJ