Web Wiz Support and Community Forums : MySQL: Search error https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 13 Apr 2026 18:00:35 +0000 Tue, 17 Jan 2006 12:49:57 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=17858 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[MySQL: Search error : The above wouldn&#039;t work as...]]> https://forums.webwiz.net/mysql-search-error_topic17858_post97524.html#97524 Author: WebWiz-Bruce
Subject: 17858
Posted: 17 January 2006 at 12:49pm

The above wouldn't work as a solution as it means that sub query (not support in mySQL 4.0) would not run, thus the page would never display a result.

What you need to do is use mySQL 4.1 or above which does support sub queries.
]]> Tue, 17 Jan 2006 12:49:57 +0000 https://forums.webwiz.net/mysql-search-error_topic17858_post97524.html#97524 <![CDATA[MySQL: Search error : find: &#039;Put in where cluases...]]> https://forums.webwiz.net/mysql-search-error_topic17858_post97013.html#97013 Author: longcong
Subject: 17858
Posted: 12 January 2006 at 5:26pm

Embarrassedfind:
    'Put in where cluases for the actual search
    strSQL = strSQL & _
    strSQLwhereDate & _
    strSQLwhereForum & _
    strSQLwhereMemSearch & _
    strSQLwhereKeywords
       
    'Check the permissions
    strSQL = strSQL & _
    "AND (" & strDbTable & "Topic.Forum_ID " & _
        "IN (" & _
            "SELECT " & strDbTable & "Permissions.Forum_ID " & _
            "FROM " & strDbTable & "Permissions " & strDBNoLock & " " & _
            "WHERE (" & strDbTable & "Permissions.Group_ID = " & intGroupID & " OR " & strDbTable & "Permissions.Author_ID = " & lngLoggedInUserID & ") " & _
                "AND " & strDbTable & "Permissions.View_Forum=" & strDBTrue & _
        ")" & _
    ") "


Ouchre:

    'Put in where cluases for the actual search
    strSQL = strSQL & _
    strSQLwhereDate & _
    strSQLwhereForum & _
    strSQLwhereMemSearch & _
    strSQLwhereKeywords
       
    'Check the permissions
    strSQL = strSQL & _
    "AND (" & strDbTable & "Topic.Forum_ID " & _
        "IN ('" & _
            "SELECT " & strDbTable & "Permissions.Forum_ID " & _
            "FROM " & strDbTable & "Permissions " & strDBNoLock & " " & _
            "WHERE (" & strDbTable & "Permissions.Group_ID = " & intGroupID & " OR " & strDbTable & "Permissions.Author_ID = " & lngLoggedInUserID & ") " & _
                "AND " & strDbTable & "Permissions.View_Forum=" & strDBTrue & _
        "')" & _
    ") "

]]> Thu, 12 Jan 2006 17:26:13 +0000 https://forums.webwiz.net/mysql-search-error_topic17858_post97013.html#97013 <![CDATA[MySQL: Search error : Talking about weather, I&#039;m...]]> https://forums.webwiz.net/mysql-search-error_topic17858_post96998.html#96998 Author: conxion
Subject: 17858
Posted: 12 January 2006 at 2:57pm

Talking about weather, I'm so lucky that living in a tropic country line mine. My colleagues from UK also enjoy staying here in the warm weather with beautiful sunshine. Have you ever thought about living and working in an SouthEastAsia country?]]> Thu, 12 Jan 2006 14:57:02 +0000 https://forums.webwiz.net/mysql-search-error_topic17858_post96998.html#96998 <![CDATA[MySQL: Search error : Yeah that brings back memoriesI...]]> https://forums.webwiz.net/mysql-search-error_topic17858_post96996.html#96996 Author: Mikey
Subject: 17858
Posted: 12 January 2006 at 2:36pm

Yeah that brings back memories LOL
I shall be purchasing a link/Ad removal key in the next few months, so maybe a little more heating for ya lol Wink


