Command.Timeout Option
I am using ADO to connect to a database to get some data that I then display
on my web page.
I build the entire script in ASP code the finally use response.write to get
the web page itself
When I create the connection object
set objConn = Server.Create.Object("Server.Command)
objConn.Timeout = 90
Even thought I set the time out to 90 seconds the time out occurs in 30
seconds. And this is pain as I have some large queries returning some 100K
records.
Is there any other way of increasing the timeout Is it a Registry setting on IIS?
View Replies
ADVERTISEMENT
Inside my asp page, I want this stored procedure to run till it executes. I am somewhat familiar with the command.timeout = 0 but not sure of the exact syntax. My current code for this is: Code:
Response.Expires = 0
response.ContentType="application/vnd.ms-excel"
Response.Buffer = true
set conn = createObject("ADODB.Connection")
conn.Open GetConnectionString()
Then comes the execution of my recordset here.
View Replies
View Related
I am getting the above error when trying to execute the following code:
View Replies
View Related
I have a site that utilizes online forms. The problem is people could easily spend well more than 20 minutes filling out the forms before submitting them. To avoid the default timeout of 20 minutes (or whatever) I added a Session.Timeout = 120 to the forms page. I also checked IIS and set the connection timeout property to 120 minutes as well.
sessions still seem to be timing out well short of the 120 minute cutoff. (I haven't yet tested to see if it's still 20 minute default or somewhere between 20 and 120).
Is there anywhere else this setting might be controlled? Is there any simple way to do some sort of "keep-alive" from the page so that the server thinks it's active?
View Replies
View Related
I have an online application. I get the following error when a user selects an option from one drop down list but doesn't select an option from another drop down list. Here is the error:
Microsoft OLE DB Provider for SQL Server error '80040e0c' Command Text was not set for the command object. Code:
View Replies
View Related
I have an online application. I get the following error when a user selects an option from one drop down list but doesn't select an option from another drop down list. Here is the error:
Microsoft OLE DB Provider for SQL Server error '80040e0c'
Command Text was not set for the command object.
Line 87
Line 87 = rs1 = conn.execute(finalSQL)
Here is the page causing the error. Code:
View Replies
View Related
I keep getting this error. I searched the forums, and found one. It said to basically replace elseif with else. It worked for that person.
I tried it and it didn't work. So what i decided to do was, remove all of the if statements and keep one. Even with just one if statement i get the same problem. Does anybody know what is wrong? It worked fine, up until i added the if statement. I need them there though for a reason.
Personally i think, it;s not getting the value from the request form, and hense it isn't picking anything up. What do you lot reckon? Code:
View Replies
View Related
I am getting the above error in an asp page. Not sure why? The error details is given below. Code:
View Replies
View Related
how can i create an option tag whith the onpick event?
View Replies
View Related
if the default value of my my option value i want to retrieve it from the record if it's not empty. how can i do it? for example Code:
View Replies
View Related
Is there a way I can iterate an option value using ASP so I can pass in multiple values on submit to the Federated item? Here's an example of pseudocode of what I'm trying to do:
<SELECT name="grpNm" style="LEFT: 8px; WIDTH: 213px; TOP: 1px">
<OPTION value="XXXXXXXXXXXXXXX">Federated
</OPTION>
</SELECT>
View Replies
View Related
Below is an extract from a form that i am writing. I need the user to be able to have a drop down menu of languages. How do I use the 'option value' command in ASP like you can do in HTML.If someone could amend my code to give me a couple of language options so I can get an idea of how it is down.
<tr id="r_Lang">
<td class="ewTableHeader"><span>Language<span class='ewmsg'> *</span></span></td>
<td class="ewTableAltRow"><span id="cb_x_Lang">
<input type="text" name="x_Lang" id="x_Lang" size="30" maxlength="25" value="<%= Server.HTMLEncode(x_Lang&"") %>">
</span></td>
</tr>
View Replies
View Related
i have a dynamically created drop down menu where the values are pulled from our database. i've been trying with no success to pass those values to the page but it never works.
how do you pass the values from the <option value="<%=...%></option>? i thought you recalled it in the sql statement like:
Code:
" WHERE Something = '" & Request.Form("optionvalue") & "' "
View Replies
View Related
I am trying to get a font of a label to change to times new roman when an option button is clicked, i have tried this:
Private Sub optHigh_Click()
lblHeading.FontName=Times New Roman
End Sub
This is wrong but i cant work out how to get the font to change,
View Replies
View Related
how extract previews option value disable from script.
View Replies
View Related
I have a form named: 'formhandheld' and a select with the name: 'pricing_option'.
I'm trying to make the select <option> thats based on 'axDD3current' selected.
what's the code ? Probably more of a JavaScript question than ASP
document.formhandheld.pricing_option.options[<%=axDD3current%>].selected;
the above doesn't work
View Replies
View Related
Here is my page:
<form name=myForm>
<select onChange="myForm.forename.value = this.options[this.selectedIndex].value;">
<option value="Arnold">Pam
<option value="Mokoena">Joe
<option value="Seth">Pat
</select>
<input type=text name=forename disabled>
</form>
when inserting on the database,the value of the dropdown option is the same as the value of the textbox which is wrong.they must not have the same values example
when Pan is selected,then the value inserted to the database must be "pam" not Arnold.
View Replies
View Related
I have a dropdown list on my page. It is populated with values from database ;some values are unsually long that the DDL extends to the right of the screen where i need to scroll to find the arrow.
if i dont i wudn be able to read the values fully[i.e only half the length can be read]. Hence i wud like to provide a toottip for each <option> in the DDL whch will help me read the values onmouseover event. Hope I am clear abt it.Thus me scrolling to the right can be avioded.
View Replies
View Related
I created one ASP page for Online Test. i get all the questions from database. In home page if user select the topic and no. of questions then its displayed in second page.
My trouble in Second Page, becs I show the questions like:
Ques No. Ques Name
====== =========
1. XXXXXXXXX
(1) ans1(Option Button)
(2) ans2
(3) ans3
(4) ans4
untill the users selection of question numbers. all this are created dynamically. if user submit the answers next page shows the result. How can i get the User answer(Option button) in Text Box or other ways.
View Replies
View Related
I need to pass an Cat_ID and Category from an option field on a form, but can't figure it out. the code on my form:
<select name="Cat" >
<% Do Until rscat.EOF %>
<option value="<% response.write rscat("Category") %>">
<% response.write rscat("Category") %>
</option>
<%
rscat.MoveNext
Loop
%>
</select>
In the database, I have two fields which need to be filled in. The Category field and the Cat_ID field. How do I assign two values to the one field to pass this along?
View Replies
View Related
I want to know if you can write a print this page option to a page. I want to write this function in asp or vbscript. I know you can do this in javascript but I don't want tot use this. I also know there is a print fuinction in the browser this is also not what I'm looking for.
I want a piece of tekst which say something like "print this page" When you click on it a asp or vbscript will print the page to your own printer.
I need to know if this is possible and what the code is.
View Replies
View Related
i have a list of provinces in an option select right, so when i click one province i want it to chance the header of my page according to the provinces, and i have no idea on how to do that.
View Replies
View Related
I have loaded a combobox (select) with a recordset from SQL Server. I am trying to accomplish two things, so I will break them up.1) Is there a way to allow the user to enter as many characters in the dropdown menu. For example, if you have serveral options in the dropdown menu that start with A, they can key in app.. to got to apples, instead of entering A and then having to keydown or click on the dropdown menu.
Granted there is a solution to #1, could you also allow the user to key information and if it is not apart of the dropdown menu, insert the value back into SQL (kind of like an notonlist event in Access).I have googled this and can't find anything, probably wrong keywords used.
View Replies
View Related
I have a select list that gets populated from the DB. When the user makes a selection I am able to retrieve this value via Request.Form(...) However, I am wondering if you can retrieve the text value using ASP? I know this can be done in JavaScript using the options text attribute, but it is possible in ASP?
View Replies
View Related
Are there any articles / resources out there about the point of setting the domain when you set cookies? I have been able to find nothing and fail to see the point in setting a domain. As cookies can only be accessed by the domain that set them, what is the point in setting a domain? if the domain is set for say .example.com, can all subdomains read it?
View Replies
View Related
i just want to ask on how will i load the other version of file written in another language (e.g Japanese)upon selecting that particular language from the option box. Like for instance the options are English, Arabic, Japanese and so on...then upon choosing the Arabic language, the page that contains an Arabic language (layout and data)will be displayed.
View Replies
View Related
Is it possible that I can create a check box that corresponds with a group of radio buttons which become visible and invisible as the check box is checked and unchecked ?
View Replies
View Related
I have some filter fields - when these are chosen it should list the records only with these values that are chosen.
For e.g. I have a filter for month. So, want to list the records only for that month. Also for week. How do I go about?
View Replies
View Related
I am displaying few values in a List box. I would like to put first item as selected by default. i.e <option value="some value" selected>Name</option>
Here is my code.
<SELECT size=15 id=select1 name=select1>
<% do while not Rs.EOF %>
<Option value=<%=Rs("value")%>><%= Rs("Name") %></Option>
<%
Rs.MoveNext
loop
%>
</SELECT>
View Replies
View Related
I have seen a code to populate a list box from a data base table. Earlier I gave my own values using HTML coding like :
<Option Value="P-159">P-159</Select>. It was working fine but not after using code to build a list box, it is not coming in form value as input and next redirecting page retutns with error:
two codes pages are attached : profile page and search page. Profile page sends input to search page and search pages returns the output.
View Replies
View Related
Based on the layout selected by the user in the search page, im displaying the search result!! Now, i have to give him a option for "print"!! What code should i put in, so that he will have an Printer Friendly option and that prints the search output in the diplayed format!
View Replies
View Related
The two options I am interested in modifying are:
Const SO_RCVBUF = &H1002& ' Receive buffer size.
Const TCP_NODELAY = &H1& ' Turn off Nagel Algorithm.
Again, I am just not sure what code should be used in ASP to accomplish
this.
View Replies
View Related
I am trying to force the last option selected in a drop down!, I basically have a page with a drop down box in which sends to itselfs when selected, the idea is
the selected value updates a postage amount depending on the country selected from the dropdown.
However when it returns to the page it defaults back to 'select country' and I would really like it to be able to display the option selected as this is part of the address form.
the relevant country is correct, and i am putting that into a request.querystring so this variable (destination) is available to test/compare against and maybe force select this way, but i just don;t know how to write the asp/html to make the select value go to either this variable or the last one selected. Code:
View Replies
View Related