---
title: "Finns inte detta i MySQL"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/134076-finns-inte-detta-i-mysql"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "WebbisNet"
published: "2005-09-10T21:41:16.000Z"
updated: "2005-09-11T12:00:17.000Z"
replies: 19
views: 1003
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/databaser-sql/134076-finns-inte-detta-i-mysql"
---

# Finns inte detta i MySQL

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

Varför får jag
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 '()) and day(persnr) = day(date())' at line 1 

/default.asp, line 12 

med denna rad
Set bday=objConn.Execute("Select \* From tblUsers where month(persnr) = month(date()) and day(persnr) = day(date())")

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

## #2 — ampy, 2005-09-10T22:21Z

Prova detta:

```
Set bday=objConn.Execute("Select * From tblUsers where (extract(month from persnr) = '"&month(date())&"') AND (extract(day from persnr) = '"&day(date())&"')")
```

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

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

verkar fungera, tack

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

## #4 — WebbisNet, 2005-09-10T22:30Z

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/1670606

## #5 — ampy, 2005-09-10T22:33Z

Varför har du specifierat att hämta vissa kolumner när du har en asterix på slutet som hämtar alla kolumner?

Rekommenderar att du tar bort asterixen samt kommat precis innan det och anger de kolumner du vill hämta.

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

## #6 — WebbisNet, 2005-09-10T23:01Z

I denna har jag en kolumn som heter agare men får ändå detta fel

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

Unknown column 'tblUsers_Galleri_kommentar.agare' in 'having clause' 

/Gallery/viewComment.asp, line 14 

Felet:
Set kommentarRS=objConn.Execute("SELECT DISTINCT username, vemKollar, anvandare, bild, rubrik, inlagd, tblUsers_Galleri_kommentar.Kommentar, nytt, Postad, tblUsers_Galleri_kommentar.bildID,picture "&\_
"FROM tblUsers INNER JOIN (tblUsers_Galleri_kommentar INNER JOIN tblUsers_Galleri ON (tblUsers_Galleri_kommentar.bildID = tblUsers_Galleri.bildID) AND (tblUsers_Galleri_kommentar.agare = tblUsers_Galleri.agare)) ON tblUsers.userID = tblUsers_Galleri_kommentar.vemKollar "&\_
"GROUP BY username, vemKollar, anvandare, bild, rubrik, inlagd, tblUsers_Galleri_kommentar.Kommentar, nytt, Postad, tblUsers_Galleri_kommentar.bildID, picture, anvandare, rubrik, bild, tblUsers_Galleri_kommentar.agare, rubrik "&\_
"HAVING tblUsers_Galleri_kommentar.bildID="& ID &" AND tblUsers_Galleri_kommentar.agare="& uid &" ORDER BY Postad DESC")

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

## #7 — ampy, 2005-09-10T23:04Z

Prova detta:

```
Set kommentarRS=objConn.Execute("SELECT DISTINCT username, vemKollar, anvandare, bild, rubrik, inlagd, tblUsers_Galleri_kommentar.Kommentar, nytt, Postad, tblUsers_Galleri_kommentar.bildID,picture, tblUsers_Galleri_kommentar.agare "&_
"FROM tblUsers INNER JOIN (tblUsers_Galleri_kommentar INNER JOIN tblUsers_Galleri ON (tblUsers_Galleri_kommentar.bildID = tblUsers_Galleri.bildID) AND (tblUsers_Galleri_kommentar.agare = tblUsers_Galleri.agare)) ON tblUsers.userID = tblUsers_Galleri_kommentar.vemKollar "&_
"GROUP BY username, vemKollar, anvandare, bild, rubrik, inlagd, tblUsers_Galleri_kommentar.Kommentar, nytt, Postad, tblUsers_Galleri_kommentar.bildID, picture, anvandare, rubrik, bild, tblUsers_Galleri_kommentar.agare, rubrik "&_
"HAVING tblUsers_Galleri_kommentar.bildID="& ID &" AND tblUsers_Galleri_kommentar.agare="& uid &" ORDER BY Postad DESC")
```

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

