Basically I have few HTML forms which accept the filters and brings the data accordingly using the ARI DAta Module in Jhoomla.

However it has started giving me problems to recognize the Requestvariable passed as parameters to SQL.

One of my reports using kind of same query works fine , I am stuck on this one and the error is as detailed below


JDatabaseMySQL::query: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and (arrival_Airport like concat('%' , , '%') or ='SelectAll') ) limi' at line 38 SQL=(SELECT concat(attendee1_FirstName, ' ' ,attendee1_LastName,'(Main)', IF (attendee2_FirstName = '', '', concat(',
',attendee2_FirstName ,' ',attendee2_LastName)), IF (attendee3_FirstName = '', '', concat(',
',attendee3_FirstName ,' ',attendee3_LastName)), IF (attendee4_FirstName = '', '', concat(',
',attendee4_FirstName ,' ',attendee4_LastName)), IF (attendee5_FirstName = '', '', concat(',
',attendee5_FirstName ,' ',attendee5_LastName)), IF (attendee6_FirstName = '', '', concat(',
',attendee6_FirstName ,' ',attendee6_LastName)), IF (attendee7_FirstName = '', '', concat(',
',attendee7_FirstName ,' ',attendee7_LastName)), IF (attendee8_FirstName = '', '', concat(',
',attendee8_FirstName ,' ',attendee8_LastName)), IF (attendee9_FirstName = '', '', concat(',
',attendee9_FirstName ,' ',attendee9_LastName)) , IF (attendee10_FirstName = '', '', concat(',
',attendee10_FirstName ,' ',attendee10_LastName, '
'))) as 'Attendees', concat(country_Departure ,' (',city_Departure,')') as 'Coming From', arrival_Airport as 'Arrival Airport' , DATE_FORMAT(day_Arrival , '%d/%m/%Y') as 'Arrival Date', arrival_FlightTime as 'Flight Time', flight_Number as 'Flight No.', airport_Terminal as 'Terminal', departure_Airport as 'Departure Airport' , DATE_FORMAT(day_Departure , '%d/%m/%Y') as 'Departure Date' , phone_Number as 'Phone Number', mobile_Number as 'Mobile Number', email_Confirmation as 'Email' , IF (designation='Regular',concat('(P) ',pramukh_Mukhi,', Town: ',branch_Town),concat('(H) ', host_Name , ', Town: ' , your_Town ) ) as 'Pramukh(P)/Host (H) details' FROM jos_NISRegistration where ( accomodation_FriendsFamily = 'None')and and (arrival_Airport like concat('%' , , '%') or ='SelectAll') ) limit 0,300

Appreciate ur reply.
Many Thanks

Hello,

What SQL query do you use?

Regards,
ARI Soft

Just to keep it simple I have simplified my query and still not working,

(SELECT arrival_Airport as 'Arrival Airport' , arrival_FlightTime as 'Flight Time' FROM jos_NISRegistration where ( accomodation_FriendsFamily = 'None') and (arrival_Airport like concat('%' ,{$REQUEST:ArrivalAirporttest} , '%') or {$REQUEST:ArrivalAirporttest}='SelectAll') ) limit 0,300


and the error is

JDatabaseMySQL::query: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' '%') or ='SelectAll') ) limit 0,300' at line 1 SQL=(SELECT arrival_Airport as 'Arrival Airport' , arrival_FlightTime as 'Flight Time' FROM jos_NISRegistration where ( accomodation_FriendsFamily = 'None') and (arrival_Airport like concat('%' , , '%') or ='SelectAll') ) limit 0,300


Your quick help will be geniunely highly appreciated

Use the next code:



instead of:



Regards,
ARI Soft

This is no working, but I still have a question to ask.

I have lets say A menu attached to Custom HTML and ARI DATA Table filtered on variables passed thru Custom HTML and I give the same query and it works(ie my original query).(This was developed using earlier version of ARIDataTable)

I have lets say a menu attached to 3-4 ARIDataTables, a Custom HTML and 1 more ARIDATATABle to be filtered on Custome HTML and in this if I give my original query it doesn't work. This is developed using version 1.9

I want to know what exactly is happening. Why is it recognising the Request variables with menu A and not with menu B?

Sorry the first line meant to say this is now working.. But pls read the ques and answer it. Many Thanks.