This content has been marked as final. Show 6 replies
What did you do wrong? This
<cfset used = #UsedProjects.RecordSet#>
does not give a recordcount.
<cfset available = #AvailProjects.project#>
does not give you a number.
Plus if I remember correctly, cfc's do not recognize session variables.
That's the stuff that is definitely wrong. You are also being inefficient. You should be able to get the answer in one query.
CFCs do recognize session variables, unless you are storing the CFC in the application as an object.
My CFCs recognize sessions.
I noticed the error on my first one. It should be RecordCount, not
RecordSet. I apologize, it was late.
Why wouldn't my AvailProjects.projects give a number? It is a number in the
'projects' column set to INT. Wouldn't that produce a number?
I am not that great at SQL queries. What should I be looking for to get the
result from one SQL query?
Help me be effective.
I appreciate your submission to my question, but I am asking cause I don't
know. I apologize for my lack of knowledge. If I knew how to do it
efficiently I would not be asking.
Also, I know the item is wrong. That is why I am asking how make it right.
"Dan Bracuk" <firstname.lastname@example.org> wrote in message
> What did you do wrong? This
> <cfset used = #UsedProjects.RecordSet#>
> does not give a recordcount.
> and this
> <cfset available = #AvailProjects.project#>
> does not give you a number.
> Plus if I remember correctly, cfc's do not recognize session variables.
> That's the stuff that is definitely wrong. You are also being
> You should be able to get the answer in one query.
Without knowing your table structure, it's hard to give the exact answer. I thought your 2nd query would retun a list of projects. If you are storing the actual number instead of calculating it, you could have problems keeping it up to date.
In any event, the following thread shows how to do math by selecting from sub-queries. There are probably better ways for your particular situation, but it might give you some ideas.
Ok, the only column I need from the 'members' table is 'projects' (which is
I then need to count the projects currently in the 'project' table based on
the column 'dirname' which equals #Session.MM_username#
I need to take the number from the 'project' column from the 'members' table
and subtract from it the total number from the count of all projects from
the 'project' table and output that number to variable which can be passed
on to the requesting page.
Does that help?