Re: MS Access Query Search Fails on Boolean

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: jt (jtsoft_at_hotmail.com)
Date: 04/21/04


Date: Wed, 21 Apr 2004 22:18:18 GMT

My apology.

jt

"Bob Barrows" <reb01501@NOyahoo.SPAMcom> wrote in message
news:%23g8tlD5JEHA.892@TK2MSFTNGP09.phx.gbl...
> jt wrote:
> > I have a query that I would like to search on where my field is a
> > boolean.
> >
> > This is the error and the sql statment below,
> >
> > Error: No value given for one or more required parameters.
> >
> > SQL : SELECT * FROM [tablename] WHERE Red-Flag = True
> >
> > Appreciate any help on this, since I am new to SQL.
> >
> > Thank!
> > jt
>
> Already answered over in .db
>
> Please do not multipost jt.This is definitely a database-related
> question so .asp.db was the perfect group in which to post it. Posting it
> here as well did not increase your chances of getting an answer (most of
us
> subscribe to both groups). On the contrary, if somebody had taken his time
> to answer it here, only to find that it was already resolved in the other
> group, that person may have been annoyed enough to ignore any future posts
> from you, thereby decreasing your chances of getting help in the future.
>
> There are times when you will not be sure which group is most appropriate
> (again, this was not one of them), and you will want to post a question to
> both groups. In that situation, you should use the cross-posting
technique,
> rather than posting the same message multiple times. To crosspost, put
> a semicolon-delimited* list of the newsgroups to which you wish to post in
> the To: header of your post and post it once. It, and any replies to it,
> will appear in all the newsgroups in your list. So, if I reply in .asp.db,
> my reply will also appear here in .asp.general.
>
> * ... or whatever delimiter is recognized by your news client
>
> Bob Barrows
> --
> 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"
>
>
>



Relevant Pages

  • Re: Trapping odbc error when execing INSERT command
    ... Thanks for letting me know. ... that person may have been annoyed enough to ignore any future posts ... thereby decreasing your chances of getting help in the future. ... >rather than posting the same message multiple times. ...
    (microsoft.public.inetserver.asp.general)
  • Re: MS Access Query Search Fails on Boolean
    ... that person may have been annoyed enough to ignore any future posts ... thereby decreasing your chances of getting help in the future. ... will appear in all the newsgroups in your list. ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.general)
  • Re: Failed to acces the SQL Server table from MS Access by ODBC Link T
    ... that person may have been annoyed enough to ignore any future posts ... thereby decreasing your chances of getting help in the future. ... will appear in all the newsgroups in your list. ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.general)
  • Re: ASP help required
    ... that person may have been annoyed enough to ignore any future posts ... thereby decreasing your chances of getting help in the future. ... will appear in all the newsgroups in your list. ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.general)
  • Re: Pattern Matching
    ... thereby decreasing your chances of getting help in the future. ... should use the cross-posting technique, ... It, and any replies to it, will appear in all the newsgroups in ... header is my spam trap, so I don't check it very often. ...
    (microsoft.public.inetserver.asp.db)