Adam Parker wrote: > I have posted this question on an ASP board to no avail. My question regards > translating classic asp code to coldfusion 8. My problem is I don't > completely understand the asp code in order to create the CF code. I am > hoping the community can help me out as always.
It appears that if there are no matching records, a variable "clientPreReg" gets a value of a single comma. Otherwise, it creates a list of values and then breaks them out into an array called "clientPreRegArray". If ColdFusion, it would look like: <cfquery name="getEvents" datasource="whatever"> SELECT * FROM eventAttendance WHERE clientID = #clientID# </cfquery> <!--- You should use a CFQUERYPARAM in that query as well. ---> <cfif getEvents.recordCount> <cfset clientPreReg = valueList(getEvents.eventID)> <cfset clientPreRegArray = listToArray(clientPreReg)> <cfelse> <cfset clientPreReg = ","> </cfif> -Justin ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4377 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
