what i'm trying to do is when user submit the form,automatically the db table is update..

<% IF rsOrder.Fields.Item("stocklist") > 1 Then %>
<% rsOrder.Fields.Item("stocklist") =rsView.Fields.Item("stocklist").Value -1
rsOrder.Update%>

this is the error msg i got.
Error Type:
(0x80020009)
Exception occurred.

-ASPbeginner

I would suggest storing the value in a variable, properly convert it to a number, and then store it again:

<%
  Dim Stock
  Stock = CInt(rsOrder.Fields.Item("stocklist"))
  If Stock > 1 Then
    rsOrder.Fields.Item("stocklist") = Stock
    rsOrder.Update
  Else

  End If
%>

Why do you open and close so many ASP code blocks? They can all be withing one block of <% and %> tags....

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

ic..thank you so much.well i'm a new beginner and just start playing with ASP and i need to build a website that sell book online for my subject's project.now i got the idea how it goes..but can i write this way to make my stock colum in product table automatically substract when user submit their form

<%
  Dim Stock
  Stock = CInt(rsOrder.Fields.Item("stocklist"))
  If Stock > 1 Then

    rsOrder.Fields.Item("stocklist") = Stock - 1
    rsOrder.Update
  Else

  End If
%>

Sure, that would certainly work. In fact, that was what I was trying to write, but I forgot to subtract 1 in my code ;)

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

tq so much Imar.tq very2 much.