---
title: "SQL fel ?"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/52734-sql-fel"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "Pellefant"
published: "2002-09-09T22:12:16.000Z"
updated: "2002-09-09T22:22:18.000Z"
replies: 2
views: 177
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/52734-sql-fel"
---

# SQL fel ?

## #1 — Pellefant, 2002-09-09T22:12Z

I urlfältet: 
<http://www20.brinkster.com/kursbok/sok.asp?typ=saljes&val=Forfattare&ord=Prata>
dvs, sok.asp?typ=saljes&val=Forfattare&ord=Prata

SQLsatsen i koden(rad 67):
SQL="SELECT \* FROM annonser WHERE" & Request.QueryString("val") & "LIKE  '%" & Request.QueryString("ord") & "%' AND typ LIKE '" & Request.QueryString("typ") & "' ORDER BY " & Request.QueryString("val") &""

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

\[Microsoft\]\[ODBC Microsoft Access Driver\] Syntax error in FROM clause. 

/kursbok/sok.asp, line 67

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

## #2 — Viktor, 2002-09-09T22:17Z

Du har inget mellanrumm mellan WHERE och ", samma sak innan LIKE. Kan vara det :)

/Viktor

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

## #3 — Pellefant, 2002-09-09T22:22Z

JAPP! :)

Det var det, tack för hjälpen.

Pellefant

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

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/52734-sql-fel