---
title: "MySQL i ASP"
type: "forum-thread"
url: "https://www.webforum.nu/amne/asp/134075-mysql-i-asp"
topic: "ASP"
topic_url: "https://www.webforum.nu/amne/asp"
author: "WebbisNet"
published: "2005-09-10T21:23:17.000Z"
updated: "2005-09-10T23:34:51.000Z"
replies: 3
views: 407
page: 1
pages: 1
language: "sv-SE"
site: "webForum — webforum.nu"
rights: "Upphovsrätten till varje inlägg tillhör dess författare."
attribution: "Citera som: webForum, https://www.webforum.nu/amne/asp/134075-mysql-i-asp"
---

# MySQL i ASP

## #1 — WebbisNet, 2005-09-10T21:23Z

Kan nån se varför jag får
Microsoft OLE DB Provider for ODBC Drivers error '80040e14' 

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 '' at line 1 

/chat/preDefault.asp, line 2 

med denna kod
\<!-- #include virtual="include/dbconn.asp" --\>
\<%Set preChat=objConn.Execute("Update tblUsers SET Chattar = -1 WHERE userID= " & Request.Cookies("UserID") &"")
response.redirect "/chat/default.asp"%\>

Permalänk: https://www.webforum.nu/p/134075

## #2 — Thompa__85, 2005-09-10T21:57Z

> **WebbisNet skrev:**
>
> Kan nån se varför jag får
> Microsoft OLE DB Provider for ODBC Drivers error '80040e14' 
> 
> 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 '' at line 1 
> 
> /chat/preDefault.asp, line 2 
> 
> 
> med denna kod
> \<!-- #include virtual="include/dbconn.asp" --\>
> \<%Set preChat=objConn.Execute("Update tblUsers SET Chattar = -1 WHERE userID= " & Request.Cookies("UserID") &"")
> response.redirect "/chat/default.asp"%\>

Testa med:
\<!-- #include virtual="include/dbconn.asp" --\>
\<%Set preChat=objConn.Execute("Update tblUsers SET Chattar = Chattar -1 WHERE userID= " & Request.Cookies("UserID") &"")
response.redirect "/chat/default.asp"%\>

Permalänk: https://www.webforum.nu/p/1670598

## #3 — WebbisNet, 2005-09-10T22:03Z

Samma fel

Har även strul med
Set bildRS=objConn.Execute("SELECT clicks,tblUsers.userID, tblUsers.username, tblUsers.picture, \* FROM tblUsers LEFT JOIN tblUsers_Galleri ON tblUsers.userID = tblUsers_Galleri.agare WHERE tblUsers_Galleri.agare="&request("userID") &" ORDER BY tblUsers_Galleri.bildID DESC")

får felet
Microsoft OLE DB Provider for ODBC Drivers error '80040e14' 

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 '\* FROM tblUsers LEFT JOIN tblUsers_Galleri ON tblUsers.userID = 

/gallery/Default.asp, line 9

Permalänk: https://www.webforum.nu/p/1670599

## #4 — emission, 2005-09-10T23:34Z

Vad har du stjärnan (\*) till? Ta bort den och ange kolumnerna du behöver. Och request("userID") är väl inte tom?

Permalänk: https://www.webforum.nu/p/1670624

---

Tråden på webben: https://www.webforum.nu/amne/asp/134075-mysql-i-asp