Skip to main content
D
davidbarrackphoto
Participant
May 25, 2010
Question

1064 error with recordset

  • May 25, 2010
  • 1 reply
  • 764 views

Well, I have a MySQL query that runs just fine when testing it outside of DW CS5.  When I put the query in a recordset I get an error.  Some 1064 error.  What gives?  The query works and is perfectly fine except when I feed it to DW.  Here it is:

SELECT PRV_Reservation_People.PRV_person_id, PRV_Reservation_People.PRV_person_first_name, PRV_Reservation_People.PRV_room_name, PRV_Reservation_People.PRV_occupancy_cat, david.cnt

FROM PRV_Reservation_People JOIN (SELECT PRV_Reservation_People.PRV_room_name, COUNT(*) AS cnt FROM PRV_Reservation_People

WHERE PRV_reservation_ID = column

GROUP BY PRV_room_name ) AS david ON (PRV_Reservation_People.PRV_room_name = david.PRV_room_name) WHERE PRV_reservation_ID = column

This topic has been closed for replies.

1 reply

B
bregent
Participating Frequently
May 26, 2010

>that runs just fine when testing it outside of DW CS5.

Is it running against the same MySQL server in both cases?

D
davidbarrackphotoAuthor
Participant
May 26, 2010

Yes, the same database. In fact I repeated this by moving to a

different host and trying again. Same thing. I run the query in

myPHPAdmin and get the expected result set. When I create a recordset

with the same code and try to bind to the recordset the error appears.

It happens in both CS4 an 5.

David

404-805-0888

www.channelbstudio.com

B
bregent
Participating Frequently
May 27, 2010

OK. But to be clear,

1) You are running myPHPAdmin on a remote host?

and

2) You have defined your testing server as the same remote host?


What I am getting at is that different versions/configurations of MySQL may have different syntax rules so I want to be sure both operations are occuring on the same server.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices