I don't use ms-sql, so I'm a bit rusty on the ansi standard left join
sytax. It'll look something like the below. (Note the change in the
from close, and the deletion of the one part of the where clause.)
The a and p (and now l) are just aliases, so I don't have to type out
your tablenames over and over.
As for your generating your checkboxes, there's no need to use
different checkbox names. Just do this:
<cfloop query="FindAttributes">
<cfinput type="checkbox"
name="attributes" label="#attributeName#" value="#attributeid#">
</cfloop>
On your action page, if any of the checkboxes have been selected, then
you'll get a comma-delimited list of all the checked ones. (If none
have been checked, form.attributes won't be there at all, so be
careful. Come to think of it, attributes is a reserved word, so call
it something else, too - maybe "attributesDesired" or something.
<cfquery name="FindMatches" datasource="user020">
SELECT profileID, userID, profileTitle, gender,
genderSeeking, screenName, location, locationID, locationName, age,
confirmationID, imageName, imageAuthorisation
FROM (tbl_020publicProfiles p LEFT OUTER JOIN
tbl_020publicProfilesAttributes a on p.profileid = a.profileid) INNER
JOIN tbl_020publicLocations l ON p.locationid = l.locationid
WHERE gender = '#form.genderSeeking#' AND genderSeeking =
'#form.gender#' AND confirmationID = 'yes' AND userID <>
<cfqueryparam value='#Client.KissMyDate_UserID#'
cfsqltype="cf_sql_integer" maxlength="4"> AND
tbl_020publicLocations.locationID =
tbl_020publicProfiles.location<cfif isDefined('form.location') and
form.location neq 0> AND location = '#form.location#'</cfif><cfif
isDefined('form.minAge') and form.minAge neq 0> AND age >=
#form.minAge#</cfif><cfif isDefined('form.maxAge') and form.maxAge
neq 0> AND age <= #form.maxAge#</cfif><cfif isDefined
('form.hasPhotograph') and form.hasPhotograph eq 1> AND
imageAuthorisation = 1</cfif>
AND a.attributeid IN (<cfqueryparam cf_sql_type="integer"
value="#form.attributeid#" list="yes")
ORDER by confirmationDate DESC
</cfquery>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:212020
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=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
