in!
>From: "Cornillon, Matthieu (Consultant)" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: RE: Comparing two records within the query
>Date: Thu, 9 Sep 2004 11:54:22 -0400
>
> >> Another option is to do a se
>> Another option is to do a self-join.
> This works, though I am not getting all rows returned and I haven't quite
> figured why yet. I hate to rely on the titles being exactly the same. I
> have data where one title contains the words DVD while the VHS version
> doesn't.
Unfortunate
Thanks
>From: "Cornillon, Matthieu (Consultant)" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: RE: Comparing two records within the query
>Date: Wed, 8 Sep 2004 13:12:36 -0400
>
>Another option is to do a self-jo
Another option is to do a self-join. I'll make some assumptions here that
may not be true, but which you can modify to fit the truth. Key among those
is that you have column called VID_MediaFormat holding either DVD or VHS.
(I know you don't have this, but you seem to have some way of determining
Are you using sqlserver? Aren't there some substring functions? If the 01
and 03 indicate the media type and the number before the dash will match,
couldn't you do something like this pseudocode:
select left(id, 4) AS primaryID, right(id, 2) AS mediatype,
othercolumnshere
from yourtable
#name#
It's probably too late for this, but I'd have a table just for the
movies themselves, and another table (one-to-many) where you match up
the movies with the various formats (a row for movie 1 in VHS, another
row for movie 1 in DVD, etc). In addition to making your work easier,
when the next big fo
EDIA_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
27;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
On Sep 7, 2004, at 4:48 PM, B G wrote:
> For example -01 = The Teletubbies meet Jason (VHS) -03 = The
> Teletubbies meet Jason (DVD).
Personally, I can't wait for the sequel, The Teletubbies vs Jason vs
Santa Claus.
--
Damien McKenna - Web Developer - [EMAIL PROTECTED]
The Limu Company
I'd strongly advise you add a column called Media_Type and use VHS or DVD as a media type codethat 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-mai
10 matches
Mail list logo