one of my clients just pointed out a strange issue that seems to occur when trying to do a 'find' with multiple requests.
The problem only seems to happen with certain columns
What happens is the client goes into 'find' mode, enters a criteria into a field, then does 'New (Record) Request', enters a new value in the same field, repeats etc. and then starts search and the results are only the result from the FIRST and LAST requests, not the ones in between...
I set Servoy to output the SQL & Params to help me :-
- Code: Select all
SQL = select products103.product_id from products products103 where products103.comments like ? or products103.comments like ? or products103.comments like ? order by products103.product_id asc
SQL Params = [%a%,%b%,%c%]
SQL = select products103.product_id from products products103 where products103.title like ? or products103.title like ? order by products103.product_id asc
SQL Params = [%a%,%c%]
SQL = select products103.product_id from products products103 where products103.subtitle like ? or products103.subtitle like ? order by products103.product_id asc
SQL Params = [%a%,%c%]
SQL = select products103.product_id from products products103 where products103.product_id between ? and ? order by products103.product_id desc
SQL Params = [2000,2002]
SQL = select products103.product_id from products products103 where products103.product_id = ? or products103.product_id = ? order by products103.product_id desc
SQL Params = [2000,2002]
In the 1st one above, I am doing 3 requests into the 'comments' field - this works
In 2nd, I also tried same 3 params/requests into the 'title' field - doesn't work
in 3rd, same 3 in 'subtitle' - doesn't work
In 4th I tried 1 request with a range of product_id's, this returned 3 results
in 5th I tried doing those product_id's as 3 individual requests [2000,2001,2002] - doesn't work
I obviously don't have time to test with every column in every table in the solution, but this seems to be a serious issue and I can't see anything I am doing to make it not work (title,comments & subtitle are all varchars of 255 or less)
Client is running Servoy 5.2.11, as was I
I then updated to 5.2.15 to see if it was a bug that was fixed, still doesn't work.
Back end is MS SQL Server 2005
Driver is jTDS (net.sourceforge.jtds.jdbc.Driver)
Driver URL is jdbc:jtds:sqlserver://x.x.x.x:1433/abrsm_pubs;SelectMethod=cursor
This is potentially a very worrying issue, as if user's are doing searches and trusting the results, but those results are not correct.........
Please can anyone advise me as to what might be going wrong??
Thanks
Rafi