Database

CREATE TABLE [1384/6] <br />
(<br />
OrderTable int NOT NULL ,<br />
OrderNo int NOT NULL,<br />
OrderTypeIDn text(20) NOT NULL, <br />
Report text(254) NOT NULL,<br />
Receptionist text(50) NOT NULL ,<br />
Cashier text(254) NOT NULL,<br />
Day text(15) NOT NULL,<br />
TimeInstant text(15) NOT NULL,<br />
Description text(254) <br />
)<br />

<br />
CREATE TABLE [1384/6] <br />
(<br />
OrderTable int NOT NULL ,<br />
OrderNo int NOT NULL,<br />
OrderTypeIDn nvarchar(20) NOT NULL,<br />
Report nvarchar(254) NOT NULL,<br />
Receptionist nvarchar(50) NOT NULL ,<br />
Cashier nvarchar(254) NOT NULL,<br />
DayField nvarchar(15) NOT NULL,<br />
TimeInstant nvarchar(15) NOT NULL,<br />
Description nvarchar(254) <br />
)<br />

SELECT ticker, name, MAX(close) - MIN(close) AS difference
FROM MyStockTable
GROUP BY ticker, name

My: Blog | Photos
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More

Ticker  Name                     Close
PRD     Pernod Ricard            9000
PRD     Pernod Ricard            9058
PRD     Pernod Ricard            8945
PRD     Pernod Ricard            8988
SSE     Scottish & Southern Elec  978
SSE     Scottish & Southern Elec  977
SSE     Scottish & Southern Elec  969
SSE     Scottish & Southern Elec  975
EZY     EasyJet                   235
EZY     EasyJet                   240
EZY     EasyJet                   233
EZY     EasyJet                   237
EZY     EasyJet                   232

SELECT Ticker, Name, MIN(Close) AS MinClose, MAX(Close) as MaxClose
FROM StockData
GROUP BY Ticker, Name

Ticker  Name                     MinClose MaxClose
PRD     Pernod Ricard            8945     9058
SSE     Scottish & Southern Elec  969      978
EZY     EasyJet                   233      240

My: Blog | Photos
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More

-- modified at 14:21 Wednesday 31st August, 2005

if (getPicture() != null) {
    ByteArrayInputStream inStream;
    inStream = new ByteArrayInputStream(getPicture());
    rqt.setBinaryStream(1, inStream, inStream.available());
    // Where rqt is a PreparedStatement
}
 
in my bean :

    private byte[] picture;
 
    public byte[] getPicture() {
        return picture;
    }