-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
I have a string of numbers, seperated by commas, stored in a text field in a
table, call it tblItem.
These numbers each correspond to a primary key in tblContent.
I build a select box by looping over all the primary keys in tblContent, like
this:
<cfquery name="get_content" datasource="#application.dsn#">
SELECT *
FROM TblContent
</cfquery>
<td><select name="Contents" size="5" multiple>
<cfoutput query="get_content">
<option value="#ContentsID#">#ContentsName#</option>
</cfoutput>
</select>
</td>
Now, what I want to do is to add a bit of code to this that will check for a
match between the ContentsID from my option and any of the values in the
string from this query:
<cfquery name="get_tobacco" datasource="#application.dsn#">
SELECT *
FROM tblItem
WHERE ItemID = #url.ITEM#
</cfquery>
any ideas?
- --
Jon Tillman - the perpetual newbie
http://www.eruditum.org
computeri non cogitant, ergo non sunt
-----BEGIN PGP SIGNATURE-----
Version: PGP 6.5.1i
iQA/AwUBOrYK/Nga7tZtnIOtEQKnQgCgqxT7Eco8C+GbKcbtAPMIcinGbicAniRN
QDB3P18X8wgQBGtq/wsIlefF
=vhUV
-----END PGP SIGNATURE-----
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
