Skip to main content
A
Anonymous
December 1, 2008
Question

Help with CFMAIL QUERY?

  • December 1, 2008
  • 1 reply
  • 1246 views
OK- in order to help solve my dilemma, I have posted the DB (Access) table relationship grid here:

http://www.cityofnewport.com/vendor/relations.cfm

The problem is to send one email message (located in the lookup_vendor table) to only those vendor contacts (from lookup_contact) who match the code ID - vendor_ID and code ID reside in the junction table junction_vendor_CCC.

I know it's probably an easy one, but I can't get it to work- today's the due day!

I tried query of queries, inner joins etc. etc.

I appreciate any help.... thanks.

newportri
This topic has been closed for replies.

1 reply

B
BALAJI_JAY
Participating Frequently
December 4, 2008
Can you post your cfcode that you use to do the cfmail? That will be needed to tell where is the error?
A
Anonymous
December 4, 2008
Jay:

Thanks for your response- all code attached.
D
dchard
Inspiring
December 4, 2008
Hi

Have you tried putting your cfmail inside the body? I'm not sure if being inside or outside the body affect your cfmail...but it doesn't hurt to try

Hope it helps
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices