Professional Web Applications Themes

How come if you use a rs.fields(0).value it sometimes is empty? - ASP Database

Why does this happen: the code below works fine as-is. If I take out tempValue = rs.fields(i).value and put rs.fields(i).value everywhere instead, some fields end up empty!! Why does this happen? I'm using Access. while not rs.eof for i = 0 to rs.fields.count - 1 miniId = rs.fields(0).value statId = i + 1 tempValue = rs.fields(i).value if (not tempValue = "") And (not isNull(tempValue)) Then response.write(tempValue & "<br>") statValue = replace(tempValue, "'", "''") else response.write(tempValue & "<br>") statValue = "--" end if...

  1. #1

    Default How come if you use a rs.fields(0).value it sometimes is empty?

    Why does this happen:

    the code below works fine as-is. If I take out tempValue =
    rs.fields(i).value and put rs.fields(i).value everywhere instead, some
    fields end up empty!! Why does this happen? I'm using Access.


    while not rs.eof
    for i = 0 to rs.fields.count - 1
    miniId = rs.fields(0).value
    statId = i + 1
    tempValue = rs.fields(i).value
    if (not tempValue = "") And (not isNull(tempValue)) Then
    response.write(tempValue & "<br>")
    statValue = replace(tempValue, "'", "''")
    else
    response.write(tempValue & "<br>")
    statValue = "--"
    end if
    Mike Guest

  2. #2

    Default Re: How come if you use a rs.fields(0).value it sometimes is empty?

    Mike wrote:
    > Why does this happen:
    >
    > the code below works fine as-is. If I take out tempValue =
    > rs.fields(i).value and put rs.fields(i).value everywhere instead, some
    > fields end up empty!! Why does this happen? I'm using Access.
    Huh? I don't understand what you are saying. Show us the modification you
    are making (and explain the problem you are trying to solve that prompted
    you to make the modification)
    >
    >
    > while not rs.eof
    > for i = 0 to rs.fields.count - 1
    > miniId = rs.fields(0).value
    > statId = i + 1
    > tempValue = rs.fields(i).value
    > if (not tempValue = "") And (not isNull(tempValue)) Then
    > response.write(tempValue & "<br>")
    > statValue = replace(tempValue, "'", "''")
    > else
    > response.write(tempValue & "<br>")
    > statValue = "--"
    > end if
    --
    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 Barrows [MVP] Guest

  3. #3

    Default Re: How come if you use a rs.fields(0).value it sometimes is empty?

    Is the column MEMO? [url]http://www.aspfaq.com/2188[/url]

    --
    [url]http://www.aspfaq.com/[/url]
    (Reverse address to reply.)




    "Mike" <mike_newsgroups> wrote in message
    news:6a68ace3.0408111959.3667d6a6posting.google.c om...
    > Why does this happen:
    >
    > the code below works fine as-is. If I take out tempValue =
    > rs.fields(i).value and put rs.fields(i).value everywhere instead, some
    > fields end up empty!! Why does this happen? I'm using Access.
    >
    >
    > while not rs.eof
    > for i = 0 to rs.fields.count - 1
    > miniId = rs.fields(0).value
    > statId = i + 1
    > tempValue = rs.fields(i).value
    > if (not tempValue = "") And (not isNull(tempValue)) Then
    > response.write(tempValue & "<br>")
    > statValue = replace(tempValue, "'", "''")
    > else
    > response.write(tempValue & "<br>")
    > statValue = "--"
    > end if

    Aaron [SQL Server MVP] Guest

Similar Threads

  1. Check Empty form fields
    By wavesurfer in forum Macromedia Exchange Dreamweaver Extensions
    Replies: 0
    Last Post: August 19th, 10:05 AM
  2. Empty Fields
    By HMOKeefe in forum Coldfusion - Getting Started
    Replies: 12
    Last Post: October 14th, 03:43 PM
  3. Dealing with empty fields from database query
    By Ian50 in forum Dreamweaver AppDev
    Replies: 0
    Last Post: February 22nd, 06:04 AM
  4. Replies: 1
    Last Post: March 4th, 07:46 PM
  5. Omitting form fields if empty
    By JDJones in forum PHP Development
    Replies: 1
    Last Post: September 8th, 06:20 PM

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