if Err_Msg = "" then
		'## Forum_SQL - Do DB Update
		strSql = "INSERT INTO " & strTablePrefix & "FORUM "
		strSql = strSql & "(CAT_ID"
		if strPrivateForums = "1" then
			strSql = strSql & ", F_PRIVATEFORUMS"
		end if
		strSql = strSql & ", F_LAST_POST"
		strSql = strSql & ", F_LAST_POST_AUTHOR"
		strSql = strSql & ", F_SUBJECT"
		strSql = strSql & ", F_URL"
		strSql = strSql & ", F_DESCRIPTION"
		strSql = strSql & ", F_TYPE"
		strSql = strSql & ", F_L_ARCHIVE "
		strSql = strSql & ", F_ARCHIVE_SCHED "
		strSql = strSql & ", F_L_DELETE "
		strSql = strSql & ", F_DELETE_SCHED "
	        strSql = strSql & ", F_SUBSCRIPTION, F_MODERATION"
		strSql = strSql & ", F_ORDER "
		strSql = strSql & ")  VALUES ("
		strSql = strSql & Cat_ID
		if strPrivateForums = "1" then
			strSql = strSql & ", " & ChkString(Request.Form("AuthType"), "SQLString") & ""
		end if
		strSql = strSql & ", " & "'" & DateToStr(strForumTimeAdjust) & "'"
		strSql = strSql & ", " & getMemberID(strDBNTUserName) & " "
		strSql = strSql & ", " & "'" & txtSubject & "'"
		strSql = strSql & ", " & "'" & txtAddress & "'"
		strSql = strSql & ", " & "'" & txtMessage & "'"
		strSql = strSql & ", " & Request.Form("Type")
	        strSql = strSql & ", ''"
	        strSql = strSql & ", 30"
	        strSql = strSql & ", ''"
	        strSql = strSql & ", 365"
	        ' DEM --> Added 0's for the subscription and moderation fields since they are ignored for URLS
	        strSql = strSql & ", 0, 0"
	        strSql = strSql & ", 1"
	        strSql = strSql & ", 0"
		strSql = strSql & ") "

quote:

---

ok thnx. but now i have an new error

Microsoft JET Database Engine fout '80040e14'

De instructie INSERT INTO bevat de volgende onbekende veldnaam: F_L_DELETE_SCHED. Zorg ervoor dat u de naam correct hebt getypt en probeer het nogmaals.

/forumv33/post_info.asp, regel 1001

(the instruction INSERT INTO has an unknown field name:........)

---

quote:

---

yessssssss it works THANX! again Pierre

---

You're welcome
Make sure you also read: http://forum.snitz.com/forum/topic.asp?TOPIC_ID=13740

Pierre
Join a Snitz Mailinglist

quote:

---

I have followed the instructions above and got it to work - but now I get this when I try to delete an URL:

Microsoft JET Database Engine error '80040e10'

No value given for one or more required parameters.

/3.3/pop_delete.asp, line 332

---