| Author |
 Topic  |
|
|
german
Starting Member
23 Posts |
 Posted - 27 November 2002 : 09:07:13
|
Hi
I get this error when running the contentdisplay_tester.asp:
Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
/forum/content.asp, line 122
That line is:
rs.open strSql, my_Conn, 3, adLockReadOnly, adCmdText
I imagine it has has to do with the SQL string somehow, but I am not sure.
I am using v 3.4.03 and I have the message icon mod and the custom avatar mods installed.
I believe i did everything correctly in the read me, just can't figure out where in the string the error is occurring, or what value is missing.
Any insight would be appreciated!
|
www.deeko.com |
|
|
wiltech
Starting Member
17 Posts |
Posted - 05 January 2003 : 16:17:46
|
I'm having the same problem. Were you able to fix yours?
Thanks
Tony W |
CJOffroad.com |
 |
|
|
Steve D.
Average Member
USA
640 Posts |
Posted - 05 January 2003 : 16:42:56
|
make sure you have the Message Icons & Avatar mod installed if you are going to use it out of the box.
If you don't have them and don't plan to install them, you can follow these instructions
quote:
You can easily edit those out yourself.
1. Remove lines with this from content.asp:
strSql = strSql & strTablePrefix & "TOPICS.T_MSGICON, "
And this:
strSql = strSql & strTablePrefix & "MEMBERS.M_AVATAR_URL "
Remove functions calls that look like the following from display modes:
Call WriteOrnament(Ornament, counter) - Message Icons
Call WriteSpecial(Special) - Also message Icons for the most part although you could hard code some images like new.gif etc. and remove references to message icons.
Call WritePhotoAvatar - This is for displaying the avatar OR the profile pic. It actually foes for the profile pic first but goes for an avatar image second. You could leave these and default on a file called noimage.gif or a blank gif and keep this. You just need to give the function something to do in case there is no profile pic.
Take care of those and you can use this MOD without those other MODs.
@tomic
|
Swing Dancing Video Clips - It's All Swing! Forum |
|
|
|
wiltech
Starting Member
17 Posts |
Posted - 05 January 2003 : 17:12:37
|
quote:
Originally posted by Steve D.
make sure you have the Message Icons & Avatar mod installed if you are going to use it out of the box.
If you don't have them and don't plan to install them, you can follow these instructions
Steve,
I have them both installed. I guess I should have been a bit clearer.
I added a response.write(strSQL) right above the line that is giving the error and pasted the SQL string into the Access query designer, and the query works there.
I am using version 3.4.03.06 of the content display. I've also changed all of the includes on my site from FILE="" VIRTUAL="forums/"
My test is at: http://cjoffroad.nldev.nlci.com/test.asp
Thanks
Tony W |
CJOffroad.com |
|
|
|
jkmcgrath
Junior Member
USA
145 Posts |
Posted - 05 January 2003 : 18:27:02
|
make sure you dont have a <% misplaced
|
Delta Force Seals |
|
|
| |
Topic |
|
Topic Locked
