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'm looking to display information pulled from a database based on
information the user puts into a text box. The user will enter their
sales rep number and I want to hit a table and return their name as
soon as they tab off of the text box. Any ideas or help would be
appreciated
It s very basic question..but stil i am getting a bit confused.I want to have two radio buttons which can be selected as well be deselected. The value shud be inserted in the DB.
How should i go on doing this. Also if i want to see my selection when i return back to the order page..how should i pull it from DB and display the radio button with the dot in it(checked )?
I am working on a project that displays a recordset of video titles to a webpage in asp. I would like users to be able to click the title, as it is a link, to view the details of the video.
With PHP and SQL I can send the variable in the anchor tag then use that variable in the SQL select statement of the details page. Is it that simple in ASP and I'm just not getting it?
Does anyone know the best way to pass a value from the same line to the next page?
View Replies View Relatedi'm using the following code to output the contents of a database:
VALUE="<%=fldThis.Value%>"
which works fine on all of my fields expect for the first which is called "Title" this field contains HTML code so that when displayed or queried by asp it should display as a link.
However, the title field displays the data as follows inside the text box: <ahref= (then a massive gap) then after the text box I have the link title text which is just after the close tag for the link followed by the close quotation marks and close tag as follows:
text box denoted by square brackets: [<a href= blank space] link title">
I am presuming that the code isn't liking the quotation marks for the link.
I have a hyper link field in access 2003. when I present the information in my form(after retrieving it from a recordset) the link appears like this:
c#http://c#
even though the actual field in the database contains only the letter "c". this is the same for every value I insert in the field..
I have a page that is database driven. The customer want the option to sort the data by Date and by Title and have the default be by Date.I have two queries that show data by date and then by title. I have them in separate ASP pages that I can use a server side include depending on which button is pushed. I just don't know how to implement it.
how would I set up a page so thatI have the data defaulted to show by Date and two buttons at the top that one could click to toggle to show by Title if they so choose? -- all keeping this in one page.
When users clicked a unkown mime type link such as Zip on my website, a "Save/Open/Cancel" dialog box pops up. Is there a way to detect which button
users clicked by using ASP? actually I only what to record the "valid" click -- when Open/Save was clicked.
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) "
How do you pass data, from a database to a form? So that data, is displayed in the form ...
View Replies View RelatedI 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.
How do I find out which submit button was clicked?
View Replies View RelatedI 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 move from one form to another when I click to a radio button. I can
identify which radio button I clicked by trapping its value. but my problem
is that there are a set of radio buttons followed by values being displayed
from a join table.
I want to know the values displayed from the table. so that based on which I
can do my further processing. Like the radio button is showing the name of
student, his id, story id...and 2-3 more things. when I select the first
radio button (its value = 0 ),
how can I know that the selected one is for which student_id and for which
story_id.??? Code:
How can I make it that if the user clicks the back button --- the page will be automatically refreshed form the database (the asp) and not just show what was on the page before they submitted?
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 Related