Select Characters.Callsign
from Characters
Where CharacterID in (Select Administration from Governments where
GovernmentID = 4)
The right of the in comes out correct (‘3,4,5,6,7,8’)
However, I keep getting an error which transduces it to 3.
I was told that the answer is to put it in quotes, but it errors out. I
also tried casting the characterID as a string (it’s an bigint), but that
didn’t work.
I presume there is an obvious solution, but I’m not finding it. Anyone got
any tips as to how I can find out if CharacterID is in the List generated
by the subquerry?
Can you be more specific or clear what “Transduced Double” refers to? Is
that phrase in the error message? You might also give more detail, such as
the exact error message and stack trace, as well as the database engine in
use here.
I often use IN statements and the only issue I typically run into is if the
list is empty, an error is thrown.
And just to be clear, if you run the query “Select Administration from
Governments where GovernmentID = 4”, you get a list of integers, correct? Administration seems like a strange column name for an integer, so I
thought I’d double check.
Aria Media Sagl
+41 (0)76 303 4477 cell
skype: ariamediaOn Mon, Jun 20, 2016 at 7:00 PM, Phillip Vector <@Phillip_Vector> wrote:
Can someone help me out here?
Select Characters.Callsign
from Characters
Where CharacterID in (Select Administration from Governments where
GovernmentID = 4)
The right of the in comes out correct (‘3,4,5,6,7,8’)
However, I keep getting an error which transduces it to 3.
I was told that the answer is to put it in quotes, but it errors out. I
also tried casting the characterID as a string (it’s an bigint), but that
didn’t work.
I presume there is an obvious solution, but I’m not finding it. Anyone got
any tips as to how I can find out if CharacterID is in the List generated
by the subquerry?
–
Win a ticket to dev.objective from Lucee via Twitter, see http://bit.ly/1UbTMWj for details, good luck and see you there…
