Community Learn Tools Library Leisure
search
English
Home > Database > Mysql Tutorial > 关于access数据库的查询问题

关于access数据库的查询问题

WBOY
Release： 2016-06-07 15:42:26
Original
1582 people have browsed it

SELECT MemberID FROM Members WHERE (Account = 'iisp') AND (PWD = '96E79218965EB72C92A549DD5A330112') AND (Audited = [true]) 黑色部分是有错部分， 数据库 中字段类型位布尔类型 这个 查询 报错，至少一个参数没有被指定值， 如果修改为 (Audited =tr

SELECT MemberID FROM Members
WHERE (Account = 'iisp') AND (PWD = '96E79218965EB72C92A549DD5A330112') AND 
      (Audited = [true])

黑色部分是有错部分，数据库中字段类型位布尔类型

这个查询报错，至少一个参数没有被指定值，

如果修改为    (Audited =‘true’)，

报错信息修改为：标准表达式式中数据类型不匹配

Related labels：
access mem select about database Inquire question
source：php.cn
Previous article：DBI模块操作数据库示例 Next article：数据库SQL之表关系&连接查询
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
Where is the courseware about CSS mind mapping? Courseware
From 2024-04-16 10:10:18
0
0
1335
Move the content to the left by adding the Width property I have provided margins to the body. main {left margin: 200px; right margin: 200px; text a...
From 2024-04-06 22:01:35
0
3
816
Where should I place CustomLog directive in apache I'm using php:7.2-apachedocker. I need to disable health check url login access log. Based...
From 2024-04-06 22:03:59
0
1
990
The query and formula form the entire table, with new columns, where the new columns are formulas involving other conditional column values EDIT: The formula should be the "value" column - the "value" column wi...
From 2024-04-06 21:23:40
0
2
530
Creating this specific design using a grid: a step-by-step guide I'm trying to create a layout similar to this image, I've tried using this grid but can't ...
From 2024-04-06 20:29:08
0
2
492
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template