joseph2k
Posts: 72
|
| Posted: 11/11/2006, 8:28 PM |
|
I see for a datasource selection I can modify the parameter selection.
So there is a condition of "BETWEEN" followed by a parameter text box.
I have two fields 's_MYCURRENCY' and 's_MYCURRENCY1' which I want to use the range on, the question is how do I do that? I keep getting errors
Tried parameter
s_MYCURRENCY and s_MYCURRENCY1
Ideas?
|
 |
 |
Edd
Posts: 547
|
| Posted: 11/12/2006, 1:55 PM |
|
"Between" is just short notation of >= A and <= B
Just create 2 parameters >= s_MYCURRENCY
in the second <= s_MYCURRENCY1
_________________
Accepting and instigating change are life's challenges.
http://www.syntech.com.au |
|
|
|
joseph2k
Posts: 72
|
| Posted: 11/12/2006, 8:24 PM |
|
Thats exactly what I have but the problem is that CCS does not like using parameter "s_MYCURRENCY and s_MYCURRENCY1" in text box.
To clarify the steps of where I am trying to get the parameters accepted.
Use a Grid Builder wizard, select db, table, and search filter..
Add a text field for s_MYCURRENCY1 either manually or copy/paste into search grid.
So I have a search grid and a results grid, if you select the results grid and select properties and then get to datasource, doubleclick on ".." so you then see the "Visual Query Builder",
click on field in the WHERE statement for s_MYCURRENCY to get next popup...
Here is where you can place parameters.... select condition of between.
Tell me where to use the upper and lower limits... if placed in parameter box then....
If I do a show sql I get:
SELECT *
FROM CUST_NEW
WHERE CUST_NUM LIKE '%{s_CUST_NUM}%'
AND CUST_NAME LIKE '%{s_CUST_NAME}%'
AND CREDIT_RATING = {s_CREDIT_RATING}
AND SHIP_TERMS LIKE '%{s_SHIP_TERMS}%'
AND CREDIT_LIMIT = {s_CREDIT_LIMIT}
AND MYCURRENCY BETWEEN {s_MYCURRENCY and s_MYCURRENCY1}
AND MYOther1 = {s_MYOther1}
AND MYFLOAT = {s_MYFLOAT}
ORDER BY CUST_NUM
which works in the test mode but runs with an error in ASP.
ERROR [07002] [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
|
|
|
|
dexter
Posts: 6
|
| Posted: 11/14/2006, 10:23 PM |
|
try changing
BETWEEN {s_MYCURRENCY and s_MYCURRENCY1}
to
BETWEEN {s_MYCURRENCY} and {s_MYCURRENCY1}
note the extra braces.
|
|
|
|
|
