Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access_asp thread: I am at a loss.....


Message #1 by "Jeremy" <raistlinmagic@c...> on Sun, 1 Sep 2002 20:59:08 -0700
I have made a script to insert records into my database. Some of this
script is hacked from Dreamweaver. I get no error messages when I click
submit. But the record is not submitted into the database..

Here is my code..

=A0
=A0
<%@LANGUAGE=3D"VBSCRIPT" CODEPAGE=3D"1252"%>
<HTML>
<HEAD>
<META NAME=3D"GENERATOR" Content=3D"Microsoft Visual Studio 6.0">
</HEAD>
<%
Dim listings_STRING
Dim editAction
Dim abortEdit
Dim editQuery
Dim editCmd
Dim editConnection
Dim editTable
Dim editRedirectUrl
Dim editColumn
Dim recordId
Dim fieldsStr
Dim columnsStr
Dim fields
Dim columns
Dim typeArray
Dim formVal
Dim delim
Dim altVal
Dim emptyVal
Dim i
listings_STRING =3D "PROVIDER=3DMICROSOFT.JET.OLEDB.4.0;DATA
SOURCE=3Dc:\inetpub\wwwroot\websites\debraberry\listings.mdb"
editAction =3D CStr(Request.ServerVariables("SCRIPT_NAME"))
If (Request.QueryString <> "") Then
  editAction =3D editAction & "?" & Request.QueryString
End If
abortEdit =3D false
editQuery =3D ""
%>
<%
If (CStr(Request("insert")) =3D "form1") Then

  editConnection =3D Listings2_STRING
  editTable =3D "Results"
  editRedirectUrl =3D "submitted.asp"
  fieldsStr  =3D
"blob|value|blob1|value|blob2|value|blob3|value|blob4|value|blob5|value|
Bathrooms|value|Bedrooms|value|details|value|levels|value|Location|value
|lotsize|value|MLS|value|Price|value|propertytype|value|squarefeet|value
|Yearbuilt|value|zip|value|address|value|garage|value|basement|value"
  columnsStr =3D
"image1|'none''|image2|'none''|image3|'none''|image4|'none''|address|'no
ne,''|garage|'none''|basement|'none''|Bathrooms|',none,''|Bedrooms|',non
e,''|details|',none,''|levels|',none,''|Location|',none,''|lotsize|',non
e,''|MLS|',none,''|Price|',none,''|propertytype|',none,''|squarefeet|',n
one,''|Yearbuilt|',none,''|zip|',none,''"
  fields =3D Split(fieldsStr, "|")
  columns =3D Split(columnsStr, "|")
  For i =3D LBound(fields) To UBound(fields) Step 2
    fields(i+1) =3D CStr(Request.Form(fields(i)))
  Next
  If (editRedirectUrl <> "" And Request.QueryString <> "") Then
    If (InStr(1, editRedirectUrl, "?", vbTextCompare) =3D 0 And
Request.QueryString <> "") Then
      editRedirectUrl =3D editRedirectUrl & "?" & Request.QueryString
    Else
      editRedirectUrl =3D editRedirectUrl & "&" & Request.QueryString
    End If
  End If

End If
%>
<%
Dim tableValues
Dim dbValues
If (CStr(Request("insert")) <> "") Then
  tableValues =3D ""
  dbValues =3D ""
  For i =3D LBound(fields) To UBound(fields) Step 2
    formVal =3D fields(i+1)
    typeArray =3D Split(columns(i+1),",")
    delim =3D typeArray(0)
    If (delim =3D "none") Then delim =3D ""
    altVal =3D typeArray(1)
    If (altVal =3D "none") Then altVal =3D ""
    emptyVal =3D typeArray(2)
    If (emptyVal =3D "none") Then emptyVal =3D ""
    If (formVal =3D "") Then
      formVal =3D emptyVal
    Else
      If (altVal <> "") Then
        formVal =3D altVal
      ElseIf (delim =3D "'") Then  ' escape quotes
        formVal =3D "'" & Replace(formVal,"'","''") & "'"
      Else
        formVal =3D delim + formVal + delim
      End If
    End If
    If (i <> LBound(fields)) Then
      tableValues =3D tableValues & ","
      dbValues =3D dbValues & ","
    End If
    tableValues =3D tableValues & columns(i)
    dbValues =3D dbValues & formVal
  Next
  editQuery =3D "insert into " & editTable & " (" & tableValues & ")
