| Author |
 Topic  |
|
|
thephantomnl
New Member
Netherlands
66 Posts |
 Posted - 30 July 2001 : 09:25:16
|
when having the topics archiefd and i want to view them i get the
error:Microsoft JET Database Engine fout '80040e10'
Waarden voor een of meer vereiste parameters ontbreken.
/forumv33/topic.asp, regel 274
(valeu for 1 or more parrameters is missing)
adres: topic.asp?ARCHIVE=true&TOPIC_ID=2
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 30 July 2001 : 09:34:46
|
I have checked the code, it looks ok. could you try the following
in topic.asp on line 248 you should find the following code
set rsCount = my_Conn.Execute(strSql2)
on the line imediately above it, type response.write strSQL, then reload try again, it should write out th query, so I can see what it is missing.
You can then remove the line I asked you to type.
|
 |
|
|
thephantomnl
New Member
Netherlands
66 Posts |
Posted - 30 July 2001 : 11:01:04
|
when i place response.write strSQL i get no respons on it. it gives no information on screen  but this is the 'strDBType = "mysql" and we are using access??
when i put the code on line 273 i get:
SELECT FORUM_MEMBERS.M_NAME, FORUM_MEMBERS.M_ICQ, FORUM_MEMBERS.M_YAHOO, FORUM_MEMBERS.M_AIM, FORUM_MEMBERS.M_TITLE, FORUM_MEMBERS.MEMBER_ID, FORUM_MEMBERS.M_HOMEPAGE, FORUM_MEMBERS.M_LEVEL, FORUM_MEMBERS.M_POSTS, FORUM_MEMBERS.M_COUNTRY, FORUM_A_REPLY.REPLY_ID, FORUM_A_REPLY.FORUM_ID, FORUM_A_REPLY.R_AUTHOR, FORUM_A_REPLY.TOPIC_ID, FORUM_A_REPLY.R_MESSAGE, FORUM_A_REPLY.R_STATUS, FORUM_A_REPLY.R_DATE FROM FORUM_MEMBERS, FORUM_A_REPLY WHERE FORUM_MEMBERS.MEMBER_ID = FORUM_A_REPLY.R_AUTHOR AND TOPIC_ID = 8 ORDER BY FORUM_A_REPLY.R_DATE ASC
maybe this helps??
|
|
|
|
Asdeus
Starting Member
7 Posts |
Posted - 01 August 2001 : 16:00:20
|
I get this error also, using access, same query (the one thephantomnl posted).
SELECT FORUM_MEMBERS.M_NAME,
FORUM_MEMBERS.M_ICQ,
FORUM_MEMBERS.M_YAHOO,
FORUM_MEMBERS.M_AIM,
FORUM_MEMBERS.M_TITLE,
FORUM_MEMBERS.MEMBER_ID,
FORUM_MEMBERS.M_HOMEPAGE,
FORUM_MEMBERS.M_LEVEL,
FORUM_MEMBERS.M_POSTS,
FORUM_MEMBERS.M_COUNTRY,
FORUM_A_REPLY.REPLY_ID,
FORUM_A_REPLY.FORUM_ID,
FORUM_A_REPLY.R_AUTHOR,
FORUM_A_REPLY.TOPIC_ID,
FORUM_A_REPLY.R_MESSAGE,
FORUM_A_REPLY.R_STATUS,
FORUM_A_REPLY.R_DATE FROM FORUM_MEMBERS,
FORUM_A_REPLY WHERE FORUM_MEMBERS.MEMBER_ID = FORUM_A_REPLY.R_AUTHOR AND TOPIC_ID = 22 ORDER BY FORUM_A_REPLY.R_DATE ASC
Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
/topic.asp, line 274
Edited by - Asdeus on 01 August 2001 16:09:05 |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 01 August 2001 : 18:00:14
|
ok, try changing this line
" AND TOPIC_ID = " & Topic_ID & " " (line 225)
to this
" AND " & strActivePrefix & "REPLY.TOPIC_ID = " & Topic_ID & " "
|
|
|
|
Asdeus
Starting Member
7 Posts |
Posted - 01 August 2001 : 18:13:38
|
quote:
ok, try changing this line
" AND TOPIC_ID = " & Topic_ID & " " (line 225)
to this
" AND " & strActivePrefix & "REPLY.TOPIC_ID = " & Topic_ID & " "
didn't work.
same error same line.
|
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 01 August 2001 : 18:17:03
|
coul you check that your db has all the fields that are being selected.
|
|
|
|
Asdeus
Starting Member
7 Posts |
Posted - 01 August 2001 : 18:31:13
|
quote:
coul you check that your db has all the fields that are being selected.
that was it.
strActivePrefix & "REPLY.R_STATUS, " & _
this field is not in the db, I removed the line from the query and now it works.
Is it a problem with the code or the DB needs the field?
whats the datatype?
Thanks for your help  |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 01 August 2001 : 18:34:34
|
The DB needs the field, I think this has already been addressed, will do a quick hunt and check
I checked the forum code, and this field is in all the scripts, what DB are you using ?
|
|
|
|
Asdeus
Starting Member
7 Posts |
Posted - 01 August 2001 : 18:43:31
|
Access, clean install.
Just checked the .02 zip, and the field is not in the DB inside.
|
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 01 August 2001 : 18:47:21
|
Many thanks.
I wil now lock this since we know the problem and the solution.
|
|
|
| |
Topic |
|
Forum Locked
Topic Locked
