I've not used the flash forms at all yet. So, I don't think I can be
of great help. Sorry. Have you looked at the documentation to see if
it mentions anything about checkboxes?
On 7/15/05, Saturday (Stuart Kidd) <[EMAIL PROTECTED]> wrote:
> 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>
> >
> >
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212029
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