values (" & dbValues & ")"
  If (Not abortEdit) Then
    ' execute the insert
    Set editCmd =3D Server.CreateObject("ADODB.Command")
    editCmd.ActiveConnection =3D editConnection
    editCmd.CommandText =3D editQuery
    editCmd.Execute
    editCmd.ActiveConnection.Close
    If (editRedirectUrl <> "") Then
      Response.Redirect(editRedirectUrl)
    End If
  End If
End If
%>
<BODY>
<table>
<P align=3Dcenter>&nbsp;</P>
<P align=3Dcenter>&nbsp;</P>
<DIV align=3Dcenter>
<FORM ENCTYPE=3D"multipart/form-data" ACTION=3D"submitted.asp" 
METHOD=3D"post"
name=3D"form1">
<P align=3Dcenter>MLS NUMBER</P>
<P align=3Dcenter> <INPUT name=3D"mls" style=3D"WIDTH: 99px; HEIGHT: 
22px"
size=3D12></P>
<p align=3Dcenter>Location</p>
<P align=3Dcenter><SELECT name=3D"Location">
	<option Value=3D"Ahsahka" selected>Ahsahka</option>
	<option Value=3D"Anatone">Anatone</option>
	<OPTION value=3D"Asotin">Asotin</OPTION>
	<option value=3D"Cavendish">Cavendish</option>
	<option Value=3D"Clarkston">Clarkston</option>
	<option Value=3D"Colton">Colton</option>
	<option Value=3D"Cottonwood">Cottonwood</option>
	<option Value=3D"Craigmont">Craigmont</option>
	<option Value=3D"Culdesac">Culdesac</option>
	<option value=3D"Dixie">Dixie</option>
	<option value=3D"Elk City">Elk City</option>
	<option Value=3D"Fenn">Fenn</option>
	<option Value=3D"Ferdinand">Ferdinand</option>
	<option Value=3D"Flora">Flora</option>
	<option Value=3D"Genesee">Genesee</option>
	<option Value=3D"Grangemont">Grangemont</option>
	<option Value=3D"Grangeville">Grangeville</option>
	<option Value=3D"Greencreek">Greencreek</option>
	<option Value=3D"Greer">Greer</option>
	<option Value=3D"Harpster">Harpster</option>
	<option Value=3D"Juliaetta">Juliaetta</option>
	<option Value=3D"Kamiah">Kamiah</option>
	<option Value=3D"Kendrick">Kendrick</option>
	<option Value=3D"Keuterville">Keuterville</option>
	<option Value=3D"Kooskia">Kooskia</option>
	<option Value=3D"Lapwai">Lapwai</option>
	<option Value=3D"Lenore">Lenore</option>
	<option Value=3D"Leon">Leon</option>
	<option value=3D"Lewiston">Lewiston</option>
	<option Value=3D"Lowell">Lowell</option>
	<option Value=3D"Lucile">Lucile</option>
	<option Value=3D"Nezperce">Nezperce</option>
	<option value=3D"Orofino">Orofino</option>
	<option Value=3D"Pataha">Pataha</option>
	<option Value=3D"Peck">Peck</option>
	<option Value=3D"Pierce">Pierce</option>
	<option Value=3D"Pinehurst">Pinehurst</option>
	<option Value=3D"Pollock">Pollock</option>
	<option Value=3D"Pomeroy">Pomeroy</option>
	<option Value=3D"Powell">Powell</option>
	<option Value=3D"Reubens">Reubens</option>
	<option Value=3D"Riggins">Riggins</option>
	<option Value=3D"Southwick">Southwick</option>
	<option Value=3D"Stites">Stites</option>
	<option Value=3D"Sweetwater">Sweetwater</option>
	<option Value=3D"Uniontown">Uniontown</option>
	<option Value=3D"Weippe">Weippe</option>
	<option Value=3D"White Bird">White Bird</option>
	<option Value=3D"Winchester">Winchester</option>
	<option Value=3D"Woodland">Woodland</option>
	<option Value=3D"Other">Other</option>
