use the ORDER BY clause with the SELECT
SELECT * FROM table ORDERBY fieldname ASC
(or replace ASC with DESC for descending order)
Siggy
- Original Message -
From: "Michael M. Ocana" [EMAIL PROTECTED]
To: "Mysql Lists" [EMAIL PROTECTED]
Sent: Wednesday, April 18, 2001 2:55 PM
Subject:
for 'asap' things like this, go use a chatroom / IRC type scenario. Or look
up TEXTAREA
What you're asking has NOTHING to do with databases.
siggy
- Original Message -
From: "Mike Roberts" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, April 12, 2001 6:49 AM
Subject: Need it
I have a (dumb!) program that performs SELECT statements with a quote around
the table and the fieldname; see the portion from the trace log below:
Cardfivefffe35e1:fffed875 EXIT SQLExecDirect with return code -1
(SQL_ERROR)
HSTMT 0x00cf17ac
UCHAR *