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

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

The answer is yes.

When testing for 'yes' you would say

WHERE Field = 1

Or

WHERE Field = 'True'


"A P" <ap@textguru.ph> wrote in message
news:%23Ju0DOfoEHA.536@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
>
>

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" <david@davidmorgan.me.uk> wrote in message
news:e4v79eioEHA.3728@TK2MSFTNGP09.phx.gbl...
> The answer is yes.
>
> When testing for 'yes' you would say
>
> WHERE Field = 1
>
> Or
>
> WHERE Field = 'True'
>
>
> "A P" <ap@textguru.ph> wrote in message
> news:%23Ju0DOfoEHA.536@TK2MSFTNGP11.phx.gbl... 
> and 
>
>

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" <ap@textguru.ph> wrote in message
news:eKIerNFpEHA.2900@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" <david@davidmorgan.me.uk> wrote in message
> news:e4v79eioEHA.3728@TK2MSFTNGP09.phx.gbl... 
>
>

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:u9BJlaFpEHA.692@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" <ap@textguru.ph> wrote in message
> news:eKIerNFpEHA.2900@TK2MSFTNGP12.phx.gbl... 
IE 
am 
generation 
>
>

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:u9BJlaFpEHA.692@TK2MSFTNGP12.phx.gbl... 

--
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"