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