473,573 Members | 2,686 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Passing email in string from one page to another.

Hi,

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("NOTETE XT")

And to pass to the next page:

<a
href="createema il.asp?strIssue No=<%=zero(rsno tes.fields(0))% >&strNote=<%=st r
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?

Thanks.

Jul 19 '05 #1
2 2736
a) If you want to pass data in the querystring you need to use
Server.URLEncod e() on the data, ie:

<a href="newpage.a sp?var=<%=Serve r.URLEncode(str Var)%>">click</a>

because some of the characters are not legal in querystrings, and need to
encoded

b) Why don't you just pass the Primary Key value of the record in question,
and then use that to do a lookup on the record on the next page?

<a href="newpage.a sp?recordID=5"> click here</a>

Cheers
Ken

"Miguel Orrego" <mi****@stresse dmonkey.net-nospam> wrote in message
news:3f******** *************@n ews.dial.pipex. com...
: Hi,
:
: 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("NOTETE XT")
:
: And to pass to the next page:
:
: <a
:
href="createema il.asp?strIssue No=<%=zero(rsno tes.fields(0))% >&strNote=<%=st r
: 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?
:
: Thanks.
:
:
:
:
:
Jul 19 '05 #2
Hi Ken,

Thanks for the answer, that solved it.

Cheers.

"Ken Schaefer" <ke*******@THIS adOpenStatic.co m> wrote in message
news:#m******** ******@tk2msftn gp13.phx.gbl...
a) If you want to pass data in the querystring you need to use
Server.URLEncod e() on the data, ie:

<a href="newpage.a sp?var=<%=Serve r.URLEncode(str Var)%>">click</a>

because some of the characters are not legal in querystrings, and need to
encoded

b) Why don't you just pass the Primary Key value of the record in question, and then use that to do a lookup on the record on the next page?

<a href="newpage.a sp?recordID=5"> click here</a>

Cheers
Ken

"Miguel Orrego" <mi****@stresse dmonkey.net-nospam> wrote in message
news:3f******** *************@n ews.dial.pipex. com...
: Hi,
:
: 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("NOTETE XT")
:
: And to pass to the next page:
:
: <a
:
href="createema il.asp?strIssue No=<%=zero(rsno tes.fields(0))% >&strNote=<%=st r : 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?
:
: Thanks.
:
:
:
:
:

Jul 19 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
8520
by: Jason Us | last post by:
Does anyone have experience with passing variables from an ASP page to a JSP page. The way it currently works in passing the SSN in the URL. This cannot be good. I thought that storing a unique session ID in a cookie and referencing the SSN from the Session ID would be the correct way to do this. But since we have two separate servers,...
12
6524
by: Kevin Lyons | last post by:
Hello, I am trying to get my select options (courses) passed correctly from the following URL: http://www.dslextreme.com/users/kevinlyons/selectBoxes.html I am having difficulty getting the courses to pass the correct option value and then be displayed at the following URL: http://www.dslextreme.com/users/kevinlyons/selectResults.html ...
12
1950
by: Patrick | last post by:
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
5
36388
by: Andy | last post by:
Hi Could someone clarify for me the method parameter passing concept? As I understand it, if you pass a variable without the "ref" syntax then it gets passed as a copy. If you pass a variable with the "ref" syntax then it gets passed as a reference to the object and any changes to
27
6177
by: Oscar | last post by:
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? regards, Oscar
7
4734
by: Ken Allen | last post by:
I have a .net client/server application using remoting, and I cannot get the custom exception class to pass from the server to the client. The custom exception is derived from ApplicationException and is defined in an assembly common to the client and server components. The custom class merely defines three (3) constructors -- the null...
6
3245
by: Scott Zabolotzky | last post by:
I'm trying to pass a custom object back and forth between forms. This custom object is pulled into the app using an external reference to an assembly DLL that was given to me by a co-worker. A query-string flag is used to indicate to the page whether it should instantiate a new instance of the object or access an existing instance from the...
3
1978
by: James Robertson | last post by:
I am new to the ASP and VB thing so be kind. Question I have is that I have created an ASPX web site to use as an E-Mail 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. This is a response...
7
2753
by: Kun | last post by:
I have a python-cgi form whose sole purpose is to email. It has the fields 'to', 'from', 'subject', 'body', etc. and if the user fills them out and clicks submit, it will invoke another file called mail.py which uses smtplib to send the message. This works fine but instead of typing in a 'body', i would like the initial python program to...
0
7746
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7668
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
1
7736
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
8036
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6358
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5556
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
3701
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
1
2167
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
0
999
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.