Gossamer Forum
Home : Products : DBMan : Installation :

dynamically linking to a user profile in a database.

Quote Reply
dynamically linking to a user profile in a database.
I am using DBMan as a database to store people's profiles who submit artwork, etc.. to my website. What I want to do is associate each image with its artist, so when the image (or a button) is clicked, the artist's profile is brought
up. Any ideas. Please email directly if you want.

thanks!

[This message has been edited by luthien (edited January 09, 1999).]
Quote Reply
Re: dynamically linking to a user profile in a database. In reply to
Well, assuming you use a username as the database key, you could just create a link like:

db.cgi?uid=default&view_records=1&ww=1&ID=bob

to automatically pull up the record with ID=bob. The ww=1 will make sure it doesn't pull up ID=bobby as well..

Hope that helps,

Alex
Quote Reply
Re: dynamically linking to a user profile in a database. In reply to
it seems like it wants to work, but I get this error - "invalid/expired user session".

I tried to exchange the 'guest' part with 'admin', but same results. (I did change 'bob' to a real ID...) BTW - what field does ID refer to?

thanks

[This message has been edited by luthien (edited January 09, 1999).]
Quote Reply
Re: dynamically linking to a user profile in a database. In reply to
Well, assuming all the artwork is submitted through DBMAN, as is the Authors name/info, why not edit the scripts to make an HTML tag when they sign up, similar to how the URL and E-Mail address fields are?



------------------
James A. (Jamie) Dennis
*Certified AIX Administrator
*Certified Solaris Administrator
*Member - SAGE, USENIX
Quote Reply
Re: dynamically linking to a user profile in a database. In reply to
I dont have DBMAN set up for file submissions (yet?) ... basically all i
need is the proper way to link from an ordinary html page 'directly' to a
specific user profile in the database. I just cant seem to figure out how
to get the "&ID=bob" part of "db.cgi?uid=default&view_records=1&ww=1&ID=bob"
to work without getting the "invalid/expired user session" error.
Quote Reply
Re: dynamically linking to a user profile in a database. In reply to
In your .cfg file, be sure you set $auth_allow_default to 1. You will probably also want to set @auth_default_permissions = (1,0,0,0,0)

That should keep you from getting the invalid/expired user session message.



------------------
JPD
Quote Reply
Re: dynamically linking to a user profile in a database. In reply to
thanks! that seems to be what I was looking for.
Quote Reply
Re: dynamically linking to a user profile in a database. In reply to
I'm trying to do this also. I have a $rec{'ID'} that I'm trying to link with from a short list (ie, only some of the fields in the record are listed and it links to the entire record). My code is:

<a href="db.cgi?uid=default&view_records=1&ww=1&ID=$rec{'ID'}">View ID No. $rec{'ID'}</a>

The error I get is:

There were problems with the search. Reason: no search terms specified

Is this 'cuz I can't use ID=$rec('ID'} in the linking URL?

Thanks in advance. This forum is super helpful. I've made quite a few modifications and changes without having to ask! Smile

--Train
Quote Reply
Re: dynamically linking to a user profile in a database. In reply to
Train, I'm not sure what you are trying to do. Are you, as luthien was, trying to create the links on a static html page?

If so, you have to enter the ID number within your link on the html page.

<a href="db.cgi?uid=default&view_records=1&ww=1&ID=47">View ID No. 47</a>

replacing the "47" above with whatever the key is for the record you want to link to.


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





Quote Reply
Re: dynamically linking to a user profile in a database. In reply to
I have a short description page that displays short records (only some of the fields in the record). I want it to have a clickable link to display the entire record.

I've tried what I've found in this forum, but haven't been successful in getting it to work. Right now I have the url as you show above written to the database, but I get the error:

There were problems with the search. Reason: no search terms specified

when I click on it. How can I make it bring up the entire record from the short description page generated from a search?

--Train

Quote Reply
Re: dynamically linking to a user profile in a database. In reply to
So you want to link from the short display that DBMan generates to a long display? I'm sorry. I misunderstood.

In your "short display" subroutine include

<a href="$db_script_link_url&$db_key=$rec{$db_key}&ww=1&view_records=1">



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