</SELECT></P>
<p align=3D"center">Zip Code</p>
<P align=3D"center"><INPUT type=3D"text" name=3D"zip" style=3D"WIDTH: 
77px;
HEIGHT: 22px" size=3D9></P>
<p align=3D"center">Address</p>
<P align=3D"center"><INPUT Name=3D"address" style=3D"WIDTH: 275px; 
HEIGHT:
22px" size=3D35></P>
<P align=3D"center">Property Type</P>
<p align=3D"center"><select name=3D"Propertytype">
<option value=3D"Single Family" selected
 >Single Family</option>
<option Value=3D"Multi-Family">Multi-Familiy</option>
<option Value=3D"Manufactured Home">Manufactured Home</option>
<option Value=3D"Mobile Home">Mobile Home</option>
<option Value=3D"Plex">Plex</option>
<option Value=3D"Commercial">Commercial</option>
<option Value=3D"House with Land">House With Land</option>
<option Value=3D"Land">Land</option>
</select>
</p>
<p align=3D"center">Bedrooms</p>
<p align=3D"center"><select name=3D"bedrooms">
<option Value=3D"NA(land)" selected>NA(land)</option>
<option value=3D"1 Bedroom">1 Bedroom</option>
<option value=3D"2 Bedrooms">2 Bedrooms</option>
<option Value=3D"3 Bedrooms">3 Bedrooms</option>
<option Value=3D"4 Bedrooms">4 Bedrooms</option>
<option Value=3D"5 Bedrooms">5 Bedrooms</option>
<option Value=3D"6 Bedrooms">6 Bedrooms</option>
<option Value=3D"7 Bedrooms">7 Bedrooms</option>
<option Value=3D"8 Bedrooms">8 Bedrooms</option>
<option Value=3D"9 Bedrooms"> 9 Bedrooms</option>
</select>
</p>
<p align=3D"center">Bathrooms</p>
<p align=3D"center"><select name=3D"bathrooms">
<option value=3D"NA(land)" selected
 >NA(land)</option>
