I am having trouble setting a cell in a query....
Code is below the line -----
Here are things I have know:
1. There column does get created. I can see it in the cfdump ( I love
cfdump :-)
2. cfinclude template="qrySelectjobs.cfm" does execute I can see the
sql on debug output.
2. The value in #qrySelectJobs.RecordCount# is 62
3. The vaue in #RowNumber# is 1
The PROBLEM is the "JobsFound" does not get set !!!!!!
<cfquery name="qryJobAgent" datasource="#setting.dsn#">
select * from search_job where jobseeker_id = #client.jobseekerid#
</cfquery>
<cfset ColumnValues = arraynew(1)>
<cfset temp = queryaddcolumn(qryJobAgent,"JobsFound",columnvalues)>
<cfset RowNumber = 0>
<cfoutput query="qryJobAgent">
<cfset RowNumber = RowNumber + 1>
<cfinclude template="qrySelectjobs.cfm"> <--- execute another query to
get JobFound count
<cf temp =
QuerySetCell(qryJobAgent,"JobsFound","#qrySelectJobs.RecordCount#",RowNu
mber)>
#qrySelectJobs.RecordCount# #RowNumber#<br> <----- prove there is
something in the count
</cfoutput>
<cfdump var="#qryjobagent#">
Bartee Lamar
www.enterpriseenergy.com <http://www.enterpriseenergy.com/>
MSN <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED]
______________________________________________________________________
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
