Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: MOD Implementation
 Microsoft JET Database Engine error '80040e07'
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Carefree
Advanced Member

Philippines
4207 Posts

Posted - 26 April 2008 :  23:29:47  Show Profile
aka "Data type mismatch in criteria expression."

I'm sure that somewhere in my inc_function_common.asp, there's a comma missing or something out-of-order in a sql expression; but I've been staring at these files for several days and I'm probably missing the big pink elephant.

Would someone take a look and see why the routine at lines 2018-2041 is giving me a "you're stupid" message?

http://98.25.191.199/ifc.txt<

Edited by - Carefree on 30 May 2008 21:30:34

cripto9t
Average Member

USA
881 Posts

Posted - 27 April 2008 :  08:27:08  Show Profile
strSQL = strSQL & "FROM " & strActivePrefix & "TOPICS WHERE TOPIC_ID = '" & iTopicID & "'"

TOPIC_ID is numeric (integer field), lose the apostrophes
strSQL = strSQL & "FROM " & strActivePrefix & "TOPICS WHERE TOPIC_ID = " & iTopicID

that would be my guess <

    _-/Cripto9t\-_

Edited by - cripto9t on 27 April 2008 08:31:30
Go to Top of Page

Shaggy
Support Moderator

Ireland
6780 Posts

Posted - 28 April 2008 :  04:34:30  Show Profile
quote:
Originally posted by Carefree
Would someone take a look and see why the routine at lines 2018-2041 is giving me a "you're stupid" message?
Ah-hahaha! I'm off to reconfigure my error pages!

Both those functions are as they should be so the problem must lie in whatever is being passed to them through the arguments; what page is the error actually occurring on?

<

Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.”
Go to Top of Page

Carefree
Advanced Member

Philippines
4207 Posts

Posted - 28 April 2008 :  16:05:55  Show Profile
We figured it out in another thread, Shaggy. The problem was two-fold: first, the variable iTopicID was supposed to be numeric and it had apostrophes surrounding it; secondly, at no point did the mod ever configure it (or half-a-dozen other variables).

It's going to need a bit of a rewrite lol.<
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.32 seconds. Powered By: Snitz Forums 2000 Version 3.4.07