Snitz Forums 2000 - Smile Mod (Updated)

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Snitz Forums 2000 MOD-Group

MOD Add-On Forum (W/Code)

Smile Mod (Updated)

New Topic

Topic Locked

Printer Friendly

Previous Page | Next Page

Author

Topic

Page: of 6

HuwR
Forum Admin

United Kingdom
20595 Posts

Posted - 22 December 2000 : 20:00:18

I can't get the pop_icon_legend to work for Access, works great on my SQL forum, but on my Access DB I get this whenever I select a category
<pre id=code>
Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.

/sr3/pop_icon_legend.asp, line 111
</pre id=code>

I have checked the query, nothing wrong, if you open Access and run the query, it works OK.

Any Ideas ?

'Resistance is futile'

Hopper
Junior Member

192 Posts

Posted - 22 December 2000 : 22:49:19

<BLOCKQUOTE id=quote>quote:<hr height=1 noshade id=quote>
I can't get the pop_icon_legend to work for Access, works great on my SQL forum, but on my Access DB I get this whenever I select a category
<pre id=code>
Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.

/sr3/pop_icon_legend.asp, line 111
</pre id=code>

I have checked the query, nothing wrong, if you open Access and run the query, it works OK.

Any Ideas ?

'Resistance is futile'
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote>

Yep, I get the same thing for any new catagories i add..

Da_Stimulator
DEV Team Forum Moderator

USA
3373 Posts

Posted - 22 December 2000 : 23:21:08

Dunno, I've done some modifications to mine and havnt had any problems, on that line I have 'loop'

Whats on your lines?

Da_Stimulator
Stimmy's Forums - Using 3.1 SR3
"We all die someday, but your goin down before I do" - Me

Hopper
Junior Member

192 Posts

Posted - 23 December 2000 : 00:14:58

<BLOCKQUOTE id=quote>quote:<hr height=1 noshade id=quote>
Dunno, I've done some modifications to mine and havnt had any problems, on that line I have 'loop'

Whats on your lines?

Da_Stimulator
Stimmy's Forums - Using 3.1 SR3
"We all die someday, but your goin down before I do" - Me
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote>

My lines 164-166 (the error is on 165 in my latest version) are:

if not (drs.eof or drs.bof) then
drs.PageSize = strCount2
drs.AbsolutePage = 2

Da_Stimulator
DEV Team Forum Moderator

USA
3373 Posts

Posted - 23 December 2000 : 01:23:29

Try changing

if not (drs.eof or drs.bof) then

To

if not(drs.eof or strCount2 = 0) then

Da_Stimulator
Stimmy's Forums - Using 3.1 SR3
"We all die someday, but your goin down before I do" - Me

HuwR
Forum Admin

United Kingdom
20595 Posts

Posted - 23 December 2000 : 05:03:38

ion mine it erorrors when executing this query
<pre id=code>
strsql = "select smile_name from "&strTablePrefix&"smiles where cat_id="&request.querystring("cat_id")

set drs = my_conn.execute(strsql) error line
</pre id=code>

'Resistance is futile'

Hopper
Junior Member

192 Posts

Posted - 23 December 2000 : 17:42:00

<BLOCKQUOTE id=quote>quote:<hr height=1 noshade id=quote>
Try changing

if not (drs.eof or drs.bof) then

To

if not(drs.eof or strCount2 = 0) then

Da_Stimulator
Stimmy's Forums - Using 3.1 SR3
"We all die someday, but your goin down before I do" - Me
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote>

That did not work, DA.. all it does is say there are no smiles in that catagory.. even through I put 2 in it.

HuwR
Forum Admin

United Kingdom
20595 Posts

Posted - 23 December 2000 : 20:41:19

<BLOCKQUOTE id=quote>quote:<hr height=1 noshade id=quote>
ion mine it erorrors when executing this query
<pre id=code>
strsql = "select smile_name from "&strTablePrefix&"smiles where cat_id="&request.querystring("cat_id")

set drs = my_conn.execute(strsql) error line
</pre id=code>

'Resistance is futile'
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote>

I fixed my problem, I dropped the tables and reran the setup scripts, now everything is OK.

'Resistance is futile'

Da_Stimulator
DEV Team Forum Moderator

USA
3373 Posts

Posted - 23 December 2000 : 20:43:40

Tables musta got corrupted huwr... sorry i couldnt respond sooner.

Hopper, try

if not(drs.eof) or not(strCount2 = 0) then

Da_Stimulator
Stimmy's Forums - Using 3.1 SR3
"We all die someday, but your goin down before I do" - Me

Hopper
Junior Member

192 Posts

Posted - 23 December 2000 : 22:54:27

<BLOCKQUOTE id=quote>quote:<hr height=1 noshade id=quote>
Tables musta got corrupted huwr... sorry i couldnt respond sooner.

Hopper, try

if not(drs.eof) or not(strCount2 = 0) then

Da_Stimulator
Stimmy's Forums - Using 3.1 SR3
"We all die someday, but your goin down before I do" - Me
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote>

Error on line 165: This is 164-166

if not(drs.eof) or not(strCount2 = 0) then
drs.PageSize = strCount2
drs.AbsolutePage = 2
***********
ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

/pop_icon_legend.asp, line 165

Da_Stimulator
DEV Team Forum Moderator

USA
3373 Posts

Posted - 23 December 2000 : 23:04:24

Sorry to suggest this Hopper, as I've seen the amount of smiles you've added, but try dropping tables and re-installing? thats all I can think of...

Da_Stimulator
Stimmy's Forums - Using 3.1 SR3
"We all die someday, but your goin down before I do" - Me

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 24 December 2000 : 18:05:36

Da_Stimulator,

I added this mod to someone's forum today and I am having a little problem.

The user has added a smilie to the default category making a total of 27 smilies.

In pop_icon_legend.asp it is displaying 1 icon twice. It does 14 icons on the left side and 13 icons on the right like it's supposed to, but the #14 and #15 icons are the same icons and the #27th icon that the user added isn't showing up.

you can see it here: http://www15.brinkster.com/snark6/forum/post.asp?method=Topic&FORUM_ID=2&CAT_ID=1&Forum_Title=free+for+all

(it's showing cool_guy <img src=icon_smile_cool.gif border=0 align=middle> twice)

Thanks!

Edited by - Richard Kinser on 24 December 2000 18:08:30

Da_Stimulator
DEV Team Forum Moderator

USA
3373 Posts

Posted - 24 December 2000 : 18:53:46

Acutally its showing Big smile twice <img src=icon_smile_big.gif border=0 align=middle>

Try submitting the added smile a second time (making 2 in the db) and see what happens.

For some reason I think it only shows them the way they are supposed to be shown when there is an even amount, which is odd...

Da_Stimulator
Stimmy's Forums - Using 3.1 SR3
"We all die someday, but your goin down before I do" - Me

Hopper
Junior Member

192 Posts

Posted - 24 December 2000 : 18:59:57

Ick, start over after adding over 50 smiles? Goodness.

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 24 December 2000 : 19:01:26

looks like he changed them around. It was cool guy... honest... <img src=icon_smile_cool.gif border=0 align=middle>

so we need to keep an even # for it to work right?

Page: of 6

Topic

Previous Page | Next Page

New Topic

Topic Locked

Printer Friendly

Jump To:

Snitz Forums 2000

This page was generated in 0.48 seconds.