I have been working on my site for a very long time and am almost done. I needed a powerful database, so I chose DBMan based on user recommendation. I have set up the database the way I want it (with the excellent "validate records" mod, but I have noticed some things about the database that must be changed before I can release the site.

I have a description field that is to be displayed with every record. These fields will contain large amounts of text. However, whenever I view the record after it is submitted, the text continues across the screen and does not "word wrap" as it could be called. The description field is a text area and I have installed the "autogenerate enhancements" mod (just the part that replaces sub_build_html) but nothing is happening.

That brings me to my next problem. I need to make web addresses automatically into clickable links - "autogenerate enhancements" is supposed to do that as well, but it does not. I have tried "AutoURL 2.0" as well, but I still do not end up with clickable links.

The only other thing I would like to do is make the whole database appear as a pop-up window. It would be ideal for my site.

If anyone would be kind enough to help, I'd be very grateful.


P.S. - JPDeni - your site is very well done and extremely helpful.

It should wrap at spaces, unless you have another field that is very long and is expanding your table.

With the "autogenerate enhancements," the "clickableness" of the link is dependent upon the beginning of the field being http:/. If your urls are just in the form of "www.something.com," you'll need to change it to "http://www.something.com".

I know there are threads here that discuss pop-up windows. I don't "do" javascript, though, so I can't help on this.

Thank you! It's nice to know I've been able to create something to make the DBMan world a little better.


JPD
http://www.jpdeni.com/dbman/

I figured out how to do the pop-up window by searching this board - I guess I should have done that first.

All of my links start with http:// and I have the autogenerate enhancements mod installed. I also still cannot figure out why the text continues across the screen and does not wrap.

The autogenerate enhancements mod contains several steps, but the only part I installed was the one that replaced the sub build_html subroutine because it contained (according to the description) all of the features that I wanted. Do I have to go though every step? Or is there something else I am doing wrong?

do u mind tell me the ur of your site ?

It's below my signature.


JPD
http://www.jpdeni.com/dbman/

Parallax, I think I need to see your database in action.

JPD
http://www.jpdeni.com/dbman/

=) not yours carol
may be i reply to the wrong person

You can get my site at http://www.digitalmagik.com/click/
and you can see the database at http://www.digitalmagik.com/click/db/db.cgi

I have set up the database the way I want it, with the exception of the two problems I am having (clickable links, wrapping) and the fact that I have not edited the html to match the layout of my site yet.

Hi Parallax,

I went in to your database to see if I could help out with some of the problems, but no records had been added, so I added a test record to see the output. (hope you don't mind)

The clickable links problem is fairly simple to solve. In sub html_record, try the following code:

Code:

<tr><td>Web Site:</td>
<td><a href="$rec{'WebSite'}">$rec{'WebSite'}</a></td></tr>

Change $rec{'WebSite'} to match the appropriate field name. You can also add similar code to the other fields with links.

As for the wrapping, maybe I didn't enter a long enough enough description, but it seems to be working fine. In fact, it's probobly working a little too well because long URLs are being wrapped. This is easily fixed by increasing the TABLE in which the records are being displayed in.

- Mark

Astro-Boy!!
http://www.zip.com.au/~astroboy/

The reason that the autogenerate enhancements are not working is that you are not using the autogenerate feature. If you want to use the code from the autogenerate enhancements, you will have to set $db_auto_generate = 1; in the .cfg file.

I can't answer anything about your word-wrapping problem, because there are no records in your database.

JPD
http://www.jpdeni.com/dbman/

I turned on $db_auto_generate and the links worked. The wrapping was also always working, it's just that when I was testing the database I would just hold down a key in the description field (without any spaces) so the wrapping would not work. I should have picked up on it when JPDeni said "It should wrap at spaces."

Thanks a lot to everyone that helped, and, Astroboy, I don't mind.