That makes sence, I just don't see how this will make multiple links, say I
have four numbers in the list, will it make four seperate links? I know it
is probably really simple, but for some reason the higher the level of the
programming language is, the harder it gets for me to understand, I am used
to machine code and assembly languages, those make perfect sense to me:) lol
I am just trying to understand this thoroughly so when I come to this
situation again I can draw back on it and be able to create the solution
easily.
Thank you,
Donald Pavlik
-----Original Message-----
From: Hal Helms [mailto:[EMAIL PROTECTED]]
Sent: Saturday, November 25, 2000 11:16 PM
To: Fusebox
Subject: RE: Comma Delimited lists
Donald, here's one way:
<cfset myList = "2,4,6,29">
<cfquery name="GetProductNames"...>
SELECT productID, productName
FROM Products
WHERE productID IN (#myList#)
</cfquery>
<cfloop query="#GetProductNames#">
<a
href="index.cfm?fuseaction=productDetail&productID=#productID#">#productName
#</a><br>
</cfloop>
Something like that make sense?
Hal
-----Original Message-----
From: Donald R. Pavlik [mailto:[EMAIL PROTECTED]]
Sent: Saturday, November 25, 2000 11:01 PM
To: Fusebox
Subject: Comma Delimited lists
I have a few fields in my databases that use comma delimited lists in them,
my biggest problem is that I have not found a way where I could go through
it and have certain actions be done for each item in the list. For example,
I have a field that has all the partIds that make one part assembly in a
field, (2,4,6,29) and then I would like a link made off of this information.
I want a query done for each number, and then a link to be make out of the
drawn information put up on a web page. I know I should be able to do this
with <cfloop></cfloop> and have a <cfquery></cfquery> inside the loop for
each number, but I just don't seem to understand how to do it. I have read
my coldfusion books on it, and I just get lost on how to do it. Can any of
you help shed some light on this for me?
Thank you,
Donald Pavlik
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
