Yes that would help :). But I am still getting no records returned. The sql seems to me like it is selecting only one record as the last line show 20040113, I would like it to return all the records from my database table, where the same date exists in the Directory.
Sort of a sub query, can you do that with QofQ?
If it were to tables I wouldn't this work?
Select * from table where left(#getfiles.name#,8) in (select #dateformat(GetCCrecords.BATCH_DATE,
> "yyyymmdd")# from datetable)
can't get it to work for me.
----- Original Message -----
From: Thomas Chiverton
To: CF-Talk
Sent: Tuesday, January 13, 2004 12:21 PM
Subject: Re: Problem with QofQ or just SQL
On Tuesday 13 Jan 2004 17:05 pm, Mickael wrote:
> <cfquery dbtype="query" name="GetJoin">
> Select * from GetFiles, GetCCRecords
> where 'Left(GetFiles.Name,8)' = '#dateformat(GetCCrecords.BATCH_DATE,
> "yyyymmdd")#'
> When I look at the SQL output I get this,
> Select * from GetFiles, GetCCRecords
> where 'Left(GetFiles.Name,8)' = '20040113'
Don't you mean
where 'Left(#GetFiles.Name#,8)' = '#dateformat(GetCCrecords.BATCH_DATE,
in your query ?
Oh, and use cfqueryparam tags :-)
--
Tom Chiverton
Advanced ColdFusion Programmer
Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 834900
Fax: +44 (0)1749 834901
web: www.bluefinger.com
Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple
Quay, BRISTOL. BS1 6EG.
*** This E-mail contains confidential information for the addressee
only. If you are not the intended recipient, please notify us
immediately. You should not use, disclose, distribute or copy this
communication if received in error. No binding contract will result from
this e-mail until such time as a written document is signed on behalf of
the company. BlueFinger Limited cannot accept responsibility for the
completeness or accuracy of this message as it has been transmitted over
public networks.***
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