<option Value=3D"1 Bathroom">1 Bathroom</option>
<option value=3D"1.5 Bathrooms">1.5 Bathrooms</option>
<option value=3D"2 Bathrooms">2 Bathrooms</option>
<option Value=3D"2.5 Bathrooms">2.5 Bathrooms</option>
<option Value=3D"3 Bathrooms">3 Bathrooms</option>
<option value=3D"3.5 Bathrooms">3.5 Bathrooms</option>
<option Value=3D"4 Bathrooms">4 Bathrooms</option>
<option Value=3D"4.5 Bathrooms">4.5 Bathrooms</option>
<option Value=3D"5 Bathrooms">5 Bathrooms</option>
<option Value=3D"5.5 Bathrooms">5.5 Bathrooms</option>
<option Value=3D"6 Bathrooms">6 Bathrooms</option>
<option value=3D"6.5 Bathrooms">6.5 Bathrooms</option>
<option Value=3D"7 Bathrooms">7 Bathrooms</option>
<option Value=3D"7.5 Bathrooms">7.5 Bathrooms</option>
<option Value=3D"8 Bathrooms">8 Bathrooms</option>
<option Value=3D"8.5 Bathrooms">8.5 Bathrooms</option>
<option Value=3D"9 Bathrooms">9 Bathrooms</option>
<option value=3D"9.5 or more Bathrooms">9.5 or more Bathrooms</option>
</select>
</p>
<p align=3D"center">Garage/shop</p>
<p align=3D"center"><select name=3D"garage">
<option value=3D"No Garage" selected>No Garage</option>
<option Value=3D"1 Car">1 Car</option>
<option Value=3D"2 Car">2 Car</option>
<option Value=3D"3 Car">3 Car</option>
<option Value=3D"4 Car">4 Car</option>
<option Value=3D"5 Car">5 Car</option>
<option Value=3D"6 or more Car">6 or more car</option>
<option Value=3D"garage/shop">garage/shop</option>
<option Value=3D"garage and shop">Garage and shop</option>
<option Value=3D"shop">Shop</option>
</select>
</p>
<p align=3D"center">Lot Size</p>
<p align=3D"center"><input name=3D"Lotsize" style=3D"WIDTH: 93px; 
HEIGHT:
22px" size=3D12>
</p>
<p align=3D"center">Square feet</p>
<p align=3D"center"><input name=3D"squarefeet" style=3D"WIDTH: 103px; 
HEIGHT:
22px" size=3D13>
</p>
<p align=3D"center">Year Built</p>
<p align=3D"center"><input name=3D"yearbuilt" style=3D"WIDTH: 79px; 
HEIGHT:
22px" size=3D10>
</p>
<p align=3D"center">Levels</p>
<p align=3D"center"><select name=3D"levels">
<option value=3D"1 Level" selected>1 Level</option>
<option Value=3D"1.5 Level">1.5 Level</option>
<option Value=3D"2 level">2 Level</option>
<option Value=3D"2.5 Level">2.5 Level</option>
<option Value=3D"3 Level">3 Level</option>
<option Value=3D"3.5 Level">3.5 Level</option>
<option Value=3D"4 or more Level">4 or more Level</option>
</select>
</p>
<p align=3D"center">Basement</p>
<p align=3D"center"><select name=3D"basement">
<option value=3D"Full Basement" selected>Full Basement</option>
<option Value=3D"Partial Basement">Partial Basement</option>
<option Value=3D"No Basement">No Basement</option>
</select>
</p>
<P>&nbsp;</P>
<p align=3D"center">Add Images:</p>
<p align=3D"center">
<input type=3D"file" name=3D"BLOB" value=3D""></p>
<p align=3D"center">
<input type=3D"file" name=3DBLOB1" value=3D""></p>
<p align=3D"center">
<input type=3D"file" name=3D"BLOB2" value=3D""></p>
<p align=3D"center">
<input type=3D"file" name=3D"BLOB3" value=3D"">
</P>
<p align=3D"center">
<input type=3D"file" name=3D"BLOB4" value=3D"">
</P>
<p align=3D"center">
<input type=3D"file" name=3D"BLOB5" value=3D"">
</P>
<p align=3D"center">More Details</p>
<p align=3D"center"><TEXTAREA style=3D"WIDTH: 618px; HEIGHT: 168px"
name=3Ddetails rows=3D8 cols=3D65></TEXTAREA>
</p>
<P align=3D"center"><INPUT type=3D"submit" value=3D"Submit"><INPUT
type=3D"reset" value=3D"Reset"></P>
<p>
</p>
</form></DIV>

</BODY>
</HTML>



What am I missing????

Thanks in advance..


Jeremy


Message #2 by "Ken Schaefer" <ken@a...> on Mon, 2 Sep 2002 16:20:08 +1000
Put some Response.Write() in to see where the code is falling to. I suspect
that somewhere along the line you are falling into an If...Else...End If
condition that you don't expect to.

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Jeremy" <raistlinmagic@c...>
Subject: [access_asp] I am at a loss.....


I have made a script to insert records into my database. Some of this
script is hacked from Dreamweaver. I get no error messages when I click
submit. But the record is not submitted into the database..

Here is my code..

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Message #3 by "michael shulman" <mikeinapo@h...> on Tue, 3 Sep 2002 12:20:32 -0400
First off your code is submitting to submitted.asp, which does the posting
since theres no INSERT statement here, i think you have the webform up, not
the processing.

Michael SHulman
----------------------------------------------------------------------------
You may stop this individual, but you can't stop us all... after all, we're
all alike.

---Mentors Hacker Manifesto
http://semper.securitygeek.net/mentor.php
----- Original Message -----
From: "Jeremy" <raistlinmagic@c...>
To: "Access ASP" <access_asp@p...>
Cc: <raistlinmagic@c...>
Sent: Sunday, September 01, 2002 11:59 PM
Subject: [access_asp] I am at a loss.....


I have made a script to insert records into my database. Some of this
script is hacked from Dreamweaver. I get no error messages when I click
submit. But the record is not submitted into the database..

Here is my code..



