Forums

DREAMWEAVER

This topic is locked

ASP.NET form error

John Levandowski

Posted 13 Jan 2003 16:56:56

has voted

Vote

13 Jan 2003 16:56:56 John Levandowski posted:

I am trying to post information to an Access database using an ASP.NET form. Every time I try to post the data, I get the following debug information:

System.Data.OleDb.OleDbException: Syntax error in INSERT INTO statement.
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr)
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
at DreamweaverCtrls.DataSet.DoInit()

Could someone tell me what I'm doing wrong? (Aside from the fact that my code isn't posting correctly)
<pre id=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<img src=../images/dmxzone/forum/icon_smile_blush.gif border=0 align=middle>nsert
runat="server"
CommandText='<%# "INSERT INTO Customers_CreditCards (BillingAddress, BillingCity, BillingState, BillingZip, CreditCardExpiration, CreditCardType, Email, FirstName, LastName, Password, PhoneNumber, ShippingAddress, ShippingCity, ShippingState, ShippingZip, Username) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" %>'
ConnectionString='<%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_STRING_conn_Webstore"

%>'
DatabaseType='<%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_DATABASETYPE_conn_Webstore"

%>'
Expression='<%# Request.Form("MM_insert"

= "form1" %>'
CreateDataSet="false"
SuccessURL='<%# "confirm.aspx" %>'
Debug="true"
><Parameters>
<Parameter Name="@BillingAddress" Value='<%# IIf((Request.Form("billingaddress"

