Syntax error on some IIS

saban · May 16th, 2007, 03:47 AM

Does anyone has any idea what could be wrong

I have an ASP page, which runs OK on some IIS but on other IIS(for ex. my comp) IE throws an error "Syntax error" in SQL statement.

I would understand that it would not work on any IIS but strange thing is that it works on some and on some it gives me this error.

Any ideas what should I do??
Or can soemone explain me how can I debug this page(default.asp) with some debugger. I tried to debug it but the problem is I cant use any of this damn debuggers:(( (nothing is geting debugged default.asp is just opened in debuger and I can see the source but that is it nothing more)

Thnx for replies

planoie · May 16th, 2007, 07:23 AM

Does the error give you a line number? And if so, can you post the relevant code?

-Peter

saban · May 16th, 2007, 09:01 AM

line 41 gives an error error in date expression

Code:

Set rsObjave = Server.CreateObject("ADODB.Recordset")
rsObjave.ActiveConnection = MM_connBlog_STRING
rsObjave.Source = "SELECT dtePostDate, intCatID, intPostBy, intPostID, memPostContent, txtPostTitle, txtNickName, ST_knjig  FROM tblBlog, tblUsers  WHERE bitPostShow = " + Replace(rsObjave__MMColParam, "'", "''") + " And tblBLog.intPostBy = tblUsers.intUserID AND dtePostDate > #" + Replace(rsObjave__MMColParam2, "'", "''") + "# AND intCatID LIKE  '" + Replace(rsObjave__MMColParam3, "'", "''") + "' AND txtPostTitle LIKE '%" + Replace(rsObjave__MMColParam4, "'", "''") + "%'  ORDER BY dtePostDate DESC"
rsObjave.CursorType = 0
rsObjave.CursorLocation = 2
rsObjave.LockType = 1

I think it is somwhere here
Database is access

saban · May 16th, 2007, 09:06 AM

But the strange thing is it works somwhere but on my personal pc it does not
Does it maybe have something to do with regional settings of IIS or WinXP

dparsons · May 16th, 2007, 09:11 AM

Ok. IE isn't throwing the error, the ASP Interpeter is throwing it. Secondly, this has nothing (or shouldn't) to do with your environment, it has to do with your SQL Statement. Since you have said that it works sometimes and other times it does not, I can only assume you are passing in a value to the Sql statement that causes it to bomb. Since you can't step into the code, read this articl about handling errors and just have your system send you an email with relevant data, e.g. what your sql statement looked like at the time of failure.

http://www.4guysfromrolla.com/webtech/060399-1.shtml

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

planoie · May 16th, 2007, 10:42 PM

Also, please post question in the appropriate forum. (This is ASP.NET, not [Classic] ASP).

-Peter

saban · May 19th, 2007, 06:07 AM

ok planoie thnx for info and for your help
Will post it in right section next time