RE: Comparing two records within the query

2004-09-09 Thread B G
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

RE: Comparing two records within the query

2004-09-09 Thread Cornillon, Matthieu (Consultant)
>> 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

RE: Comparing two records within the query

2004-09-08 Thread B G
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

RE: Comparing two records within the query

2004-09-08 Thread Cornillon, Matthieu (Consultant)
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

Re: Comparing two records within the query

2004-09-08 Thread Deanna Schneider
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#

Re: Comparing two records within the query

2004-09-07 Thread Scott Brady
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

Re: Comparing two records within the query

2004-09-07 Thread Nando
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

Re: Comparing two records within the query

2004-09-07 Thread B G
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

OT (was "Re: Comparing two records within the query")

2004-09-07 Thread Damien McKenna
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

Re: Comparing two records within the query

2004-09-07 Thread Bryan Stevenson
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