It Monday morning and I had a rough weekend so I'm sorry but I don't understand your question<BR><BR>-->Is there a way to keep my hyperlinks when I do a query on my database <--<BR><BR>Yes, I assume that you have hyperlinks and the you make some kind of action that reads in the database and you loose all of your links?<BR><BR>-->then post it to a new page<--<BR>So I assume you have a <form>...</form> with a <submit button><BR><BR>-->My items are hyperlinked in access<--<BR>So inside your database, in a field, you store your data as an hyperlink?<BR><BR>Let me put everything back together just to make sure I understand correctly<BR><BR>-You have an .asp page<BR>-You make a Query to your database an obtain a recordset<BR>-Then you create a <form>...<form> and a <submit button><BR>-You loop with your recordset in order to show your hyperlinks (the one's stored in your Recordset because in your database they are saved as hyperlinks"<BR>-Then what happens?<BR><BR>-You submit your <form>...</form> to where? what is the purpose?<BR>I need more info
-I have a form page: you type in what your looking for then hit submit.<BR>-You make a Query to your database an obtain a recordset<BR>-You loop with your recordset in order to show your hyperlinks <BR>- Then do a write to the page, and they look like this:<BR>Training Guide#..WINDOWSDesktopNew PDF2000-0-301-001.pdf#<BR><BR>where everything after the "Training Guide" is the hyperlink.But it writes it to the page.
do it the hardway like the rest of us (i think *lol*)<BR><BR>when outputing the result of your recordset<BR><BR><% while rsSomething.EOF %><BR><BR><a href="<%=rsSomething("yourlink")%>"> ;<%=rsSomething("yourlink")%></a><BR><BR><%<BR>rsSomething.MoveNext<BR> Wend<BR>%>
Ok thanks this is more clear ;)<BR><BR>Ok I assume you've done all of this already and you have problems where exactly?<BR><BR>Is you problem when trying to loop and make a Response.Write of your hyperlink?
if i get you right you have one table with all the links? <BR><BR>the code i just wrote loop through the recordset and prints every link until the recordset has come to the last post !!! <BR><BR>so you only have to do write ONE line