What happens when you dump OpenedUpSeats and/or isquery(OpenedUpSeats) ?
On Thu, May 19, 2011 at 6:57 AM, Phillip Vector
wrote:
>
>
> Select *
> from OpenedUpSeatsView
> where account=''
>
>
>
>
> First of all.. This isn't my code, so I know it's pretty bad. The Query
> doesn't er
>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!
http://www.amazon.com/Adobe-Coldfusi
On 5/19/2011 7:57 AM, Phillip Vector wrote:
>
>
> Select *
> from OpenedUpSeatsView
> where account=''
>
>
>
>
> First of all.. This isn't my code, so I know it's pretty bad. The Query
> doesn't error, but when it hits the recordcount, I get the "Element
> RECORDCOUNT is und
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
wrote:
>
>>What happens when you dump OpenedUpSeats and/or isquery(OpenedUpSeats) ?
>
> Variable OPENEDUPSEATS is undefined.
>
> But it IS defined.. *
: 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:
>
>
> Select *
> from OpenedUpSeatsView
> where account=''
>
>
>
>
> First of all.. This isn't my code, so I
>On 5/19/2011 7:57 AM, Phillip Vector wrote:
>
>Run it without the Where clause in the SQL and see what happens.
Select * from OpenedUpSeatsView
gets me
Variable OPENEDUPSEATS is undefined.
~|
Order the Adobe Coldfusion
>Can we see more of the code? There's obviously something funny here
>and we're not able to see it.
Select * from OpenedUpSeatsView
That's the code there. I get at the end "Variable OPENEDUPSEATS is undefined.".
Even when I removed the where, it's still messing up. The
The code looks like this: ?
I have never seen code like this ever or that writeoutput() above..
have you tried just
On Thu, May 19, 2011 at 8:29 AM, Phillip Vector
wrote:
>
~|
Order the Adobe Coldfusion Anthology now!
ht
>The code looks like this: ?
>
>I have never seen code like this ever or that writeoutput() above..
>
>have you tried just
>
>
Same result. It's not the closing of the tags that are messing things up.
is a valid tag. :)
~|
O
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
Select * from OpenedUpSeatsView
And see what happens.. make sure there's not some flow issue
On
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
>
> Select * from OpenedUpSeatsView
>
>
>
> And see what happens.. make sure there's n
> 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 n
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 ColdFusi
> 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
dif
Sent: Thursday, May 19, 2011 10:12 AM
To: "cf-talk"
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 and
>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" wrote:
>
>>On 5/19/2011 7:57 AM, Phillip Vector wrote:
>>
>>Run it without the Where clause in the SQL and see what happens.
>
>
> Select * from OpenedUpSeatsView
>
>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
to move past it.
So yeah. Still a mystery, but we are moving past and not worrying about it.
Tha
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 g
[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.
Select * from OpenedUpSeatsVi
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 resu
22 matches
Mail list logo