Unable delete the data if it has space in between

[kirubagari]

Hi Experts,
If i want to delete a data ,lets say RayMond Roy the code that i developed have bugs to delete that.Without space i can able to delete without any problem.Please help

      response.write "<td align=center><img border=0 src=images/delete.gif alt=Delete onmouseover=this.style.cursor='hand' onmouseout=this.style.cursor='default' onclick=getcell('d','" & rsct("ID") & "','" & rsct("VALUE") & "');>"
 
 
if operation = "d" then
          cn.execute("delete from table where ID = " & detail) %>
            <script languange="javascript">
            document.operation.submit();
        </script>    <%
end if

[ariful alam]

you should use (') single quote in both side of variable details like

cn.execute("delete from table where ID = '" & detail & "'") %>

Hope works for you. :)

[PsychoCoder]

You dont need 's if the variable type is integer

[debasisdas]

As already suggested use single quotes on both the sides and trim the values before assigning to the variable if the variable is a string type. If it is a number type, you will not have any issue.

[kirubagari]

Hi All,

Still having issue.
Please help.Unable delete the data.The data type is Varchar

[Rabbit]

Use the single quotes as suggested. If you are still having a problem, you need to show us the new code.