This is a forum where members new and old can come to ask questions and get info and opinions. It is not a place to advertise your business or have other forms of advertising, whether it be in your posts or signature.

All links in the forum will not be indexed by Search Engines and any unapproved forms of advertising or spam will be dealt with accordingly, deleted, and that member's account banned.

Forums

Overview » Dreamweaver » Jumpmenu to get records out of database

Jumpmenu to get records out of database
Igor B Member Since: 30 Dec 2001 Posts: 19	Posted 30 Dec 2001 23:11:19 I want to use the DW jumpmenu to get records from my database. Jumpmenu contains: - rave - trance - hardtrance The recordset (rsResults) has the following: - from .MDB colums: Product, Description and Price. - The SQL coding (in advanced settings in UD): SELECT * FROM Products WHERE ProductGroup= 'hardtrance' ORDER BY Product ASC This SQL is all I have at this moment. It is just static now and not good for what I want to do with the jumpmenu. I has to contain a variable to 'communicate' with the SQL. I think this has to do with "WHERE Artikel= 'hardtrance'". That 'hardtrance' has to be replaced by a variable but I just don't know with what variable and how to change the value (or other) settings from the jumpmenu. So please help me if possible. Thanx. Edited by - ornathon on 30 Dec 2001 23:20:03 I want to use the DW jumpmenu to get records from my database. Jumpmenu contains: - rave - trance - hardtrance The recordset (rsResults) has the following: - from .MDB colums: Product, Description and Price. - The SQL coding (in advanced settings in UD): SELECT * FROM Products WHERE ProductGroup= 'hardtrance' ORDER BY Product ASC This SQL is all I have at this moment. It is just static now and not good for what I want to do with the jumpmenu. I has to contain a variable to 'communicate' with the SQL. I think this has to do with "WHERE Artikel= 'hardtrance'". That 'hardtrance' has to be replaced by a variable but I just don't know with what variable and how to change the value (or other) settings from the jumpmenu. So please help me if possible. Thanx. Edited by - ornathon on 30 Dec 2001 23:20:03

Jumpmenu to get records out of database

Igor B
Member

Since: 30 Dec 2001
Posts: 19

Posted 30 Dec 2001 23:11:19

I want to use the DW jumpmenu to get records from my database.

Jumpmenu contains:
- rave
- trance
- hardtrance

The recordset (rsResults) has the following:
- from .MDB colums: Product, Description and Price.
- The SQL coding (in advanced settings in UD):
SELECT *
FROM Products
WHERE ProductGroup= 'hardtrance'
ORDER BY Product ASC

This SQL is all I have at this moment. It is just static now and not good for what I want to do with the jumpmenu. I has to contain a variable to 'communicate' with the SQL. I think this has to do with "WHERE Artikel= 'hardtrance'".
That 'hardtrance' has to be replaced by a variable but I just don't know with what variable and how to change the value (or other) settings from the jumpmenu.

So please help me if possible. Thanx.

Edited by - ornathon on 30 Dec 2001 23:20:03

I want to use the DW jumpmenu to get records from my database.

Jumpmenu contains:
- rave
- trance
- hardtrance

The recordset (rsResults) has the following:
- from .MDB colums: Product, Description and Price.
- The SQL coding (in advanced settings in UD):
SELECT *
FROM Products
WHERE ProductGroup= 'hardtrance'
ORDER BY Product ASC

This SQL is all I have at this moment. It is just static now and not good for what I want to do with the jumpmenu. I has to contain a variable to 'communicate' with the SQL. I think this has to do with "WHERE Artikel= 'hardtrance'".
That 'hardtrance' has to be replaced by a variable but I just don't know with what variable and how to change the value (or other) settings from the jumpmenu.

So please help me if possible. Thanx.

Edited by - ornathon on 30 Dec 2001 23:20:03

