cfquery name=OpenedUpSeats dbtype=ODBC datasource=TrainingBE
Select *
from OpenedUpSeatsView
where account='cfset zz=writeoutput(session.account)'
/cfquery
cfif OpenedUpSeats.RecordCount
First of all.. This isn't my code, so I know it's pretty bad. The Query doesn't
error,
What happens when you dump OpenedUpSeats and/or isquery(OpenedUpSeats) ?
On Thu, May 19, 2011 at 6:57 AM, Phillip Vector
vec...@mostdeadlygame.comwrote:
cfquery name=OpenedUpSeats dbtype=ODBC datasource=TrainingBE
Select *
from OpenedUpSeatsView
where account='cfset
What happens when you dump OpenedUpSeats and/or isquery(OpenedUpSeats) ?
Variable OPENEDUPSEATS is undefined.
But it IS defined.. *pulls hair*
~|
Order the Adobe Coldfusion Anthology now!
On 5/19/2011 7:57 AM, Phillip Vector wrote:
cfquery name=OpenedUpSeats dbtype=ODBC datasource=TrainingBE
Select *
from OpenedUpSeatsView
where account='cfset zz=writeoutput(session.account)'
/cfquery
cfif OpenedUpSeats.RecordCount
First of all.. This isn't my code, so
Can we see more of the code? There's obviously something funny here
and we're not able to see it.
On Thu, May 19, 2011 at 7:02 AM, Phillip Vector
vec...@mostdeadlygame.com wrote:
What happens when you dump OpenedUpSeats and/or isquery(OpenedUpSeats) ?
Variable OPENEDUPSEATS is undefined.
...@nc.rr.com]
Sent: Thursday, May 19, 2011 7:26 AM
To: cf-talk
Subject: Re: Recordcount not working
On 5/19/2011 7:57 AM, Phillip Vector wrote:
cfquery name=OpenedUpSeats dbtype=ODBC datasource=TrainingBE
Select *
from OpenedUpSeatsView
where account='cfset zz
On 5/19/2011 7:57 AM, Phillip Vector wrote:
Run it without the Where clause in the SQL and see what happens.
cfquery name=OpenedUpSeats dbtype=ODBC datasource=TrainingBE
Select * from OpenedUpSeatsView
/cfquery
cfdump var=#OpenedUpSeats# abort
gets me
Variable OPENEDUPSEATS is undefined.
Can we see more of the code? There's obviously something funny here
and we're not able to see it.
cfif (not isdefined(session.stack))
or (not isdefined(session.stackT))
or (not listlen(session.stack) is listlen(session.stackT))
or (listlen(session.stack) gt 40)
The code looks like this: cfdump var=#OpenedUpSeats# abort ?
I have never seen code like this ever or that writeoutput() above..
have you tried just
cfdump var=#OpenedUpSeats# /
cfabort /
On Thu, May 19, 2011 at 8:29 AM, Phillip Vector
vec...@mostdeadlygame.com wrote:
cfdump
The code looks like this: cfdump var=#OpenedUpSeats# abort ?
I have never seen code like this ever or that writeoutput() above..
have you tried just
cfdump var=#OpenedUpSeats# /
cfabort /
Same result. It's not the closing of the tags that are messing things up.
cfdump var=#OpenedUpSeats#
ah, added in CF9
http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-7ef7.html
Just to rule everything else out..
Go up to the top of the page and JUST put
cfquery name=OpenedUpSeats dbtype=ODBC datasource=TrainingBE
Select * from OpenedUpSeatsView
/cfquery
I've seen this in the past when the request to the DB server just dies for
some reason. The DB server may even process and return the request, so it may
not be obvious. Make sure the DB is giving a response back.
Make sure things like JDBC drivers are up to date.
Wil Genovese
Sr. Web
ah, added in CF9
http://help.adobe.com/en_US/ColdFusion/9.
0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-7ef7.html
Just to rule everything else out..
Go up to the top of the page and JUST put
cfquery name=OpenedUpSeats dbtype=ODBC datasource=TrainingBE
Select * from OpenedUpSeatsView
I've seen this in the past when the request to the DB server just
dies for some reason. The DB server may even process and return the
request, so it may not be obvious. Make sure the DB is giving a
response back.
It's able to do tables.. I think that it's because it's a view and not a
Are you under CFMX? Try to remove dbtype=ODBC
This is not valid anymore:
Deprecated the connectString, dbName, dbServer, provider, providerDSN, and sql
attributes, and all values of the dbtype attribute except query. They do not
work, and might cause an error, in releases later than ColdFusion
Are you under CFMX? Try to remove dbtype=ODBC
This is not valid anymore:
Thanks for the tip. Eliminated, but still not working.
I changed the query to point to a table and that works fine. It's looking up a
view that it does this. I can't find anywhere on the interwebs where the is a
...@mostdeadlygame.com
Sent: Thursday, May 19, 2011 10:12 AM
To: cf-talk cf-talk@houseoffusion.com
Subject: Re: Recordcount not working
Are you under CFMX? Try to remove dbtype=ODBC
This is not valid anymore:
Thanks for the tip. Eliminated, but still not working.
I changed the query to point to a table
There is no difference: we successfully query SQL Server views all the
time in several of our apps. Have you checked the permissions? Could it
be that the View doesn't allow the CF service user to SELECT data?
Thanks.. I will check with our DB admin and see.
Phillip..I don't think dbtype is supported for anything other than type:
query any more.
On May 19, 2011 9:34 AM, Phillip Vector vec...@mostdeadlygame.com wrote:
On 5/19/2011 7:57 AM, Phillip Vector wrote:
Run it without the Where clause in the SQL and see what happens.
cfquery
Thanks.. I will check with our DB admin and see.
Turns out, I didn't have permission for the view. I since got it and he
mentioned that the view has no records at all anyway and to just put in a
cfset
OpenedUpSeats.recordcount = 0 to move past it.
So yeah. Still a mystery, but we are moving
This sort of makes sense. The DB rejected the request, somewhere in the
process the JDBC driver returned nothing or NULL or something not exactly
expected and closed the request. CF not getting a result set (not even an empty
results set) didn't set the query result set variable. Thus you
[mailto:vec...@mostdeadlygame.com]
Sent: Thursday, May 19, 2011 8:29 AM
To: cf-talk
Subject: Re: Recordcount not working
Can we see more of the code? There's obviously something funny here
and we're not able to see it.
cfif (not isdefined(session.stack))
or (not isdefined
Wil Genovese wrote:
This sort of makes sense. The DB rejected the request, somewhere in the
process the JDBC driver returned nothing or NULL or something not exactly
expected and closed the request. CF not getting a result set (not even an
empty results set) didn't set the query result
23 matches
Mail list logo