| paramter list of values [message #90008] |
Wed, 29 September 2004 02:37  |
jhsharma
Messages: 58
Registered: June 2004
|
Member |
|
|
hi
I want to add two parameter in my report e.g serial no. and serial date.
I just want to have parameter list value from the query like.
select serial_no from t1 serial_no=:p1
and other parameter list for serial date
can parameter list value query should be like as ?
select serial_date from t1 where serial_no=:p1 and serial_date=:p2
can anybody help to find the solution.
using oracle 8 with d2k
regards
jhsharma
|
|
|
|
| Re: paramter list of values [message #90014 is a reply to message #90008] |
Thu, 30 September 2004 06:44  |
Steve
Messages: 190
Registered: September 1999
|
Senior Member |
|
|
jhsharma -
You were close, but the syntax is very specific. It should look like this if you are using simple parameter form in d2k:
where
:p1 = serial_no
AND :p2 = serial_date
Don't forget to mind the datatypes. I assume serial_no is a number data type in the database and that serial_date is a date datatype. Make sure your parameters reflect this, you must be consistent.
HTH,
Steve
|
|
|
|
| Re: paramter list of values [message #90015 is a reply to message #90014] |
Thu, 30 September 2004 21:41 |
jhsharma
Messages: 58
Registered: June 2004
|
Member |
|
|
Hi steve
I have tried the same but there is a error messg like
"Bind variable are not acceptable in the list of value for serial date. (:p1=serial_no) is not allowed.
can suggest some other
regards
jhs
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