Owen Eastwick lost Member Since: 10 May 2001 Posts: 748	Replied 31 Dec 2001 07:08:25 Something like: If Request("JumpMenuName" <> "" Then varProductGroup = Request("JumpMenuName" Else varProductGroup = "%" then YourRecordsetName.Source = "SELECT * FROM Products WHERE ProductGroup= '" & varProductGroup & "' ORDER BY Product ASC" Take a look at the link below for more ideas. Regards Owen. Multiple Parameter UD4 / Access 2000 Database Search Tutorial: www.tdsf.co.uk/tdsfdemo

Igor B Locked Member Since: 30 Dec 2001 Posts: 19	Replied 31 Dec 2001 12:07:12 thanx! I will check it out

Igor B Locked Member Since: 30 Dec 2001 Posts: 19	Replied 31 Dec 2001 20:20:46 Hi again....it didn't work out so wel. I have used a bit of your code. This is how is looks now: If Request ("NameJumpmenu" <> "" Then varArtikel = Request("NameJumpmenu" Else varArtikel = "null" End If rsResults.Source = "SELECT * FROM Products WHERE Artikel= "& Artikel &" ORDER BY Omschrijving ASC" Still it isn't working. Maybe it has to do with the jumpmenu code: <form name="componenten" method="post" action=""> <select onChange="MM_jumpMenu('parent',this,0)" name="componenten"> <option value="#" selected>Componenten</option> <option>rave</option> <option>trance</option> <option>hardtrance</option> So now I'm stuck again <lol> All suggestions are more than welcome

Owen Eastwick lost Member Since: 10 May 2001 Posts: 748	Replied 02 Jan 2002 00:23:15 This isn't the complete code you will need: ------------------------------------------------------------------------------- If Request ("NameJumpmenu" <> "" Then varArtikel = Request("NameJumpmenu" Else varArtikel = "null" End If rsResults.Source = "SELECT * FROM Products WHERE Artikel= "& Artikel &" ORDER BY Omschrijving ASC" ------------------------------------------------------------------------------- You will need the whole code for the recordset, use Data Bidndings > Recordset(Query): You will need to modify the jump menu, something like: <form name="componenten" method="post" action=""> <select onChange="MM_jumpMenu('parent',this,0)" name="componenten"> <option value="%" selected>Componenten</option> <option value="rave">rave</option> <option value="trance">trance</option> <option value="hardtrance">hardtrance</option> Regards Owen. Multiple Parameter UD4 / Access 2000 Database Search Tutorial: www.tdsf.co.uk/tdsfdemo Edited by - oeastwick on 02 Jan 2002 00:26:57

Igor B Locked Member Since: 30 Dec 2001 Posts: 19	Replied 02 Jan 2002 21:19:16 suck bigtime in UltraDev. I have modified the jumpmenu how you said to do: <form name="componenten" method="post" action=""> <select onChange="MM_jumpMenu('parent',this,0)" name="componenten"> <option value="%" selected>Componenten</option> <option value="rave">rave</option> <option value="trance">trance</option> <option value="hardtrance">hardtrance</option> But what do I have to do with the ASP to let it recognize the jumpmenu. Btw, what do you mean with "whole code for the recordset". That I have to make the code in Recordset(query)? Again, thanx for your help. I tried your tutorial and it rules. Though I couldn't combine it to make my jumpmenu-thing work <img src=../images/dmxzone/forum/icon_smile_sad.gif border=0 align=middle> Maybe it is important to know that the jumpmenu is on the same page as the resultpage. I've used other examples, but all this will be used on this site: www.bluestorm.nl/componenten/behuizing.html There are 2 seperate jumpmenu's. The text on the right (content) has to come from the database. Dropdownbox 1 (components): selArtikel Table: - ArtikelNr (the recordID) - Artikel (not shown on page, only used as search criteria..these are used in dropdownmenu) - Omschrijving (description like CPU 1400Mhz) - Prijs (the price) Ah man....what problems. LOL! Edited by - ornathon on 02 Jan 2002 22:25:06

Owen Eastwick lost Member Since: 10 May 2001 Posts: 748	Replied 03 Jan 2002 02:34:27 I had a look into this further and it appears you can't use a jump menu to do this. However I have worked out a solution that will give the result you want. I've created a page that will work with the Database in the UD4 Access Tutorial, so if you've dowloaded and installed that you should be able to unzip this file in the same directory and get the page working locally or just take a look at the code. You can see the page working here: www.tdsf.co.uk/tdsfdemo/JumpDemo.asp You can download the zipped page here: www.tdsf.co.uk/tdsfdemo/JumpDemo.zip Regards Owen. Multiple Parameter UD4 / Access 2000 Database Search Tutorial: www.tdsf.co.uk/tdsfdemo

Igor B Locked Member Since: 30 Dec 2001 Posts: 19	Replied 04 Jan 2002 15:25:05 thanx!!!! I appreciate your help <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle> Wow! did you handcode this? Much ASP coding. This demo almost needs a tutorial to see what's going on LOL! Edited by - ornathon on 04 Jan 2002 15:59:01

Igor B Locked Member Since: 30 Dec 2001 Posts: 19	Replied 05 Jan 2002 03:32:19 Okay it is working! Thanx again. I think it would be a great add-on for your advanced search tutorial <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle> I see that on your site: www.tdsf.co.uk/tdsfdemo/JumpDemo.asp you can see directly all artists, without searching. Is it possible to let the screen be empty and let the records ONLY appear after you use the jumplink? I tried to insert a new word in the jumpmenu and changed the value to NULL and #, but thit trick doesn't work on this one. <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle> Edited by - ornathon on 05 Jan 2002 03:33:29

alice xiao Member Since: 20 Mar 2008 Posts: 9	Replied 01 Apr 2008 11:16:06 when i used the demo sample on my own computer i always got the error of Error Type: ADODB.Command (0x800A0BB9) Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. how come? and the error was caused by Recordset1_cmd.ActiveConnection = MM_testconn_STRING...