Professional Web Applications Themes

Query problem, please help. - MySQL

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?...

  1. #1

    Default Query problem, please help.

    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?
    Raphael Emportu Guest

  2. #2

    Default Re: Query problem, please help.

    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]jstucklexattglobal.net[/email]
    ==================
    Jerry Stuckle Guest

  3. #3

    Default Re: Query problem, please help.

    Jerry Stuckle <jstucklexattglobal.net> wrote in
    news:rsqdnc1l2rcPedLZnZ2dnUVZ_vGdnZ2dcomcast.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.
    Raphael Emportu Guest

Similar Threads

  1. query problem
    By Tony Rogerson in forum Coldfusion Database Access
    Replies: 35
    Last Post: November 2nd, 03:01 PM
  2. Query problem...
    By Martine Duval in forum MySQL
    Replies: 4
    Last Post: June 17th, 04:02 PM
  3. Query of Query problem
    By JakeFlynn in forum Macromedia ColdFusion
    Replies: 18
    Last Post: August 11th, 08:15 AM
  4. Problem with query
    By toby007 in forum Coldfusion Database Access
    Replies: 2
    Last Post: June 9th, 10:52 PM
  5. Query on Query and CF casting problem
    By obxlefty in forum Coldfusion - Advanced Techniques
    Replies: 0
    Last Post: May 18th, 12:44 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139