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

 All Forums
 Community Forums
 Code Support: ASP (Non-Forum Related)
 SQL Problems....
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Da_Stimulator
DEV Team Forum Moderator

USA
3373 Posts

Posted - 04 March 2001 :  12:58:51  Show Profile  Send Da_Stimulator an AOL message  Send Da_Stimulator a Yahoo! Message
Maybe this is another one of my stupidity actions... where I didnt get enuf sleep or something, but I get the following error.

Microsoft JET Database Engine error '80040e14'

The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect.

/snitz_testing/mod_db.asp, line 472


This is line 472 with the strsql string that is executed...


strsql = "SELECT "
strsql = strsql & "M_NAME, "
strsql = strsql & "M_VERSION, "
strsql = strsql & "M_DESC, "
strsql = strsql & "M_AUTHOR, "
strsql = strsql & "M_SITE, "
strsql = strsql & "M_FORUM, "
strsql = strsql & "M_STOPIC, "
strsql = strsql & "M_EMAIL, "
strsql = strsql & "M_DOWNLOAD, "
strsql = strsql & "FROM " & strTablePrefix & "MODS1 "
strsql = strsql & "WHERE M_ID=" & strMID
set frs = my_conn.execute(strsql)


I double checked all the DB fields, they are all spelled correctly...

----------------
Da_Stimulator
Need a Mod?
My Snitz Test Center


Edited by - da_stimulator on 04 March 2001 13:00:00

Doug G
Support Moderator

USA
6493 Posts

Posted - 04 March 2001 :  13:34:55  Show Profile
Remove the comma after M_DOWNLOAD

======
Doug G
======
Go to Top of Page

Da_Stimulator
DEV Team Forum Moderator

USA
3373 Posts

Posted - 04 March 2001 :  13:39:50  Show Profile  Send Da_Stimulator an AOL message  Send Da_Stimulator a Yahoo! Message
see, i knew it :) something stupid... thx Doug

----------------
Da_Stimulator
Need a Mod?
My Snitz Test Center
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.19 seconds. Powered By: Snitz Forums 2000 Version 3.4.07