Query problem, please help.

[Raphael Emportu]

mysql Ver 12.22 Distrib 4.0.24, for pc-linux-gnu (i386)

gives me:

The following database Error occured:
You have an error in your SQL syntax. Check the manual that corresponds to
your MySQL server version for the right syntax to use near ') and
A.OB_AREAID=C.TR_REFID and C.TR_LANG='de' and

Statement:
select A.*, B.*, C.TR_TEXT from LS_OBJECTS A, LS_OBJECT_TR B,
LS_TRANSLATION C where A.OB_ID=B.OTR_OBJECTID and B.OTR_LANG='de' and
A.OB_ID IN() and A.OB_AREAID=C.TR_REFID and C.TR_LANG='de' and
C.TR_REFNAME='AREA_ID'

Manual check doesn't help much as I do not fully comprehend the query. Is
there someone who can help?

[Jerry Stuckle]

Raphael Emportu wrote:

> mysql Ver 12.22 Distrib 4.0.24, for pc-linux-gnu (i386)
>
> gives me:
>
> The following database Error occured:
> You have an error in your SQL syntax. Check the manual that corresponds to
> your MySQL server version for the right syntax to use near ') and
> A.OB_AREAID=C.TR_REFID and C.TR_LANG='de' and
>
> Statement:
> select A.*, B.*, C.TR_TEXT from LS_OBJECTS A, LS_OBJECT_TR B,
> LS_TRANSLATION C where A.OB_ID=B.OTR_OBJECTID and B.OTR_LANG='de' and
> A.OB_ID IN() and A.OB_AREAID=C.TR_REFID and C.TR_LANG='de' and
> C.TR_REFNAME='AREA_ID'
>
> Manual check doesn't help much as I do not fully comprehend the query. Is
> there someone who can help?

You didn't provide a list of items for your IN clause. It needs to be something
like

IN (1, 2, 3, 4)

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
[email]jstucklex@attglobal.net[/email]
==================

[Raphael Emportu]

Jerry Stuckle <jstucklex@attglobal.net> wrote in
news:rsqdnc1l2rcPedLZnZ2dnUVZ_vGdnZ2d@comcast.com:

> Raphael Emportu wrote:

<snip for brevity>

>
>
> You didn't provide a list of items for your IN clause. It needs to be
> something like
>
> IN (1, 2, 3, 4)
>

Thanks great, I can work with that answer.

Cu.