Professional Web Applications Themes

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

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

  1. #1

    Default 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


    A Guest

  2. #2

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

    The answer is yes.

    When testing for 'yes' you would say

    WHERE Field = 1

    Or

    WHERE Field = 'True'


    "A P" <ph> wrote in message
    news:%phx.gbl... 
    and 


    David Guest

  3. #3

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

    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" <me.uk> wrote in message
    news:phx.gbl... 
    > and 
    >
    >[/ref]


    A Guest

  4. #4

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

    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" <ph> wrote in message
    news:phx.gbl... 
    >> and 
    >>
    >>[/ref]
    >
    >[/ref]


    Ray Guest

  5. #5

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

    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:phx.gbl... [/ref]
    IE [/ref][/ref]
    am [/ref][/ref]
    generation 
    > >
    > >[/ref]
    >
    >[/ref]


    A Guest

  6. #6

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

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

    Bob Barrows

    A P wrote: [/ref][/ref]

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


    Bob Guest

Similar Threads

  1. Problems inserting a date field into Access db
    By Terry Murray in forum ASP Database
    Replies: 6
    Last Post: September 18th, 01:18 AM
  2. [PHP] How to access a program outside of PHP?
    By Adam Douglas in forum PHP Development
    Replies: 6
    Last Post: September 11th, 02:39 PM
  3. How to access a program outside of PHP?
    By Adam Douglas in forum PHP Development
    Replies: 2
    Last Post: September 10th, 03:49 PM
  4. program access
    By Bob in forum Windows Setup, Administration & Security
    Replies: 0
    Last Post: July 26th, 09:16 PM
  5. Replies: 1
    Last Post: July 16th, 11:29 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139