A) query for all records
B) create a new query object (adding some columns)
C) loop through original query (and perhaps the new query, nested
within it) and derive the result set you need to display your form to
the user. maybe the new result set has a boolean to display/not
display the radio buttons. Maybe you'd use a combination of both
queries in your form to display and set the values of the choices.
That's how i'd try and approach it. i'll let you think it through to the end.
On Tue, 07 Sep 2004 17:35:24 -0500, B G <[EMAIL PROTECTED]> wrote:
> That may be possible. Though it's not always up to me to get the marketing
> dept and the DB people to do work so my life is easier.
>
> Nonetheless...The basic nature of this kind of compare is eluding me. Even
> if I had two records, one with DVD and one with VHS in the MEDIA_TYPE field,
> I'd still need to have some way to identify that while displaying the
> records.
>
> >From: "Bryan Stevenson" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: CF-Talk <[EMAIL PROTECTED]>
> >Subject: Re: Comparing two records within the query
> >Date: Tue, 7 Sep 2004 13:52:17 -0700
> >
> >I'd strongly advise you add a column called Media_Type and use VHS or DVD
> >as a media type code....that will make your life much easier ;-)
> >
> >Bryan Stevenson B.Comm.
> >VP & Director of E-Commerce Development
> >Electric Edge Systems Group Inc.
> >phone: 250.480.0642
> >fax: 250.480.1264
> >cell: 250.920.8830
> >e-mail: [EMAIL PROTECTED]
> >web: www.electricedgesystems.com
> >
> >
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
