Hello, i have met a order problems now, that's happen between Order and Items.
My Order database consists fields: id, transId, totalAmount, orderType, stallFk and dateOrder.
Then Item database consists fields: id, qty, amount, unitPrice, productName, and orderFk.
I have get a list of orders which filter those sales-cancel transaction(which customer may make sales, but he/she wanna to cancel the sales), order by stallName and Date. Then i need to order those items by productName, then i implement Comparable in Item bean and use Collections.sort( ), but somehow it change my previous ordering, which it order by productName, not order by stallName, follow order by date and productName.
Any clue or solution fit this problems are welcome. Your reply is apprecited.
Thanks.
1  1248 
Hello, i have met a order problems now, that's happen between Order and Items.
My Order database consists fields: id, transId, totalAmount, orderType, stallFk and dateOrder.
Then Item database consists fields: id, qty, amount, unitPrice, productName, and orderFk.
I have get a list of orders which filter those sales-cancel transaction(which customer may make sales, but he/she wanna to cancel the sales), order by stallName and Date. Then i need to order those items by productName, then i implement Comparable in Item bean and use Collections.sort( ), but somehow it change my previous ordering, which it order by productName, not order by stallName, follow order by date and productName.
Any clue or solution fit this problems are welcome. Your reply is apprecited.
Thanks.
Erm, maybe some will confusing on stallFk and orderFk. stallFk actually is stall's id which is primary key; and orderFk is order's id , which also a primary key. About stallName, since Order database consists stallFk, then it can get stallName by stallFk. I hope this reply will make all more understand the flow and hope to get you'll reply soon.
Thanks.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Ken Fine |
last post by:
(originally posted to one of macromedia's groups; no help, so hopefully
someone here can help me out. I'm using VBScript ASP.)
When designing administrative interfaces to websites, we often need...
|
by: masood.iqbal |
last post by:
What is the standard C/C++ lexicograhic ordering of punctuation
characters with respect to each other and the alphanumeric characters?
--Masood
|
by: D. Dante Lorenso |
last post by:
First I created a function that selected the next available pin
code from a table of pre-defined pin codes:
CREATE FUNCTION "public"."get_next_pin_code" () RETURNS varchar AS'
DECLARE...
|
by: Ken Durden |
last post by:
Is there any way to control ordering of items in intellisense via
attributes?
For example, I have the following enum:
public enum ESeverity
{
Acceptable,
Low,
Medium,
|
by: Ryan |
last post by:
My project uses the /ORDER specifier to order functions as specified in file containing the decorated names of packaged functions (COMDATs). I am in the process of upgrading from VC6 to VC.NET 2003....
|
by: Matt Roberts |
last post by:
Please accept my apologies if this is answered elsewhere in the archives
or docs but I have searched without luck.
I've always assumed that default ordering of selects are based on a first
in...
|
by: Brian Tkatch |
last post by:
An ORDER BY a simple-integer inside a FUNCTION, results in SQL0440N,
unless the FUNCTION expects an INTEGER as its parameter. For example:
DECLARE GLOBAL TEMPORARY TABLE A(A CHAR(1))
INSERT INTO...
|
by: Benjamin M. Stocks |
last post by:
Hello all,
I've heard differing opinions on this and would like a definitive
answer on this once and for all. If I have an array of 4 1-byte values
where index 0 is the least signficant byte of a...
|
by: ChrisWang |
last post by:
Dear all,
I am reading the book "Core Python Programming". In the chapter talking about modules, it says the modules should follow this ordering:
import Python Standard Library modules
...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
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,...
|
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...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |
