I want to get all the fields matching the userid and return and array of
the matching values. So in my component, I have the following (see
comments in the middle) :
cffunction name=getCourseData access=remote
cfargument name=R_userName type=string required=yes
cfquery
Just return the whole query and skip all the other stuff...like so:
cffunction name=getCourseData access=remote
cfargument name=R_userName type=string required=yes
cfquery name=getCourses datasource=learnline
SELECT title FROM courses
WHERE userid = cfqueryparam cfsqltype=CF_SQL_STRING
cfreturn listtoarray(valuelist(getCourses.title))
-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]
Sent: 21 July 2005 17:19
To: CF-Talk
Subject: Re: Looping over query assistance
Just return the whole query and skip all the other stuff...like so:
cffunction name
On 7/21/05, Merrill, Jason [EMAIL PROTECTED] wrote:
I want to get all the fields matching the userid and return and array of
the matching values. ...
#getCourses.title#
It works, I can get the first title that matches the userid in the
query, but if I do the loop like that, and I just return
Perfect, thank you.
Jason Merrill | E-Learning Solutions | icfconsulting.com
-Original Message-
From: Eddie Awad [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 21, 2005 12:36 PM
To: CF-Talk
Subject: Re: Looping over query assistance
On 7/21/05, Merrill, Jason [EMAIL
:[EMAIL PROTECTED]
Sent: Thursday, July 21, 2005 12:19 PM
To: CF-Talk
Subject: Re: Looping over query assistance
Just return the whole query and skip all the other stuff...like so:
cffunction name=getCourseData access=remote
cfargument name=R_userName type=string required=yes
!--- you forgot
6 matches
Mail list logo