Loading ...
Sorry, an error occurred while loading the content.
 

RE: [baseball-databank] database and openoffice

Expand Messages
  • Alberto Perdomo
    Why not using , =, instead of like operator? Like operator is normally used for strings values. Ex. Select * from batting 3B 23 .. Also you
    Message 1 of 8 , May 3, 2009

      Why not using >,<,=,>=,<=,<> instead of ‘like’ operator?   Like operator is normally used for strings values.

       

      Ex.   Select * from batting 3B > 23 …. Also you might need to enclose the 3B or 2B fields between [] …  like, Select * from batting where [3B] like 23

       

      From: baseball-databank@yahoogroups.com [mailto:baseball-databank@yahoogroups.com] On Behalf Of moose
      Sent: Sunday, May 03, 2009 1:10 PM
      To: baseball-databank@yahoogroups.com
      Subject: [baseball-databank] database and openoffice

       





      Is anyone using openoffice with the Lahman database?

      I am having issues when I try to make a query with the 2B and 3B data, getting errors that I do not understand...

      an example

      select *
      from batting
      where 3B like 23

      gives the following error

      SQL Status: HY000
      Error code: 1000

      syntax error, unexpected $end, expecting BETWEEN or IN or SQL_TOKEN_LIKE



      what am I missing?

      thanks

      mike

       

    Your message has been successfully submitted and would be delivered to recipients shortly.