For the drop down box, how do we get the server side value
For example, the following won't work because it produce:
<select name="streetdirectional" value="E">. But we need
<OPTION VALUE="E" SELECTED>E</OPTION
Example: Code:
I am trying to create a drop down list that I have populated. But what I want to do is to populated the other drop down based on the selection in the first one, I am getting an error when I try to make the selection. here is the error that I recieved
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '='.
/reportrequest/admin/ReportRequest.asp, line 233
and here is my code:
is it possible to open an excel file (used as a template) from server using server-side vbscript; then modify it or add values from client using client-side vbscript?
View Replies View RelatedFollowing is a vbscript code extract triggered by a combobox OnChange event. arrVendorA and arrdefpack are server side arrays and i need the intCounter parameter to be the array index. Code:
<script>
sub getstdPackByVendor(strPartNo, intCounter)
dim selVendor
selvendor= colSelect("cboVendor", intCounter).value
if selvendor= "<%=arrvendorA(intCounter)%>" then
if "<%=arrdefpack(intCounter)%>" = 2 then
colTD("txtStdPack" & intcounter+1 ).innertext = cstr("<%=arrVAStdPAckL2(intCounter)%>")
end if
end if
end sub
</script>
The following code is giving me a type mismatch error at the 'if' statements... any ideas, anyone ?
sub getstdPackByVendor(strPartNo, intCounter)
dim selVendor
selvendor= colSelect("cboVendor", intCounter).value
if selvendor= "<%=arrvendorA(" & intCounter & ")%>" then
if "<%=arrdefpack(" & intCounter & ")%>" = 2 then
colTD("txtStdPack" & intcounter+1 ).innertext =
cstr("<%=arrVAStdPAckL2(" & intCounter & ")%>")
end if
end if
end sub
How do I go about calling a server-side vbscript within a client-side
javascript function? What I have is a page heavy on the javascript that has
a number of functions, one of which is to begin a visual countdown with an
onclick and also open an asp page containing the server-side vbscript, which
initiates a wake-on-lan call. I had no idea how to call the vbscript within
the javascript function, so this is why I opted for the vbscript asp page
"pop-up" via window.open. Code:
I've got three drop down menus which allows the user to select a date on a html form. The day drop down menu has the values 1-31, the month menu has values 1-12 etc etc. However i would like when the page is loaded for the current date to be present as the intially selected value in the menu. How can i apply the selected attribute of the current date.
View Replies View Relatedl've created an Access db with these fields (Title, Body and Section) Section field is Lookup column (About Me, Contact and Links). Also I created a form on add_data.asp to add data from it. On the form there's a Drop Down Menu. The peoblem is how to add from the drop down menu to the database. Here's my code:
View Replies View Relatedwe are working with the date of birth and have three drop down menus...my question is in the year because what we want is to make the drop down menu to start in 2006 not in 1906. Code:
<label>Year
<select name="select4">
<%
dim zzzz
dim a
zzzz = year(Date())
for a = CInt(zzzz)-100 to CInt(zzzz)
Response.write("<option value=""" & a & """>" & a & "</option>")
Next
%>
</select>
</label>
I check to see if a certain submission button is asking for removal. If the removal is true, I update a recordset's delete column. This has been tested and it works. However, now I'd like to prompt the user to make sure that he/she wants to remove the record. Here's the code: ....
View Replies View RelatedI have a Client Side Java Script which is supposed to re-load the options on my serverside ASP form.
I have been trying to get the syntax right to assign the Select box on the ASP form to a variable in my JavaScript so I can update the options. Can anyone either tell me if this is not possible or what the syntax should be. Here is some information.
Form Name = AddProdForm
Select Box name = subprodline
JavaScript Variable = form1
Here is one of the many versions of this line I have tried.
var form1=document.forms(""AddProdform"");
I m writing one code to invoke remote desktop service for given IP address. For that i m using mstsc.exe file to invoke RDP.
I have a no of links to be displayed on the page and on click of link, RDP for that IP should be called. Currently i m using one button to invoke RDP. Code:
I am having some problems populating a drop down menu called province with data.
This is the error I am receving:
ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal.
/fairmont/order.asp, line 85
I am sure there is data in the DB. I have attached the file.
Anyone know how to create a drop down menu where the user can enter text
also?
If they do not want to choose an answer from the drop down menu, the
users can just enter their own answers in the drop down box. Anyone
know if this is possible?
I want to create two drop down menu. one is for the Main Category and second is for Sub Category. Both value should be come from the database.
when i choose the Main cat. say business then it should load sub cat of business in second drop down menu but is should be done without refreshing the page.
I am trying to generate a dropdown menu form a ms sql database with two columns in it. I need both colums to show in the menu. I can't get it to work for the life of me. Code:
View Replies View Relatedi'm having some difficulty coding my dropdown menu's on a page, i want the contents of one to be dependent upon the value of the selected option of another.
View Replies View Relatedcan someone give me an example code for how to retrieve the selected value from a drop down menu in ASP. i have been trying something like this:
<%response.write(request.form("selected"))%>
but it doesn't display anything.
I have a form that I would like to create. My primary concern is 2 drop-down menus. The contents of the second drop down menu depend on the selection of the first drop-down menu.
For example: In the first drop-down menu, I want to select a department, and after a department is selected, I want to be able to select one of that department's employees from the second drop-down menu. Of course the content of the employee menu will depend on which department was selected.
I've been experimenting a little bit with my Access database, but how I design that really depends on suggestions I get here, so let me know what you think.
EDIT: I should also mention that the contents need to be read from the Access database, rather than storing everything in a javascript array. In this way, I can have Human Resources add new departments and employees via a web form so that I don't have to manually edit code every day.
I have an access database called contact.mdb and I have linked to it just fine and used the records held in it to populate a datagrid and can update and delete records.
I don't understand databases that much but I would like to read the values into a drop down menu which are held in the field 'ID' from a table called 'courses'. I have a feeling it is something to do with data sets but am not too hot on these either.
I have created a drop down menu populated from a database. Would this warrant posting?
View Replies View RelatedBelow 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; so there is a list of languages for one to be selected. 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>
I am working on an ASP website and my boss wants to have drop downs.
I have taken the existing code of menu includes but am unable to view
the drop downs. it just shows the url (menu.asp) in the browser but
doesnt throw the drop down.
How can I add a quick drop down menu to an asp page? I've tried to incorporate javascript and I can't seem to make it work. I want it to replace the current navigation on this page.
http://www.compsports.com/poll.asp?No=1
I am creating a "search by category" page using a drop down menu. I am very new at SQL/ASP and am having trouble with the correct syntax for sorting my search results.
Each category in drop down has an id ("catid"). Results need to show all Company names that fall under that specific category in alphabetical order. I have already completed a directory that is sorted alphabetically and tried to "borrow" some of that code:
I have an asp page with several txt feilds and drop down menus
on. I can validated as "required feilds" with the following code:
if (new_ex.elements["first_name"].value=="")
{ str_err += ("
Please enter your first name(s)") }
The validation below is for a drop down menu with mr, mrs, ms etc,
it doesnt work no matter how i try and solve this.
if (new_ex.elements["title"].value=="")
{ str_err += ("
Please enter your title, for example Mr or Mrs") }
Can anybody shed some light on this: Ive exaused all ideas.
i have one table called PAGES . in pages i have the following columns: page_Url, title, image etc... i would like to write a function/subroutine that is called that generates drop down list of all urls (PAGE_URL) from pages table. how can i do that?
what would the code look like?
I am starting to build quite a few pages that will have
tables of data from an SQL database.
I have been building the table rows on the server side
in VBScript, but I have been thinking about having the
VBScript code just build array variables in the <head>
section (or as local variables), and then have JavaScript
functions on the client side actually populate the tables
when the page loads.
I do plan to do other things like being able to sort the
tables in JavaScript code on the client, limit the tables
height and be able to scroll the rows, and click on a row
in the table, and have the values populate a form. I will
also need to be able to export/download/? some tables into
Excel.
I am doing login page . (login.asp)As usual it has username , password textbox and a login button .i need to do client side validation for mandatory fields and I need to do server side validations to check for the hardcoded username and password .if it matches i have to redirect to another page(content.asp)
View Replies View RelatedI have created a dropdown menu that allows users to navigate and load other pages into a different frame (detail) than the one in which the dropdown is sited. All menu items and urls are stored in an access db.
Now I would like to try and make 2 improvements but I don't know how:
1. I would like to use the [Category] field in my data set to produce (non-clickable) headings in the drop down list. Code:
Is there a way to have a drop down menu where u can select an option from the menu or type in ur own??? I am using ASP and SQL
View Replies View RelatedI have a dropdownlistbox (html control) and some text fields displayed on my page. The top menu bar of my page works fine in every case (as it always be on top of every thing that i display in my page) except of DropDown Combobox (html control). WHY ?
Can not understand the reason why my combobox always displayed on top when i tried to select some other item from my menu bar (say some other page) while my menu bar always on top for other controls.
How do i fatch value in dropdown menu in asp from MS access database....
How can I create two connection at a time...