MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.
Course Of The Month
5 days, 4 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Query not working with number
Posted on 2006-11-30
I'm trying to make a query that will select records
where category = restaurant, restaurant and bar, etc (see below)
AND
24hour = True
I had a previous recordset but instead of 24hour = True best = true: which works fine (SQL below)
SELECT *
FROM entertainment
WHERE category in ('Restaurant' , 'Restaurant and Bar', 'Restaurant and Club', 'Restaurant, Bar and Club') AND best = True
ORDER BY ID DESC
When I change "best = true" to "24hour = true" I get error "Syntax error (missing opperator)" I assume this is becasue "24hour" starts with a number or some other small problem with my syntax. Below is what I have. Does anyone know what I'm din wrong?
SELECT *
FROM entertainment
WHERE category in ('Restaurant' , 'Restaurant and Bar', 'Restaurant and Club', 'Restaurant, Bar and Club') AND 24hour = True
ORDER BY ID DESC
where category = restaurant, restaurant and bar, etc (see below)
AND
24hour = True
I had a previous recordset but instead of 24hour = True best = true: which works fine (SQL below)
SELECT *
FROM entertainment
WHERE category in ('Restaurant' , 'Restaurant and Bar', 'Restaurant and Club', 'Restaurant, Bar and Club') AND best = True
ORDER BY ID DESC
When I change "best = true" to "24hour = true" I get error "Syntax error (missing opperator)" I assume this is becasue "24hour" starts with a number or some other small problem with my syntax. Below is what I have. Does anyone know what I'm din wrong?
SELECT *
FROM entertainment
WHERE category in ('Restaurant' , 'Restaurant and Bar', 'Restaurant and Club', 'Restaurant, Bar and Club') AND 24hour = True
ORDER BY ID DESC
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2
2
5 Comments
Not sure which database you're using, but SQL Server doesn't use True/False. It uses a bit field instead which is 1/0
It obviously depends on how you designed the tables, but you should always use a bit field for true/false values, in which case your query becomes this:
SELECT *
FROM entertainment
WHERE
(category in ('Restaurant' , 'Restaurant and Bar', 'Restaurant and Club', 'Restaurant, Bar and Club')) AND
(24hour = 1)
ORDER BY ID DESC
It obviously depends on how you designed the tables, but you should always use a bit field for true/false values, in which case your query becomes this:
SELECT *
FROM entertainment
WHERE
(category in ('Restaurant' , 'Restaurant and Bar', 'Restaurant and Club', 'Restaurant, Bar and Club')) AND
(24hour = 1)
ORDER BY ID DESC
Rouchie,
Thanks, I'm using an Access database. I fixed the problem by changing the name of the column from "24hour" to "twentyfourhour Any idea why the query won't work when it starts with a number?
Thanks, I'm using an Access database. I fixed the problem by changing the name of the column from "24hour" to "twentyfourhour Any idea why the query won't work when it starts with a number?
Probably because Access automatically reads the start of the word (the numbers) and presumes it's a number, then throws an error. 24hour may even be the name of a built-in time function in access. This is the most common cause of problems.
In SQL you can wrap braces around the column name to force it to read correctly:
SELECT *
FROM entertainment
WHERE
(category in ('Restaurant' , 'Restaurant and Bar', 'Restaurant and Club', 'Restaurant, Bar and Club')) AND
([24hour] = 1)
ORDER BY ID DESC
In SQL you can wrap braces around the column name to force it to read correctly:
SELECT *
FROM entertainment
WHERE
(category in ('Restaurant' , 'Restaurant and Bar', 'Restaurant and Club', 'Restaurant, Bar and Club')) AND
([24hour] = 1)
ORDER BY ID DESC
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Suggested Solutions
| Title | # Comments | Views | Activity |
|---|---|---|---|
| Unable to Connect Via FTP | 109 | 1,317 | |
| removing xml elements and children | 5 | 553 | |
| Setting up PHP server | 3 | 223 | |
| Dreamweaver FTP Access | 12 | 96 |
I still run into .cgi files every now and then. In some instances, I actually prefer the simplicity of a .cgi script to other options. Since I use DreamWeaver extensively, what I needed was a way to open .cgi scripts in Dreamweaver. And I wanted to …
This article is very specific and is only intended to help if you are installing Dreamweaver 8 in a Windows 7 environment with Office 2007 installed. I'm not sure why Microsoft tends to release OS' that should not be released but they do. Windows…
Are you ready to implement Active Directory best practices without reading 300+ pages?
You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…
Suggested Courses
Course of the Month5 days, 4 hours left to enroll
739 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.