| Author |
 Topic  |
|
cripto9t
Average Member
USA
881 Posts |
 Posted - 05 February 2007 : 12:56:28
|
quote:
Originally posted by runsh
I think this part in quiz.asp also should be change, gives error:
'## Quiz Page Sql
strSql = "SELECT QUIZ_ID, Q_AUTHOR, Q_TITLE, Q_DATE, Q_STATUS, Q_QUESTIONS, Q_CHOICES, Q_TEMPLATE, Q_ENTRIES, Q_RETAKE," & _
" Q_RANDOM_QUESTIONS, Q_RANDOM, Q_ANON, M_NAME, Q_DESCRIPTION" & _
" FROM " & strTablePrefix & "QUIZ Q" & _
" LEFT JOIN " & strTablePrefix & "MEMBERS" & _
" ON Q_AUTHOR = MEMBER_ID" & _
" WHERE QUIZ_ID = " & QuizID '& " AND Q_STATUS = 1"
this is the error
Microsoft JET Database Engine error '80040e14'
Join expression not supported.
/froumq/quiz.asp, line 81
i seen this one coming :)
replace it with this
'## Quiz Page Sql
strSql = "SELECT QUIZ_ID, Q_AUTHOR, Q_TITLE, Q_DATE, Q_STATUS, Q_QUESTIONS, Q_CHOICES, Q_TEMPLATE, Q_ENTRIES, Q_RETAKE," & _
" Q_RANDOM_QUESTIONS, Q_RANDOM, Q_ANON, M_NAME, Q_DESCRIPTION" & _
" FROM " & strTablePrefix & "QUIZ, " & strTablePrefix & "MEMBERS" & _
" WHERE QUIZ_ID = " & QuizID & " AND Q_AUTHOR = MEMBER_ID"
I'm going to keep looking for a reason the left join isn't working.< |
_-/Cripto9t\-_ |
 |
