Check Box SQL

Posted on 2006-04-01
Last Modified: 2008-02-07
I am using a Yes/No checkbox in my access DB and want to display all records on a page which have checkbox ticked.

rsItem.Source = "SELECT * FROM tblItem WHERE ItemYesNo = '1' ORDER BY ItemRef ASC"

The above code doesn't work.
Any suggestions?
Question by:Swn-Y-Mor
    LVL 4

    Expert Comment

    Please clarify. What database are you using, and what scripting language?

    Author Comment

    I mentioned Access database in the question.
    Sorry, forgot to mention ASP and VBScript
    LVL 17

    Accepted Solution

    rsItem.Source = "SELECT * FROM tblItem WHERE ItemYesNo=1 ORDER BY ItemRef ASC"

    BR Dushan

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    For those who don't know, Adobe Dreamweaver is a popular commercial web editor that enables you to design, build and manage complex websites. The editor is a WYSIWYG (What You See Is What You Get) web editor, which means that you can create your web…
    I still run into .cgi files every now and then. In some instances, I actually prefer the simplicity of a .cgi script to other options. Since I use DreamWeaver extensively, what I needed was a way to open .cgi scripts in Dreamweaver. And I wanted to …
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now