Re: Easy SQL query, brain died

use an outer join On Mon, 26 Nov 2001, Robert Everland wrote: > Here is what I am trying to do. I have a table that lists types of > stuff. In another table I refer to this stuff. So say one record will refer > to stuff 1. another to stuff 2, but maybe no stuff 3 > how would I make a quer

RE: Easy SQL query, brain died

PROTECTED]] Sent: Monday, November 26, 2001 2:57 PM To: CF-Talk Subject: Re: Easy SQL query, brain died Is this it? SELECT ts.*, tr.* FROMtbl_stuff ts, tbl_stuffReference tr WHERE ts.id_stuff = tr.id_stuff Hope it helps Michael Corrigan Programmer Endora Digital Solutions

RE: Easy SQL query, brain died

SELECT p.StuffName, (SELECT Count(c.Table2ID) FROM T_StuffChild c WHERE c.StuffID = p.StuffID) AS StuffCount FROM T_StuffParent p Then #QueryName.StuffName# = #QueryName.StuffCount# Or something along those lines. Alex Santantonio, Lead Developer Macromedia Coldfusion 5 Certified P

Re: Easy SQL query, brain died

Is this it? SELECT ts.*, tr.* FROMtbl_stuff ts, tbl_stuffReference tr WHERE ts.id_stuff = tr.id_stuff Hope it helps Michael Corrigan Programmer Endora Digital Solutions www.endoradigital.com 630/942-5211 x-134 - Original Message - From: Robert Everland To: CF-T

RE: (Easy SQL)

Take a look at the convert function. convert(char(8), signup_datetime, 1) as signup_date should give you what you want. -Original Message- From: Eric Dawson [mailto:[EMAIL PROTECTED]] Sent: Monday, April 16, 2001 2:09 PM To: CF-Talk Subject: (Easy SQL) I have a member table which conta

Re: (Easy SQL)

getdate() for now() getdate(-1) for yesterday and so on - Original Message - From: "Eric Dawson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, April 16, 2001 9:08 PM Subject: (Easy SQL) > I have a member table which contains > userid, signup_datetime > > I want to

RE: (Easy SQL) Case Sensitive?

case sensitivity. Is this correct? Erika "Twixt optimist and pessimist, The difference is droll; The optimist sees the doughnut, The pessimist, the hole." - McLandburgh Wilson -Original Message- From: John Wilker [mailto:[EMAIL PROTECTED]] Sent: Monday, April 16, 2001 4:26 P

RE: (Easy SQL)

6.4460 ___ DevTech, Inc.: Web Application Training & Development www.dev-tech.com 600 Stewart Street 15th Floor Seattle, WA 98101 -Original Message- From: Eric Dawson [mailto:[EMAIL PROTECTED]] Sent: Monday, April 16, 2001 2:00 PM To: CF-Talk Subject: RE: (Easy SQL) hmmm. I am

RE: (Easy SQL)

amount of record that are returned by using SQL aggregate functions. It seems like there should be a way to easily group by justthedatepartofadatetimefield but I can't find any syntax to do it. Eric From: "John Wilker" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: CF-T

RE: (Easy SQL)

dateformat(signup_datetime, "mm/dd/") Or use any mask you choose for the mm/dd/ part. Just run your query and grab the fields, then do the mask in CF when displaying the data. J. John Wilker Web Applications Consultant Allaire Certified ColdFusion Developer www.red-omega.com