| Author |
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
| |
| David Morgan 2004-09-24, 8:55 am |
| 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
>
>
| |
| Ray Costanzo [MVP] 2004-09-27, 3:55 am |
| 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[color=darkred]
am[color=darkred]
generation[color=darkred]
>
>
| |
| Bob Barrows [MVP] 2004-09-27, 8:55 am |
| You need to use the numeric representations of true/false:
SELECT * FROM tblform WHERE Served = -1
Bob Barrows
A P wrote:[color=darkred]
> 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"
|
|
|
|