Passing Data ...
How do you pass data, from a database to a form? So that data, is displayed in the form ...
View RepliesHow do you pass data, from a database to a form? So that data, is displayed in the form ...
View RepliesI 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-
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:
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 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 RelatedI 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 trying to use gmap and have worked out how to post postcodes but now need to pass infotext data. Code:
View Replies View RelatedI 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.
View Replies View Relatedhow 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 RelatedI'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 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:
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.
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 RelatedAny 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?
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.
View Replies View RelatedI 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 pass some data through a form to a mailing script.
The form entry is ...
<input name="width1" type="hidden" value=<% = rsMoreDetails("width1")%>>
and is picked up in the mailing.asp as
width1=Request.Form("width1")
and the mailing script uses...
body_text = body_text & "Option 2 - "& width1 & vbcrlf
The problem is that when the mail is sent and the value is say "14 inches" I seem to loose everything after the first space so it only sends "14"
Am I doing something wrong or this the way it is and if so is there a work around please?
I have the following pages...
page1.asp
page2.asp
page3.asp
page4.asp
page5.asp
The following variables are given values on page1.asp:
FirstName
LastName
Address1
Address2
City
State
Zip
The values are not used in pages 2-4, but are used in page5.asp.
Should I put the values in session variables? Or should I put them in form
post data? Or does it really matter?
I have created a page that pulls up my data from an access database. A value has a link that goes to a detail page that I want to show all of the information for that value that was clicked.
How do I pass that value and then pull up the information for that value? Do I need to give you my code?
I have a resume form with four separate pages,and on the last page when you submit the form I need it to gather all the information inputed to be sent to an email address.
View Replies View RelatedI am creating a form that has 5 steps/pages. Each page contains about 20 fields. But I don't want to write them until they submit on the last page. I figured out that I can use hidden fields to carry the data from the previous forms forward. If should bascially work like this:
Page 1 Page 2 Page 3 Page 4 Page 5 Page 6
20 Fields 20 Fields 20 Fields 20 Fields 20 Fields 100 Hidden
20 Hidden 40 Hidden 60 Hidden 80 Hidden Write to DB
But the problem I am having is when I submit page 4 page 5 won't load. No error, it just won'tload. It seems to be overburdened. Is there a max on the number of fields it can pass? Is there a better way to go about doing this that someone can suggest? Or a suggestion that someone can make to fix this problem?
I have a page that calls itself using a form. The form has two select elements. In the sql statement I am attempting to match the values of the select element to populate a recordset.
The two fields in teh Access db are of type Text and of type Integer. What baffles me is that one sql statement works fine and the other returns nothing. I am having the issue matching on the bedrooms.
In the first statement I took out all other doo-doo and just matched bedrooms = request("bedrooms"). On the other one I used p.bedrooms but it keeps turning up empty. Code:
I have a form that has the option to upload a file at the bottom. If you select a file it works fine but if you leave file selection blank the forms bombs. This is not how I want it to work. On the form you need to use ENCTYPE="multipart/form-data" in the form tag.
On the processing page I need to use Set to assign a variable to the form data. I tried using IF on the variable assigned to the file path but it bombs out telling me "This function is not supported". Is there any other way I can check to see if curQes has a value assigned to it?
I am using an asp page (upload.asp) to gather information and to upload
files to the web server using SoftArtisans SAUpload Tool. In the first page
(upload.asp), I have a form for gathering info with the following: Code:
is there any way of passing a javascript variable over to a asp variable so
i can write it to my database.
I am trying to create a form where the user can check a box within a form and the address will fill in automatically from a previous address in the form, without submitting the form.
View Replies View RelatedI'm using DW MX 2004 to build an asp based eStore. I have a checkout page created with both the billing and shipping information in the same form. I'd like to add some code and a button to activate it to copy the code to the shipping info (but it can't submit form). Also the State choice is a drop down list based on a recordset. There are other behaviors attached.
View Replies View Related