473,769 Members | 2,376 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

'group by' plus a specific action on form

A doubt by a complete ignoramus.

I have a table, named ttt :
fields : state, continent, capital, currency.
The user tries to input values : "France", "Europe", "Nantes",
"Dollar"

A validation routine files following errors in error_table :
"France" "Europe" "Nantes" "Check The Capital"
"France" "Europe" "Dollar" "Check The Currency"

The table 'error_table' has one more entry :
"Germany" "Europe" "Geneva" "Check the Capital"

I want to show a form which displays all fields of error_table
plus a re-submit button per row. However, if there are more than
one entry, like France-Europe has 2 entries, only one row for
France should have its re-submit button enabled, the other rows
for France should have that button disabled. The idea is that
once the user of the form sees a disabled button, he knows
he needs to correct more than one field for that record.

TIA.
Nov 13 '05 #1
2 1325
dn*****@hotmail .com wrote:
A doubt by a complete ignoramus.

I have a table, named ttt :
fields : state, continent, capital, currency.
The user tries to input values : "France", "Europe", "Nantes",
"Dollar"

A validation routine files following errors in error_table :
"France" "Europe" "Nantes" "Check The Capital"
"France" "Europe" "Dollar" "Check The Currency"

The table 'error_table' has one more entry :
"Germany" "Europe" "Geneva" "Check the Capital"

I want to show a form which displays all fields of error_table
plus a re-submit button per row. However, if there are more than
one entry, like France-Europe has 2 entries, only one row for
France should have its re-submit button enabled, the other rows
for France should have that button disabled. The idea is that
once the user of the form sees a disabled button, he knows
he needs to correct more than one field for that record.

TIA.


I'm not sure what you need. I don't underst6and the 2 entires,
disable/enable buttons stuff since I can't see your form.

Anyway, I'd probably take another approach. I'd have a table that
would contain the country, continent, currency, capitol.

I would also create a table of continents since that is small and very
static.

Then a person could enter a country. In the afterupdate event I'd check
to see if that country existed. If so, I'd then read the record and
fill in the currency, capitol, and continent.

If it didn't exist, I'd then have a dropdown on continents, maybe a
dropdown on currency types and let a person add a currency type if it
doesn't exist.

It seems there is too much data entry work asked from the operators/users.

Nov 13 '05 #2
Salad <oi*@vinegar.co m> wrote -

I'm not sure what you need. I don't underst6and the 2 entires,
disable/enable buttons stuff since I can't see your form.

Anyway, I'd probably take another approach. I'd have a table that
would contain the country, continent, currency, capitol.


I had given the example of a table about Country to make
my case clear. The real-life table I am dealing with is
far more complex.

Still let me try to show how the form should look like.

Field1 Field2 F3 F4 Field5 Button
country1 continent1 only one error for record 1 Submit
country2 continent2 three errors for record 2 GRAY-OUT
country2 continent2 three errors for record 2 GRAY-OUT
country2 continent2 three errors for record 2 Submit
country3 continent3 only one error for record 3 Submit

F3, F4 fields carry info which we can edit. So we change the capitol
of France to Paris from the earlier wrong entry in F3.

If for (countryN, continentN) there is more than one error, only
one entry for that combo should have active submit button.
Other entries for that combo should have the submit button
grayed out.

----
Nov 13 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
2122
by: fowlertrainer | last post by:
Hi ! Sorry, but zope@zope.org is not send mails to me... So I trying with that list... 1.) I want to use query-string, and post datas in combined dictionary. I have a page that I must access with special query string, but it have post datas.
1
2925
by: lothar | last post by:
i want to traverse a set of messages in a Yahoogroups group from a Python program. to get to the messages of the group, one must log in. this presents, i think, two problems, 1) handling the form element for the login, which has a javascript submit routine, 2) keeping login state with cookies.
4
5926
by: Simon Niederberger | last post by:
Hi I need to create a MessageQueue in my C# service (running as SYSTEM). Users will have no permissions on this queue, so I can't look if messages are present. When setting MessageQueue.SetPermissions, I have the problem of knowing the Windows Group Name. I'd like to set Full Control to either Users or Everyone (doesn't really matter), but the service might run under English (Users, Everyone) or German Windows (Benutzer, Jeder). On a...
19
2025
by: What-a-Tool | last post by:
I have a school project (ASP) in which I have to call three different ASP pages from three different and identical (except for the form "action", obviously) HTM pages. This I have no problem with. However, as a personal learning project and challenge, I decided to see if I could code my initial HTM page to call any of the three ASP pages, depending on the condition of an option group. (3 buttons - id="function", id="sub", id="class") I...
15
3325
by: lawrence | last post by:
Is this the correct way to test for a method before I use it? createRange() is, I believe, an IE only method. function wrapSelectionInTag(selection, tag) { if (document.selection.createRange) { var range = document.selection.createRange(); if (range.parentElement() == element) range.text = '<' + tag + '>' + range.text + '<\/' + tag + '>'; }
6
8776
by: RobG | last post by:
I am writing a script to move an absolutely positioned element on a page by a factor using style.top & style.left. The amount to move by is always some fraction, so I was tossing up between Math.ceil/floor and parseInt +/- 1 to ensure the amount to move was at least 1 and in the right direction. I made a small test to see which one is faster and also included simply adding/subtracting 1. parseInt generally took 50% to 100% longer than...
1
1622
by: charlie fortune | last post by:
I want to use a form with several different possibilities of posting to a single PHP program. Is there a way of telling the action not just the name of the file, but which function to call with the information ?
61
620
by: John.L.Henning | last post by:
The new CPU benchmark from the Standard Performance Evaluation Corporation is announced http://www.spec.org/cpu2006/ Readers of comp.arch and comp.benchmarks may recall that I posted a call for benchmark candidates a few years ago. Thank you to those who responded. There were many contributions of real applications, as well as a variety of freely-available programs,
8
1910
by: Amil Hanish | last post by:
There is a site that has multiple FORM elements. How do I programatically POST to a specific form? The individual FORM elements have a <input name=xxx type=image return truethat is used to submit the form. <form name="form1" action=http://abc.com METHOD="POST"><input name="submit" type="image" onclick="return checkinput();"src="/img/submit.gif" WIDTH="56" HEIGHT="18">Amil
0
9586
marktang
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...
0
9423
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,...
0
10210
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9861
tracyyun
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...
0
8869
agi2029
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...
1
7406
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5446
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3956
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
2
3561
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.