## #8 — WebbisNet, 2005-09-10T23:10Z

en liten fråga till :-)

\<!-- #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"%\>

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

/chat/preDefault.asp, line 2

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

## #9 — ampy, 2005-09-10T23:16Z

Ser inget fel i sql-frågan.
Kolla om Request.Cookies("UserID") verkligen innehåller något genom att skriva ut sql-frågan.

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

## #10 — WebbisNet, 2005-09-10T23:32Z

Går inte ens med Session("userId")

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

## #11 — ampy, 2005-09-10T23:34Z

Har du skrivit ut sql-frågan?

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

## #12 — WebbisNet, 2005-09-10T23:35Z

en annan sak jag undrar över är varför jag får rs.eof här

```
					<%Dim oConn ,strSQL ,bilder ,i, j ,Count ,post ,antalBilder ,Found 
                       Set oConn = server.CreateObject("ADODB.Connection") 
                        oConn.Open "DRIVER={MySQL ODBC 3.51 Driver};SERVER=db.webbisen.com;PORT=3306;DATABASE=wse29918;USER=wse29918;PASSWORD=1989x32p63;OPTION=3;" 
                        strSQL = "SELECT userID, picture, username, visaBild" & vbCrLf & _ 
                                 "FROM tblUsers" & vbCrLf & _ 
                                 "WHERE not picture='nopic.jpg' and visaBild=1" 
                        Set rs = oConn.Execute(strSQL) 
                        If rs.EOF Then 
                            Response.Write "Det finns inga bilder..." 
                        Else 
                            Response.Write "<table><tr><td align=""left"">" 
                            bilder = rs.GetRows() 
                            antalBilder = UBound(bilder, 2) 
                            Count = 7
                            If Count > antalBilder Then 
                                Count = antalBilder 
                            End If 
                            ReDim Shown(Count) 
                            Randomize 
                            For i = 1 To Count 
                                Do 
                                    Found = 0 
                                    post = Int(Rnd * antalBilder) +1
                                    For j = 1 To i - 1 
                                        If Shown(j) = post Then 
                                            Found = 1 
                                            Exit For 
                                        End If 
                                    Next 
                                Loop While Found 
                                Shown(i) = post 
                                Response.Write "<a href=""view-preview.asp?userID="&bilder(0, post)&"""><img style=""border-style:none;"" height=""100"" width=""90"" src=""/upload/images/users/" & bilder(1, post) & """ alt=""" & bilder(2, post) & """ /></a>&nbsp;" 
                            Next 
                            Response.Write "</td></tr></table>" 
                        End If 
                        rs.Close 
                        Set rs = Nothing 
                    %>
```

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

## #13 — ampy, 2005-09-10T23:44Z

```

					<%Dim oConn ,strSQL ,bilder ,i, j ,Count ,post ,antalBilder ,Found 
                       Set oConn = server.CreateObject("ADODB.Connection") 
                        oConn.Open "DRIVER={MySQL ODBC 3.51 Driver};SERVER=db.webbisen.com;PORT=3306;DATABASE=wse29918;U  SER=wse29918;PASSWORD=1989x32p63;OPTION=3;" 
                        strSQL = "SELECT userID, picture, username, visaBild" & _ 
                                 "FROM tblUsers" & _ 
                                 "WHERE not picture='nopic.jpg' and visaBild=1" 
                        Set rs = oConn.Execute(strSQL) 
                        If rs.EOF Then 
                            Response.Write "Det finns inga bilder..." 
                        Else 
                            Response.Write "<table><tr><td align=""left"">" 
                            bilder = rs.GetRows() 
                            antalBilder = UBound(bilder, 2) 
                            Count = 7
                            If Count > antalBilder Then 
                                Count = antalBilder 
                            End If 
                            ReDim Shown(Count) 
                            Randomize 
                            For i = 1 To Count 
                                Do 
                                    Found = 0 
                                    post = Int(Rnd * antalBilder) +1
                                    For j = 1 To i - 1 
                                        If Shown(j) = post Then 
                                            Found = 1 
                                            Exit For 
                                        End If 
                                    Next 
                                Loop While Found 
                                Shown(i) = post 
                                Response.Write "<a href=""view-preview.asp?userID="&bilder(0, post)&"""><img style=""border-style:none;"" height=""100"" width=""90"" src=""/upload/images/users/" & bilder(1, post) & """ alt=""" & bilder(2, post) & """ /></a>&nbsp;" 
                            Next 
                            Response.Write "</td></tr></table>" 
                        End If 
                        rs.Close 
                        Set rs = Nothing 
                    %>
```

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

