Looks like a straightforwad SQL problem -- the query isn't correct.
Are you sure there is a value in Session("askedQuestions")? If not
your query would look like
SELECT TOP 1 QuestionId, QuestionHTML, QuestionType FROM
Question WHERE QuestionId NOT IN ();
Also, you might have more luck with
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOK/
HTH
On Wed, 22 Dec 2004 14:47:02 -0000, scaevola637 <[EMAIL PROTECTED]> wrote:
>
>
> I am looking at a classic ASP application written in JavaScript.
> 1) Does IIS 5.0 support such an application?
> 2) This code is giving a problem:
> <---- code begins here
> <%
> Session("totalQuestionsAsked")= parseInt(Session
> ("totalQuestionsAsked")) + 1;
> var questionId;
> var mySQL;
> var adoConnection = Server.CreateObject("ADODB.Connection")
> adoConnection.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data" +
> " Source=C:\\Temp\\TriviaQuestions.mdb")
> mySQL = "SELECT TOP 1 QuestionId, QuestionHTML, QuestionType FROM
> Question ";
> mySQL = mySQL + " WHERE QuestionId NOT IN (" +
> Session("AskedQuestions") + ")";
> var adoRecordset = adoConnection.Execute(mySQL);
> questionId = adoRecordset("QuestionId").Value;
> Session("AskedQuestions") = Session("AskedQuestions") + "," +
> questionId;
> --- code ends -->
>
> specifically this line is giving an error:
> var adoRecordset = adoConnection.Execute(mySQL);
>
> this is the error:
> Error Type:
> Microsoft JET Database Engine (0x80040E10)
> No value given for one or more required parameters.
> /BegJSChap17/AskQuestion.asp, line 21
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
--
Dean Fiala
Very Practical Software, Inc
http://www.vpsw.com
------------------------ Yahoo! Groups Sponsor --------------------~-->
Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/saFolB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
<*> 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/
