__________________________________
Daniel Farmer
Coldfusion Developer
P: 613.269.3463
>From: Rick Root <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: Re: adding a record to a query object
>Date: Tue, 13 Jul 2004 13:29:40 -0400
>
>In addition to using QueryAddRow() and QuerySetCell(), you could do
>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]
