I've created a page that has a dropdown listbox with values derived from a recordset. That is working fine. What I want to do is take a value selected from the dropdown listbox and pass it to another page that is pulling a report based on the parameter I'm selecting in the dropdown listbox.
I'm able to do this with a textbox being used to accept the parameter, but I want the client to select from a list of actual values, which will then "filter" their report.
I have a database table called Pumpdata. This table contains all the different pumps available. I had to make 2 other related tables one called pumpType which is just a description of Pump Types. ie.. (single, double, mixer etc..) and the other table is PumpManufacturer which contains a list of Pump Manufacturers.. the 2 tables are related to the pumpdatatable based on the TypeID (in PumpType) and MfgID(in PumpManufacturer)..
Ok the problem I'm faced with Is I need to create a form to get a particular pump based on the Pump Type, The manufacturer, and then the specific Model Number..
The First list box alllows the user to select the Pump Type, The second ListBox allows the user to select the manufacturers based on the pump selection. (Note in the pumpdata table there could be an occurance where a particulatar PumpManufacturer could have several Pumps of the same type (I just need to show one occurance of the PumpManufacturer here). Code:
I was wondering if you could help me with the following problem. I have 2 listboxes in my webpage, 1 has cities, and the other lists the streets of the city from the first listbox.
When I click on a city, I want the 2nd listbox to populate with all streets in the city. The city and streets are saved in a database, so when the user selects the city, I will run a query on the database and populate the 2nd listbox with all streets.
How can I do this with normal ASP? I know how to do this with ASP.NET, but don't know how to activate this with normal ASP?
I am passing a variable called businessID from one page to the next page in my URL. On the next page I want to use the value of businessID to query my access database in a SELECT statement. How do I put this in my SELECT statement?
"SELECT * from tlbbusiness where businessID = (im not sure) "
I need to pass data though a URL ill explain my situation. I have made oen page using JavaScript and ASP (have to use these for my project) which basically allows the user to search a database to find a link to a car which most suits them. This is shown by this-
This sends the user to a separate page showing the full details of the car on the specific page.
On this new page i need to read from the URL what the value of carnumber is and then write the full details fo the car to the page. there is a different carnumber for each car in the database. Code:
We are attempting to do an on-line registration system using asp and MySQL. Unfortunately, it doesn't appear that the information from the input form is passing to the execute form. In fact, it doesn't look as though it is even getting to the database.
I am very new to asp and the person I'm working with is used to working with MS SQL, so this could be a syntax issue......
I have written some stored procedures in SQL and these procedures return some value. I want these values to be captured by the ASP code. I am able to access the tables using ADO( recordsets ) but is there a way to pass data returned from stored procedures to vairables in ASP code.
I have a asp page created which pulls information from an access database. One of the things it pulls from the database is the address. I want to put a link on this page which when clicked will open a smaller new window asking the user to input their address. Once they input the address and hit submit, the 2 addresses, user inputted (as starting point) and the one from database (ending point) needs to be inputted such that a url is formed, leading to the directions page on yahoo or mapquest or any other site.
My question is how do I take the ending address and pass it over to this new page (using http_referrer???) and then construct the url to the directions page.
OK this query if probably fairly elementary, and forgive my novice understanding of the terminology, I have dealt a little with php but .asp is relatively new to me.
I am able to store variables posted from a form using something along the lines of
strStartDay = Request.Form("StartDay")
however this only works for the .asp page that immediately results from the form. how do I then pass these same values(entered from the form) into an asp page that follows (link from the first asp page).
In my ignorance I have placed the same variable statements in my second asp page but no values are being returned (which of course they wouldnt).
I am using enctype="multipart/form-data" in my form.
Everything has worked for past 2 years and I have not changed the code in the slightest. (1)
I pass some value to another page and this has worked for as long without any tweaks needed. (2)
Now (2) no longer picks up the values submitted by (1) for some unknown reason. If I take away the enctype, the data is passeed through but it's wasted as the form is to upload a file.
Would any change on the server or network be to blame? What do people suggest?
I've been doing some reading about "AJAX" and it sounds pretty interesting. While I can make it work, it seem like I'm doing much of it the "hard way". I was wondering what kind of code that others use to pass data via XMLHTTPRequest.
My code is usually in ASP, with VBScript or Javascript for the client side of things. I've done a bit of PHP as well. Definately not an expert by any means, but I do understand programming - I just don't know what elements/objects/methods/etc. are available.
So, consider the following and tell me what you'd do. Sample code is great as well.
Address book type web application, but page contains info from two seperate queries. User enters a name in one area of the page and clicks Search. The XMLHTTPRequest object hits an ASP page and populates the related fields (Name, age, SIN, etc.) in the clients screen, keeping other elements in the page intact. What if the returned data contained a binary, like a photo?
Would you have the ASP page return a simple HTML document and parse out the "responseText" property to find your field data? How about having the ASP page generate a XML response and using the "responseXML" property as an "object" containing the required information?
I guess I'm just trying to get my head around how I'd be passing different types of information from my server side page using the XMLHTTPRequest object. It seems like such a simple thing, but looks much more complicated in any samples that I can find.
I have a registration page which will be receiving user input. These data will NOT be insert into DB within this page. However, all the data (first name,last name, address...) will be pass to second page. And the insertion to DB will be execute in second page.What will be a better way to handle the passing of data from page 1 to page 2?Used querysting in the hyperlink? Err...abit tedious rite? I mean the url will like so long.
how to pass the selected value in dropdowm box into a textbox.for ur informations, all the data inside the dropdown box are retrieve from Access Database.i want to pass the data that is selected into a textbox, which already consist data from the database also. how to overwrite it with the data from the dropdown box?
I have a page where a user can edit the meta tags for the page which are then written dynamically at the time of the page being redendered.
I was wondering today whether this actually works or not? ie, if a search engine (google or whatever) is trawling a site, does it only read html pages? What happens when it encounters an .asp? Surely it wouldn't execute it and therefore be able to read the meta data correctly?
Any info on this would be appreciated, if my current way of doing it is not appropriate I will need to invest some time into changing it.
1. I want a form field which retrieve data from Sql database and when button pressed, it should open a pop-up window with a form-text-field and data must present in this text field.
2. I have a database with 4 tables named myname, urname, hername, hisname. What I want is to retrieve data of table-myname into a page and then retrieve those data of other tables which may match the data of table-myname; into same page.
As if table-myname have data like John with code-01 and then these 3 tables must show those codes which are having data like John.
Any ideas on how I can set some data in 1.asp, then have 1.asp do a server.transfer (or .execute, come to that) to 2.asp, and have 2.asp access the original data?
I'm aware that the Session object fits the bill but want to avoid using this if I can. Having said that, the nature of the data is very much per-user so things like the application object are definitely inappropriate.
Another way I can do this is redirect/querystring, but the additional roundtrip here is not attractive.
Because of �refresh� problem after updating the form. So, I have to put the confirmation message in a seperate page:
1.update.asp page click update - goes to updated.asp (update to the db and sending email) then redirect to updatedconfirmation.asp page (confirmation message)
I would like to carry a few information from update.asp page such as name and their address to the confirmation page depends on their ID, how can we I do that in the updatedconfirmation.asp?
I�ve used hidden fields in the update.asp page. but there is nothing display in the UpdatedConfirmation.asp page Code:
I have a main form which opens a popup when you click on a button (via jscript). From there the user can can click another button to open another popup with just the calendar control on it.
I want the user to be able to click on a day on the calender and then pass this date back to a text box on the first popup. Remember the first popup is already open and I've already evaluated whether IsPostback = true on the first popup.
I have a page "entry.asp" where a user enters data into a form (named "form"). I want to submit the form and have the data passed to a frameset with two frames (frame1.asp and frame2.asp). I need the posted data from the form to be accessible to frame1.asp and frame2.asp.
I have an asp page that uploads binary files. I am trying to pass the binary data to a function in a dll (written in c++) to process it. The file I'm testing with is the range of bytes from 0x00 to 0x51. When the data is passed to the function, it is passing it as the string "A^? ".
which is what is printed out when I do a Response.Write. How can I pass the binary data to the function? A Response.BinaryWrite prints out the correct contents of the file. Why won't it pass it as binary?
I am trying to generate an email from the webpage using code below, which works fine. However I want to be able to include some dyanmic data how do I go about it ?can anybody point me in the direction of some sample code ?
Dim myMail Dim HTML Set myMail = CreateObject("CDONTS.NewMail")
HTML = "<!DOCTYPE HTML PUBLIC""-//IETF//DTD HTML//EN"">" HTML = HTML & "<html>" HTML = HTML & "<head>" HTML = HTML & "<meta http-equiv=""Content-Type""" HTML = HTML & "content=""text/html; charset=iso-8859-1"">" HTML = HTML & "<meta name=""GENERATOR""" HTML = HTML & " content=""Microsoft Visual Studio 6.0"">" HTML = HTML & "<title>HTMLMail</title>" HTML = HTML & "</head>" HTML = HTML & "<body bgcolor=""FFFFFF"">" HTML = HTML & "<IMG SRC=""http://www.microsoft.com/library/" HTML = HTML & "images/gifs/homepage/microsoft.gif"" BORDER=0 " HTML = HTML & "WIDTH=167 HEIGHT=36 ALT=""Microsoft Corporation"">" HTML = HTML & "<p><font size =""3"" face=""Arial""><strong>" HTML = HTML & "Microsoft Exchange CDONTS Example</strong></p>" HTML = HTML & "<p><font size =""2"" face=""Tahoma"">" HTML = HTML & "CDO for NTS allows an easy way to send mail.<br>" HTML = HTML & "This example shows how the content can be " HTML = HTML & "an HTML page<br>" HTML = HTML & "which allows you to send rich text and" HTML = HTML & "inline graphics.</p>" HTML = HTML & "</body>" HTML = HTML & "</html>"
myMail.From="someone@microsoft.com" myMail.To="someone@microsoft.com" myMail.Subject="Sample CDONTS HTML Message" myMail.BodyFormat=0 myMail.MailFormat=0 myMail.Body=HTML myMail.Send set mymail=nothing Response.Write "Message Sent" %> </HEAD> <BODY> </BODY> </HTML>
Each three digit number in the string represents a unique ID of a file in a database. Following each ID are six digits, all seperated by a "_" . Each file will ALWAYS have six subsequent integers, such as above ID "234" has "_0_8_22_2_0_3_" following it.
What I am trying to figure out is given a string of any length of this specific pattern, how to decarle a multi dimensional array that would hold each ID and its corresponding digits.
To clarify a little further, this is from a shopping cart for a photographer. Each "ID" represents an image, each of the six corresponding numbers for each ID represents a qty for an image print size, ie., 4 4x6's, 5 5x7s, 0 8x10s, 1 16x20, 23 20x30's, 48 wallets. Oh, and the image ID's are not necessarily always going to be 3 digits, they could be of any lenght integer...
I have a Dynamic product page that displays the items using "DO UNTIL rs.EOF" and I have assigned form input type to be hidden(for some) for information that I would like to retrieve. On the product page I have a "Add to Cart" button which points to my "addCart.asp".
addCart.asp is where I would insert the items into a Table called "cartItems" in the Database when the user clicks on the "Add to Cart" button.
My "addCart.asp" now generates a "Syntax error in INSERT INTO statement." which I think is caused by my inability to filter for the values from the product page and insert it into the "cartItems" table. Code:
Basically I want the text in the iframe to change depending on the pid value. (pageID), I have all this set-up previously in my functions page. Except the only way I can see any action is by running the iframe directly and passing the querystring like iframe/iframe.asp?pid=4 and this works fine, but in my main window index.asp it does not change.
I have an idea that when i type index.asp?pid=3 its trying to get the querystringbased on the index.asp not the iframe.asp, so does anyone know how I connect these two up so that my content will change in the iframe held within the index.asp page.
I am am trying to write some code to perform a INSERT in SQL table using a loop. What would be great is a way of dynamically entering in data in a requaest.form ie the final code should look something like:
if Request.Form("type1") = "1" then
where the 1 in "type1" is dynamic so the code would look something like
Request.Form("type" & Rs.("fld_type_id") & ") = "1" then
But not sure how to form this or whether it would work, anyone have any idea?
i want to have a bubble pop up on hover but in that bubble have data from a database populate it. has anyone else done this , if so how? Also i would like to try to stick to vb/asp/html if possible.
