Calvin
Just got the a single checkbox ??? turned on debugging
Queries
getgroups (Records=72, Time=40ms)
SQL =
SELECT groupid, groupname, permname, permid
FROM groups, permissions
----------------------------------------------------------------------------
----
Execution Time
40 milliseconds
0 ms C:\INETPUB\WWWROOT\APPLICATION.CFM
40 ms C:\INETPUB\WWWROOT\UNTITLED288.CFM
10 ms STARTUP, PARSING, & SHUTDOWN
This is the code I used
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title>Untitled</title>
</head>
<CFQUERY DATASOURCE="perm" NAME="getgroups">
SELECT groupid, groupname, permname, permid
FROM groups, permissions
</CFQUERY>
<cfset ListGroupID = ValueList(getgroups.GroupID)>
<body>
<cfscript>
tChecked = '';
if (ListFind(ListGroupID,qryGetUserGroupsPerms.GroupID))
tChecked = ' checked';
</cfscript>
<input type="checkbox" name="groupid" value="#getgroups.groupid#"#tChecked#>
</body>
</html>
and got
----- Original Message -----
From: "Calvin Ward" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, June 19, 2003 11:01 AM
Subject: Re: Why is this not working the way it should ???
> Just for fun, try:
>
> <snip>
>
> <CFQUERY DATASOURCE="perm" NAME="getgroups">
> SELECT groupid, groupname, permname, permid
> FROM groups, permissions
> </CFQUERY>
> <cfset ListGroupID = ValueList(getgroups.GroupID)>
>
> <snip>
>
> <cfscript>
> tChecked = '';
> if (ListFind(ListGroupID,qryGetUserGroupsPerms.GroupID))
> tChecked = ' checked';
> </cfscript>
>
> <input type="checkbox" name="groupid"
value="#getgroups.groupid#"#tChecked#>
>
> <snip>
>
> I find that the seperation of the logic and the display of the tag makes
it
> easier for me to trouble-shoot. The real problem appeared to be that you
> were referencing the same query on both sides of the if statement for the
> checkbox, which to me was harder to spot having it all strung in the html
> like that.
>
> Hope this helps,
>
> Calvin
>
> ----- Original Message -----
> From: "Ian Vaughan" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, June 19, 2003 4:50 AM
> Subject: Why is this not working the way it should ???
>
>
> > Any idea why the code below is not working the way it should, as you can
> see
> > from my cfif statements the checkbox fields should only be checked if
> there
> > is a value in the database for that entry and the same for the
permissions
> > select.
> >
> > But at present every checkbox is checked and every select box is
populated
> > with a value when it should'nt be ?
> >
> > Can anybody see why this is occuring is it my queries, the placing of my
> > cfoutputs? or the actual cfif statements ??
> >
> >
> > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> >
> > <html>
> > <head>
> > <title>Untitled</title>
> > </head>
> >
> > <body>
> > <CFQUERY DATASOURCE="perm" NAME="updateusers">
> > SELECT *
> > FROM users
> > WHERE id = #session.id#
> > </CFQUERY>
> >
> >
> > <CFQUERY DATASOURCE="perm" NAME="getgroups">
> > SELECT groupid, groupname, permname, permid
> > FROM groups, permissions
> > </CFQUERY>
> >
> > <cfquery datasource="perm" name="qryGetUserGroupsPerms">
> >
> > SELECT users.id AS "userid",
> >
> > users.fname,
> > users.lname,
> > users.username,
> > users.password,
> > users.email,
> > users.position,
> > users.division,
> > groups.groupname,
> > permissions.permname,
> > userpermissions.groupid,
> > userpermissions.permid
> >
> > FROM ((
> > users INNER JOIN usergrouppermissions AS userpermissions ON users.id
=
> > userpermissions.userid)
> >
> > INNER JOIN permissions AS permissions ON userpermissions.permid =
> > permissions.permid)
> >
> > INNER JOIN groups AS Groups ON userpermissions.groupid =
groups.groupid
> >
> > WHERE (((users.id)=#session.id#));
> >
> > </cfquery>
> >
> > <table>
> > <cfoutput query="getgroups" group="groupID">
> > <tr>
> > <td width="39%" height="20">#getgroups.groupname#</td>
> >
> > <td width="3%" align="center" height="20">
> > <input type="checkbox" name="groupid" value="#getgroups.groupid#"
> <cfif
> > getgroups.GroupID IS getgroups.groupid> checked</cfif>>
> > </td>
> >
> > <td width="45%" height="21">
> > <select size="1" name="perm#qryGetUserGroupsPerms.groupid#">
> > <cfoutput>
> >
> >
> > <option value="#getgroups.PermID#" <cfif
> qryGetUserGroupsPerms.PermID
> > IS getgroups.PermID>selected</cfif> >#getgroups.PermName#</option>
> > </cfoutput>
> > </select>
> > </td>
> >
> > </tr> </cfoutput>
> > </table>
> >
> > </body>
> > </html>
> >
> >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at
http://www.coolfusion.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
