> Les, without knowing the relationships between the tables (one-to-one,
> one-to-many, many-to-many) this may or may not produce your desired output,
> but lets start with the following:
Thanks, the below is a good start. What's got me buggered is that:
1. Any of the relationships *could* be
a. "one to many" (Lots of horror movies on one network)
b. "many to many" (all horror movies on all networks)
2. There may or may not be a value for some inputs.
So, you could search for:
1. all the directors of all the horror movies
2. all the directors of all the horror movies on CBS
3. all the directors of all the horror movies on CBS
with the word "blood" in the title.
4. all the directors of all the horror movies on CBS
with the word "blood" in the title. and that are MUSICALS
5. ...and even more....
I'm slowly getting there.
Is there a damned good book/tutorial somewhere on writing these things?
As I previously stated, I can get it to work if I write 14 little
queries and use a bunch of "and PlayerID in
(#valuelist(players.PlayerID)#)" statements.
Luckily, "trim" isn't needed on a lot of variables, as they're drop down
boxes on the forms.
Thanks to all that have replied so far.
> SELECT
> p.FName,
> p.LName,
> s.Title,
> s.Network,
> c.CreditType
> FROM
> Shows s
> INNER JOIN SubjectMatter sm ON (s.ShowID = sm.ShowID)
> INNER JOIN Credits c ON (s.ShowID = c.ShowID)
> INNER JOIN Players p ON (sShowID = p.ShowID)
> WHERE
> s.Network =
> <cfqueryparam
> cfsqltype="CF_SQL_VARCHAR"
> null="false"
> value="#trim(form.network)#" />
> AND
> c.CreditType =
> <cfqueryparam
> cfsqltype="CF_SQL_VARCHAR"
> null="false"
> value="#trim(form.credittype)#" />
> AND
> s.Logline LIKE
> <cfqueryparam
> cfsqltype="CF_SQL_VARCHAR"
> null="false"
> value="%#trim(form.logline)#%" />
> ORDER BY
> p.LName
--
-----------
Les Mizzell
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222631
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
