Passing email in string from one page to another.

[Miguel Orrego]

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("NOTETEXT")

And to pass to the next page:

<a
href="createemail.asp?strIssueNo=<%=zero(rsnotes.f ields(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?

Thanks.

[Ken Schaefer]

a) If you want to pass data in the querystring you need to use
Server.URLEncode() on the data, ie:

<a href="newpage.asp?var=<%=Server.URLEncode(strVar)% >">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.asp?recordID=5">click here</a>

Cheers
Ken

"Miguel Orrego" <mi****@stressedmonkey.net-nospam> wrote in message
news:3f*********************@news.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("NOTETEXT")
:
: And to pass to the next page:
:
: <a
:
href="createemail.asp?strIssueNo=<%=zero(rsnotes.f ields(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?
:
: Thanks.
:
:
:
:
:

[Miguel Orrego]

Hi Ken,

Thanks for the answer, that solved it.

Cheers.

"Ken Schaefer" <ke*******@THISadOpenStatic.com> wrote in message
news:#m**************@tk2msftngp13.phx.gbl...

a) If you want to pass data in the querystring you need to use
Server.URLEncode() on the data, ie:

<a href="newpage.asp?var=<%=Server.URLEncode(strVar)% >">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.asp?recordID=5">click here</a>

Cheers
Ken

"Miguel Orrego" <mi****@stressedmonkey.net-nospam> wrote in message
news:3f*********************@news.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("NOTETEXT")
:
: And to pass to the next page:
:
: <a
:
href="createemail.asp?strIssueNo=<%=zero(rsnotes.f ields(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?
:
: Thanks.
:
:
:
:
: