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:
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?
i m passing a string like "NEW PAGE" thru the URL itself.. when i derive the value using request.querystring("<somename>") i get only NEW.. i tried to pass it thru session but still i get the word NEW.. i dont want to pass it in sessions...i need to do it thru URL itself. y such a prob occurs?
How do you pass a string parameter that contains a slash (for instance a date) to a com object? I pass a date with slashes and I get "Type Mismatch" with the date 05/16/1974 being interpreted as 05%2F16%2F1998.
I have a View button that shows a database record of entries. At the end it has a delete link for each entry. When u click it, it passes the Address(like a house address) to a script that searchs the DB for the matching address.
The only problem is most address have spaces. I read somewhere about double quotes, or using single quotes or some combination, I don't remember.
How can I pass the results of a form field submitted to this statement below?
<% Set MyFileObj = Server.CreateObject("Scripting.FileSystemObject") '### This Works '###Set MyTextFile = MyFileObj.OpenTextFile(Server.MapPath("body.txt")) '### This Doesnt work Set MyTextFile = MyFileObj.OpenTextFile(Server.MapPath(" & request.form("MyFileName") & "))
WHILE NOT MyTextFile.AtEndOfStream Response.Write(MyTextFile.ReadLine & Chr(10)) WEND MyTextFile.Close %>
I have a webform that I would like for customers to fill out. Their information is written to a sql db and in the background, an email is sent back to the customer and also proving a url for them to fill out a questionare. Ok, that part is done without any problems.
The url that I am providing to the customer to return back to the site, is also passing their email address in the url for validation. which is http://www.url?email=email
Here is the query that I am trying to run in displaying their company information: SQL = "SELECT * FROM CONTACT where email = " & request.QueryString("email")"
If i do a basic select * from contact, that works, so it has to be w/ the ending part of passing the email address.
I have created an ASPX web site to use as an EMail page. But I want to use this for a lot of users. Can I create the link on the WEB site to mail to passing a variable from the WEB site to the ASPX web site to E-Mail to? Hope I explained this correctly.
Lets say I have a page with 6 different options a user can select, each linking to a registration form. Regardless of what the user picks, they will fill out the same form. The only difference is the title of the Email sent. To avoid having a seperate form page for each option, is there a way to pass a value and put it into the Subject title of the email depending on which link they click?
I have a batch file that takes variables from the cmd and passes them by sqlcmd to an SQL script. When I pass the variable 'MikeTestList' the script runs as expected with no problems. When I passed 'BulkTransferTest' I got an error message, 'The string or binary data will be truncated'.
Some testing has shown that I get the error when the string is anything above 12 characters. Is there a limit to the length of a string you can pass using sqlcmd from a batch file? Is there any way around it?
Also, if I have a space in the string, it only passes the string up to the space. I have tried to fill it with a '%' which then gets passed as is, so the % stays in place through out the script. Code:
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:
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?
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.
I'm having a problem with passing variables inserting to my database. Here's what I'm doing. I have a page where the user selects a team member (this is fine) Once the team member is selected I have the variables on the form send and email to all supervisors and the member selected (this is fine also) BUT, I'm having problems inserting the emailed information to my access 2000 database after is email. Can someone guide me in the right direction.
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.
I need to get the userName from an Email address. For example, if the email is Join Bytes!, how can I can I get just the "username" part using the RIGHT() or LEFT() functions?
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.
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.
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.
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:
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!
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.
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:
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).
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") %>
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.
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:
In line 7, I need to display the results of the variables strFName and strLName (and have a space in between the two) but I don't know the proper formatting. If I just use the & then I get the literal strFname instead of the value. Could someone please show me the correct syntax for this?
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: