Passing Text ID From One Page To Another
my database has a table with a primary key that is both text and numeric
(seems like a bad idea now but there's 1000s of records so too late to change it ((((
basically i want to pass this from one asp page to another using the ?ID=house_ID
house_ID being the offending key
the other end i pick it up using lngRecordNo = Request.QueryString("ID")
and then my sql statement is as follows ...
strSQL = "Select * FROM House WHERE House_ID LIKE " & lngRecordNo
but it doesn't work .... i'm getting the rather generic error message of Too few parameters expected 1.
anyone got any ideas
also if i want to use date in a where clause how do i format it i've tried < " # Now() # ";" but it doesn't like it because of the quote marks inside of the sql statment.
View Replies
ADVERTISEMENT
I have a date in a frame/page that i want to pass to another page. I can succefully pass a static value, i just can't pass a value from a text box.
I tried to make everything public. I believe that Me. may only refer to the page that is orginating the action. But how do I pass the text box. Can we assume since I can pass the static value, that the issue is how I grab the textbox value Code:
View Replies
View Related
I'm trying to have a user enter the quantity he wants to order in the text box and pass all the parameters to a sub called "add" on the same page. I can't figure out how to pass the quantity entered to the sub. Code:
View Replies
View Related
I hav an online learning system with a questionaire that emails relative people with the results and also outputs results at end. the input is into textareas and it is being passed via
response.write<input type="hidden">
i.e all data is passed through each page to the last page. At the end only the last pages data is correct, all previous pages have only the first word.
i.e computers annoy me -on page 1
would be:
computers -by the time it gets to page 4 . Is their a restriction in VBScript for passing data more then once.
View Replies
View Related
I have an asp page that allows cdont mailing of form field values to persons matching slected criterea in their profile.
Works good if the user goes straight from the form to the email-making asp.
Then the user asked for a proofreading screen and what seemed simple took a bad turn.
When I try to pass from the proof reading screen to the asp that actually sends the email I only get the first word. as soon as a blank is encountered in the text it thinks it it done. Code:
View Replies
View Related
Is there any way I can pass the value in a disabled text field without creating a hidden field?
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
I have a string (holding a book title) that contains an apostrophe. This is generating an error when I try to pass it through sql into a table of orders. I retrieve it from the form with
title=request.form("title")
I'm trying to pass it through with: '"&rs("title")&"'
This isn't working. I tried taking out the ' ' but that didn't help, nor did elmiminating the " " help eather. Can someone suggest what might be the problem?
View Replies
View Related
how to i passing values to text field?
<input type="text" name="Usrname" size="20" value=<%= fullname %> >
i knew this is wrong.. but how do i solve this problem?
View Replies
View Related
I am trying to pass a value into the text field on selecting the option in a drop down. The code works if the 'For' loop is not included. What should I do to make it work inside the loop? Code:
View Replies
View Related
I have an application which allow users to search our database. Quite a lot
of search fields pull data from other tables. I don't want to populate the
dropdowns (total 14 of them) from the database everytime as it slow the page
load.
Instead I would like to have a link next to the text field which a
user and click and the choices can be displayed and whatever the user click
in the pop up I want to transfer it to the text box and close the popup.
For example there is a Textbox called country. The user can either type in
the country name or click on the link which will pull all the countries from
table in the database and which ever country user selects, the textbox is
popluated with the country name and the pop up closes automatically. Code:
View Replies
View Related
I am looking for a way to pass an ADO recordset that has been retrieved in
an ASP page to another HTML-page. Is there someone who can provide me with a
small sample or a link to see how this is done?
View Replies
View Related
I have code that gets its values from a Request.Form it then inputs the data into the Database.The problem is when I do A Response.Redirect back to the original page I would like to pass a value back to a hidden field in the original page. Psudo Code
index.asp ---> User enters data from drop downs ---> values get passed to insertintodb.asp ----> then ----> Repsonse.Redirect's back to index.asp where I would like to get the values from the insert statement back into this page as hidden field so It can be passed to another page based upon the users next actions.
View Replies
View Related
I have some text (part description) that sometimes includes " to indicate inches. I pass that text via a URL and of course it gets cut off at the quote mark. Ok, i thought, I'll replace " with in to indicate inches in longhand. Well, I outsmarted myself as I've been unable to figure out how to do an instr search to see if " exists and then do a replace.
I tried multiple ", tried chr(34), no luck.Looking for the right way to ESCape the " so that it gets looked at and and ultimately replaced in the string.
View Replies
View Related
I have a normal link in a drop down menu placed on the web page inside an include:
<li><a href="#">Etchings</a></li>
How do I get that title 'Etchings' to be passed over to a new page, and with that title a search is carried out in the access databse to draw out all 'stuff' associated with that title.
View Replies
View Related
I am currently creating a multiple page form where the information on
the first page needs to be validated. To do this, I have an asp page
between the 1st and second pages of the form. However, I need to pass
all of the information from the 1st page to the third (the second page
of the form) so that all collected information can be sent out in an
e-mail.
I thought about doing this with hidden form fields, but I don't know
if this is possible. I put a form with hidden fields on the
validation page, but I don't know how to make it forward to the proper
page after that without a submit button.
I have also heard of session variables, but I could not find too much
information on the topic.
View Replies
View Related
i create a dynamic table to modify user/account for administrative management.
I have modify & delete function to be performed.
The idea is that when the admin click the Delete link, he can delete a particular account/user. is it possible to pass variable of buff value to recID?? because when i see the result of request.querystring("recID"), i does not pass the mumerical value sound pretty simple but i can't get it. Code:
View Replies
View Related
I have two ASP pages payment.asp:
For customers to fill in payment/card details (pre-populating details if
details submitted were invalid and user had to re-fill in details)
confirmorder.asp:
Display the credit card details in hidden fields and also the order details
from Database
My question is:
1) If payment.asp submit to confirmorder.asp, then
1.1) I could get confirmorder.asp to display card details in hidden fields
BUT
1.2) But if card details are invalid how could I return user to payment.asp
with card details prepopulated??
1.2.1) If I Response.Redirect, nothing would be pre-popualting (unless I put
in details in Query string, which is not what I wanted for security reasons)
2) If payment.asp submit to payment.asp then
2.1) I could get page to pre-populate details on payment.asp if card details
are invalid BUT
2.2) How could I direct user to confirmorder.asp back to payment.asp with
details pre-populated
1.2.2) If I Response.Redirect, hidden fields cannot be populated by reading
in Request.form!
View Replies
View Related
I am trying to pass the values of a form to another page depending on what the user selects from the sample field. I have created a form where a user is inputting data to be displayed on the next page in the form of a business card (preview/proof)
When the user selects a sample I want the next page to be sampleone.asp, two etc but hold all of the data that the user entered. I have the following code in designit.asp but I want to pass all of the variables at once to samplexxx.asp in the form of a business card (table). Code:
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 would like to learn the syntax for passing variables that I retreived from
a database to a second asp page. Currently, I'm using:
Response.Write "<tr><td> </td><td><Font size= ""-1""><B><a href=
""InterviewerInfo2.asp?timeID=" & rs("Starttime") & " "">"
How do I add more variables to my link: <a href = ...?
ie Nameofcandidate and InterviewDate
in this context: Code:
View Replies
View Related
What I want to do is pass a Field value directly from the URL to the webpage content, but it's getting stuck and sometimes no values get passed? For eg:
Suppose my site is www.mysite.com/member.asp?id=25
I want the 25 to be placed somewhere on the member.asp page when the above url is hit.
I have tried <% =id %>
I have also tried <% =Request.Form("id") %>
View Replies
View Related
I'm trying to pass a variable from one page to another and I keep getting an error.
Missing insert, delet, update...
Take a look at the attached files.
View Replies
View Related
i am trying to pass a variable to another page using a button.this is the code i have
<form action="G_Reply.asp?Title="<%=rsUser("Title")%>" method="post">
<button name="add" type="submit">
<img src="Pictures/G_Chat.png" width="150" height="20"></button>
</form>
Even though it does not work ,it does pass the variable when using as hyperlink like :
<% response.write ("<a href=G_Reply.asp?Title="&rsUser("Title")&"> Post Reply </a>")%>
(rsUser is my recordset and ("Title") is the field in the database. )
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
Does anyone know the best way to pass a value from the same line to the next page?
View Replies
View Related
I have a login.asp page which verifies the user logon and password. It's a bit messy at the minute but it does actually work.
What I really want to do is move all this code to an Include.asp file. This is another problem to be honest as I'm unsure on how to pass an ADO database connection (cnDB) from a sub routine in my include.asp file to a function which will also reside in my Include.asp file.
Basically, the overall effect I am looking for is...once a user has logged in I want to pass the variables strLoginID and the strPassword to each and everypage so that I can run a quick check on these variables when ever a restricted page is loaded to prevent people from jumping ahead to a page they shouldn't be at. Code:
View Replies
View Related
I have a page that pulls data from a database, one of the fields is Notetext
which frequently contains an email. I then want to pass this onto another
page, that updates the email field in another database, so in page 1:
strNote = rsnotes("NOTETEXT")
And to pass to the next page:
<a
href="createemail.asp?strIssueNo=<%=zero(rsnotes.fields(0))%>&strNote=<%=str
Note%>"><img src="Images/createemail.gif" width="75" height="25"></a>
It all works fine except that only about half the email gets copied into the
other database. It's not an issue with the database as it can take that
length of characters.
So my question, Is there a limit to the number of charachters you can pass
from one page to another in a string? and if so is there any way of
increasing this or getting around it?
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 guess this is a continuation of my erlier problem which I thought I had solved.
I have several inputs being passed from one page where they are inputed in, to a preview page so the user can chek there info, then it will be passed to a page to submit the info to a data base.
I have a input that is the item description var name of �prodesc�. It pass from the input page to the preview page just fine. Then I use the same method to pass it to the next page to save it to a data base, but when it gets to the submit page the var �prodesc� only has the first word of the description that was shown on the previous page? Any one know why its acting like its been trimmed? Code:
View Replies
View Related
Is it possible to send a variable through a hyperlink, to a frames page, and have all 3 pages in the frame pick up the variable using the request.querystring ?
In other words, I click on a link that has ?id=2 lets say.. it goes to a
page called umm say index.asp the index page has a top, main, and a left.
how do i get each one of those to receive the variable, when i can only send
it to one page? or is it possible to send it to more than one page, but only
travel to one page? so the link looks like index.asp?id=<%=var%> Code:
View Replies
View Related
I want to pass a variable or value from the pop up page to the parent page. how do i do that?
Another approach i was thinking was dragging and dropping the selected variable from pop up page to the text box in the parent page. but i dont know whether ASP has any drag and drop module or something.
View Replies
View Related
I have a web form page that passes values to an asp page, in which an email is sent to the customer with those values. The email functionality works fine. But I also want to display these values on a separate "thank you" web page after that.
What is the asp code to display those values into the "thank you" web page? Does this involve adding code to the asp page and the "thank you" html page?
View Replies
View Related
