Column name spacing problem

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • KK
    #1

    Column name spacing problem

    Hello Everyone,

    i have a column named "Cell No" but when am trying to get data from it
    using query "select * from data where Cell No=?" it throws an error

    i know the problem is because of the spacing in the column name. For
    some technical reasons i cannot change the column name, so is there
    any way in which the query will run properly with space?

    If anyone know abt this plz share it with me.


    Thanking you,


    Regards,

    Kartikeya
    Tags: None
    • JvC
      #2
      Re: Column name spacing problem

      [Cell No] needs to have brackets.

      "select * from data where [Cell No]=?"

      John

      "KK" <Kartikeya.Karn atak@gmail.comw rote in message
      news:dd3fba69-65ad-4b3c-a1fa-7edee857127b@s2 1g2000prm.googl egroups.com...
      Hello Everyone,
      >
      i have a column named "Cell No" but when am trying to get data from it
      using query "select * from data where Cell No=?" it throws an error
      >
      i know the problem is because of the spacing in the column name. For
      some technical reasons i cannot change the column name, so is there
      any way in which the query will run properly with space?
      >
      If anyone know abt this plz share it with me.
      >
      >
      Thanking you,
      >
      >
      Regards,
      >
      Kartikeya

        Comment

        Previous template Next
        Working...