Updating two table

[klee]

Hi,

please show me the example how to update two table in active server pages

i created update select, update entry, and update form, it works only on one table.

thanks

[jeffstl]

The simplest answer is that you need 2 insert statements executed right in a row.

If you are having problems with this it would probably be best to post the specific SQL or ASP you are having problems with.

[idsanjeev]

Hi klee
If you wants to update more then one table then you have to use more then one update statement in oracle like

      R1="update table set column='"&value&"' where column= "&id&""
      Conn.execute R1
 
      R2 = "update table set column='"&value&"' where column= "&id&""
      Conn.execute R2
 

But you can do it in mysql

Thanks