I AM GETTING THIS ERROR WHEN I AM DOING RESPONSE.WRITE DELSQL<BR>VALUE I AM GETTING FOR LOC & DIV ALL THE RECORDES WHICH I HAVE ON SCREEN<BR><BR>UserName: lquick<BR>delete from hr_rep_assignment where user_id = &#039lquick&#039and Location_id = &#039C00 , C00 &#039and division_id = &#039F , L &#039 <BR><BR><BR>This is my query where i am retriving all the recoreds <BR>i am want location_id and division_id values for my delete statment so, i have hiddenbox<BR><BR> &#039--This query will display Location,Division,LocationId and DivisionId for selected user--<BR> StrSql = "SELECT hr_rep_assignment.user_id, division.division," _<BR> & "location.location,hr_rep_assignment.division_ id, " _ <BR> & "hr_rep_assignment.location_id " _<BR> & "FROM hr_rep_assignment INNER JOIN " _ <BR> & "division ON hr_rep_assignment.division_id = division.division_id INNER JOIN " _<BR> & "location ON hr_rep_assignment.location_id = location.location_id " _<BR> & "WHERE hr_rep_assignment.user_id = &#039" & StrUsername & "&#039 "<BR> rs.open StrSql,conn<BR> <BR> %&#062;<BR> <BR> <BR> &#060;% do while not rs.eof%&#062;<BR> &#060;TR&#062;<BR> &#060;TD ALIGN= "left"&#062;&#060;INPUT TYPE = "checkbox" NAME = "location" VALUE = "checked"&#062;&#060;/TD&#062;<BR> &#060;TD&#062;&#060;CENTER&#062;&#060;%=rs("locati on_id")%&#062;&#060;/CENTER&#062;&#060;/TD&#062;&#060;input type="hidden" name="hidLocID" value="&#060;%=rs("location_id")%&#062;"&#062;<BR> &#060;TD&#062;&#060;CENTER&#062;&#060;%=rs("Locati on")%&#062;&#060;/CENTER&#062;&#060;/TD&#062;<BR> &#060;TD&#062;&#060;CENTER&#062;&#060;%=rs("Divisi on_id")%&#062;&#060;/CENTER&#062;&#060;/TD&#062;&#060;input type="hidden" name="hidDivID" value="&#060;%=rs("division_id")%&#062;"&#062;<BR> &#060;TD&#062;&#060;CENTER&#062;&#060;%=rs("Divisi on")%&#062;&#060;/CENTER&#062;&#060;/TD&#062;<BR> &#060;/TR&#062; <BR> &#060;%rs.movenext%&#062;<BR> &#060;%loop%&#062;<BR><BR>THIS IS MY DELETE QUERY<BR><BR>if request("deleteloc")&#060;&#062;"" then<BR> for each item in Request.Form <BR> if Request.Form("location") = "checked" then<BR> delsql = "delete from hr_rep_assignment " _<BR> & "where user_id = &#039" & userid & "&#039"_<BR> & "and Location_id = &#039" & request("hidLocID") & "&#039"_<BR> & "and division_id = &#039" & request("hidDivID") & "&#039" <BR> <BR> set delrs.Activeconnection = conn<BR> delrs.Open delsql<BR> <BR> end if <BR> next<BR> end if<BR> Response.Write delsql