<> Nothing), Request.Form("billingaddress"

, ""

%>' Type="WChar" />
<Parameter Name="@BillingCity" Value='<%# IIf((Request.Form("billingcity"

<> Nothing), Request.Form("billingcity"

, ""

%>' Type="WChar" />
<Parameter Name="@BillingState" Value='<%# IIf((Request.Form("billingstate"

<> Nothing), Request.Form("billingstate"

, ""

%>' Type="WChar" />
<Parameter Name="@BillingZip" Value='<%# IIf((Request.Form("billingzip"

<> Nothing), Request.Form("billingzip"

, ""

%>' Type="WChar" />
<Parameter Name="@CreditCardExpiration" Value='<%# IIf((Request.Form("ccexpiration"

<> Nothing), Request.Form("ccexpiration"

, ""

%>' Type="WChar" />
<Parameter Name="@CreditCardType" Value='<%# IIf((Request.Form("cctype"

<> Nothing), Request.Form("cctype"

, ""

%>' Type="WChar" />
<Parameter Name="@Email" Value='<%# IIf((Request.Form("email"

<> Nothing), Request.Form("email"

, ""

%>' Type="WChar" />
<Parameter Name="@FirstName" Value='<%# IIf((Request.Form("fname"

<> Nothing), Request.Form("fname"

, ""

%>' Type="WChar" />
<Parameter Name="@LastName" Value='<%# IIf((Request.Form("lname"

<> Nothing), Request.Form("lname"

, ""

%>' Type="WChar" />
<Parameter Name="@Password" Value='<%# IIf((Request.Form("password"

<> Nothing), Request.Form("password"

, ""

%>' Type="WChar" />
<Parameter Name="@PhoneNumber" Value='<%# IIf((Request.Form("phonenumber"

<> Nothing), Request.Form("phonenumber"

, ""

%>' Type="WChar" />
<Parameter Name="@ShippingAddress" Value='<%# IIf((Request.Form("shippingaddress"

<> Nothing), Request.Form("shippingaddress"

, ""

%>' Type="WChar" />
<Parameter Name="@ShippingCity" Value='<%# IIf((Request.Form("shippingcity"

<> Nothing), Request.Form("shippingcity"

, ""

%>' Type="WChar" />
<Parameter Name="@ShippingState" Value='<%# IIf((Request.Form("shippingstate"

<> Nothing), Request.Form("shippingstate"

, ""

%>' Type="WChar" />
<Parameter Name="@ShippingZip" Value='<%# IIf((Request.Form("shippingzip"

<> Nothing), Request.Form("shippingzip"

, ""

%>' Type="WChar" />
<Parameter Name="@Username" Value='<%# IIf((Request.Form("username"

<> Nothing), Request.Form("username"

, ""

%>' Type="WChar" />
</Parameters>
</MM<img src=../images/dmxzone/forum/icon_smile_blush.gif border=0 align=middle>nsert>
<MM

ataSet
id="dsRegister"
runat="Server"
IsStoredProcedure="false"
ConnectionString='<%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_STRING_conn_Webstore"

%>'
DatabaseType='<%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_DATABASETYPE_conn_Webstore"

%>'
CommandText='<%# "SELECT Customers.*, CreditCards.* FROM Customers INNER JOIN CreditCards ON Customers.CustomerID = CreditCards.CustomerID;" %>'
Debug="true"
></MM

ataSet>
<MM<img src=../images/dmxzone/forum/icon_smile_tongue.gif border=0 align=middle>ageBind runat="server" PostBackBind="true" />
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<form method="POST" name="form1" runat="server">
<table width="400" border="0">
<tr bgcolor="#999999">
<td colspan="2">Personal Information</td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td width="185">First Name</td>
<td width="205"> 
<asp:textbox ID="fname" MaxLength="20" runat="server" Text="First Name" />
</td>
</tr>
<tr>
<td>Last Name</td>
<td> 
<asp:textbox ID="lname" MaxLength="20" runat="server" Text="Last Name" />
</td>
</tr>
<tr>
<td>Username</td>
<td> 
<asp:textbox ID="username" runat="server" Text="Username" />
</td>
</tr>
<tr>
<td>Password</td>
<td> 
<asp:textbox ID="password" MaxLength="20" runat="server" Text="Password" />
</td>
</tr>
<tr>
<td>Email</td>
<td> 
<asp:textbox ID="email" MaxLength="20" runat="server" Text="Email" />
</td>
</tr>
<tr>
<td>Phone Number</td>
<td> 
<asp:textbox ID="phonenumber" MaxLength="12" runat="server" Text="Phone Number" />
</td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr bgcolor="#999999">
<td colspan="2">Billing
Information</td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Credit Card Type</td>
<td> 
<asp:dropdownlist ID="cctype" runat="server">
<asp:listitem>Visa</asp:listitem>
<asp:listitem>MC</asp:listitem>
<asp:listitem>AmEx</asp:listitem>
<asp:listitem>Disc</asp:listitem>
</asp:dropdownlist>
</td>
</tr>
<tr>
<td>Expiration Date</td>
<td> 
<asp:dropdownlist ID="ccexpiration" runat="server">
<asp:listitem>2002</asp:listitem>
<asp:listitem>2003</asp:listitem>
<asp:listitem>2004</asp:listitem>
<asp:listitem>2005</asp:listitem>
<asp:listitem>2006</asp:listitem>
</asp:dropdownlist>
</td>
</tr>
<tr>
<td>Billing Address</td>
<td> 
<asp:textbox ID="billingaddress" MaxLength="30" runat="server" Text="Billing Address" />
</td>
</tr>
<tr>
<td>Billing City</td>
<td> 
<asp:textbox ID="billingcity" MaxLength="30" runat="server" Text="Billing City" />
</td>
</tr>
<tr>
<td>Billing State</td>
<td> 
<asp:dropdownlist ID="billingstate" runat="server">
<asp:listitem>MI</asp:listitem>
<asp:listitem>OR</asp:listitem>
<asp:listitem>NE</asp:listitem>
<asp:listitem>TN</asp:listitem>
<asp:listitem>TX</asp:listitem>
</asp:dropdownlist>
</td>
</tr>
<tr>
<td>Billing Zip</td>
<td> 
<asp:textbox ID="billingzip" MaxLength="5" runat="server" />
</td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr bgcolor="#999999">
<td colspan="2">Shipping
Information</td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Shipping Address</td>
<td> 
<asp:textbox ID="shippingaddress" MaxLength="30" runat="server" Text="Shipping Address" />
</td>
</tr>
<tr>
<td>Shipping City</td>
<td> 
<asp:textbox ID="shippingcity" MaxLength="30" runat="server" Text="Shipping City" />
</td>
</tr>
<tr>
<td>Shipping State</td>
<td> 
<asp:dropdownlist ID="shippingstate" runat="server">
<asp:listitem>MI</asp:listitem>
<asp:listitem>OR</asp:listitem>
<asp:listitem>NE</asp:listitem>
<asp:listitem>TN</asp:listitem>
<asp:listitem>TX</asp:listitem>
</asp:dropdownlist>
</td>
</tr>
<tr>
<td>Shipping Zip</td>
<td> 
<asp:textbox ID="shippingzip" MaxLength="5" runat="server" />
</td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td><asp:button ID="btnsubmit" runat="server" Text="Submit" /></td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
</table>
<input type="hidden" name="MM_insert" value="form1">
</form>
</body>
</html>
</pre id=code>

John

Replies

John Levandowski

Replied 13 Jan 2003 19:28:31

13 Jan 2003 19:28:31 John Levandowski replied:

I fixed my own problem. The line:
CommandText='<%# "INSERT INTO Customers_CreditCards (BillingAddress, BillingCity, BillingState, BillingZip, CreditCardExpiration, CreditCardType, Email, FirstName, LastName, Password, PhoneNumber, ShippingAddress, ShippingCity, ShippingState, ShippingZip, Username) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" %>'

should have brackets around the field names (ie [BillingAddress]). There is an article on the microsoft site that explains this: support.microsoft.com/default.aspx?scid=kb;en-us;189220. I'm wondering though why Dreamweaver generated this type of error...

John

Reply to this topic

Latest Extensions

App Connect Summernote File Upload Upload different files in Summernote Editor
App Connect Summernote Simple, yet powerful and modern WYSIWYG Editor
Bootstrap 4 Dynamic Table Generator 2 Automatically generate dynamic data tables
Bootstrap 4 Dynamic Form Generator 2 Auto generate perfect Bootstrap 4 dynamic forms in seconds
App Connect Bootstrap 4 Dynamic Paging Generator Auto generate awesome dynamic Bootstrap 4 paging in seconds
App Connect Event Calendar The most powerful full-sized event calendar for Dreamweaver
DMXzone App Connect Next generation client side framework for data-driven web sites and apps
DMXzone Database Custom Query Create advanced, complex custom SQL queries with ease

Latest Videos

Using App Connect Autocomplete Learn how to add autocomplete functionality on your page, using the App Connect Autocomplete
Creating Custom SQL Queries Learn how to create custom SQL Queries with DMXzone Database Custom Query
Restricting Access to Your Pages Learn how to restrict access to your pages, using DMXzone Security Provider 2
Adding Log Out Functionality with DMXzone Security Provider 2 Learn how to add log out functionality to your page with DMXzone Security Provider 2
Creating a Log In Page with DMXzone Security Provider 2 Learn how to create a log in page with DMXzone Security Provider 2
Setting Up Site Security Settings Learn how to setup your site security, using DMXzone Security Provider 2
Generating an Update Record Form Learn how to create an update record form, using the Bootstrap 4 Dynamic Form Generator 2
Generating an Insert Record Form Learn how to create an insert record form, using the Bootstrap 4 Dynamic Form Generator 2