Everything appears to work fine until posting. I get hthe following error. Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'FORUM_FILELISTER'. Make sure it exists and that its name is spelled correctly.
/forum/file_lister_upload.asp, line 84 Any ideas would help.
Got File Lister to work. I had to build the databases in access and loaded them in my database file. I read the code to see what the name of the colums should be.
My other problem with file lister is now, when I go to Force Administrator Approve All File in the Admin Section I still see the posted files. Everything else works with respect to this function but it won't hide the files prior to approval. ANY IDEAS????????
Man, I thought I had it whipped but I can't get the approval parts to work. The files will not hide until approval. The files when downloaded show up even though the admin part says that the files are not approved yet?????? Any Help!!!!!!!!!!!! The File_Lister_Setup.asp doesn't build the tables at all. I had to manually look at the files and make the tables to get this far.
Can you post that code and where you added it for anyone in the future who may experience the same problems?
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.”
Here is the code change to file_lister_view.asp that corrected my problem as stated above.
Find Existing file;
sqldtl = "select * from "& strMemberTablePrefix & "FILELISTER where Member_Id ="&trim(cint(tMID))&" and File_Cat = "&trim(cint(cid))
Replace that line with the following;
sqldtl = "select * from "& strMemberTablePrefix & "FILELISTER where Member_Id ="&trim(cint(tMID))&" and File_Status = 1 and File_Cat = "&trim(cint(cid))&" order by File_Name"