469,090 Members | 1,310 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,090 developers. It's quick & easy.

update the join table

102 100+
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
Jun 21 '07 #1
5 1413
r035198x
13,262 8TB
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?
Jun 21 '07 #2
lyealain
102 100+
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..
Jun 22 '07 #3
code green
1,726 Expert 1GB
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?
Jun 22 '07 #4
lyealain
102 100+
Are you asking how to construct a multiple table UPDATE query?
yes .right.... thanks
Jun 26 '07 #5
code green
1,726 Expert 1GB
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
Jun 28 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Narine | last post: by
17 posts views Thread by kalamos | last post: by
2 posts views Thread by Mike Leahy | last post: by
7 posts views Thread by Jon Maz | last post: by
3 posts views Thread by Michel Esber | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.