I think in some databases this will create a resultset with as many rows
as there are rows in up_user. "select 1 from dual" for example in
Oracle will return only 1 row. with one column with the value 1.
"select 1 from up_user" I think will return multiple rows.
---- Cris J H
Drew Wills wrote:
George Lindholm wrote:
The ultimate safe query would be "SELECT user_id FROM up_user WHERE
user_id = 1"
Or even...
SELECT 1 FROM up_user
provided the database schema will have been created in all cases before
the validationQuery is executed.
drew
--
You are currently subscribed to [email protected] as: [EMAIL
PROTECTED]
To unsubscribe, change settings or access archives, see
http://www.ja-sig.org/wiki/display/JSG/uportal-dev
