Show the code maybe we can help ... without it it would be hard :)
----- Original Message -----
From: "Heather" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Monday, July 18, 2005 1:11 AM
Subject: [AspClassicAnyQuestionIsOk] Randomisation of results - ASP/SQL
> Help!!
>
> I'm going absolutely nuts (not to mention around in circles) with this
> problem. I recently migrated from Access to MS SQL and after initial
> glitches, all problems are sorted out except one.
>
> My results page is showing randomised results but when there's more
> than 10 records, and it goes through to a 2nd page, the 2nd page
> results are chosen from the entire Recordset again rather than just
> the remaining records. I'm using Order by NEWID for the randomisation.
>
> I've searched high and low on the net and can't seem to find a
> solution for my particular situation (a few hopeful pieces of code
> have ended up breaking the page).
>
> Can anyone offer me any advice? I can post my code or send it
> privately if anyone can help.
>
> Thanks!
>
> Heather
>
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
