Forums

This topic is locked

Bit Confused ???

Posted 28 Apr 2002 23:46:05
1
has voted
28 Apr 2002 23:46:05 David Thomas posted:
Hi all,
Where do i start..... Okay, Access DB with a table called "scripts"
Fields:- Id,Script,Category,Url,Description etc...
and a Table called "Categories" with fields : 'Id' and 'Category'.

I've established a relationship between the field "category" in the both tables.

I have a search box, (which works fine)i can filter the records easily enough to search script name or keywords etc.., by passing the form variable. BUT How do i do it from a link only.

For example in my menu, a link called "Browser Scripts" is to open a page (browser_scripts.asp) to display records from the category "Browser". But not knowing a great deal of SQL im finding it a bit of a struggle, and UD only gives so many pre defined options.

Is it using the URL variable and if so how?
The Help files aren't very specific on this one.
I hope i explained this clearly enough. Thank for any advice.

"Those who think they know it all, in fact no nothing at all" - Me!

Replies

Replied 29 Apr 2002 23:49:14
29 Apr 2002 23:49:14 Dennis van Galen replied:
this may sound like a DUH solution...but did you think about using goto detail page behavior for this, have it submit a URL parameter, like: Category=Scripts showing all scripts or Category=Tutorial showing all tutorials, just switch the filter from form to url param. should work fine.

With kind regards,

Dennis van Galen
Webmaster KPN Services
Financial and Information Services
Replied 30 Apr 2002 03:00:25
30 Apr 2002 03:00:25 David Thomas replied:
Thanks Dennis, it most probably is a Duh!! question. But thats what the forum is for <img src=../images/dmxzone/forum/icon_smile_cool.gif border=0 align=middle>

I will try it the way you say, and thanks for the reply. Much appreciated.

"Those who think they know it all, in fact no nothing at all" - Me!
Replied 30 Apr 2002 11:50:09
30 Apr 2002 11:50:09 David Thomas replied:
Well, no joy here.

I can get all scripts to display easily, just add a recordset with no filter.

But I still cant get only "Browser" related scripts to show up. I know this can be done using the list/select form element like in the tutorial, but when i try and pass it as a URL var then it displayes the last record in "category", NOT "browsers", and the page is blank.
If anyone wants to take a look at how i am doing it, i will share the FTP info so you can have a look at the DB etc..
Or am i just Stupid??? (Don't answer that)<img src=../images/dmxzone/forum/icon_smile_wink.gif border=0 align=middle>

"Those who think they know it all, in fact no nothing at all" - Me!
Replied 30 Apr 2002 12:25:03
30 Apr 2002 12:25:03 David Thomas replied:
I managed to sort this out. Yippee <img src=../images/dmxzone/forum/icon_smile_cool.gif border=0 align=middle>

I just buried my head in an SQL book and learnt advanced queries.
Created a WHERE statement and variable for the recordset, and it worked 2nd time.

Topic Closed.

"Those who think they know it all, in fact no nothing at all" - Me!

Reply to this topic