Professional Web Applications Themes

help with a SELECT query - MySQL

Hi all, I have tables with columns names containing dots and I'm trying to build up queries as in: select it.n.cuore.1.lemma from a027; But I get errors complaining about a syntax error. I have been told that for names containing special chars need to be wrapped by squared brackets as in: select [it.n.cuore.1.lemma] from a027 but I get the same error. Can someone help me?...

  1. #1

    Default help with a SELECT query

    Hi all, I have tables with columns names containing dots and I'm trying to
    build up queries as in:

    select it.n.cuore.1.lemma from a027;
    But I get errors complaining about a syntax error.

    I have been told that for names containing special chars need to be wrapped
    by squared brackets as in:

    select [it.n.cuore.1.lemma] from a027

    but I get the same error.
    Can someone help me?


    halex2000 Guest

  2. #2

    Default Re: help with a SELECT query

    halex2000 wrote:
    > Hi all, I have tables with columns names containing dots and I'm trying to
    > build up queries as in:
    >
    > select it.n.cuore.1.lemma from a027;
    > But I get errors complaining about a syntax error.
    >
    > I have been told that for names containing special chars need to be
    > wrapped by squared brackets as in:
    >
    > select [it.n.cuore.1.lemma] from a027
    >
    > but I get the same error.
    > Can someone help me?

    Use backticks.

    SELECT `it.n.cuore.1.lemma` FROM a027;


    --
    Brian Wakem
    Email: [url]http://homepage.ntlworld.com/b.wakem/myemail.png[/url]
    Brian Wakem Guest

  3. #3

    Default Re: help with a SELECT query

    This works, thanks!

    "Brian Wakem" <noemail.com> ha scritto nel messaggio
    news:4j4im4F6748pU1individual.net...
    > halex2000 wrote:
    >
    >> Hi all, I have tables with columns names containing dots and I'm trying
    >> to
    >> build up queries as in:
    >>
    >> select it.n.cuore.1.lemma from a027;
    >> But I get errors complaining about a syntax error.
    >>
    >> I have been told that for names containing special chars need to be
    >> wrapped by squared brackets as in:
    >>
    >> select [it.n.cuore.1.lemma] from a027
    >>
    >> but I get the same error.
    >> Can someone help me?
    >
    >
    > Use backticks.
    >
    > SELECT `it.n.cuore.1.lemma` FROM a027;
    >
    >
    > --
    > Brian Wakem
    > Email: [url]http://homepage.ntlworld.com/b.wakem/myemail.png[/url]
    >

    halex2000 Guest

Similar Threads

  1. Query of Query to select a title first letter
    By Conti in forum Coldfusion Database Access
    Replies: 2
    Last Post: March 18th, 11:42 PM
  2. select query help
    By Abul Hasan Lakhani in forum MySQL
    Replies: 8
    Last Post: October 15th, 07:04 PM
  3. Select query
    By Ad Bec in forum Coldfusion Database Access
    Replies: 2
    Last Post: October 10th, 06:00 AM
  4. Using < and > in a select query
    By Grynch in forum Coldfusion Database Access
    Replies: 3
    Last Post: April 18th, 03:55 AM
  5. Select box determines query...
    By Seth Buntin in forum Coldfusion - Advanced Techniques
    Replies: 1
    Last Post: February 17th, 07:25 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