extending 255 letter hyperlink limit

G

Greg

the subject is a little rough but here is the problem...

I have a DRW on a page with a hyperlink within it to
carry the info over into another pages memo box using the
PARAMETERS option on the hyperlink. So when the next
page comes up, the text from that DRW comes up in the
memo box on the next page where it can be edited. Ive
done this a million times but now i cant get it to work
for this one thing. this is carrying over well over 1000
words and all i can think of its exceeding the 255 limit
for hyperlinks because when i changed the text in the
database to just a couple words manually, it carried over
fine!

BUT....

I have another page which is identical to all this but
there are less words but still over 1000 words and i have
no problems at all carrying everything over. If this
problem isnt confusing to you, please give me some help!
thanks!
 
T

Thomas A. Rowe

Why not pass the record ID or some other type of ID to the next page, then
on this next page retrieve the info for the memo field by querying the
database via the supplied ID value?

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle,
MS KB Quick Links, etc.
==============================================
 
G

Greg

Thats new to me. Ive always carried over every field
including the ID to the next page. I would put <%=Request
("ID")%> for each of the text boxes on that 2nd page with
of course ID representing each field. So how would i do
what you are talking about?
 
T

Thomas A. Rowe

Greg,

The hyperlink that you are generated, just add the record ID as the
querystring, ie,

<a href="review.asp?id=<%=RecordSet("ID")%>Subject</a>

Then on the next page

<%
Dim ID
ID = Request.Querystring("ID")
%>

Your database query

SQL = "Select * From TABLE Where ID = " & ID


--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle,
MS KB Quick Links, etc.
==============================================
 
G

Greg

Im sorry, im not understanding some things...

<a href="review.asp?id=<%=RecordSet("ID")%>Subject</a>
does that replace the hyperlink which i used to go to the
next page which is kept in the DRW area? (between the
yellow bars?)

<%
Dim ID
ID = Request.Querystring("ID")
%>
where on the 2nd page does this exactly go, at the top of
the body of the html?

SQL = "Select * From TABLE Where ID = " & ID
Where does this go, in the Initial Value area of the text
or memo box?
 
T

Thomas A. Rowe

Greg,

Actually you will need to do a little hand coding of your ASP and not rely
on the DRW.

See my replies inline below.
--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle,
MS KB Quick Links, etc.
==============================================


Greg said:
Im sorry, im not understanding some things...

<a href="review.asp?id=<%=RecordSet("ID")%>Subject</a>
does that replace the hyperlink which i used to go to the
next page which is kept in the DRW area? (between the
yellow bars?)
Click to expand...

I don't use the DRW, but if that is where your current link is, then yes.
<%
Dim ID
ID = Request.Querystring("ID")
%>
where on the 2nd page does this exactly go, at the top of
the body of the html?
Click to expand...

See below.
SQL = "Select * From TABLE Where ID = " & ID
Where does this go, in the Initial Value area of the text
or memo box?
Click to expand...

This is where you learn to write you own ASP code.

Place the following before the opening <html> tag on the page you are
linking to. The "Application("Connection_ConnectionString")" is copied from
the global.asa file that FP generates in the root of the web.

<%
Dim DSN_Name
DSN_Name = Application("Connection_ConnectionString")
set Conn = Server.CreateObject("ADODB.Connection")
set objRS = server.CreateObject("ADODB.Recordset")
Conn.Open DSN_Name

Dim ID
ID = Request.QueryString("ID")

Set objRS = Server.CreateObject("ADODB.Recordset")
SQL = "SELECT * FROM TABLENAME WHERE ID= " & ID
objRS.Open SQL, DSN_Name
%>

In the Memo field or other fields, as the initial value use:

<%=objRS("Fieldname"%>


 
Top