update the join table

[lyealain]

hi.. let say i have this statement

dim A, B

A = "select fa.partnumber, bom.GOD
from fa,bom
where fa.partnumber= bom.partnumber"

set B= conn.execute(A)

<input type=textbox name=1 value="&B.fields("partnumber")&">

<input type=textbox name=1 value="&B.fields("GOD")&">

How do i update this statement? with one click

[r035198x]

hi.. let say i have this statement

dim A, B

A = "select fa.partnumber, bom.GOD
from fa,bom
where fa.partnumber= bom.partnumber"

set B= conn.execute(A)

<input type=textbox name=1 value="&B.fields("partnumber")&">

<input type=textbox name=1 value="&B.fields("GOD")&">

How do i update this statement? with one click

I'm not sure I get your question. Do you mean how do I execute the SQL?

[lyealain]

I'm not sure I get your question. Do you mean how do I execute the SQL?

yes.. yes... how do i update it?? because got 2 tables data..

[code green]

How do i update this statement? with one click

how do i update it?? because got 2 tables data..

Are you asking how to construct a multiple table UPDATE query?

[lyealain]

Are you asking how to construct a multiple table UPDATE query?

yes .right.... thanks

[code green]

I am sorry. I just don't understand what your problem is. It may help you and us if when writing code you try to seperate HTML SQL and the scripting language as much as possible. This really is an awful mess