Passing Dynamic Data From Listbox
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.
View Replies
ADVERTISEMENT
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:
View Replies
View Related
Is i t possible to get data into a list/menu from a specific field in a db table like "date"?
View Replies
View Related
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?
View Replies
View Related
if I create a dynamic selectbox from the table tblRewardsDetail - I can submit what is selected to tblLineItems BUT not the corresponding values.
For example if I select Item2 the corresponding value associated with that Item 50points does not write to the tblLine Items but ItemIden2 does. Code:
View Replies
View Related
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) "
View Replies
View Related
How do you pass data, from a database to a form? So that data, is displayed in the form ...
View Replies
View Related
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-
Response.Write("<tr><td colspan='2' class='results'><a href='detail.asp?carnumber=" + MyQuery("carnumber");
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:
View Replies
View Related
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......
View Replies
View Related
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.
View Replies
View Related
I have been using the post method, but that only works for one other page...how do I go about making variables available to more than one page?
View Replies
View Related
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.
View Replies
View Related
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).
View Replies
View Related
I am trying to use gmap and have worked out how to post postcodes but now need to pass infotext data. Code:
View Replies
View Related
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?
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
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?
View Replies
View Related
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.
View Replies
View Related
I have IIS server installed on XP-pro. I also have Norton Internet
Security installed.
I can run simple ASP programs without any problem. But when I use forms
with post method and call an asp in action, it does not pass any data
to ASP.
Request.Form method on a form field does not return any value.
This code works on web hosting provider server, just does not work on
my workstation with my own IIS server. Code:
View Replies
View Related
I am having 2 problems in asp.
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.
View Replies
View Related
i have 2 text box whom data are generated randomly, how can i get this data and pass it to a access database using ASP?
View Replies
View Related
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.
Any other (sensible) methods anyone can think of?
View Replies
View Related
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:
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
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?
View Replies
View Related
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 ?
<%@ Language=VBScript %>
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
<%
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>
View Replies
View Related
Ok, given a string such as this -
203_2_0_0_1_5_0_234_0_8_22_2_0_3_345_2_3_0_0_0_9
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...
View Replies
View Related
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:
View Replies
View Related
I am having some problems with setting this up. Included in my main index.asp page is an iframe like below:
<iframe src="iframes/iframe.asp" width="425" height="225" frameborder="0" scrolling="auto"></iframe>
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.
View Replies
View Related
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?
View Replies
View Related
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.
View Replies
View Related
