Gossamer Forum
Home : Products : DBMan : Installation :

linking into database

Quote Reply
linking into database
I would like to link to different categories in the database while taking the UID and sort order etc. into consideration. Here's what I have so far as an example link:

<a href="/cgi-bin/db/db.cgi?db=reviews&uid=$in{'uid'}&Category= Bars&so=ascend&view_records=View+Records">Bars</a>

My problem is that $in{'uid'} doesn't work after the person has logged in -- when they're at db.cgi - it just puts them back at the logon screen.
__

One more quick question, I added:
$in{'keyword'} to show the search terms in the results page. It works on the first page, but not on the second. -- like switching from short to long view loses the keyword. If you need a url, let me know. The page is under construction so its pretty messy right now.

Anyways, thanks for your help!



------------------
Jason
Extreme mtb
http://extreme.nas.net
Quote Reply
Re: linking into database In reply to
First one's easy -- use $db_uid instead of $in{'uid'}.

Second one I'd need to see a URL..

Cheers,

Alex
Quote Reply
Re: linking into database In reply to
Thanks for answering my first question. You can see my database at http://extreme.nas.net/...ews&uid=defaul t

Go to the search page and enter "Jason" as a keyword and choose to return results in "brief". It should say "Your search for Jason returned 4 matches." Click where it says "click here for more" -- which will bring you to a full view. It then says "your search for returned 1 matches."

Does that make sense? If you need some clarity on that one, let me know.

Thanks for all of your help, my database is almost done!


------------------
Jason
Extreme mtb
extreme.nas.net

[This message has been edited by jdulberg (edited December 10, 1998).]

[This message has been edited by jdulberg (edited December 10, 1998).]
Quote Reply
Re: linking into database In reply to
Unfortunately there's not an easy fix. Because you don't know what the user searches on, it's difficult to write out a message.

For example if you search for Category=Clothing, then no message is displayed. It only works with keywords (as I'm assuming you are just displaying $in{'keyword'})?

There isn't really an easy fix for this.

Cheers,

Alex
Quote Reply
Re: linking into database In reply to
Yeah, I'm using $in{'keyword'}. I'll have to figure out a way around that. Thanks for all of your help, its greatly appreciated.


------------------
Jason
Extreme mtb
http://extreme.nas.net
Quote Reply
Re: linking into database In reply to
Jason,

I don't know if you can do that. The way I set up the mod for the long view, it is technically searching by the ID when it goes into the long view.

The only way I can see to do it, and I am not sure technically how, would be to insert the search string into the link but with the long=1 (or whatever you use).

-Norm
Quote Reply
Re: linking into database In reply to
Looking at the example link that I gave in the first post:

<a href="/cgi-bin/db/db.cgi?db=reviews&uid=$in{'uid'}&Category= Bars&so=ascend&view_records=View+Records">Bars</a>

Is there some way to retrieve &Category= from the search string?

------------------
Jason
Extreme mtb
http://extreme.nas.net