Hello
I am new in web development and am stuck with a page i am working on .I have done everything i think on the page for it to update the information but once i get to the update page i change the information that i want updated it is not changing .Can u tell me what i should look for that would cause the problem .

here is the sql statment i have <%
fp_sQry="UPDATE contact SET ""Surname""=''::surname::'' , ""First""=''::First::'' , ""Department""=''::Department::'' , ""Ext""=''::Ext::'' , ""E-MailAddress""=''::E-mailAddress::'' , ""PagerNo""=''::PagerNo::'' , ""CellularNo""=''::Cellularno::'' WHERE ID=::ID::"
fp_sDefault="surname=&First=&Department=&Ext=&E-mailAddress=&PagerNo=&Cellularno=&ID="
fp_sNoRecords="<tr><td colspan=16 align=left width=""100%"">No records returned.</td></tr>"
fp_sDataConn="Phone"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_iDisplayCols=16
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>

Either you have not properly pasted your code, or there is something wrong with your query. Btw are you using VBScript ( ASP ) to update records?

Here is your query:

fp_sQry = "UPDATE contact SET ""Surname""=''::surname::'',
	""First""=''::First::'',
	""Department""=''::Department::'',
	""Ext""=''::Ext::'',
	""E-MailAddress""=''::E-mailAddress::'',
	""PagerNo""=''::PagerNo::'',
	""CellularNo""=''::Cellularno::''
WHERE ID=::ID::"

Change it to ( in VBScript ):

fp_sQry = "UPDATE contact SET Surname = ''" & surname & "''," & _
	"First = ''" & First & "''," & _
	"Department = ''" & Department & "''," & _
	"Ext = ''" & Ext & "''," & _
	"E-MailAddress = ''" & E-mailAddress & "''," & _
	"PagerNo = ''" & PagerNo & "''," & _
	"CellularNo = ''" & Cellularno & "'' " & _
"WHERE ID = " & ID