Navneet Kakkar
|
Posted: 01/14/2004, 2:54 AM |
|
Dear All
I m using ASP and Access
I need to update two different table from two different connections. the
record / maint page contains two forms.
I want to update both tables on click of the submit button from any of the
record / form.
--
Thanks
luv
Navneet
aquananu@yahoo.com
9811153443
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.561 / Virus Database: 353 - Release Date: 1/13/2004
|
|
|
peterr
Posts: 5971
|
Posted: 01/13/2004, 5:21 PM |
|
The HTML standard doesn't allow submitting multiple forms with one button.
However, many of our examples show how to update additional tables after the primary table/form is updated.
Please refer to:
- Shopping Cart page in the Store example - the "On Click" even of the "Purchase" button inserts a new order record into the database.
- "Updating Many-to-Many via Multi-select ListBox" example in CCS Example Pack - the "After Insert" and "After Update" events are used to insert records into additional tables.
Also refer to the documentation: http://docs.codecharge.com/studio/html/ProgrammingTechn...eCustomSQL.html
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
Navneet Kakkar
|
Posted: 01/14/2004, 11:45 AM |
|
Dear Peter
Thanks for your help.
Cud you tell me which sub (of the non submitted form) to call from after
update of the submitted form, so that the execution of code takes place as
if the second submit button has been clicked too.
--
Thanks
luv
Navneet
aquananu@yahoo.com
9811153443
"peterr" <peterr@forum.codecharge> wrote in message
news:6400499b775455@news.codecharge.com...
> The HTML standard doesn't allow submitting multiple forms with one button.
>
> However, many of our examples show how to update additional tables after
the primary table/form is updated.
> Please refer to:
> - Shopping Cart page in the Store example - the "On Click" even of the
"Purchase" button inserts a new order record into the database.
> - "Updating Many-to-Many via Multi-select ListBox" example in CCS Example
Pack - the "After Insert" and "After Update" events are used to insert
records into additional tables.
>
> Also refer to the documentation:
> http://docs.codecharge.com/studio/html/ProgrammingTechn...HowTo/WorkingWi
thDatabases/ExecuteCustomSQL.html
>
> _________________
> Peter R.
> YesSoftware Support Representative
> http://support.codecharge.com
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
peterr
Posts: 5971
|
Posted: 01/19/2004, 2:21 PM |
|
This will not help you, again, because the HTML standard doesn't allow submitting multiple forms with one button.
Therefore the Web browser will simply submit one form and all information on the 2nd fom wil be lost. There will be no reason to "call" the 2nd form.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
kmcook
Posts: 6
|
Posted: 01/19/2004, 2:41 PM |
|
|
|
|
kmcook
Posts: 6
|
Posted: 01/19/2004, 2:42 PM |
|
Oops,
meant this - maybe some ideas to help found here.
http://developer.irt.org/script/form.htm#7.3
|
|
|
peterr
Posts: 5971
|
Posted: 01/19/2004, 2:49 PM |
|
BTW, please also see: http://forums.codecharge.com/posts.php?post_id=27260
As there I suggested a method of submitting 2 forms using JavaScript. Unfortunately I don't have an example.
However, you may notice that almost no Websites can submit multiple forms with one button. If you find such Website then you can look at their JavaScript to get ideas. And if you don't find such Websites then why would you want to do something that no one else did?
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
Henkie
|
Posted: 04/15/2004, 1:10 AM |
|
|
|
|