Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server ASP
SQL Server ASP Discussions about ASP programming with Microsoft's SQL Server. For more ASP forums, see the ASP forum category.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server ASP section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old May 21st, 2007, 02:48 AM
Authorized User
Join Date: Jan 2006
Posts: 37
Thanks: 0
Thanked 0 Times in 0 Posts
Default Is there some ':, missing ???

Can someone plizz help me out and tells me wha tis wrong with this statement ???

I am lost (Online validators says it is an error in this statement, at work I get the desired results with no errors but at home on my IIS server it throws an error)

SELECT dtePostDate, intCatID, intPostBy, intPostID, memPostContent, txtPostTitle, txtNickName, st_knjig, imeslike  FROM tblBlog, tblUsers  WHERE bitPostShow = " + Replace(Recordset1__MMColParam, "'", "''") + " AND tblBLog.intPostBy = tblUsers.intUserID AND dtePostDate > #" + Replace(Recordset1__MMColParam2, "'", "''") + "# AND tblBLog.intCatID LIKE  '" + Replace(Recordset1__MMColParam3, "'", "''") + "' AND memPostContent LIKE '%" + Replace(Recordset1__MMColParam4, "'", "''") + "%'  ORDER BY dtePostDate DESC
Old May 28th, 2007, 06:32 AM
Friend of Wrox
Join Date: Jun 2003
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post

When you say it throws an error, What is the error that it throws? What database is that you use (ACCESS/SQL server)?

NOTE: It is better you break your code into multiple lines when posted here for better reading, than to scroll RIGHT and LEFT to strain the eyes. ;)

- Vijay G
Strive for Perfection

Similar Threads
Thread Thread Starter Forum Replies Last Post
What is missing? grstad SQL Language 11 March 6th, 2006 01:53 AM
MISSING TDs cleytonjordan Javascript How-To 3 July 29th, 2005 10:12 AM
Missing Code Alphonse BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7 1 July 10th, 2005 08:10 AM
what am i missing? m002864 Crystal Reports 0 July 6th, 2004 07:24 AM
Missing sp_Accounts_GetPermissionDetails Dennis0656 BOOK: ASP.NET Website Programming Problem-Design-Solution 3 May 10th, 2004 10:07 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.