I am getting the following error message when I execute my asp page:

Microsoft OLE DB Provider for SQL Server (0x80040E14)
Incorrect syntax near '11'.
/expertcs/Forum/index.asp, line 27

This error is referencing my new recordset, here is the code:


<%
Dim rsPost__MMColParam
rsPost__MMColParam = "1"
If (Request("MM_EmptyValue") <> "") Then
rsPost__MMColParam = Request("MM_EmptyValue")
End If
%>
<%
Dim rsPost__MMColParam2
rsPost__MMColParam2 = "1/14/2007"
If (Now() - 7 <> "") Then
rsPost__MMColParam2 = Now() - 7
End If
%>
<%
Dim rsPost
Dim rsPost_numRows

Set rsPost = Server.CreateObject("ADODB.Recordset")
rsPost.ActiveConnection = MM_connExpertCS_STRING
rsPost.Source = "SELECT intPostID, txtPostTitle, dtePostDate, intPostBy, intCatID, memPostContent, txtNickName FROM dbo.tbl_Blog, dbo.tbl_Users WHERE bitPostShow = " + Replace(rsPost__MMColParam, "'", "''") + " AND dbo.tbl_Blog.intPostBy = dbo.tbl_Users.intUserID AND dtePostDate > " + Replace(rsPost__MMColParam2, "'", "''") + " ORDER BY dtePostDate DESC"
rsPost.CursorType = 0
rsPost.CursorLocation = 2
rsPost.LockType = 1
rsPost.Open() <-- This is the line 27 that the error message is referring too.

rsPost_numRows = 0
%>

Can anyone tell me why I am getting an error for my rsPost function?

Most probably, your SQL Command is incorrect, double check it.

-----------------------------------------------------------
I will only tell you how to do it, not do it for you.------------
Unless, of course, you want to hire me to do work for you.---
^^Thats my signature--------------------------------------
-----------------------------------------------------------
http://www.catb.org/~esr/faqs/smart-questions.html -------
^^Took that from planoie's profile--------------------------
-----------------------------------------------------------

Well, I'm a student trying to learn asp... So if you are willing to tell me how to troubleshoot this problem, I am all ears...

I am in the process of building a blog and I only want to display posting that are 7 days old. In my recordset, I created a variable called MMCalParam to hold a default date value "1/14/2007". I was taught that whenever you declare date variables in Sql, you're suppose to presede and procede it with # signs. When I did that, dreamweaver threw an error message stating "Invalid syntex '#'".

So now that I've omitted the # signs, I was able to create my recordset. But when I tried to view the web page live, I got the error message stated above... Do you have any idea on what I can do to resolve this?

Try Following code to open your recordset:

Set rsPost = Server.CreateObject("ADODB.Recordset")
sSQL = "SELECT intPostID, txtPostTitle, dtePostDate, intPostBy, intCatID, memPostContent, txtNickName FROM dbo.tbl_Blog, dbo.tbl_Users WHERE bitPostShow = " + Replace(rsPost__MMColParam, "'", "''") + " AND dbo.tbl_Blog.intPostBy = dbo.tbl_Users.intUserID AND dtePostDate > " + Replace(rsPost__MMColParam2, "'", "''") + " ORDER BY dtePostDate DESC"

rsPost.Open sSQL,MM_connExpertCS_STRING,0,2,1

hi,
replace with this, only your sql query.
still error, please send me the error back.
rsPost.Source = "SELECT intPostID, txtPostTitle, dtePostDate, intPostBy, intCatID, memPostContent, txtNickName FROM dbo.tbl_Blog, dbo.tbl_Users WHERE bitPostShow = '" Replace(rsPost__MMColParam, "'", "''") "' AND dbo.tbl_Blog.intPostBy = dbo.tbl_Users.intUserID AND dtePostDate > '" Replace(rsPost__MMColParam2, "'", "''") "' ORDER BY dtePostDate DESC"

surendran
(Anything is Possible)
http://ssuren.spaces.msn.com

Use JOIN in your SQL Query.

-Saurabh