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
[code=asp]
R1="update table set column='"&value &"' where column= "&id&""
Conn.execute R1

R2 = "update table set column='"&value &"' where column= "&id&""
Conn.execute R2
[/code]


But you can do it in mysql

Thanks