recordset paging

[flashermx]

I have connected Dreamwever with an access database. I have a search page that searches for records and displays them in a results page. I want to display four records at a time in my results page. This part works but, when I use recordset paging to go to next record I get an empty recordset. How come?

:block:

[abzoid]

post your code

[flashermx]

I tried to post the code but it shows the formatting not the code behind it. How do I post just the code. I copy and paste but still see the page formatting not the code.

[flashermx]

Abzoid in mysql I had a request form variable not a request.query variable and my form was a post action not a get action so now all works. :cowboy:

Question: Using asp visual basic how can I format the reults to be an active hyperlink?


:sigh:

[abzoid]

I assume by visual basic you mean VBScript.

I need more info about what your linking to? A page with more detailed info, also pulled from the database? Or a URL pulled from that record in the database?

[flashermx]

Abzoid this is all new to me and my level of understanding is very concrete. Yes I mean ASP VBscript.

The database is a collection of urls. The url is a column in the database and you can query the urls by subject or content. I would like the url results to be hot. Currently there is an extension from the Macromedia exchange that makes email addresses hot and any website with a http://www
hot but websites without the www aren't hot. Is there a way to code the results for all urls to be hot.

:rambo:

[abzoid]

OK, this one is easy.

First select the dynamic text that displays the link URL. Now click the small folder icon in the Properties Tool Box just to the right of the link text area. Up at the top of the browse box that comes up click the radio button for Select File Name From: Data Sources. Select the proper recordset and data field for the URL, then click OK.

That's it.