Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MySql
 Microsoft OLE DB Provider for ODBC Drivers error
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

top
Junior Member

150 Posts

Posted - 25 August 2010 :  12:02:01  Show Profile
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]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 'LIMIT 1 aID, aHits, aTable, aTitle FROM advertising WHERE aValid=1 AND ((aRoleB' at line 1
database-inc.asp, line 273

thanks for your help in advance

Edited by - top on 25 August 2010 12:43:42

HuwR
Forum Admin

United Kingdom
20577 Posts

Posted - 25 August 2010 :  18:30:51  Show Profile  Visit HuwR's Homepage
this forum is for asking MySQL related questions about Snitz, what has this to do with Snitz? perhaps you should try a MySQL site

MVC .net dev/test site | MVC .net running on Raspberry Pi
Go to Top of Page

AnonJr
Moderator

United States
5765 Posts

Posted - 25 August 2010 :  21:14:49  Show Profile  Visit AnonJr's Homepage
Looks like a problem with the SQL string you're creating, but as HuwR said - this site is for MySQL questions related to Snitz and their MODs. Unless this is a MOD (posted or personal), you may want to try somewhere like http://stackoverflow.com/ or another Q&A site.
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20577 Posts

Posted - 26 August 2010 :  03:04:01  Show Profile  Visit HuwR's Homepage
I may be wrong, but shouldn't the LIMIT bit be at the end of a query in mysql

eg

select * from table where x=y LIMIT 1

pretty sure the MySQL help documentation would be your first port of call

MVC .net dev/test site | MVC .net running on Raspberry Pi
Go to Top of Page

AnonJr
Moderator

United States
5765 Posts

Posted - 26 August 2010 :  08:39:38  Show Profile  Visit AnonJr's Homepage
quote:
Originally posted by HuwR

I may be wrong, but shouldn't the LIMIT bit be at the end of a query in mysql

eg

select * from table where x=y LIMIT 1

pretty sure the MySQL help documentation would be your first port of call


Yeh, its TOP for the SQL Server crowd that goes in front of the query.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000 Version 3.4.07