Retrieving value from querystring

cjcd · April 28th, 2004, 11:39 PM

I'm trying to display an object from my database, the object in question is specified by a number on the querystring pulled from a prior page, how can I do this?

Here's my code so far, whoch of course gives me an error that follows:

Exception Details: System.Data.OleDb.OleDbException: Data type mismatch in criteria expression.

Source Error:

Line 14: Dim objAdapter as new OledbDataAdapter(strSQL, objConnection)
Line 15:
Line 16: objAdapter.Fill(objDataSet, "Noticias")
Line 17:
Line 18: Dim objDataView as New DataView(objDataSet.Tables("Noticias"))

And here's my code:

<%@ Page Language="VB" ContentType="text/html" ResponseEncoding="iso-8859-1" debug="true" trace="true" %>

<%@ import Namespace="System.Data" %>

<%@ import Namespace="System.Data.Oledb" %>

<script runat="server">

    Sub Page_Load()

        Dim strConnection as String = ConfigurationSettings.AppSettings("myDSN")

        Dim strSQL as String = "SELECT * FROM Noticias WHERE newsID ='" & request.querystring("id") & "'"

        Dim objDataSet as new DataSet()

        Dim objConnection as New OledbConnection(strConnection)

        Dim objAdapter as new OledbDataAdapter(strSQL, objConnection)

        objAdapter.Fill(objDataSet, "Noticias")

        Dim objDataView as New DataView(objDataSet.Tables("Noticias"))

      DataGrid1.DataSource = objDataView

      DataGrid1.DataBind()

    End Sub

</script>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<title>Armytel - Noticias</title>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

</head>

<body>

<asp:Datalist id="datagrid1" runat="server">

<itemTemplate>

<table width="600" border="1" cellspacing="0" cellpadding="0">

  <tr>

    <td><%# Container.DataItem("txtTitle") %></td>

  </tr>

  <tr>

    <td>Por: | Fuente: (con link) </td>

  </tr>

  <tr>

    <td>Fecha</td>

  </tr>

  <tr>

    <td> </td>

  </tr>

  <tr>

    <td><%# Container.DataItem("txtSummary") %></td>

  </tr>

  <tr>

    <td> </td>

  </tr>

  <tr>

    <td>Noticia con foto alineada a la izquierda. </td>

  </tr>

</table>

</itemTemplate>

</asp:Datalist>

</body>

</html>

bmains · April 29th, 2004, 07:39 AM

Is newsID a character value in the database? If not, you have single quotes around the ID: newsID ='" & request.querystring("id") & "'", which need removed.