I have the short-long mod working at http://ah/...cgi-bin/k_mod/db.cgi you can log in as guest

When you click on 'List All' you get different fields being displayed on different lines of the Search Results page. I have looked through the Support Forum in the DBMAN customization section and have not found anyone else mentioning this problem.

Any clues about what could be causing this?

Thanks

David

The url you supplied gives a page not found error.

What is displayed in the short list is determined by what you have entered in sub html_record. Check over that section and be sure you have followed the instructions on how to display your fields.

You can post that portion of your code or provide a link to a .txt copy of your html.pl file so we can check it over for you.

Unoffical DBMan FAQ

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

dang, fat fingered it!

ok, let's try it this way:



http://ah.web2dave.com/html_record.txt



has just the html_record portion.

Thanks,

David

Since the long display seems to be working properly, there's gotta be something wrong with the part of the script that runs the short display...

Compare this bit of code against yours:



The $record_number bit seems to be slightly different than what you have (this version is dated 25 Jul 2000 from JPDeni so it very well may be ok for the bits not to match).

My suggestion would be the same as LoisC's. Go back and verify that the mod was put in and replaces all of the proper parts.

Thank you for your input.

I did check the version I have against the version available in the

Mods section on JP Deni's site, I have not yet found a difference

between the original and my application ( other than the things

that are specific to my application ). Still looking...

Rather than using:

print qq|
<a href="$long_url">
$rec{'Graduation_Year'}&nbsp
$rec{'Graduation_Last_Name'}&nbsp
$rec{'First_Name'}
</a>
|;

Try using something like this:

print qq|
$rec{'Graduation_Year'}</TD>
<TD><a href="$long_url">$rec{'Graduation_Last_Name'}</A></TD>
<TD>$rec{'First_Name'}
|;

I think it's best to just choose one field for the long_url and not several.

Since I can't see what it's actually doing I can't offer any other suggestions at this time.

Unoffical DBMan FAQ

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

here is the link to the application:

http://ah.web2dave.com/cgi-bin/k_mod/db.cgi

access w/ guest / guest

I have the entire html.pl posted at

http://ah.web2dave.com/html_record.txt

even though the file name has not been changed, I pasted

the whole html.pl into it. You will see that I have made the

change you suggested, something still is not working correctly.

Thanks,

David

I can't spot anything that could be causing the problem, and really dont' see how it can be displaying more fields that was is defined in the html_record sub?

Are you positive that you uploaded the changed html.pl file to your server? I would also suggest checking over your html coding .. especially where you define widths as percentages and perhaps enclose those in quotes such as width="50%".

Since your short display is showing quotes in the record I'm thinking perhaps there mismatched quotation marks somewhere in your code.

Unoffical DBMan FAQ

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

T H A N K Y O U !

Thank you, thank you.

The hint about the quotes was right on, I looked in the database and

sure enough, there were some entries in there with quotes in. Once

I got rid of those, it works a treat!

Best regards,

David

Great! I'm so glad you got the problem solved!!

Unoffical DBMan FAQ

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