Paul Smith
Member since Mar 1, 2012
- Profile: /members/9685-paul-smith.htm
- URL: http://SFBay.SmarterYellowPages.com
- Comments: 4
Recent Blog Comments By Paul Smith
-
SELECT TOP And ColdFusion Query Of Queries
Posted on May 6, 2012 at 10:01 PM
I found the problem in the above. <cfset ID_Array2[#IDD#] = qSub.ID[IDD] > should have been: <cfset ID_Array2[#IDD#] = qSub.ID > best, paul... read more »
-
SELECT TOP And ColdFusion Query Of Queries
Posted on May 6, 2012 at 7:03 PM
The above app is for Admin purposes only, not for the general public. So it doesn't have to be efficient. I'm thinking the easy way, code-wise, might be to put the data in a SQL Server Table. Then one query could do the job. best, paul... read more »
-
SELECT TOP And ColdFusion Query Of Queries
Posted on May 6, 2012 at 12:13 PM
The following works as I wanted. But only for the FIRST OrgID (the CFOUTPUT proves there are 2). Any ideas? best, paul <!--- Create arrays. ---> <cfset ID_Array2 = ArrayNew(1)> <!--- Make a query. ---> <cfset GetListingsInOneClass2 = QueryNew("")> <cfset ID... read more »
-
Deleting ColdFusion Scheduled Tasks With CFThread And CFSchedule
Posted on Mar 1, 2012 at 9:23 AM
How could you use a template similar to the one above, but not delete the scheduled tasks, and change a single parameter in the above template every time it was executed?... read more »