quote:

---

Frankie, here are the admin files I have re-done for you. Basically, I took out the frames, uses tables instead. Added inc_top and the admin navigation folders to the top of the files. Included the admin check on each admin page, so that no one can type in the url of the admin page without signing in as admin first. I also took the files out of the admin folder, put them in the forum folder and prefixed the names with "admin_listings_" at the beginning of each admin file. I also commented out the many connection strings that you had open.

http://www.dsilvera.com/forum/mods/admin_listings_mod.zip

Any fixes you made to the admin files since you asked me to fix up them up frankie you will have to fix it in these files again. And to access these files you will have to put a link to "admin_listings_main.asp" from your "admin_home.asp" file.

It's mostly cosmetic changes I did. If you have any questions let me know.

Note: This file is for Frankie. This is not an update to his mod.

*----*----*----*----*----*----*----*----*
"Even when you feel you have nothing left,
You still have prayer--And that's enough."
*----*----*----*----*----*----*----*----*

---

Davio,

Thanks a ton for the updates to this kewl mod, especially the security check for admin. Have you thought about adding a option for adding pictures(url) to each category? I have seen many of these type of listing apps having pictures next to each category. This creates a nice visual effect. I was thinking of doing this manual, but unfortunately I suck with tables. Is it possible for you to give me a sample on how I would change the tables to add a picture manually before a category?

I can't believe I don't know how to set this up, I will try though

Any suggestions appreciated...

TIA

------------------
"keeping it real"

Edited by - KXS on 13 February 2001 06:12:39

quote:

---

OK, I fixed the top two, but now I am left with this...

CREATE TABLE LINK2(ID int IDENTITY (1, 1) NOT NULL , NAME VARCHAR(100), URL VARCHAR(255), KEYWORD MEMO, DESCRIPTION MEMO, EMAIL VARCHAR(100), POSTDATE VARCHAR(100), HIT INT DEFAULT 0, CATEGORY VARCHAR(50), PARENTID VARCHAR(50), SHOW BIT, BADLINK BIT)
-2147217900 | [Microsoft][ODBC SQL Server Driver][SQL Server]Column or parameter #4: Cannot find data type MEMO

Fatwillie's Forum

---

quote:

---

quote:

---

OK, I fixed the top two, but now I am left with this...

CREATE TABLE LINK2(ID int IDENTITY (1, 1) NOT NULL , NAME VARCHAR(100), URL VARCHAR(255), KEYWORD MEMO, DESCRIPTION MEMO, EMAIL VARCHAR(100), POSTDATE VARCHAR(100), HIT INT DEFAULT 0, CATEGORY VARCHAR(50), PARENTID VARCHAR(50), SHOW BIT, BADLINK BIT)
-2147217900 | [Microsoft][ODBC SQL Server Driver][SQL Server]Column or parameter #4: Cannot find data type MEMO

Fatwillie's Forum

---

fatwillie (or anyone who knows),

How did you correct the syntax errors???

Thanks.

Richard Hay
Webmaster/Forum Admin
http://AnotherWin95.com
http://AnotherWin95.com/forum
http://AnotherWin95.com/cowboys/

Edited by - anotherwin95 on 13 February 2001 07:58:48

---

anotherwin95,

Both of those fixes are posted up above in this page! For the 'lastdate' error i don't seem to encounter it, could you give me more info on how that happened?

fatwillie,

Try to delete all the fields and tables associated with this mod from the your DB and then run listings_setup.asp file one more time (that should fix it)

Intrepidone,

I do know the fix to your error, but I'm really tight on time to try fixing it (test week!). All you have to do if you encounter this code with rs("cat") field in it, like this:

<a href="showsub.asp?CatID=<%=rs("id")%>&cat=<%=rs("cat")%>"><%=rs("cat")%> </a>

change it to this:

<a href="showsub.asp?CatID=<%=rs("id")%>&cat=<%= ChkString(rs("cat"), "urlpath")%>"><%= ChkString(rs("cat"), "display")%> </a>

If you encounter this code set with rssubcat("subcatname") in it, like this:

<a href="showlink.asp?CatID=<%=rssubcat("subcatID")%>&parentID=<%=rs("id")%>&parentname=<%=rs("cat")%>&Subname=<%=rssubcat("Subcatname")%>"><%=rssubcat("subcatname")%></a>

change it to this:

<a href="showlink.asp?CatID=<%=rssubcat("subcatID")%>&parentID=<%=rs("id")%>&parentname=<%= ChkString(rs("cat"), "urlpath")%>&Subname=<%= ChkString(rssubcat("Subcatname"), "urlpath")%>"><%= ChkString(rssubcat("subcatname"), "display")%></a>

I'll try to update the files as soon as I can.

Thanks to everyone for their concerns and god bless
ô¿~




Edited by - frankie on 13 February 2001 11:49:09