I have a form on a webpage that someone enters a number (SponsorID).
After then enter that SponsorID into the form, I need to somehow query
my SQL database and find the record that has the same ID as the
SponsorID entered into the form and return the SponsorName (and write
it out on the page using a <div> tag or something of the like) WITHOUT
reloading the entire page (because I will loose the other information
already input on this page).
Now, I don't necessarly have to query the database, I *could* create
an Array when the page loads, using ASP, that will contain the
SponsorIDs and the SponsorNames and then compare the SponsorIDs within
that array with the number that was entered on the form.
I have a page that pulls 'member' registration information from a table similar to a bulk delete with checkboxes. This works fine, it pulls all of the member info. What I want to do is have the selected records added to a new table known as courses.
Sort of a bulk registration system where I have a list of members, put in the start date, end date, course name and course number once and it populates for all of the members in the new table adding the member info with the course info. Code:
I have a web page that queries a database returning a recordset containing a whole series of URLs (host headers).
I want to display these in a table with one of the columns holding the current I.P. address for each URL. I know how to get a list of these IP addresses from the cmd prompt using "nslookup" but I'm absolutely clueless how to get hold of these values in my ASP page. I'm limited to the fact that this must be only ASP (VBScript, not .NET), i.e. I can't call install any components.
Looking for a source for data and/or algorithm that would allow me to enter a zipcode and find - in our case - every car dealership that sells, say, Chevy's in that zipcode - if not there, then what about adjacent zipcodes..? - in an ever expanding circle outward, and return a list of those zipcodes. In my database, I've already got the car dealers and available makes. What I need is the zipcode "map" reference.
I need help with a simple (well not so simple for me) password lookup script that will email a user their pw when they put their email in an input box. I have the db set up and the connection enabled but need some help w/ figuring out how to set it up to mail these out.
On the top of my page i want to check what page the user has come from, as if they havent come from two pages i wanted them to, i need to redirect them. Alot of people are bookmarking my site with a page that causes errors. Any ideas?
DNS Lookup Error.This error resulted in the web browser that my user was using and this is details:"The URL you requested could not be retrieved because the named server is not registered in the domain name services. Please check the URL and try again." I've checked with the user and find no fault with the URL address. What could possibly be wrong?
Is there a way that we can search a remote web page for a specific line of text?We can check if a specific URL exist using the "MSXML2.ServerXMLHTTP" object witch works just fine, but is there anyway we can search the page for text using this same object.
Does anyone know of a pure ASP way of doing this?I am displaying the results of a large recordset and at the moment it looks like the page is not doing anything.I have a solution using an image and some javascript, f there was a way of doing it in ASP, perhaps using the response buffer?
I just received a database schema from our dba and was given the task of doing a look up of several fields & then doing several specific tasks, depending on the information. I know how to do a lookup and an if statement for 1 table, but how do I handle a lookup in multiple tables and also do an if statement based on multiple tables?
For example, there would be a customerid, which is in the customer table; support is in the support table; and customertype in the type table.
I need to look up what user name was used to login to a protected directory using ASP.
I don't want to create a login page, etc. It shouldn't be necessary. Only employees who already have user accounts need to log in to the webapp and the protected directory login box is all the security I need. I just need to be able to access the username that they used in my application. Code:
I'm trying to get a users free/busy status from exchange from within a website and using the code below, but when I run this a login page from MS Outlook Web Access is retrieved from the server rather than a XML file containing the users free/busy status for the specified time period.
I've spent all day looking for solutions to this but I'm stumped. I have been looking for an Exchange newsgroup but there doesn't seam to be one, does anyone know if i can post this some where else to get a response from an Exchange expert.
I have a sql server 2000 table with a comma delimited list of ids. there is a seperate lookup table with a desc for each id.
I need for this data to be retuned in the same order in which the data was entered into the database. right now it is returning ordered by the id from the lutable.
I need to populate two select boxes So that on selecting value from one select box, the values in second select box will be populated. eg in first select box i m having the list of all project of which a particular user is manager or co-manager. eg: Query1 :"select Project from tab1 where manager = ('" & userid & "')"
on selecting any project from this list it should populate the second selectbox with workgroups that are associated with selected project from selectbox one. eg: Query :"Select workgroup from tab2 where projectid = "
In my form i have three combo boxes, all the values in combo box comes from database, Second combo box values will come according to the value selected in first combo box, third combo box values will come according to the value selected in second combo box, i think i have explianed it clearly.
eg:- first combo consists of brands which are in database, according to the brand selected categories(second combo box) values should come from database, according to the category selected products(third combo box) values should come from database
i have this code on my combo to make it reload the page to run the querys onchange='submit();' but i also need to set a variable like var=0 with the onchange function.
I have a list box that has a list of names, and i want when the user selects the name to bring some information from the database and put it below the drop down box. I think i need to use an onchase event but how do i get the page to refresh to show the new data, suggestions or examples woudl be great.
A drop down list is populated with certain values from the database and when the selection is changed the post is posted back to itself and ceratin other processing takes place on the same page, based on the selected value. I have modified the code to make a default list item selection (using option selected etc. ) when the page loads the 1st time. I also want the onChange event to fire the 1st time (by taking this default selected item) on page load, not just when user makes a selection from the list.
When a user changes the value in a select statement, I would like to update the recordset using a onchange event. Could someone please point me in the right direction? Would like to stay away from forms if possible.
I have a select box where the user select a branch and using the onchange, show up another select box in the same page, containing all the users within that branch. this sounds easy but I just can't get round to it.
I don't think this is possible, but thought I would ask. Is there a way to trigger an onChange event. I have a couple of radio buttons and use ASP to change them at somepoint. When it does I want to trigger the onChange.
I have a Dynamic drop-down box that is populated based on a ADO query. This works fine. I want to capture the users selection and assign it to a variable for use in another query.
I am using the onChange event to try and capture the users selection but it always passes the last entry in the drop-down list not what the user selects. I am very new to ASPJscriptVbscript. A snippent of the code is below.
I am working on an asp page and am having trouble with several things. First, I connect to Oracle and populate a combobox with the field values. No problem there. The next thing I want to do then using the onchange event is update 2 textboxes with the min and max (on same form) with the min and max values from the database. The form is created dynamically using vbscript. When the user changes the value in the combo box I need the text boxes to automatically update with the min/max values. Thoughts?
i got 3 text field in my program, first, second and sum. user enter in 2 number and sum will automatically displayed in sum text box. i use event onKeyPress to control user enter in number only. and onChange to auto calculate the sum of first and second. Code:
I have a drop down menu and it is populated with different subdivisions...Those subdivisions are associated with an ID. I need a drop down box that once the subdivision is selected it will change the ID in a hidden textfield. Any thoughts or ideas on how to do this?
I am trying to use the following code to call a function staffname() and nothing happens when called. What's wrong with my code? What is the proper way to call a function?
<select name="staffname" size="1" onchange="staffname()"> <option value="#"><-- Please select your name --> </option> <%while not rs_staff.eof%> <option value="<%=rs_staff("StaffID")%>"><%=rs_staff("StaffName")%></option> <% rs_staff.MoveNext wend %> </select>
<script language="vbscript"> Function staffname() alert("hello") End Function </script>