|
|
MaD2ko0l
Senior Member
United Kingdom
1053 Posts |
Posted - 05 February 2007 : 13:38:05
|
quiz edit
error when editing
Microsoft JET Database Engine error '80040e14'
Join expression not supported.
/snitzquizzer/quiz_edit.asp, line 148
fix, find lines 139 - 146, which is this:
'write sql
strSql = "SELECT Q_TITLE, Q_TYPE, Q_QUESTIONS, Q_CHOICES"
if Action_Type = "QuizEdit" then strSql = strSql & ", Q_RETAKE, Q_ANON, Q_CORRECTIONS, Q_RANDOM, Q_RANDOM_QUESTIONS"
strSql = strSql & ", M_NAME, Q_DESCRIPTION" & _
" FROM " & strTablePrefix & "QUIZ" & _
" LEFT JOIN " & strMemberTablePrefix & "MEMBERS" & _
" ON Q_AUTHOR = MEMBER_ID" & _
" WHERE QUIZ_ID = " & QuizQuizID
replace with this
'write sql
strSql = "SELECT Q_TITLE, Q_TYPE, Q_QUESTIONS, Q_CHOICES"
if Action_Type = "QuizEdit" then strSql = strSql & ", Q_RETAKE, Q_ANON, Q_CORRECTIONS, Q_RANDOM, Q_RANDOM_QUESTIONS"
strSql = strSql & ", M_NAME, Q_DESCRIPTION" & _
" FROM " & strTablePrefix & "QUIZ, " & strTablePrefix & "MEMBERS" & _
" WHERE QUIZ_ID = " & QuizID & " AND Q_AUTHOR = MEMBER_ID"
< |
© 1999-2010 MaD2ko0l |
|
|
|
MaD2ko0l
Senior Member
United Kingdom
1053 Posts |
Posted - 05 February 2007 : 13:39:08
|
| also i did not have to change the getAverage function to make this work.< |
© 1999-2010 MaD2ko0l |
|
|
|
MaD2ko0l
Senior Member
United Kingdom
1053 Posts |
Posted - 05 February 2007 : 13:42:51
|
question...
why archive a quiz if you cannot see the questions/answer???
im sure u should be able to view the questions and correct answers if it has been archived< |
© 1999-2010 MaD2ko0l |
|
|
|
cripto9t
Average Member
USA
881 Posts |
Posted - 05 February 2007 : 14:09:34
|
quote:
Originally posted by MaD2ko0l
question...
why archive a quiz if you cannot see the questions/answer???
im sure u should be able to view the questions and correct answers if it has been archived
Ah but you can see it when you edit it.
Its just something I thought would come in handy for an old quiz that you might want to reactivate at a later date.
I need to fix the title link so that it points to archives.< |
_-/Cripto9t\-_ |
Edited by - cripto9t on 05 February 2007 14:10:04 |
|
|
|
cripto9t
Average Member
USA
881 Posts |
Posted - 05 February 2007 : 14:15:15
|
quote:
Originally posted by MaD2ko0l
also i did not have to change the getAverage function to make this work.
I think that has something to do with the server.
I wasn't getting an error either with iis.
But you need to change that function because it doesnt work :).
If youll notice it returns 0 every time.< |
_-/Cripto9t\-_ |
|
|
|
runsh
Starting Member
34 Posts |
Posted - 05 February 2007 : 14:24:04
|
cripto9t quiz_active.asp gives same error.
but now when making quiz and taking it, everything seems to be working fine except can't get to active quizzes page.
By the way is it possible to make an option for displaying one question at a time vs all question appearing in the same page.
also down the road maybe adding a timer for taking quiz would be nice.
thanks< |
|
|
|
cripto9t
Average Member
USA
881 Posts |
Posted - 05 February 2007 : 14:27:10
|
I'm going to go through and change all the outer joins to inner joins.
The reason I wanted the left join is in case a member has written a quiz
and the member is deleted in the future.
I know snitz doesnt delete the Member if they have posts it just updates them to n/a.
But if they don't have posts, they get deleted and that would put the quiz in limbo.< |
_-/Cripto9t\-_ |
|
|
|
runsh
Starting Member
34 Posts |
Posted - 05 February 2007 : 14:27:56
|
Sorry I just notice the error is little different:
Microsoft VBScript runtime error '800a005e'
Invalid use of Null: 'cInt'
/froumq/quiz_active.asp, line 339
< |
|
|
|
cripto9t
Average Member
USA
881 Posts |
Posted - 05 February 2007 : 14:46:36
|
quote:
Originally posted by runsh
Sorry I just notice the error is little different:
Microsoft VBScript runtime error '800a005e'
Invalid use of Null: 'cInt'
/froumq/quiz_active.asp, line 339
I was just getting ready to ask that ;) I'll give it another look.< |
_-/Cripto9t\-_ |
|
|
|
cripto9t
Average Member
USA
881 Posts |
Posted - 05 February 2007 : 15:01:40
|
runsh find this around line 234
QuizPercent = getAverage(QuizAverage)
replace it with this
if isNull(QuizAverage) or trim(QuizAverage) = "" then
QuizPercent = ""
else
QuizPercent = getAverage(QuizAverage)
end if
I hope that works< |
_-/Cripto9t\-_ |
|
|
|
runsh
Starting Member
34 Posts |
Posted - 05 February 2007 : 15:26:35
|
now is getting this error:
< |
Edited by - runsh on 05 February 2007 15:53:13 |
|
|
|
runsh
Starting Member
34 Posts |
Posted - 05 February 2007 : 15:42:54
|
sorry after posting above I put a fresh database and installed mod again, now seems to be working fine. I haven't noticed any error yet. I'll keep testing it.
Thanks for the mod is very nice. hope you can imporve it and add more feature.< |
|
|
|
cripto9t
Average Member
USA
881 Posts |
Posted - 05 February 2007 : 16:09:05
|
Thanks for the help runsh. The question paging is on my todo list.
time limits would be great. I looked at a few quizzes with time limits, but they weren't implemented very well and I can't think of a good way to do it other than maybe javascript.< |
_-/Cripto9t\-_ |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 05 February 2007 : 16:11:22
|
I didn't really get a chance to check it out today, but my goal for this week is to see if I can use the record keeping code I'm using in my current online testing code for this since this has some of the features I was looking to add. 
Here's hoping they leave me alone long enough to try....< |
|
|
|
Topic |
|
Quizzer 1 1.0.01 Beta (for testing only)
