asked on

Insert error

Hi

I have developed a web page in dreamweaver and am getting a error when trying to insert information. It is a access 2000 database. This is the error when I am running the page in explorer.

This is the insert statment....

<MM:Insert
runat="server"
CommandText='<%# "INSERT INTO Request(School, School_Priority, Date, Improvement, Rational, Estimated_Cost, Employee_Id) VALUES (?, ?, ?, ?, ?, ?, ?)" %>'
ConnectionString='<%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_STRING_connEnhancement") %>'
DatabaseType='<%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_DATABASETYPE_connEnhancement") %>'
Expression='<%# Request.Form("MM_insert") = "form1" %>'
CreateDataSet="false"
SuccessURL='<%# "request Added.aspx" %>'
Debug="true"

Please help, the error in explorer says System.Dat.OleDb.OleDbException:Syntax error in INSERT INTO statement

Thanks
Denise

ASKER CERTIFIED SOLUTION

YZlat

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

neicy62

ASKER

Hey there...

I tried that but not sure were to put statment in code. I did something to and now I am getting an error of
SystemData.OleDb.OleDbException.
Operation must use an updateable query.

Here is the code:

<%@ Page Language="VB" ContentType="text/html" ResponseEncoding="iso-8859-1" %>
<%@ Register TagPrefix="MM" Namespace="DreamweaverCtrls" Assembly="DreamweaverCtrls,version=1.0.0.0,publicKeyToken=836f606ede05d46a,culture=neutral" %>
<MM:Insert
runat="server"
CommandText='<%# "INSERT INTO Request (Employee_ID, Estimated_Cost, Improvement, Rational, Request_Date, School, School_Priority) VALUES (?, ?, ?, ?, ?, ?, ?)" %>'
ConnectionString='<%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_STRING_connEnhancement") %>'
DatabaseType='<%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_DATABASETYPE_connEnhancement") %>'
Expression='<%# Request.Form("MM_insert") = "form1" %>'
CreateDataSet="false"
SuccessURL='<%# "request Added.aspx" %>'
Debug="true"
><Parameters>
<Parameter Name="@Employee_ID" Value='<%# IIf((Request.Form("Employee_ID") <> Nothing), Request.Form("Employee_ID"), "") %>' Type="Integer" />
<Parameter Name="@Estimated_Cost" Value='<%# IIf((Request.Form("Estimated_Cost") <> Nothing), Request.Form("Estimated_Cost"), "") %>' Type="Currency" />
<Parameter Name="@Improvement" Value='<%# IIf((Request.Form("Improvement") <> Nothing), Request.Form("Improvement"), "") %>' Type="WChar" />
<Parameter Name="@Rational" Value='<%# IIf((Request.Form("Rational") <> Nothing), Request.Form("Rational"), "") %>' Type="WChar" />
<Parameter Name="@Request_Date" Value='<%# IIf((Request.Form("Date") <> Nothing), Request.Form("Date"), "") %>' Type="Date" />
<Parameter Name="@School" Value='<%# IIf((Request.Form("School") <> Nothing), Request.Form("School"), "") %>' Type="WChar" />
<Parameter Name="@School_Priority" Value='<%# IIf((Request.Form("School_Priority") <> Nothing), Request.Form("School_Priority"), "") %>' Type="Integer" />
</Parameters>
</MM:Insert>
<MM:DataSet
id="dsschool"
runat="Server"
IsStoredProcedure="false"
ConnectionString='<%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_STRING_connEnhancement") %>'
DatabaseType='<%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_DATABASETYPE_connEnhancement") %>'
CommandText='<%# "SELECT School_Name FROM Building" %>'
Debug="true"
>
<Parameters>
<Parameter Name="@school" Value='<%# IIf((Request.QueryString("school") <> Nothing), Request.QueryString("school"), "%") %>' Type="VarWChar" /> </Parameters>
</MM:DataSet>
<MM:PageBind runat="server" PostBackBind="true" />
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">

</style></head>
<body>
<h1 align="center">Add New Building Enhancement Request</h1>
<p> </p>

<p> </p>

<p> </p>

<form method="post" name="form1" runat="server">
<table align="center">
<tr valign="baseline">
<td width="164" align="right" nowrap>Date:</td>
<td width="210"><asp:textbox id="Date" TextMode="SingleLine" Columns="32" runat="server" />
</td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Employee_ID:</td>
<td><asp:textbox id="Employee_ID" TextMode="SingleLine" Columns="32" runat="server" />
</td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Estimated_Cost:</td>
<td><asp:textbox id="Estimated_Cost" TextMode="SingleLine" Columns="32" runat="server" />
</td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Improvement:</td>
<td><asp:textbox id="Improvement" TextMode="MultiLine" Columns="32" runat="server" />
</td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Rational:</td>
<td><asp:textbox id="Rational" TextMode="MultiLine" Columns="32" runat="server" />
</td>
</tr>
<tr valign="baseline">
<td nowrap align="right">School:</td>
<td><% School.SelectedIndex = School.Items.IndexOf(School.Items.FindByValue("")) %>
<asp:dropdownlist id="School"
DataSource="<%# dsschool.DefaultView %>"
DataTextField="School_Name"
DataValueField="School_Name"
                   runat="server"> </asp:dropdownlist>
</td>
</tr>
<tr valign="baseline">
<td nowrap align="right">School_Priority:</td>
<td><asp:textbox id="School_Priority" TextMode="SingleLine" Columns="32" runat="server" />
</td>
</tr>
<tr valign="baseline">
<td nowrap align="right"> </td>
<td><input type="submit" value="Insert record"></td>
</tr>
</table>
<input type="hidden" name="MM_insert" value="form1">
</form>
<p> </p>
</body>
</html>

Thanks for the help
Denise

neicy62

ASKER

Hey there...

Just wondering if anyone could help me with my problem

Thanks

Denise

neicy62

ASKER

Hi there...

Have not heard back still wondering if anyone can help with my problem.

Thanks

Denise

neicy62

ASKER

Hi

You can close this question 0 points awarded, figured it out for myself

Thanks
Denise