:) Thank you, those register thingies:) They are very similar to your common
variables:)
Register A
is the same as
variable A
Just that your register stored the information in binary where your variable
can store your variable in whatever format you want:)
Thought I answer just incase you were really asking:)lol
Thank you again,
Donald Pavlik
-----Original Message-----
From: Hal Helms [mailto:[EMAIL PROTECTED]]
Sent: Saturday, November 25, 2000 11:29 PM
To: Fusebox
Subject: RE: Comma Delimited lists
Yes, this will create separate, mulitple links. Don't feel bad about not
getting it right away. You really would NOT want to see me try my hand at
assembly programming. "What the heck are these register thingies?"
-----Original Message-----
From: Donald R. Pavlik [mailto:[EMAIL PROTECTED]]
Sent: Saturday, November 25, 2000 11:24 PM
To: Fusebox
Subject: RE: Comma Delimited lists
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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
