Hi Stewart,
This is the query we are using in
Where conditions as shown below
"
(A.Campaign_Id in @variable ('F.Enter Campaign Id') OR '(ALL)' in @variable
('F.Enter Campaign Id') ) "
This query is used in the Business Object, where
@variable will be prompted to enter the values in the business Objects. We can
enter multiple values in the prompt.
Here campaign id is of datatype “INT”,
while comparing with ‘(ALL)’, it gives error as “Syntax error converting the varchar value '(ALL)' to a
column of data type int.State: 22018”
If i use the Convert or Cast near
@variable as shown below
"
(A.Campaign_Id in @variable ('F.Enter Campaign Id') OR '(ALL)' in
CAST(@variable ('F.Enter Campaign Id')as Char(10) ) "
Error is like this "Incorrect syntax near the keyword 'Convert'.State:
42000"
So, i thing we are not able to use CONVERT or CAST
Statement for the multiple values. Since in @variable we can enter multiple
values. (CAST & CONVERT is used only to convert integer value to
Character).
Is there any other way to resolve this issue.
Please help me in this regards.
|
Thanks
& Regards
|
|
|
|
Srinath
Gokul
|
|
srinath.gokul
@ustri.com
|
|
|
2nd Floor, RR Tower-III
|
|
TVK industrial Estate, Guindy, Chennai -600 032
|
|
Tel: 044 42270000
|
|
Cell: +91 - 9884562978
|
|
|
|
|
Confidentiality
and Security: This e-mail and any
associated files transmitted with it are confidential and solely for the
intended recipient. If you are not the named addressee, do not disseminate,
distribute, copy or alter this e-mail. If you have received this information
in error, please notify the sender immediately and delete this communication
permanently from your records. Forward-looking
Statement: Certain portions of this e-mail or its associated files
may contain forward-looking statements that are based on management's
expectations, estimates, projections, and assumptions. Warning: USTRI has taken reasonable
precaution to ensure no viruses are present in this e-mail. The firm cannot
accept responsibility for any loss or damage arising from the use of this
e-mail or attachments.
|
|
