quote:
Originally posted by:
Merle_Hanson
When I try this...
The data gets mixed up quite a bit...
<cfquery Name=try DATASOURCE="slopitch">
select * from schedule, league
WHERE GameDate = #todaydate# and emailcpt = 1
</cfquery>
Add something like this
where some_field_from_schedule = some_field_from_league
Once you get your query giving you a good answer, you might
need separate cfmail tags for the home and visiting captains,
depending on whether or not you want to tell them different things.
