hi,
presently i m in a project of real estate website developement... her ei m getting a problem at modifying a members profile.... it contains a form.. which display a the members details..ina a form from that they can modify their data.. when they modify and click on submit then there is another page to update taht record... i m having eror in that second page; here is the code;

<%
'Dimension variables
Dim adoCon 'Holds the Database Connection Object
Dim rs 'Holds the recordset for the records in the database
Dim strSQL 'Holds the SQL query for the database
Dim lngRecordNo 'Holds the record number to be updated

'Read in the record number to be updated
strl = session("log")

'Create an ADO connection object
Set adoCon = Server.CreateObject("ADODB.Connection")

'Set an active connection to the Connection object using a DSN-less connection
adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("db/newuser.mdb")

'Set an active connection to the Connection object using DSN connection
'adoCon.Open "DSN=guestbook"

'Create an ADO recordset object
Set rs = Server.CreateObject("ADODB.Recordset")

'Initialise the strSQL variable with an SQL statement to query the database
strSQL = "SELECT members.* FROM members WHERE login=" & session("log")

'Open the recordset with the SQL query
rs.CursorType = 2
rs.LockType = 3
rs.Open strSQL, adoCon

     rs.Fields("fname") = Request.Form("edit_name")
    rs.Fields("mname") = Request.Form("edit_mid")
    rs.Fields("lname") = Request.Form("edit_last")
    rs.Fields("bday") = Request.Form("edit_day")
    rs.Fields("bmonth") = Request.Form("edit_month")
    rs.Fields("byear") = Request.Form("edit_year")
    rs.Fields("email") = Request.Form("edit_email")
    rs.Fields("add1") = Request.Form("edit_add1")
    rs.Fields("add2") = Request.Form("edit_add2")
    rs.Fields("city") = Request.Form("edit_city")
    rs.Fields("state") = Request.Form("edit_state")
    rs.Fields("country") = Request.Form("edit_country")
    rs.Fields("pin") = Request.Form("edit_pin")
    rs.Fields("businessurl") = Request.Form("edit_url")
    rs.Fields("mobile") = Request.Form("edit_mobile")
    rs.Fields("officephone") = Request.Form("edit_officeph")
    rs.Fields("homephone") = Request.Form("edit_homeph")


    rs.Update

rs.Close
Set rs = Nothing
Set adoCon = Nothing
%>

here ; session("log") -- it contains the user login name. it is assigned when user entered and varified by login....

so i m getting following error;
Microsoft OLE DB Provider for ODBC Drivers error '80040e10'

[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.

/member_edit_submit.asp, line 193

any one can help me for this... it is urgent and i m waiting for any ons's help...


shri

__________________
shri

Change your sql statement to this:

SELECT * from members

Also, you may just want to pass an Update query to access as opposed to selecting the data, pulling it down, updating it, and then pushing it back up. It seems that you have alot of unnecssary code here.

"The one language all programmers understand is profanity."

ya,
i have done before as u suggested... i have also done so many type of query sting modifications.. still i m getting same error


shri