Bug #26995 Recordset Does Not Select the Value from View in MySQL 5.0.16-nt
Submitted: 9 Mar 2007 12:20 Modified: 10 May 2007 16:05
Reporter: Muthu K Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S2 (Serious)
Version:5.0.16-nt OS:Microsoft Windows (Win XP)
Assigned to: CPU Architecture:Any

[9 Mar 2007 12:20] Muthu K
Description:
hi i am using asp mysql, and when i was opened the recordset using  from the following view:-

view-1:-
CREATE VIEW emp_performance AS
select
report_by AS Name,
report_date AS Date,
count(call_alot_id) AS Total
from service_call_reports 
group by report_by,report_date

view-2:-
REATE  VIEW view_emp_performance AS
select
Name,
count(Date) AS Days,
sum(Total) AS Total,
round((sum(Total) / count(Date)),2) AS Rank
from emp_performance
group by Name
order by rank desc limit 0,20;

when i was open the recordset the recodset will be returned empty.
but the same time the query will executed in query browser and return the
values clearly. plz help me for these task.

regards
muthu

How to repeat:
Recordset Does Not Select the Value from View in MySQL 5.0.16-
[9 Mar 2007 12:22] Muthu K
hi i am using asp mysql, and when i was opened the recordset using  from the
following view:-

view-1:-
CREATE VIEW emp_performance AS
select
report_by AS Name,
report_date AS Date,
count(call_alot_id) AS Total
from service_call_reports 
group by report_by,report_date

view-2:-
REATE  VIEW view_emp_performance AS
select
Name,
count(Date) AS Days,
sum(Total) AS Total,
round((sum(Total) / count(Date)),2) AS Rank
from emp_performance
group by Name
order by rank desc limit 0,20;

<%
dim cnConn
Set cnConn=server.CreateObject("ADODB.Connection")
set rsRec=server.CreateObject("ADODB.Recordset")

cnConn.Open(Application("cnStr"))
rsStr="Select * from view_emp_performance"

rsRec.Open(rsStr),cnConn,3,3

while not rsRec.EOF
  Response.Write(rsRec("Name"))
  rsRec.MoveNext()
wend
%>

when i was open the recordset the recodset will be returned empty.
but the same time the query will executed in query browser and return the
values clearly. plz help me for these task.

regards
muthu
[9 Mar 2007 12:23] Valeriy Kravchuk
Thank you for a problem report. Please, try to repeat with a newer version, 5.0.27, and inform about the results.
[9 Apr 2007 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[10 Apr 2007 16:05] Valeriy Kravchuk
Feedback is still needed.
[10 May 2007 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".