Free Year's Hosting to the person that solves this

techknow · #1 (**permalink**) 04-18-04, 12:18 AM

100 MB Webspace free for a year to the first person that can tell me why this doesn't work and how to fix it so that it does work...

My hosting site is at http://atkhost.com if you would like more info about my services... (Not trying to spam here...)

Ok Here's the code, it's pretty simple;

<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<Script Runat="Server">

Sub Button_Click( s As Object, e As EventArgs )
Dim conlistings As OleDbConnection
Dim strInsert As String
Dim cmdInsert As OleDbCommand

conlistings = New OleDbConnection( "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source=d:\websites\justoneguy.com\data\listings.md b" )
strInsert = "Insert Into Listings ( Address, City, Price, Bedrooms, Bathrooms, Views, Description, Comments ) Values ( @Address, @City, @Price, @Bedrooms, @Bathrooms, @Views, @Description, @Comments )"
cmdInsert = New OleDbCommand( strInsert, conlistings )
cmdInsert.Parameters.Add( "@Address", Address.Text )
cmdInsert.Parameters.Add( "@City", City.Text )
cmdInsert.Parameters.Add( "@Price", Price.Text )
cmdInsert.Parameters.Add( "@Bedrooms", Bedrooms.Text )
cmdInsert.Parameters.Add( "@Bathrooms", Bathrooms.Text )
cmdInsert.Parameters.Add( "@Views", Views.Text )
cmdInsert.Parameters.Add( "@Description", PropDescription.Text )
cmdInsert.Parameters.Add( "@Comments", Comments.Text )
conlistings.Open()
cmdINsert.ExecuteNonQuery()
conlistings.Close()
End Sub
</Script>

<html>
<head><title>FormInsert.aspx</title></head>
<body>
<form Runat="Server">

<h2>Add New Listing</h2>

Address:
 
<asp:TextBox
ID="Address"
Runat="Server" />

City:
 
<asp:TextBox
ID="City"
Runat="Server" />


Price:
 
<asp:TextBox
ID="Price"
Runat="Server" />


Bedrooms:
 
<asp:TextBox
ID="Bedrooms"
Runat="Server" />


Bathrooms:
 
<asp:TextBox
ID="Bathrooms"
Runat="Server" />


Views:
 
<asp:TextBox
ID="Views"
Runat="Server" />


Description:
 
<asp:TextBox
ID="Description"
Runat="server" Columns="3" />

Comments:
 
<asp:TextBox
ID="Comments"
Runat="Server" />

<asp:Button
Text="Add!"
OnClick="Button_Click"
Runat="Server" />

</form>
</body>
</html>

kiddu · #2 (**permalink**) 04-18-04, 03:26 AM

here is the problem:

cmdInsert.Parameters.Add( "@Description", PropDescription.Text)

PropDescription is not defined. You might wanted to use description.text

HTH
Kiddu

techknow · #3 (**permalink**) 04-18-04, 01:15 PM

Still doesn't work... Good call though... You can still have your free hosting anyway.

Thanks!

techknow · #4 (**permalink**) 04-19-04, 03:52 PM

More Proof I am a knucklehead!

I had to also change the form field indentifier!!!

No wonder the guys from MIT aren't returning my calls...

wessamzeidan · #5 (**permalink**) 04-20-04, 01:01 PM

I'm not sure but I think you have to change your sql query to this

strInsert = "Insert Into Listings ( Address, City, Price, Bedrooms, Bathrooms, Views, Description, Comments ) Values ( ?, ?, ?, ?, ?, ?, ?, ?)"

cmdInsert.Parameters.Add( "Address", Address.Text )
cmdInsert.Parameters.Add( "City", City.Text )
cmdInsert.Parameters.Add( "Price", Price.Text )
cmdInsert.Parameters.Add( "Bedrooms", Bedrooms.Text )
cmdInsert.Parameters.Add( "Bathrooms", Bathrooms.Text )
cmdInsert.Parameters.Add( "Views", Views.Text )
cmdInsert.Parameters.Add( "Description", PropDescription.Text )
cmdInsert.Parameters.Add( "Comments", Comments.Text )

it works fine for me........give it a try

techknow · #6 (**permalink**) 04-27-04, 11:18 AM

Thanks though. PM me if you want your hosting!

Thanks again to all!