<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
</HEAD>
<%
Dim listings_STRING
Dim editAction
Dim abortEdit
Dim editQuery
Dim editCmd
Dim editConnection
Dim editTable
Dim editRedirectUrl
Dim editColumn
Dim recordId
Dim fieldsStr
Dim columnsStr
Dim fields
Dim columns
Dim typeArray
Dim formVal
Dim delim
Dim altVal
Dim emptyVal
Dim i
listings_STRING = "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA
SOURCE=c:\inetpub\wwwroot\websites\debraberry\listings.mdb"
editAction = CStr(Request.ServerVariables("SCRIPT_NAME"))
If (Request.QueryString <> "") Then
  editAction = editAction & "?" & Request.QueryString
End If
abortEdit = false
editQuery = ""
%>
<%
If (CStr(Request("insert")) = "form1") Then

  editConnection = Listings2_STRING
  editTable = "Results"
  editRedirectUrl = "submitted.asp"
  fieldsStr  
"blob|value|blob1|value|blob2|value|blob3|value|blob4|value|blob5|value|
Bathrooms|value|Bedrooms|value|details|value|levels|value|Location|value
|lotsize|value|MLS|value|Price|value|propertytype|value|squarefeet|value
|Yearbuilt|value|zip|value|address|value|garage|value|basement|value"
  columnsStr 
"image1|'none''|image2|'none''|image3|'none''|image4|'none''|address|'no
ne,''|garage|'none''|basement|'none''|Bathrooms|',none,''|Bedrooms|',non
e,''|details|',none,''|levels|',none,''|Location|',none,''|lotsize|',non
e,''|MLS|',none,''|Price|',none,''|propertytype|',none,''|squarefeet|',n
one,''|Yearbuilt|',none,''|zip|',none,''"
  fields = Split(fieldsStr, "|")
  columns = Split(columnsStr, "|")
  For i = LBound(fields) To UBound(fields) Step 2
    fields(i+1) = CStr(Request.Form(fields(i)))
  Next
  If (editRedirectUrl <> "" And Request.QueryString <> "") Then
    If (InStr(1, editRedirectUrl, "?", vbTextCompare) = 0 And
Request.QueryString <> "") Then
      editRedirectUrl = editRedirectUrl & "?" & Request.QueryString
    Else
      editRedirectUrl = editRedirectUrl & "&" & Request.QueryString
    End If
  End If

End If
%>
<%
Dim tableValues
Dim dbValues
If (CStr(Request("insert")) <> "") Then
  tableValues = ""
  dbValues = ""
  For i = LBound(fields) To UBound(fields) Step 2
    formVal = fields(i+1)
    typeArray = Split(columns(i+1),",")
    delim = typeArray(0)
    If (delim = "none") Then delim = ""
    altVal = typeArray(1)
    If (altVal = "none") Then altVal = ""
    emptyVal = typeArray(2)
    If (emptyVal = "none") Then emptyVal = ""
    If (formVal = "") Then
      formVal = emptyVal
    Else
      If (altVal <> "") Then
        formVal = altVal
      ElseIf (delim = "'") Then  ' escape quotes
        formVal = "'" & Replace(formVal,"'","''") & "'"
      Else
        formVal = delim + formVal + delim
      End If
    End If
    If (i <> LBound(fields)) Then
      tableValues = tableValues & ","
      dbValues = dbValues & ","
    End If
    tableValues = tableValues & columns(i)
    dbValues = dbValues & formVal
  Next
  editQuery = "insert into " & editTable & " (" & tableValues & ")
values (" & dbValues & ")"
  If (Not abortEdit) Then
    ' execute the insert
    Set editCmd = Server.CreateObject("ADODB.Command")
    editCmd.ActiveConnection = editConnection
    editCmd.CommandText = editQuery
    editCmd.Execute
    editCmd.ActiveConnection.Close
    If (editRedirectUrl <> "") Then
      Response.Redirect(editRedirectUrl)
    End If
  End If
End If
%>
<BODY>
<table>
<P align=center>&nbsp;</P>
<P align=center>&nbsp;</P>
<DIV align=center>
<FORM ENCTYPE="multipart/form-data" ACTION="submitted.asp" METHOD="post"
name="form1">
<P align=center>MLS NUMBER</P>
<P align=center> <INPUT name="mls" style="WIDTH: 99px; HEIGHT: 22px"
size=12></P>
<p align=center>Location</p>
<P align=center><SELECT name="Location">
<option Value="Ahsahka" selected>Ahsahka</option>
<option Value="Anatone">Anatone</option>
<OPTION value="Asotin">Asotin</OPTION>
<option value="Cavendish">Cavendish</option>
<option Value="Clarkston">Clarkston</option>
<option Value="Colton">Colton</option>
<option Value="Cottonwood">Cottonwood</option>
<option Value="Craigmont">Craigmont</option>
<option Value="Culdesac">Culdesac</option>
<option value="Dixie">Dixie</option>
<option value="Elk City">Elk City</option>
<option Value="Fenn">Fenn</option>
<option Value="Ferdinand">Ferdinand</option>
<option Value="Flora">Flora</option>
<option Value="Genesee">Genesee</option>
<option Value="Grangemont">Grangemont</option>
<option Value="Grangeville">Grangeville</option>
<option Value="Greencreek">Greencreek</option>
<option Value="Greer">Greer</option>
<option Value="Harpster">Harpster</option>
<option Value="Juliaetta">Juliaetta</option>
<option Value="Kamiah">Kamiah</option>
<option Value="Kendrick">Kendrick</option>
<option Value="Keuterville">Keuterville</option>
<option Value="Kooskia">Kooskia</option>
<option Value="Lapwai">Lapwai</option>
<option Value="Lenore">Lenore</option>
<option Value="Leon">Leon</option>
<option value="Lewiston">Lewiston</option>
<option Value="Lowell">Lowell</option>
<option Value="Lucile">Lucile</option>
<option Value="Nezperce">Nezperce</option>
<option value="Orofino">Orofino</option>
<option Value="Pataha">Pataha</option>
<option Value="Peck">Peck</option>
<option Value="Pierce">Pierce</option>
<option Value="Pinehurst">Pinehurst</option>
<option Value="Pollock">Pollock</option>
<option Value="Pomeroy">Pomeroy</option>
<option Value="Powell">Powell</option>
<option Value="Reubens">Reubens</option>
<option Value="Riggins">Riggins</option>
<option Value="Southwick">Southwick</option>
<option Value="Stites">Stites</option>
<option Value="Sweetwater">Sweetwater</option>
<option Value="Uniontown">Uniontown</option>
<option Value="Weippe">Weippe</option>
<option Value="White Bird">White Bird</option>
<option Value="Winchester">Winchester</option>
<option Value="Woodland">Woodland</option>
<option Value="Other">Other</option>
</SELECT></P>
<p align="center">Zip Code</p>
<P align="center"><INPUT type="text" name="zip" style="WIDTH: 77px;
HEIGHT: 22px" size=9></P>
<p align="center">Address</p>
<P align="center"><INPUT Name="address" style="WIDTH: 275px; HEIGHT:
22px" size=35></P>
<P align="center">Property Type</P>
<p align="center"><select name="Propertytype">
<option value="Single Family" selected
 >Single Family</option>
<option Value="Multi-Family">Multi-Familiy</option>
<option Value="Manufactured Home">Manufactured Home</option>
<option Value="Mobile Home">Mobile Home</option>
<option Value="Plex">Plex</option>
<option Value="Commercial">Commercial</option>
<option Value="House with Land">House With Land</option>
<option Value="Land">Land</option>
</select>
</p>
<p align="center">Bedrooms</p>
<p align="center"><select name="bedrooms">
<option Value="NA(land)" selected>NA(land)</option>
<option value="1 Bedroom">1 Bedroom</option>
<option value="2 Bedrooms">2 Bedrooms</option>
<option Value="3 Bedrooms">3 Bedrooms</option>
<option Value="4 Bedrooms">4 Bedrooms</option>
<option Value="5 Bedrooms">5 Bedrooms</option>
<option Value="6 Bedrooms">6 Bedrooms</option>
<option Value="7 Bedrooms">7 Bedrooms</option>
<option Value="8 Bedrooms">8 Bedrooms</option>
<option Value="9 Bedrooms"> 9 Bedrooms</option>
</select>
</p>
<p align="center">Bathrooms</p>
<p align="center"><select name="bathrooms">
<option value="NA(land)" selected
 >NA(land)</option>
