How to use checkbox data in a query
I have a form which i need to select the user from, this uses a query to populate the checkboxes.
This works fine, submits data to the next page and then I need to use the names selected in the checkboxes to do another query.
The problem is the names are submitted as:
name1,name2,name3,name4
How do I seperate these names to use them as individual variables?
I understand I will need to create a query for each name, and that is fine, how do I seperate them in the first place though?
This works fine, submits data to the next page and then I need to use the names selected in the checkboxes to do another query.
The problem is the names are submitted as:
name1,name2,name3,name4
How do I seperate these names to use them as individual variables?
I understand I will need to create a query for each name, and that is fine, how do I seperate them in the first place though?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
_agx_
ie. You could run one query to get all of the selected names, instead of separate queries.
ASKER
Here is what I have so far.
FORM PAGE:
<CFOUTPUT Query="selectgroup">
<INPUT Type="Checkbox" Name="prjgroup"
Value="#username#">#fullna
</CFOUTPUT>
PROCESSING PAGE:
<cfquery datasource="#Application.D
SELECT *
FROM users
WHERE username IN(#form.prjgroup#)
</cfquery>
This does seem to seperate the values, however i get a different error:
Invalid column name 'second checkbox option'
FORM PAGE:
<CFOUTPUT Query="selectgroup">
<INPUT Type="Checkbox" Name="prjgroup"
Value="#username#">#fullna
</CFOUTPUT>
PROCESSING PAGE:
<cfquery datasource="#Application.D
SELECT *
FROM users
WHERE username IN(#form.prjgroup#)
</cfquery>
This does seem to seperate the values, however i get a different error:
Invalid column name 'second checkbox option'
ASKER
also, not sure what you mean by cfsqltype="your type">
ASKER
now have
<cfquery datasource="#Application.D
SELECT *
FROM users
WHERE username IN(<cfqueryparam list="yes" value="#form.prjgroup#" cfsqltype="cf_sql_varchar"
</cfquery>
ERROR:
[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrec
<cfquery datasource="#Application.D
SELECT *
FROM users
WHERE username IN(<cfqueryparam list="yes" value="#form.prjgroup#" cfsqltype="cf_sql_varchar"
</cfquery>
ERROR:
[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrec
> not sure what you mean by cfsqltype="your type">
Just replace it with the correct type for your column: cf_sql_varchar, cf_sql_integer, etc..
> [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrec
You left out the closing parenthesis ). Try
WHERE username IN
(
<cfqueryparam list="yes" value="#form.prjgroup#" cfsqltype="cf_sql_varchar"
)
Don't forget - validate the list size. If the list is empty the query will throw an error.
Just replace it with the correct type for your column: cf_sql_varchar, cf_sql_integer, etc..
> [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrec
You left out the closing parenthesis ). Try
WHERE username IN
(
<cfqueryparam list="yes" value="#form.prjgroup#" cfsqltype="cf_sql_varchar"
)
Don't forget - validate the list size. If the list is empty the query will throw an error.
ASKER
my mistake, forgot to close the IN with )
Cheers for your help, works a treat.
Cheers for your help, works a treat.
ASKER
Greatr work, thanks for your help
Glad to help