Migrating Access Program to ASP have problems with Yes/No Field

[A P]

I am planning to migrate my exisiting MS Access program that uses yes/no
fields (checkbox). Can ASP identifies checkbox field of ms access? I am
planning to use the same database and use msacess for report generation and
web browser for encoding to the database.

Hope you could help me.

Me

[David Morgan]

The answer is yes.

When testing for 'yes' you would say

WHERE Field = 1

Or

WHERE Field = 'True'
"A P" <[e-mail]> wrote in message
news:%2***************@TK2MSFTNGP11.phx.gbl...

I am planning to migrate my exisiting MS Access program that uses yes/no
fields (checkbox). Can ASP identifies checkbox field of ms access? I am
planning to use the same database and use msacess for report generation and web browser for encoding to the database.

Hope you could help me.

Me

[A P]

I tried to access certain field with Yes/No data type from MS Access but IE
gave me an error message:

Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.

What do I need to do?

"David Morgan" <da***@davidmorgan.me.uk> wrote in message
news:e4**************@TK2MSFTNGP09.phx.gbl...

The answer is yes.

When testing for 'yes' you would say

WHERE Field = 1

Or

WHERE Field = 'True'
"A P" <[e-mail]> wrote in message
news:%2***************@TK2MSFTNGP11.phx.gbl...

I am planning to migrate my exisiting MS Access program that uses yes/no
fields (checkbox). Can ASP identifies checkbox field of ms access? I am
planning to use the same database and use msacess for report generation

and

web browser for encoding to the database.

Hope you could help me.

Me

[Ray Costanzo [MVP]]

It's hard to say without seeing what your query is, i.e.

Response.write sqlString
response.end

Try using:

where fieldname=true

instead of
where fieldname='true'
if that's what you were using.

Ray at home

"A P" <[e-mail]> wrote in message
news:eK**************@TK2MSFTNGP12.phx.gbl...

I tried to access certain field with Yes/No data type from MS Access but IE
gave me an error message:

Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.

What do I need to do?

"David Morgan" <da***@davidmorgan.me.uk> wrote in message
news:e4**************@TK2MSFTNGP09.phx.gbl...

The answer is yes.

When testing for 'yes' you would say

WHERE Field = 1

Or

WHERE Field = 'True'
"A P" <[e-mail]> wrote in message
news:%2***************@TK2MSFTNGP11.phx.gbl...

> I am planning to migrate my exisiting MS Access program that uses
> yes/no
> fields (checkbox). Can ASP identifies checkbox field of ms access? I am
> planning to use the same database and use msacess for report generation

and

> web browser for encoding to the database.
>
> Hope you could help me.
>
> Me
>
>

[A P]

The error was gone but I think the query cannot find what I'm looking for.

SELECT * FROM tblform WHERE Served = True

Note that Served field is a Yes/No MS Access Data Type.

Me
"Ray Costanzo [MVP]" <my first name at lane 34 dot commercial> wrote in
message news:u9*************@TK2MSFTNGP12.phx.gbl...

It's hard to say without seeing what your query is, i.e.

Response.write sqlString
response.end

Try using:

where fieldname=true

instead of
where fieldname='true'
if that's what you were using.

Ray at home

"A P" <[e-mail]> wrote in message
news:eK**************@TK2MSFTNGP12.phx.gbl...

I tried to access certain field with Yes/No data type from MS Access but IE gave me an error message:

Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.

What do I need to do?

"David Morgan" <da***@davidmorgan.me.uk> wrote in message
news:e4**************@TK2MSFTNGP09.phx.gbl...

The answer is yes.

When testing for 'yes' you would say

WHERE Field = 1

Or

WHERE Field = 'True'
"A P" <[e-mail]> wrote in message
news:%2***************@TK2MSFTNGP11.phx.gbl...
> I am planning to migrate my exisiting MS Access program that uses
> yes/no
> fields (checkbox). Can ASP identifies checkbox field of ms access? I am > planning to use the same database and use msacess for report generation and
> web browser for encoding to the database.
>
> Hope you could help me.
>
> Me
>
>

[Bob Barrows [MVP]]

You need to use the numeric representations of true/false:
SELECT * FROM tblform WHERE Served = -1

Bob Barrows

A P wrote:

The error was gone but I think the query cannot find what I'm looking
for.

SELECT * FROM tblform WHERE Served = True

Note that Served field is a Yes/No MS Access Data Type.

Me
"Ray Costanzo [MVP]" <my first name at lane 34 dot commercial> wrote
in message news:u9*************@TK2MSFTNGP12.phx.gbl...

It's hard to say without seeing what your query is, i.e.

Response.write sqlString
response.end

Try using:

where fieldname=true

instead of
where fieldname='true'
if that's what you were using.

Ray at home

"A P" <[e-mail]> wrote in message
news:eK**************@TK2MSFTNGP12.phx.gbl...

I tried to access certain field with Yes/No data type from MS
Access but IE gave me an error message:

Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.

What do I need to do?

"David Morgan" <da***@davidmorgan.me.uk> wrote in message
news:e4**************@TK2MSFTNGP09.phx.gbl...
The answer is yes.

When testing for 'yes' you would say

WHERE Field = 1

Or

WHERE Field = 'True'
"A P" <[e-mail]> wrote in message
news:%2***************@TK2MSFTNGP11.phx.gbl...
> I am planning to migrate my exisiting MS Access program that uses
> yes/no
> fields (checkbox). Can ASP identifies checkbox field of ms
> access? I am planning to use the same database and use msacess
> for report generation and web browser for encoding to the
> database.
>
> Hope you could help me.
>
> Me

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"