Edited by Mikey - 12 January 2006 at 2:39pm]]> Thu, 12 Jan 2006 14:36:09 +0000 https://forums.webwiz.net/mysql-search-error_topic17858_post96996.html#96996 <![CDATA[MySQL: Search error : Thats better than me, I have an...]]> https://forums.webwiz.net/mysql-search-error_topic17858_post96989.html#96989 Author: WebWiz-Bruce
Subject: 17858
Posted: 12 January 2006 at 1:44pm

Thats better than me, I have an office with no working lights and only 1 working plug, that I'm running everything from, including, heater, stereo, PC, monitor, printer, phones, router, etc.

I know when it's a could day, I have to keep my coat on even with the heater on full, I usually give up and go home when my fingers get so cold and numb, I can no-longer feel the keys on teh keyboard.Disapprove
]]> Thu, 12 Jan 2006 13:44:27 +0000 https://forums.webwiz.net/mysql-search-error_topic17858_post96989.html#96989 <![CDATA[MySQL: Search error : To be honest with you i&#039;m...]]> https://forums.webwiz.net/mysql-search-error_topic17858_post96984.html#96984 Author: Mikey
Subject: 17858
Posted: 12 January 2006 at 1:03pm

To be honest with you i'm sitting next to a radiator and just looking out the window, the people do look cold outside in their scarfs and gloves so i don't think i risk going outside just yet, Altho unfortunatley i work outside so got no choice really Wacko]]> Thu, 12 Jan 2006 13:03:59 +0000 https://forums.webwiz.net/mysql-search-error_topic17858_post96984.html#96984 <![CDATA[MySQL: Search error : I thought it was quite mild today,...]]> https://forums.webwiz.net/mysql-search-error_topic17858_post96970.html#96970 Author: WebWiz-Bruce
Subject: 17858
Posted: 12 January 2006 at 12:08pm

I thought it was quite mild today, although I am about 100 miles from London.]]> Thu, 12 Jan 2006 12:08:14 +0000 https://forums.webwiz.net/mysql-search-error_topic17858_post96970.html#96970 <![CDATA[MySQL: Search error : Thats why we&#039;re here dude,...]]> https://forums.webwiz.net/mysql-search-error_topic17858_post96955.html#96955 Author: Mikey
Subject: 17858
Posted: 12 January 2006 at 11:30am

Thats why we're here dude, not like there's much else i can do in this freezing London weather lol LOL]]> Thu, 12 Jan 2006 11:30:54 +0000 https://forums.webwiz.net/mysql-search-error_topic17858_post96955.html#96955 <![CDATA[MySQL: Search error : Thanks again, another one to look...]]> https://forums.webwiz.net/mysql-search-error_topic17858_post96951.html#96951 Author: WebWiz-Bruce
Subject: 17858
Posted: 12 January 2006 at 11:12am

Thanks again, another one to look into.

I did do quite a bit of testing with the mySQL version, but not as much as I would have liked to.
]]> Thu, 12 Jan 2006 11:12:48 +0000 https://forums.webwiz.net/mysql-search-error_topic17858_post96951.html#96951 <![CDATA[MySQL: Search error : MySQL version, Logged in as admin,...]]> https://forums.webwiz.net/mysql-search-error_topic17858_post96906.html#96906 Author: Mikey
Subject: 17858
Posted: 11 January 2006 at 11:03pm

MySQL version, Logged in as admin, On submital of search for the term 'Test' (a term i know is in my test posts) searching all forums using 'Match all words'...

Originally posted by Error Error wrote:


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

[MySQL][ODBC 3.51Driver][mysqld-4.0.21-debug]You have an error in your SQL syntax. Checkthe manual that corresponds to your MySQL server version for the rightsyntax to use near 'SELECT tblPermissions.Forum_ID FROM tblPermissionsWHERE (tblP

/wwwv8_test/search_process.asp, line 610

Big smile


]]> Wed, 11 Jan 2006 23:03:31 +0000 https://forums.webwiz.net/mysql-search-error_topic17858_post96906.html#96906