|
Home > Archive > IIS ASP > February 2007 > Updating Records in two tables
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Updating Records in two tables
|
|
|
| Using ASP and Access is it possible for me to update recordsets in two
different tables from data collection in one page? Basically, I need
user input on 1 page that contains multiple form field areas and upon
submit it updates the records in two different tables. Any advice,
direction, or suggestions are appreciated.
thanks
| |
| Bob Barrows [MVP] 2007-02-23, 1:21 am |
| Matt wrote:
> Using ASP and Access is it possible for me to update recordsets in two
> different tables from data collection in one page? Basically, I need
> user input on 1 page that contains multiple form field areas and upon
> submit it updates the records in two different tables. Any advice,
> direction, or suggestions are appreciated.
>
> thanks
It's easy if you use sql statements for updates rather than recordsets.
There is nothing preventing you from executing as many sql statements as you
desire.
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
| |
|
| On Feb 22, 6:34 pm, "Bob Barrows [MVP]" <reb01...@NOyahoo.SPAMcom>
wrote:
> Matt wrote:
>
>
> It's easy if you use sql statements for updates rather than recordsets.
> There is nothing preventing you from executing as many sql statements as you
> desire.
> --
> Microsoft MVP - ASP/ASP.NET
> Please reply to the newsgroup. This email account is my spam trap so I
> don't check it very often. If you must reply off-line, then remove the
> "NO SPAM"
I did forget to mention that my two different tables are in two
different databases as well. Does that matter? I have a page that I
wish to pull and display data from two tables in two different
databases. Then I want my users to be able to edit the fields and
upated the records. Make sense?
| |
| Bob Barrows [MVP] 2007-02-23, 7:17 pm |
| Matt wrote:
> On Feb 22, 6:34 pm, "Bob Barrows [MVP]" <reb01...@NOyahoo.SPAMcom>
> wrote:
> I did forget to mention that my two different tables are in two
> different databases as well. Does that matter?
No, that doesn't matter at all. Why would it? Just open a connection to
each database and construct and run a sql statement to perform the
updates.
> I have a page that I
> wish to pull and display data from two tables in two different
> databases. Then I want my users to be able to edit the fields and
> upated the records. Make sense?
Yes. it did the first time, actually.
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
|
|
|
|
|