| Author |
 Topic Search  Topic Options
|
Mikey 
Senior Member
1979
Joined: 06 October 2003
Location: United Kingdom
Status: Offline
Points: 839
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: MySQL: Search error
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'...
 Error wrote:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[MySQL][ODBC 3.51
Driver][mysqld-4.0.21-debug]You have an error in your SQL syntax. Check
the manual that corresponds to your MySQL server version for the right
syntax to use near 'SELECT tblPermissions.Forum_ID FROM tblPermissions
WHERE (tblP
/wwwv8_test/search_process.asp, line 610 |
|
|
Handyman man?
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
Mikey
Senior Member
1979
Joined: 06 October 2003
Location: United Kingdom
Status: Offline
Points: 839
|
Post Options
Thanks(0)
Quote Reply
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 
|
|
Handyman man?
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 12 January 2006 at 12:08pm |
|
I thought it was quite mild today, although I am about 100 miles from London.
|
|
|
|
Mikey
Senior Member
1979
Joined: 06 October 2003
Location: United Kingdom
Status: Offline
Points: 839
|
Post Options
Thanks(0)
Quote Reply
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 
|
|
Handyman man?
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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. 
|
|
|
|
Mikey
Senior Member
1979
Joined: 06 October 2003
Location: United Kingdom
Status: Offline
Points: 839
|
Post Options
Thanks(0)
Quote Reply
Posted: 12 January 2006 at 2:36pm |
Yeah that brings back memories I shall be purchasing a link/Ad removal key in the next few months, so maybe a little more heating for ya lol 
Edited by Mikey - 12 January 2006 at 2:39pm
|
|
Handyman man?
|
|
conxion
Newbie
Joined: 13 September 2005
Location: Vietnam
Status: Offline
Points: 16
|
Post Options
Thanks(0)
Quote Reply
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?
|
|
