ASP.NET / Access query Problem
Question posted by: Myk Quayce
(Guest)
on
November 12th, 2005 11:40 PM
I have an excellent piece of SQL that returns 35 random rows from a table
but it only works as an MS Access query and not in an ASP.NET webpage where
I want to use it.
Is there any way for ASP.NET to get the results from an Access query?
The SQL is...
SELECT TOP 35 * FROM Questions WHERE UserType='Student' ORDER BY
Rnd(QuestionNo);
TIA
--
Myk Quayce
"Whatever happened to all the fun in the world?" - Frank Zappa
1
Answer Posted
On Mon, 10 May 2004 15:05:11 +0100, "Myk Quayce"
<myk@quayce.freeserve.co.uk.spamless> wrote:
No, because you are using the VBA function Rnd.
-TOm.
[color=blue]
>I have an excellent piece of SQL that returns 35 random rows from a table
>but it only works as an MS Access query and not in an ASP.NET webpage where
>I want to use it.
>
>Is there any way for ASP.NET to get the results from an Access query?
>
>The SQL is...
>
>SELECT TOP 35 * FROM Questions WHERE UserType='Student' ORDER BY
>Rnd(QuestionNo);
>
>TIA[/color]
|
|
|
What is Bytes?
We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights.
Get the best answers to your questions from over 196,907 network members.
Top Community Contributors
|
