something like this:
<cfquery name="MyQuery">
select fristname, lastname from tbl_names
UNION
select "SomeFirstName" as fristname, "somelastname" as lastname
</cfquery>
(f you're using mysql that'll work... in Oracle you'd have to add "from
dual" to the second query... for db2, you'd have to add "from
sysibm.sysdummy1" or something like that... etc...
I often do this to add a "None selected" option to a list of option.
- Rick
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
