Help with update statement

[sthmpsn1]

I have the following statement which produces a syntax error. on the updatesql line. I don't see where my problem is??
<%
updatesql = &quot;UPDATE FamilyInfo SET Address = '&quot; & Request.Form(&quot;Address&quot & &quot;', &quot; & &quot;City = '&quot; & Request.Form(&quot;City&quot & &quot;', &quot; & &quot;State = '&quot; & Request.Form(&quot;State&quot & &quot;', &quot; & &quot;ZipCode = '&quot; & Request.Form(&quot;ZipCode&quot & &quot;', &quot; & &quot;E-Mail = '&quot; & Request.Form(&quot;Email&quot & &quot;', &quot; & &quot;Phone = '&quot; & Request.Form(&quot;Phone&quot & &quot;', &quot; & &quot;CellPhone = '&quot; & Request.Form(&quot;CellPhone&quot & &quot;', &quot; & &quot;Fax = '&quot; & Request.Form(&quot;Fax&quot & &quot;' &quot; & &quot;WHERE (((FamilyNameID)=&quot; & Request.QueryString(&quot;FamilyNameID&quot & &quot)&quot;

'Sample UPDATE Statement
'UPDATE FamilyInfo SET FamilyInfo.Address = &quot;test&quot;, FamilyInfo.City = &quot;test&quot;, FamilyInfo.State = &quot;test&quot;, FamilyInfo.ZipCode = &quot;test&quot;, FamilyInfo.EMail = &quot;test&quot;, FamilyInfo.CellPhone = &quot;test&quot;, FamilyInfo.Fax = &quot;test&quot;
'WHERE (((FamilyInfo.FamilyNameID)=1));

'Response.write(updatesql)
conn.Execute(updatesql)
%>

 

[FengShui1998]

sthmpsn1,

What kind of error are you getting?

fengshui_1998

 

[FesterSXS]

try this:

updatesql = "UPDATE FamilyInfo SET Address = '" & Request.Form("Address") & "', City = '" & Request.Form("City") & "', State = '" & Request.Form("State") & "', ZipCode = '" & Request.Form("ZipCode") & "', E-Mail = '" & Request.Form("Email") & "', Phone = '" & Request.Form("Phone") & "', CellPhone = '" & Request.Form("CellPhone") & "', Fax = '" & Request.Form("Fax") & "' WHERE FamilyNameID = " & Request.QueryString("FamilyNameID")

by the way - are the phone,cellphone,fax values stored in your database as numbers or text?? The SQL string above assumes they are text. Tony

http://www.phoenix-paints.co.uk/portfolio