Dropdown To Execute
what If i wanted to have a dropdown that executed a query based off the selection. so i have a dropdown on page and when they make there selection it queries other data with out submit?
View Replieswhat If i wanted to have a dropdown that executed a query based off the selection. so i have a dropdown on page and when they make there selection it queries other data with out submit?
View RepliesI have a category that I will call "company". in my access DB, there are about 6 or so companies. On another table, I have a list of locations that are related to these companies.
What I want to do, is have a drop down menu that lists all the companies. When you select the company, the second drop down menu will automatically populate with the locations of the company you selected in the first dropdown.
Anyone know any links to some examples of this? My google searches have been pretty fruitless since Im having a bit of a problem trying to explain it concisely (as you probably noticed).
WEll I see that this issue is not yet solved ...
So here's some more beef...
There is an update the first part of the query that takes ~50 seconds
and the connection gets cut off at 30 sec sharp. Logical as the default value us 30 sec.
question :Does anyone know how to increase that value? I can't do it in the udl , it reverts back to nothing.
Option:
[1]I would/could also optimize that update using a hint to fasten it
[2] Or try to execute the proc without using the dsn?
Using ASP 3 on an ISP account (I don't have access to the root of the
server). I have a page that does some intake processing and I'd like to have
it run every 5 minutes. Right now, the only way I can see to do this is to
have a client task that wakes up every 5 minutes and opens that page.Is
there a better way?
how can i setup a connection to run the sql statement? how can i embedded it in the script? Code:
View Replies View RelatedI recently moved an app over to IIS 6 from IIS 5. Everything works great! I use ASPExecute to run an .exe - but it doesn't fire. It just sits in the process window. Doesn't do anything. Is IWAM, or IUSR or both required to run it?
View Replies View RelatedI need to use a VB6 dll like an ActiveX in ASP page. This dll use other .exe that is configured en DCOMCNFG and this dll is configured too in the same environment (DCOMCNFG) like a DllSurrogate with an specific user administrator.
I don't know how to configure this dll & IIS to it works with Anonymous authentication. I need to do this because is a development that it works in an Internet environtment and I can't assign a administration user in IIS 5 to the anonymous user.
Does anyone have any code to display a dynamic dropdown menu (similar to Windows Start menu)? There seems to be a browser compatability problem with most that I've seen.
View Replies View RelatedI am trying to get the value of a dropdown box which is populated from a access database.
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("mydb.mdb"))
set rs=Server.CreateObject("ADODB.recordset")
sql="SELECT DISTINCT Company FROM Customers ORDER BY Company"
rs.Open sql,conn
company=request.form("company")
%>
I need to send dthe value of this dropdown to the next page which will response.write the company name. Any ideas on how to do this?
i had done coding for two dependent dynamic drop down boxes.taking code from http://forums.aspfree.com/t53159/s.html......it is working nice
but now select 2nd box and populate 3rd one.i m very confused how make a changes in code for 3rd one.if any of u
have time i can send my code for urs technicalful advise
I have code to present on this forum, but not with me at the moment. This is what is happening now. On my page there is a drop down box that calls on an onChange javascript function. The drop down box dynamically displays locations depending on the location of the cars.
Therefore...if Toyota Camrys are in Philadelphia and New York, the drop-down box will display: ALL, Philadelphia, and New York. Selecting one will filter out only those in that location.
What i want to do is...change it so...it displays dynamically the locations horizontally...here is an example: PREFERED LOCATION? ALL PHILADELPHIA NEW YORK (all are links to filter out those that do not match the location).
i need to do it to save space and make it more user-friendly.
I know this is supposed to be easy but I can't get this to work. I
have a dropdown that pulls all the Projects (tp_title) available. All
I want to do is get the ID (tp_id) of that record so I can get the
developer assigned to that project (tp_assigned_to). Then, when I get
the developer, I need that to be redirected to a second page. Code:
I've got an XML file that I use to populate a treeview control and a dropdown box. That works fine, although I now want to be able to sort the list of people in the dropdown list. Someone suggested using an XML template, but I'm a bit of an XML newbie and not sure how to do this. Code:
View Replies View RelatedLets say you have a dropdown box with few options in it. Several products have such a dropdown box. is there a way to do this following stuff.
I want one of that options in the dropdown box to be 'unique'. When selected, it would dissapear, or it can't be clicked on, on another product's dropdown. 'yes or no' answer would do just fine for now.
Now that I can store variables from a form listbox into a session variable... say there are 4 options from the dropdown like
model
type
area
performance
and the user selects performance.. I store the string "performance". now how do I place it back into the listbox after the user hits 'submit'? that way the selected values are shown.
i have a web page which allows user to update Subject information. There may be several subjects in the dropdown box. However, each person will have a subject allocated to him when he is inserted into the database.
As such, now when i want to update his particulars, in the Subject dropdown box, i would like to set his Subject to the one in the database followed by the rest which he can choose.
Eg.
Originally, Subject = Literature
Update:
in Subject dropdown box, i will see Literature at default but when i click the dropdown box, i will see the other options such as History, Gepgraphy etc. How should i go about doing this?
Can server.execute provide a return value? How? ie.
dim test
test = server.execute("page2.asp")
What code in page2.asp will produce something in test?
my global.asa file doesn't seem to be executing in IIS and i don't know how to make them run. Any ideas how to execute the global.asa file in IIS 5.1 ,
View Replies View Related<%Response.Write "Hello"%>
<html>
<head>
<javascript language="javascript">
alert("First");
</script>
</head>
<body bgcolor="#FFFFFF">
<h1>Testing</h1>
</body>
Which code execute first.
In Page1.asp I am calling Server.Execute("Page2.asp"). Before calling
Server.Execute(), I set an application variable to a value that it is
important for me to know that it doesn't get accessed by another ASP page
before I call Application.unlock in Page2.asp, that is why I use
Application.lock.
According to the documentation, Application.lock gets automatically unlocked
when the ASP page terminate, I want to confirm that calling Server.Execute()
doesn't automatically unlock the application, i.e that Page2.asp will start
executing when the application is still locked.
after publishing a web to iis, asp pages based on a
database fail to work. the browzer starts loading such page
and never does- at some point the status bar stops and the
page never loads without displaying any errors. the browzer
shows that it is busy all the time.
INSERT INTO results(id, book, book_spoke, recordType, book_title, chap, chapter, chapter_spoke, vers, verse, verse_spoke, text_data) VALUES (, , , '', '', , , , , , , '')
Microsoft VBScript runtime error '800a01b6'
Object doesn't support this property or method: 'execute'
/kjvresp.asp, line 280
What is the proper format for my SQL str using command.execute? Even though
I know I have matching data in my table, I keep coming up with a
..RecordCount of -1. What am I doing wrong? Code:
How does one pass a parameter to the EXEC query recordset:
set rs = cnn.execute("EXEC tblListings_qry2")
I am extrememly new to C (only been playing with it for a few days), and will be am required to be using C and ASP.NET (also a language i have only been using for a couple of days) for work purposes in the next few months. I come from a mostly Java background where it was easy to write JAVA code, and provide web interfaces that made use of that code in JSP.
I would be greatful if anyone can tell me...
a) Is the same effect possible using ASP.net to access / execute etc C/C++ (not interested in c# code - all the explanations of this seem to cover c# only - or is there no difference? - Spot the newbie! lol) code (pretty sure that works - but be good to know incase there is another step in there).
b) Where can i learn more about it? Can you suggest any weblinks or books etc?
Incase it makes any difference - the sort of code i am interested in running would simply respond with results from databases, or extracted content of files etc (command line stuff) - and much of the code is already written in c / c++ so i am not keen on re-writting it specifically for asp.net (does that make sense? hope so!).
Can someone tell me what permissions i need to change.
error
Microsoft VBScript runtime error '800a0046'
Permission denied
/ftp.asp, line 3
Code: ...
I am getting "Failed to execute request because the App-Domain could not be created. Error: 0x8013150a"in the event log and "HTTP 500 error" in Visual Studio.when I create a new ASP.Net project. When I browse to an already existing application Internet Explorer shows Application Unavailable page
View Replies View Relatedwith dos command of " ipconfig/all>c:ip.txt " I can retrieve some info and save it in a text file of ip.txt, now I am wondering if there is a way to do the same thing within asp?
View Replies View RelatedHow do I execute two consecutive insert statements against an oracle database here is the insert that was result of a response.write ...
View Replies View RelatedThe web server is running on IIS with asp. I'd like to know how do you execute #include with asp in a file with extension .html. The codes work fine with .asp but I'd like to do this in .html.
View Replies View RelatedI want to execute .exe file like(Media Player) through ASP 3.0. I want to use in ASP folloeing langauge type
<%@ language="Javascript"%>
server.execute("file.asp")
That executes the file file.asp.But how do i execute file.asp?count=10
why my page immediately executes the Call(update_User()) function even though the client hasn't clicked on submit yet............can someone please help me with this.do not give me javascript.I'm trying to get my form to execute a function when someone clicks on the submit button.Code:
<input name="btnNew" type="button" onClick="<% Call(Update_User())%>" value="Submit" />