## #14 — WebbisNet, 2005-09-10T23:45Z

var ett tag sen jag behövde det, kommer inte ihåg hur man skrev :-)

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

## #15 — WebbisNet, 2005-09-10T23:49Z

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 'not picture='nopic.jpg' and visaBild=1' at line 1 

/index.asp, line 335

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

## #16 — ampy, 2005-09-10T23:52Z

```

					<%Dim oConn ,strSQL ,bilder ,i, j ,Count ,post ,antalBilder ,Found 
                       Set oConn = server.CreateObject("ADODB.Connection") 
                        oConn.Open "DRIVER={MySQL ODBC 3.51 Driver};SERVER=db.webbisen.com;PORT=3306;DATABASE=wse29918;U    SER=wse29918;PASSWORD=1989x32p63;OPTION=3;" 
                        strSQL = "SELECT userID, picture, username, visaBild " & _ 
                                 "FROM tblUsers " & _ 
                                 "WHERE not picture='nopic.jpg' and visaBild=1" 
                        Set rs = oConn.Execute(strSQL) 
                        If rs.EOF Then 
                            Response.Write "Det finns inga bilder..." 
                        Else 
                            Response.Write "<table><tr><td align=""left"">" 
                            bilder = rs.GetRows() 
                            antalBilder = UBound(bilder, 2) 
                            Count = 7
                            If Count > antalBilder Then 
                                Count = antalBilder 
                            End If 
                            ReDim Shown(Count) 
                            Randomize 
                            For i = 1 To Count 
                                Do 
                                    Found = 0 
                                    post = Int(Rnd * antalBilder) +1
                                    For j = 1 To i - 1 
                                        If Shown(j) = post Then 
                                            Found = 1 
                                            Exit For 
                                        End If 
                                    Next 
                                Loop While Found 
                                Shown(i) = post 
                                Response.Write "<a href=""view-preview.asp?userID="&bilder(0, post)&"""><img style=""border-style:none;"" height=""100"" width=""90"" src=""/upload/images/users/" & bilder(1, post) & """ alt=""" & bilder(2, post) & """ /></a>&nbsp;" 
                            Next 
                            Response.Write "</td></tr></table>" 
                        End If 
                        rs.Close 
                        Set rs = Nothing 
                    %>
```

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

## #17 — WebbisNet, 2005-09-10T23:55Z

Det tar mig tillbaka till början igen med att rs är eof

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

## #18 — ampy, 2005-09-10T23:57Z

Då hittar helt enkelt sql-frågan inga poster. Är du säker på att det finns poster som uppfyller kraven?

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

## #19 — WebbisNet, 2005-09-11T00:08Z

Jag hade samma kod med access och den visade bilder, var bara småändringar som true buttes till 1 och db-kopplingen byttes ut

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

## #20 — emission, 2005-09-11T12:00Z

Men finns det verkligen rader i tblUsers där visaBild=1 och picture\<\>'nopic.jpg' ?

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

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/134076-finns-inte-detta-i-mysql