02. december 2003 - 21:33Der er
25 kommentarer og 1 løsning
Microsoft JET Database Engine error '80040e14'
Hej
jeg håber at der er nogen der kan hjælpe mig jeg får denne fejl Microsoft JET Database Engine error '80040e14'
Syntax error in string in query expression 'kategori = 1''.
/dataentry/shop/Default.asp, line 58
strengen til den er denne.....
<% Dim varer__MMColParam varer__MMColParam = "1" If (Request.QueryString("kategori") <> "") Then varer__MMColParam = Request.QueryString("kategori") End If %> <% Dim varer Dim varer_numRows
Set varer = Server.CreateObject("ADODB.Recordset") varer.ActiveConnection = MM_db_STRING varer.Source = "SELECT * FROM varer WHERE kategori = " + Replace(varer__MMColParam, "'", "''") + "'" 'varer.Source = "SELECT * FROM varer"' WHERE kategori = " + Replace(varer__MMColParam, "'", "''") + "" varer.CursorType = 0 varer.CursorLocation = 2 varer.LockType = 1 varer.Open()
varer_numRows = 0 %>
den skal gå ind i DB og ind i tabellen varer kollonen kategori og lave et ud træk alt efter hvilken kategori man ønsker
hvis kategori er defineret som en tal kolonne skal der ikke ' omkring så skal den linje være: varer.Source = "SELECT * FROM varer WHERE kategori = " + Replace(varer__MMColParam, "'", "")
her er det hele <%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> <!--#include file="inc_CharonCart.asp" --> <!--#include file="Connections/db.asp" --> <% Dim aktivbruger__MMColParam aktivbruger__MMColParam = "1" If (Session("MM_Username") <> "") Then aktivbruger__MMColParam = Session("MM_Username") End If %> <% Dim aktivbruger Dim aktivbruger_numRows
kategorier_numRows = 0 %> <% Dim varer__MMColParam varer__MMColParam = "1" If (Request.QueryString("kategorier") <> "") Then varer__MMColParam = Request.QueryString("kategorier") End If %> <% Dim varer Dim varer_numRows
Set varer = Server.CreateObject("ADODB.Recordset") varer.ActiveConnection = MM_db_STRING varer.Source = "SELECT * FROM varer WHERE kategori ='" + Replace(varer__MMColParam, "'", "''") + "'" 'varer.Source = "SELECT * FROM varer"' WHERE kategori = " + Replace(varer__MMColParam, "'", "''") + "" varer.CursorType = 0 varer.CursorLocation = 2 varer.LockType = 1 varer.Open()
varer_numRows = 0 %> <% Dim Repeat1__numRows Dim Repeat1__index
Repeat1__numRows = -1 Repeat1__index = 0 kategorier_numRows = kategorier_numRows + Repeat1__numRows %> <% Dim Repeat2__numRows Dim Repeat2__index
<% ' *** Go To Record and Move To Record: create strings for maintaining URL and Form parameters
Dim MM_keepNone Dim MM_keepURL Dim MM_keepForm Dim MM_keepBoth
Dim MM_removeList Dim MM_item Dim MM_nextItem
' create the list of parameters which should not be maintained MM_removeList = "&index=" If (MM_paramName <> "") Then MM_removeList = MM_removeList & "&" & MM_paramName & "=" End If
' add the URL parameters to the MM_keepURL string For Each MM_item In Request.QueryString MM_nextItem = "&" & MM_item & "=" If (InStr(1,MM_removeList,MM_nextItem,1) = 0) Then MM_keepURL = MM_keepURL & MM_nextItem & Server.URLencode(Request.QueryString(MM_item)) End If Next
' add the Form variables to the MM_keepForm string For Each MM_item In Request.Form MM_nextItem = "&" & MM_item & "=" If (InStr(1,MM_removeList,MM_nextItem,1) = 0) Then MM_keepForm = MM_keepForm & MM_nextItem & Server.URLencode(Request.Form(MM_item)) End If Next
' create the Form + URL string and remove the intial '&' from each of the strings MM_keepBoth = MM_keepURL & MM_keepForm If (MM_keepBoth <> "") Then MM_keepBoth = Right(MM_keepBoth, Len(MM_keepBoth) - 1) End If If (MM_keepURL <> "") Then MM_keepURL = Right(MM_keepURL, Len(MM_keepURL) - 1) End If If (MM_keepForm <> "") Then MM_keepForm = Right(MM_keepForm, Len(MM_keepForm) - 1) End If
' a utility function used for adding additional parameters to these strings Function MM_joinChar(firstItem) If (firstItem <> "") Then MM_joinChar = "&" Else MM_joinChar = "" End If End Function %>
Disse links hvor kategorien vælges se sådan her ud: <li><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><A HREF="default.asp?kategori=1">Webdesign</A></font></li>
Åltså er det default.asp som skal havde koden til at vise de vare som er for den valgte kategori.
<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> <!--#include file="inc_CharonCart.asp" --> <!--#include file="Connections/db.asp" --> <% Dim aktivbruger__MMColParam aktivbruger__MMColParam = "1" If (Session("MM_Username") <> "") Then aktivbruger__MMColParam = Session("MM_Username") End If %> <% Dim aktivbruger Dim aktivbruger_numRows
kategorier_numRows = 0 %> <% Dim varer__MMColParam varer__MMColParam = "1" If (Request.QueryString("kategori") <> "") Then varer__MMColParam = Request.QueryString("kategori") End If %> <% Dim varer Dim varer_numRows
Set varer = Server.CreateObject("ADODB.Recordset") varer.ActiveConnection = MM_db_STRING varer.Source = "SELECT * FROM varer WHERE kategori ='" & Replace(varer__MMColParam, "'", "''") & "'" 'varer.Source = "SELECT * FROM varer"' WHERE kategori = " + Replace(varer__MMColParam, "'", "''") + "" varer.CursorType = 0 varer.CursorLocation = 2 varer.LockType = 1 varer.Open()
varer_numRows = 10 %> <% Dim Repeat1__numRows Dim Repeat1__index
Repeat1__numRows = -1 Repeat1__index = 0 kategorier_numRows = kategorier_numRows + Repeat1__numRows %> <% Dim Repeat2__numRows Dim Repeat2__index
<% ' *** Go To Record and Move To Record: create strings for maintaining URL and Form parameters
Dim MM_keepNone Dim MM_keepURL Dim MM_keepForm Dim MM_keepBoth
Dim MM_removeList Dim MM_item Dim MM_nextItem
' create the list of parameters which should not be maintained MM_removeList = "&index=" If (MM_paramName <> "") Then MM_removeList = MM_removeList & "&" & MM_paramName & "=" End If
' add the URL parameters to the MM_keepURL string For Each MM_item In Request.QueryString MM_nextItem = "&" & MM_item & "=" If (InStr(1,MM_removeList,MM_nextItem,1) = 0) Then MM_keepURL = MM_keepURL & MM_nextItem & Server.URLencode(Request.QueryString(MM_item)) End If Next
' add the Form variables to the MM_keepForm string For Each MM_item In Request.Form MM_nextItem = "&" & MM_item & "=" If (InStr(1,MM_removeList,MM_nextItem,1) = 0) Then MM_keepForm = MM_keepForm & MM_nextItem & Server.URLencode(Request.Form(MM_item)) End If Next
' create the Form + URL string and remove the intial '&' from each of the strings MM_keepBoth = MM_keepURL & MM_keepForm If (MM_keepBoth <> "") Then MM_keepBoth = Right(MM_keepBoth, Len(MM_keepBoth) - 1) End If If (MM_keepURL <> "") Then MM_keepURL = Right(MM_keepURL, Len(MM_keepURL) - 1) End If If (MM_keepForm <> "") Then MM_keepForm = Right(MM_keepForm, Len(MM_keepForm) - 1) End If
' a utility function used for adding additional parameters to these strings Function MM_joinChar(firstItem) If (firstItem <> "") Then MM_joinChar = "&" Else MM_joinChar = "" End If End Function %> <html> <head> <title>Jørgen's Hæfteshop</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> </head>
altså kolonnen kategori er tekst? Det underlige var at den skrive -1 som antal, det tyder på der er noget galt. At databasen er tom eller kolonnen kategori indeholder noget andet end det forvendtet.
Synes godt om
Ny brugerNybegynder
Din løsning...
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.