Hi guys,

I got an error message when I was doing a keyword search in my BBS system with the keyword: Open C's. If I only use "Open C" without "'s", it would work.

This is the error message:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 's'.
/forum/forums.asp, line 1661.

The data type of the field is text. Below is the code with line 1661:
----------------------------------------------------------------
if level1_Disc_Topics_sql <> "" then
    cmd.CommandText = level1_Disc_Topics_sql
    rs.Filter = ""
    if ForumId <> "" then rs.Filter = "ForumId = " & to_sql(ForumId,"number")
    rs.CursorLocation = 3
    rs.CacheSize = 5
    rs.Open cmd'Line 1661
        if not rs.EOF then
            rs.MoveFirst
            rs.PageSize = 15
            max_count = cInt(rs.PageCount)
            num_recs = rs.RecordCount
            rs.AbsolutePage = page_no
            results = true
            ':: inherit page params for append on grid links
            for each tmp in request.querystring
                if tmp <> "page_no" AND tmp <> "sortby" then
                request_string = request_string & tmp & "=" & request.querystring(tmp) & "&"
                end if
            next
    else
        results = false
        rs.Close
    end if
else
    results = false
end if
rec_count = 0

I just want to add that whenever I use an apostrophe in the search field, I got a syntax error message.

Cinderella

Hey Cinderella,

Have you tried replacing the apostrophes with two apostrophes e.g. "Open C's" to "Open C''s".

HTH,

Chris

Hi Cinderella,

As Chris suggested, use Replace function to replace all single quotes with 2 single quotes. and use that in your search condition.

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection