|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
| ||||||||||||||||||||||||||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#16
May 15th, 2008, 04:17 AM
|
|||
|
|||
|
Quote:
Thanks, I'll accept ur suggestion & try to create a new thread in the meantime.
|
|
#17
February 13th, 2009, 06:09 AM
|
|||
|
|||
|
Hi there,
I'm new to ASP so still learning. I have incorporated your code into my page and it is working perfectly - Thanks so much! I have a question though - how do I get it to save the selections in my access database? For the other ones I use Code:
value="<%=answers(13)%> Please be gentle if this is a really stupid question :-) Thanks Tottiescones
|
|
#18
August 5th, 2009, 06:23 AM
|
|||
|
|||
|
thank you for this solution but I want ask a question. I try to understand the script and If we want use 3 different tables what we will do. there is a problem with this we can make it from sql? or we will use extra codes and how we will do it...
|
|
#19
August 5th, 2009, 08:33 AM
|
|||
|
|||
|
Code:
<%
Set oConnection = Server.CreateObject("ADODB.Connection")
Set oRecordset = Server.CreateObject("ADODB.Recordset")
'temp="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("db/ntsrsschsp.mdb")
sSQLTitle= "DRIVER={MySQL ODBC 5.1 Driver}; SERVER=XXXXX; DATABASE=XXXXX; UID=XXXXX;PASSWORD=XXXXX; OPTION=3"
oConnection.Open sSQLTitle
sQuery = "SELECT * from tbl_product_sector,tbl_product_category,tbl_produc t_down_category where tbl_product_sector.ID=tbl_product_category.Sector_ ID and tbl_product_category.ID=tbl_product_down_category. Top_Category " ' << insert your own sql here
%>
<FORM id=form1 name=form1>
<%
Response.Write TripleLinkedList(oConnection, sQuery, "listboxname", 1, "dbfieldname-for-1st-listbox", "dbfieldname-for-2nd-listbox", "dbfieldname-for-3rd-listbox", "name-of-the-result-from-sql")
oConnection.Close
Set oConnection = Nothing
%>
</FORM>
My code is here and I want a solutions. ADODB.Recordset error '800a0cc1' Item cannot be found in the collection corresponding to the requested name or ordinal. /test/01.asp, line 100 when I put my code I recive this mistake. what is the solution. yhe script code and base code is the same 1st page at the top. can anybody solve it...
|
|
#20
August 5th, 2009, 09:30 AM
|
||||
|
||||
|
the field name "dbfieldname-for-1st-listbox" is just as example, you must
replace it with real field name that exists in one of the tables you read from.
|
|
#21
August 5th, 2009, 10:45 AM
|
|||
|
|||
|
Code:
<%
Set oConnection = Server.CreateObject("ADODB.Connection")
Set oRecordset = Server.CreateObject("ADODB.Recordset")
'temp="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("db/ntsrsschsp.mdb")
sSQLTitle= "DRIVER={MySQL ODBC 5.1 Driver}; SERVER=localhost; DATABASE=XXXXX; UID=XXXXX;PASSWORD=XXXXX; OPTION=3"
oConnection.Open sSQLTitle
sQuery = "SELECT * from tbl_product_sector,tbl_product_category,tbl_produc t_down_category where tbl_product_sector.ID=tbl_product_category.Sector_ ID and tbl_product_category.ID=tbl_product_down_category. Top_Category " ' << insert your own sql here
%>
<FORM id=form1 name=form1>
<%
Response.Write TripleLinkedList(oConnection, sQuery, "listboxname", 1, "Sectors", "Category_Name", "Category", "name-of-the-result-from-sql")
oConnection.Close
Set oConnection = Nothing
%>
</FORM>
thank you for your solution. I cant understand the name-of-the-result-from-sql what should be? I run it with out name-of-the-result-from-sql And it is worked but I think I make A mistake with my SQL Query. I have 3 product table sector-->category--> catsegory 2 I had 3 tables. tbl_product_sector,tbl_product_category,tbl_produc t_down_category. can you help me on this. what should be the SQL query. and if in our categories most of them had the 3 category. but some of them dont have. just have sectors and product category. we will do it with if else. what will be our code... how we will solve it. can you help me on it. thank you for your time.
|
|
#22
August 13th, 2009, 08:07 PM
|
|||
|
|||
|
yes,
can someone help what should this sQuery be??
|
|
#23
August 13th, 2009, 08:13 PM
|
|||
|
|||
|
by the way,
Can you plscsend a complete working form of this script. With a database and asp file.
|
|
#24
August 14th, 2009, 09:00 AM
|
|||
|
|||
|
any idea?
|
|
#25
August 14th, 2009, 07:32 PM
|
|||
|
|||
|
thank you for every body. but I dont Understand There is no body wants to help us. I see examples in php and .net but I cant convert them to Classic ASP mode.
My aim is to learn it. And I would use it in my personal web site. select continent after that country and after that city. some countries dont have cities. just this. like I will add to 20 country which have city list and the others no. 7 continent 55 country and from theese 55 just 20 of them has cities. triple dropdown list. please help me on this.
|
|
#26
August 15th, 2009, 06:11 AM
|
|||
|
|||
|
I am waiting for Shadow Wizard
I think He is expert
|
|
#27
August 18th, 2009, 02:54 AM
|
||||
|
||||
|
sorry to disappoint you.. since I didn't write this code originally there's little
I can do to help in this case as I don't know how the code work exactly, all I can help with is the syntax and maybe some tips. I couldn't crack the usage of "sDBFieldResult" parameter in the function, which is what you pass as "name-of-the-result-from-sql" and I don't have the time to start learning the logic behind the code - you better send message to the original poster of the code hopefully he's around. worst case if you can't use this, find something else - that's what I'm doing. 
|
|
#28
August 19th, 2009, 12:12 AM
|
|||
|
|||
|
thank you shadow. I have been thinking for the another way to solve the problem. I find it with the iframe. In iframe I use case selection. and I get the details from ifram with java sctipt codes. this way until I can write the code or I solve it it a littile solution.
but if you have a some codes about this I hope to help us about it. because you know that some browsers disable the javascript. so that we should find the code. the problem I cant understand one think can any body write a code in three selection in one table. I think is so useless. another think. do you have any ideas about jquery with asp. if you have I had a paging problem. thank you fro your time...
|
|
#29
August 19th, 2009, 03:58 AM
|
||||
|
||||
|
not sure how iframe is related but if you say it's working then I won't argue.
regarding JavaScript, I'm also using it extensively, unless it's critical issue you can add such code to warn users who disabled it: Code:
<noscript>Your browser does not enable JavaScript, you might experience problems using this page.</noscript> most major websites today are using JavaScript as part of their "core" IMO there's no need to write special code for such case when user has it disabled. jQuery is not relatd to ASP, it's pure client side issue. if you have problems with it feel free to start new thread in the HTML/JavaScript forum.
|
|
#30
August 19th, 2009, 08:59 AM
|
|||
|
|||
|
thank you shadow.
when I do it I use a function which take the value from iframe and put it automatically in the text input after that you can take the value. I'm sorry about it but when I was in the bed ı think about it. and I do it so fast. I will write the jquery problem please check it and if you can help me I will be happy so much. thanks...
|
|
| Viewing: ASP Free Forums > Programming > Code Bank > Dynamic Triple Linked Dropdowns |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
