quote:

---

It doesn't matter. .NET and traditional ASP will be able to run on the same server. This is something that's been stated for a long time in regards to .NET. Companies have spent a lot of time and money building applications and sites in traditional ASP and it would involve a lot of resources to get them converted to .NET. When .NET is released for production, it doesn't mean that traditional ASP will no longer function. Over time it may be phased out, but it'll probably be around for a couple of years. Case in point, how many companies are still using SQL Server 6.5, IIS 3.0, Windows 95, Windows 3.1, etc...

---

Hi

I stand corrected. I agree with you that there will still be plenty of existing code out there that will still need to be maintained in their present mode.

I tend to also have the opinion that the "spaghetti" interweaving of codes is not good for maintenance (apologies in advance). Imagine a missing quote or > here or there? ASP in its original form (likewise for JSP, PHP, Coldfusion) have all their little nuances.

It's up to the development community to improve on the legacies we have created for ourselves.

Tiki

quote:

---

I still don't see the light concerning the Syntax error, missing operator. I did every modification to the script as DocEVL described above, but it still doesn't work. Could you or anyone who has modified the file succesfully and is using Access2000, post the file with modifications?

Thank you in advance!

EQ

---

quote:

---

sorry but this chanches the error to:
<HR>
Microsoft JET Database Engine error '80040e10'

No value given for one or more required parameters.

/forumnl/content.asp, line 252
<HR>
on this line:
rs.open strSql, my_Conn, 3

pleaseeeeeeeeeeeee heeeeeeeeelp

---

quote:

---

i have tried all optieons. but nothing chage this error.

we are using avatars so i have set the line from the avatars on?? i also have tried a clean version of snitz (without mods) but it givs me the same error

---

	if strContentType = "" then ' use my defaults
		'strContentType = 1
	end if
		
	if strContentID = "" then ' use my defaults
		'strContentID = 6
	end if
		
	if strTopicStatus = "" then ' use my defaults
		'strTopicStatus = 2
	end if
		
	if strDisplayMode = "" then ' use my defaults
		'strDisplayMode = 4
	end if
		
	if strDisplayOrder = "" then ' use my defaults
		'strDisplayOrder = 0
	end if
		
	if strTopicCount = "" then ' use my defaults
		'strTopicCount = 9
	end if
		
	if strMessageLength = "" then ' use my defaults
		'strMessageLength = 260
	end if
		
	if strSubjectLength = "" then ' use my defaults
		'strSubjectLength = 35
	end if
	
	if strOrnament = "" then ' use my defaults
		'strOrnament = 5
	end if	
	
	if strSpecial = "" then ' use my defaults
		'strSpecial = 0
	end if	

<!-- BODY STARTS HERE ------------------------------------------------------------------------->	
<% 
if blnAdminMode then
	mLev=1
else
	mLev=4
end if
%>

<%	if strContentType = "" or strContentID = "" or strTopicStatus = "" or strDisplayMode = "" or strDisplayOrder = "" or strTopicCount = "" or strMessageLength = "" or strSubjectLength = "" or strOrnament = "" or strSpecial = "" then
		Response.Write("Parameter Missing")
	else
		DisplayContent strContentType, strContentID, strTopicStatus, strDisplayMode, strDisplayOrder, strTopicCount, strMessageLength, strSubjectLength, strOrnament, strSpecial
			
		' DisplayContent(ContentType, ContentID, TopicStatus, DisplayMode, DisplayOrder, TopicCount, MessageLength, SubjectLength)
'
' descriptions of parameters here...
'		
		' //////////////////////////////////////////////////////////////////////////////////////////////

	end if
%>

Response.Write(strSQL)
Response.end