Yeah, i remember now why i did that weird thing with the loop - i
couldn't seem to get it to work.
If I put the below in, the flash form will not load (although no
error comes up either).
<cfloop query="FindRelationshipTypes">
<cfinput type="checkbox"
name="relationshipTypes" label="#relationshipTypeName#"
value="#relationshipTypeID#">
</cfloop>
But if i add the _relationshipTypeID to make each name in the loop
unique it comes up no problem.
Do you know why this is happening by any chance? Is it a flash form
problem?
<cfloop query="FindRelationshipTypes">
<cfinput type="checkbox"
name="relationshipTypes_#relationshipTypeID#"
label="#relationshipTypeName#" value="#relationshipTypeID#">
</cfloop>
Thanks,
Stuart
ps: i've changed the attributes to relationshipTypes instead.
On 15 Jul 2005, at 18:43, Deanna Schneider wrote:
> 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:212026
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