<option Value="1 Bathroom">1 Bathroom</option>
<option value="1.5 Bathrooms">1.5 Bathrooms</option>
<option value="2 Bathrooms">2 Bathrooms</option>
<option Value="2.5 Bathrooms">2.5 Bathrooms</option>
<option Value="3 Bathrooms">3 Bathrooms</option>
<option value="3.5 Bathrooms">3.5 Bathrooms</option>
<option Value="4 Bathrooms">4 Bathrooms</option>
<option Value="4.5 Bathrooms">4.5 Bathrooms</option>
<option Value="5 Bathrooms">5 Bathrooms</option>
<option Value="5.5 Bathrooms">5.5 Bathrooms</option>
<option Value="6 Bathrooms">6 Bathrooms</option>
<option value="6.5 Bathrooms">6.5 Bathrooms</option>
<option Value="7 Bathrooms">7 Bathrooms</option>
<option Value="7.5 Bathrooms">7.5 Bathrooms</option>
<option Value="8 Bathrooms">8 Bathrooms</option>
<option Value="8.5 Bathrooms">8.5 Bathrooms</option>
<option Value="9 Bathrooms">9 Bathrooms</option>
<option value="9.5 or more Bathrooms">9.5 or more Bathrooms</option>
</select>
</p>
<p align="center">Garage/shop</p>
<p align="center"><select name="garage">
<option value="No Garage" selected>No Garage</option>
<option Value="1 Car">1 Car</option>
<option Value="2 Car">2 Car</option>
<option Value="3 Car">3 Car</option>
<option Value="4 Car">4 Car</option>
<option Value="5 Car">5 Car</option>
<option Value="6 or more Car">6 or more car</option>
<option Value="garage/shop">garage/shop</option>
<option Value="garage and shop">Garage and shop</option>
<option Value="shop">Shop</option>
</select>
</p>
<p align="center">Lot Size</p>
<p align="center"><input name="Lotsize" style="WIDTH: 93px; HEIGHT:
22px" size=12>
</p>
<p align="center">Square feet</p>
<p align="center"><input name="squarefeet" style="WIDTH: 103px; HEIGHT:
22px" size=13>
</p>
<p align="center">Year Built</p>
<p align="center"><input name="yearbuilt" style="WIDTH: 79px; HEIGHT:
22px" size=10>
</p>
<p align="center">Levels</p>
<p align="center"><select name="levels">
<option value="1 Level" selected>1 Level</option>
<option Value="1.5 Level">1.5 Level</option>
<option Value="2 level">2 Level</option>
<option Value="2.5 Level">2.5 Level</option>
<option Value="3 Level">3 Level</option>
<option Value="3.5 Level">3.5 Level</option>
<option Value="4 or more Level">4 or more Level</option>
</select>
</p>
<p align="center">Basement</p>
<p align="center"><select name="basement">
<option value="Full Basement" selected>Full Basement</option>
<option Value="Partial Basement">Partial Basement</option>
<option Value="No Basement">No Basement</option>
</select>
</p>
<P>&nbsp;</P>
<p align="center">Add Images:</p>
<p align="center">
<input type="file" name="BLOB" value=""></p>
<p align="center">
<input type="file" name=BLOB1" value=""></p>
<p align="center">
<input type="file" name="BLOB2" value=""></p>
<p align="center">
<input type="file" name="BLOB3" value="">
</P>
<p align="center">
<input type="file" name="BLOB4" value="">
</P>
<p align="center">
<input type="file" name="BLOB5" value="">
</P>
<p align="center">More Details</p>
<p align="center"><TEXTAREA style="WIDTH: 618px; HEIGHT: 168px"
name=details rows=8 cols=65></TEXTAREA>
</p>
<P align="center"><INPUT type="submit" value="Submit"><INPUT
type="reset" value="Reset"></P>
<p>
</p>
</form></DIV>

</BODY>
</HTML>



What am I missing????

Thanks in advance..


Jeremy





  Return to Index