Hiya guys and gals - can someone please help me with this? I must be missing something here but ater 3 hours I cant find what Im doing wrong.

For some reason, the links in the displays are not working. I have 1 x mailto field and 1 x http:// link (each link goes off to the public html directory to a unique html file per record in my database - nothing clever)...

.... however, whilst the fields in the display for each record show the correct email address and the correct html file....... the links themselves point to the directory of my dbman folder in my cgi bin; and the mailto links simply go to "". Upon checking the sourcecode of outputted results, both the mailto field and the http field show "" as the result - which explains why the DBman directory is being shown as the clickable links.

What I can't for the life of me figure out is why this is happening? The code is reading what the mailto and http links should be (they are visable on the results) its just that the links behind them are broken for some reason...

Any help would be appreciated, or if there is any code you need copied on here to help solve this, let me know! I really need to get this sorted.

Thanks greatly in advance

At the top of your sub html_record and/or sub html_record_long add:

$url{'Email'} = $rec{'Email'};
$url{'Email'} =~ s/<\/?B>//g;
$url{'URL'} = $rec{'URL'};
$url{'URL'} =~ s/<\/?B>//g;

renaming to your actual field names. This will ensure that if you have bolding turned on that it will not cause problems with your links.

Then for example your code would look something like this for the display:

Visit our web: &nbsp; <A HREF="$url{'URL'}" target="blank">$rec{'URL_Title'}</A>

Send Email: &nbsp; <A HREF="mailto:$url{'Email'}">Send Email</A>

If you still have problems, please post what you are using for your links and how you have the fields setup in your .cfg file.

If you are using the autogenerate feature for your database then you will want to check out the Resource Center for "Autogenerate Enhancements" which provides the code changes needed for clickable links. Or directly from JPDeni's site at http://www.jpdeni.com/dbman/

Unoffical DBMan FAQ

http://creativecomputingweb.com/dbman/index.shtml/

I gave what you suggested a try, but it didnt work unfortunately...

Here's how I have the links set up in the sub html_record_form {



and the following for the sub html_record {

'Contributor' => [ 7, 'alpha', 20, 255, 1, '', '.+@.+..+'],
'Get Sheet' => [ 9, 'alpha', 20, 255, 1, 'http://', '^http://'],[/code]Thanks for your help, I hope we can fix this

The only other thing I can think of is that perhaps you didn't close off a previous link reference. Such as in your footer.

You you forgot say adding an </A> somewhere prior to where the script shows the record it could cause problems.

Or perhaps a missing " within your display coding?

What you could do is to take that portion of your coding and put it into your text editor and save it as an html file, then view it to see if the links appear. If not, then you will know it is within the display code.

Unoffical DBMan FAQ

http://creativecomputingweb.com/dbman/index.shtml/

heh - thanks for your help........ I'd missed a single quote mark, goddammit!

Again, thanks for all your help - everything works fine now.