Jump to content

Rich81

Newbies
  • Content Count

    2
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Rich81

  • Rank
    newbie
  1. Rich81

    JDBC and SQL

    Sorry, I really shouldn't have used that value for name1. This query example won't work: select * from "test.fm" where (name1 = 'rich' or name1 = 'bob') and city = 'winnipeg'
  2. Rich81

    JDBC and SQL

    I have a database called: "test.fm" I have two text fields: "name1" and "city" I made one record: name1 = rich city = winnipeg The following queries give me the following results (just prints the data): select * from "test.fm" where name1 = 'rich' select * from "test.fm" where name1 = 'rich' or name1 = 'blank' select * from "test.fm" where name1 = 'rich' and city = 'winnipeg' RESULTS: name1: rich city: winnipeg Here are the queries that don't work. They return no results at all. select * from "test.fm" where name1 = 'rich' or name1 = 'blank' and city = 'winnipeg' select * from "test.fm" where (name1 = 'rich' or name1 = 'blank') and city = 'winnipeg' This should definitely work. Any ideas, I really need help on this one.
×

Important Information

By using this site, you agree to our Terms of Use.