Hi,
I wonder if someone could help me out with some queries I'm running on a
scheduled task.
I need to send out outstanding invoices, including details of what they have
bought (i.e. an Advert - details of which are in advert_details). Once
done, I need to set the "Sent" column of the Invoices
What problems are you exactly having?
Won
-Original Message-
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 12:15 PM
To: CF-Talk
Subject: Advanced queries
Hi,
I wonder if someone could help me out with some queries I'm running on a
scheduled task.
I
7;
I'm assuming you're using Access, and therefore the yes and no without
quotes should be ok.
Bob
-Original Message-
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: November 30, 2000 12:15 PM
To: CF-Talk
Subject: Advanced queries
Hi,
I wonder if someone could help me out with some
like.
At least I think the update query I gave you was correct.
Bob
-Original Message-
From: Bob Silverberg [mailto:[EMAIL PROTECTED]]
Sent: November 30, 2000 6:32 PM
To: [EMAIL PROTECTED]
Subject: RE: Advanced queries
Without any report of error messages it's hard to say if there&#
roups: dotcom.lists.cftalk
Sent: Friday, December 01, 2000 8:56 AM
Subject: RE: Advanced queries
> What problems are you exactly having?
>
> Won
>
> -Original Message-
> From: W Luke [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, November 30, 2000 12:15 PM
> To: C
advert_details
which match an email address in payments or invoices.
Thanks
Will
- Original Message -
From: ""Bob Silverberg"" <[EMAIL PROTECTED]>
Newsgroups: dotcom.lists.cftalk
Sent: Friday, December 01, 2000 9:18 AM
Subject: FW: Advanced queries
> OK, it&#x
;which match an email address in payments or invoices.
>
>Thanks
>
>Will
>
>- Original Message -
>From: ""Bob Silverberg"" <[EMAIL PROTECTED]>
>Newsgroups: dotcom.lists.cftalk
>Sent: Friday, December 01, 2000 9:18 AM
>Subject: FW: Adv
On 12/1/00, W Luke penned:
>Instead of returning 2 records, which it should have, it returned 22 (and
>incidentally email all 22!) Here's the query:
>
>
>SELECT
>advert_details.body,advert_details.subject,advert_details.end_date,advert_de
>tails.start_date,advert_details.ID,advert_details.email,a
> >What am I missing? I think it's pulling all adverts from advert_details
> >which match an email address in payments or invoices.
>
> You'll need to add 1 more join since you are using 3 tables in your
> From clause. You have payments joined to advert_details. Now you need
> to join invoices
Hi,
First of all, many thanks to those who solved my last problem ("Advanced
queries" 30/11). This one is a little more complicated, so any hints or
tips are appreciated.
I have 2 tables - advert_details and mybounty. The latter has 5 fields; ID,
email, word1, word2 and word3. Run
Hi Guys/Girls
I just have a quick query for you please, been trying to figure it out all
week but having some problems so be very grateful if you could lend a hand
please, just trying to come to grips with the concepts.
I have used this approach and it works well using the following query and
On 12/3/00, W Luke penned:
>
>
>SELECT mybounty.watch1, mybounty.watch2, mybounty.watch3, mybounty.email,
>advert_details.body, advert_details.ID
>FROM mybounty, advert_details
>WHERE advert_details.body like mybounty.watch1
>
>
>I've commented out the "OR" part because it was retreiving no resul
I cant say that ive used LIKE in a table join either but its always been
common practice to encase the parameters in single quotes like bob just
said.
>From: Bud <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: Re: Advance
> I cant say that ive used LIKE in a table join either but its always been
> common practice to encase the parameters in single quotes like bob just
> said.
I had tried that, but resorted to removing them seeing as they hadn't
helped. I'm really confused with this - the code I originally poste
ils.body)%' OR
UPPER(mybounty.watch3) like '%UPPER(advert_details.body)%'
That might not work too. But your DB schema needs a lot of normalization as
it stands now.
Won
-Original Message-
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 03, 2000 7:38 PM
To: CF
This should be easy, since it looks like everything is coming from the same
table.
In this query, just add "area" to your select
select dloadid, dltitle, dldate, area
from downloads
ORDER BY dldate DESC
Then, in your output, add the link:
http://testpages/downloadsmore.cfm?area=#latestdl.area
16 matches
Mail list logo
