Hey guys,
I currently have a giant client editor form in ASP/SQL. The form is
fine. The problem is that there are several sub-forms that store their
data in other tables. Which gets cluttered. For example, I can't let
users add data in these sub-forms until the main form is completed and
an autonumbered ID is generated.
We're taking a few months out of new developments to go back and fix a
bunch of things (like this), and I was wondering what the best way
would be (if anyone has run in to a similar issue) to allow a large
editor that touches multiple tables to have one giant master "Save"
button that validates everything and that doesn't make changes until
it's clicked.
Sadly, transactions are unable to span across multiple pages (and I
don't wanna store recordsets as session objects), and they wouldn't
work anyways, since in the event of new additions, I would need to wait
until I have that autonumbered ID generated before I attempted to store
anything in one of the smaller tables.
I was thinking of perhaps session variables that corresponded with the
names of the tables that I was working with that had an array of data
that corresponded with {fieldName} => "Value," and then loop through it
and validate it, then execute the appropriate SQL.
Cliffs: In ASP/SQL, does anyone know of some industry-standard way to
have one "Save" button store data collected through multiple pages,
assuming that in some cases, when adding a new record, we'd need to get
the value of the autogenerated "ID" field first before saving data that
affects other tables?
Wow... what an obnoxiously long question. If you're bored, feel free to
read through :) 1 1275
"Tim Feeley" <ti******@gmail .com> wrote in message
news:11******** **************@ g14g2000cwa.goo glegroups.com.. . Hey guys,
I currently have a giant client editor form in ASP/SQL. The form is fine. The problem is that there are several sub-forms that store their data in other tables. Which gets cluttered. For example, I can't let users add data in these sub-forms until the main form is completed and an autonumbered ID is generated.
We're taking a few months out of new developments to go back and fix a bunch of things (like this), and I was wondering what the best way would be (if anyone has run in to a similar issue) to allow a large editor that touches multiple tables to have one giant master "Save" button that validates everything and that doesn't make changes until it's clicked.
Sadly, transactions are unable to span across multiple pages (and I don't wanna store recordsets as session objects), and they wouldn't work anyways, since in the event of new additions, I would need to wait until I have that autonumbered ID generated before I attempted to store anything in one of the smaller tables.
I was thinking of perhaps session variables that corresponded with the names of the tables that I was working with that had an array of data that corresponded with {fieldName} => "Value," and then loop through it and validate it, then execute the appropriate SQL.
Cliffs: In ASP/SQL, does anyone know of some industry-standard way to have one "Save" button store data collected through multiple pages, assuming that in some cases, when adding a new record, we'd need to get the value of the autogenerated "ID" field first before saving data that affects other tables?
Wow... what an obnoxiously long question. If you're bored, feel free to read through :)
Each form populates hidden fields on the next. When you get to the Master
form, it contains hidden fields with values from all the previous forms. One
submit button on the Master form.
--
John Blessing http://www.LbeHelpdesk.com - Help Desk software priced to suit all
businesses http://www.room-booking-software.com - Schedule rooms & equipment bookings
for your meeting/class over the web. http://www.lbetoolbox.com - Remove Duplicates from MS Outlook http://www.outlook-find-replace.com - Find & Replace in Emails, Contacts,
Appointments, Tasks and Notes This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Dave Benjamin |
last post by:
Hey good people,
I've been doing a lot of simultaneous Jython and CPython programming lately,
and just wanted to say, with no intended ill will toward any of the
individuals who have been generous enough to make the two languages
possible, that, well, they're kinda different.
I guess it was inevitable, but with Jython stuck at Python 2.1, it's not
really the same language as CPython is today. You still have to type "from
__future__...
|
by: David P. Jessup |
last post by:
Lets see if I can explain this so I can get a good answer =)
I'm trying to speed up a file search via FSO. I have a database that
contains the exact path where files can be found and an "index" number
assigned to each file. This index number is part of each files name.
Example:
DB columns
filepath flindex
pathname 123
pathname 124
|
by: Dan |
last post by:
I've run into an interesting problem, and seemed to have stumped 3
newsgroups and 2 other forums.
For some reason when I try to insert a record into a SQL table that has a
Text column, the returned autogenerated Identity is wrong (on the VB side).
This only occurs if the length of the value inserted for the text column is
>= 8002.
I've included a simple example below.
|
by: Tim Clacy |
last post by:
How is a 64 bit type defined in strict C++?
It seems C has support for 'long long' since C99, but not so for C++?
Looking through one compiler vendor's standard library headers has clouded
the issue somewhat; it uses __int64 in some places (with a comment about
strict) but freely uses 'long long' in other places. In any case, these
standard library headers are supposed to be 'standard' w.r.t. C and C++
aren't they? How can a standard...
|
by: Kelvin |
last post by:
hi everyone...
i discover this accentally when i was debugging a program...
here is the problem( or maybe not :) )
*************CODE*******************
#include <iostream>
using namespace std;
int main(){
int i = 0;
| |
by: William Payne |
last post by:
Hello, I have a variable of type unsigned long. It has a number of bits set
(with set I mean they equal one). I need to determine those bits and their
position and create new numbers from them. For example, consider this
four-bit number:
1100
from this number I want to extract two numbers:
1000 and 100
had the four-bit number been 0101 I would want to extract 100 and 1.
How should I do this? I wish I had some code to post but I don't...
|
by: Paul |
last post by:
I found a great site for CSS tempaltes, http://blog.html.it/layoutgala/ .
I downloaded them, and played around with them. Then I tried to use the
template in as ASP.Net MasterPage, but everything seems to break. For
example, Number 13 is coded as follows:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"
"http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
<title>Layout 13</title>
<meta http-equiv="content-type" content="text/html;...
|
by: comp_novice |
last post by:
Hi,
I would like to store a key-value pair and then retrieve the value
based on a given key value.
I am quite conversent in C++ but this needs be implemented in C.
Would appriciate any idea how to achieve this in C?
Thanks in advance
|
by: Ron |
last post by:
Hi All,
I've got a requirement to print an existing statement printing report to
another printer that's set up to print on a wide-carriage, bottom-fed
dot-matrix printer. That printer's sole job is to print the company's
existing mailer statements (about 5 copies deep with their copy on top,
envelope underneath that, tractor tears on sides, then inside closed up
envelope is client's copy of bill, plus return envelope, plus stub to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |