db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "srinath Gokul" <srinath.go...@ustri.com>
Subject [jira] Commented: (DERBY-1804) [DOC] CAST conversions between data types table is incorrect in Reference manual in some VARCHAR and TIMESTAMP cases
Date Mon, 25 Sep 2006 07:02:14 GMT
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:

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. 




View raw message