Could someone please explain how I can use CL to get a variable into a Query. So that I can use the query parameter LIKE and have the ability to use the %.
Basically what I'm trying to do is create a screen, on that screen the user will enter a number for example 9000, I want the query that runs behind it to return results of 9000% to the screen, but I just can't get it to work. It's got to be really simple hasn't it?
This is all I want
Select A B C D from lib/file where A is like "Variable" order by A B C D
But I don't know how to pass a variable into a query. I tried SQL but when I built the query in that it came back with '9000%' so didn't like it.
Please note this is numeric data they are inputting and not alpha whcih may cause further problems.
Could someone please help it's driving me mad!
January 26, 2006 12:03 PM
November 25, 2009 3:54 AM