Professional Web Applications Themes

reserved word? - MySQL

Hello, I got a PHP script in wich i have the following sql request: $configs = $db->getAll( 'SELECT * from !',array( CONFIG_TABLE ) ); No table is specified what is the character '!'? is it a reserved word or symbol? Do you know how SQL select the good table by the way of "!"? Thank you. Dominique...

  1. #1

    Default reserved word?

    Hello,

    I got a PHP script in wich i have the following sql request:

    $configs = $db->getAll( 'SELECT * from !',array( CONFIG_TABLE ) );

    No table is specified

    what is the character '!'? is it a reserved word or symbol?

    Do you know how SQL select the good table by the way of "!"?

    Thank you.

    Dominique



    cd Guest

  2. #2

    Default Re: reserved word?

    cd wrote:
    > Hello,
    >
    > I got a PHP script in wich i have the following sql request:
    >
    > $configs = $db->getAll( 'SELECT * from !',array( CONFIG_TABLE ) );
    >
    > No table is specified
    >
    > what is the character '!'? is it a reserved word or symbol?
    >
    > Do you know how SQL select the good table by the way of "!"?
    >
    > Thank you.
    >
    > Dominique
    I suspec that getAll is a method in a custom class. If you look through all
    the includes to find the funcion getAll, you should find a bit of code that
    substitutes a table name for the placeholder !.

    HTH
    Regards
    Paul


    Paul Lautman Guest

  3. #3

    Default Re: reserved word?

    ok Paul. You are right certainly.
    I am not yet accustomed with the programming object...
    Thanks a lot!
    Dominique

    "Paul Lautman" <paul.lautmanbtinternet.com> a écrit dans le message de
    news: [email]4dim34F1acmkuU1individual.net[/email]...
    > cd wrote:
    > > Hello,
    > >
    > > I got a PHP script in wich i have the following sql request:
    > >
    > > $configs = $db->getAll( 'SELECT * from !',array( CONFIG_TABLE ) );
    > >
    > > No table is specified
    > >
    > > what is the character '!'? is it a reserved word or symbol?
    > >
    > > Do you know how SQL select the good table by the way of "!"?
    > >
    > > Thank you.
    > >
    > > Dominique
    >
    > I suspec that getAll is a method in a custom class. If you look through
    all
    > the includes to find the funcion getAll, you should find a bit of code
    that
    > substitutes a table name for the placeholder !.
    >
    > HTH
    > Regards
    > Paul
    >
    >

    cd Guest

Similar Threads

  1. Reserved Word Problem or CFMX7 Bug?
    By Dr. Goomba in forum Coldfusion Database Access
    Replies: 1
    Last Post: November 2nd, 01:03 AM
  2. Reserved characters in name attribute??
    By ternst in forum Coldfusion - Advanced Techniques
    Replies: 0
    Last Post: May 25th, 04:49 PM
  3. Reserved characters in name attribute???
    By ternst in forum Coldfusion Flash Integration
    Replies: 0
    Last Post: May 25th, 04:47 PM
  4. Reserved characters for name attribute
    By ternst in forum Macromedia ColdFusion
    Replies: 0
    Last Post: May 25th, 04:45 PM
  5. I4GL V7.30 and up - undoented reserved words
    By Malc P in forum Informix
    Replies: 1
    Last Post: September 18th, 01:52 AM

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