Professional Web Applications Themes

Problem with nulls - ASP.NET General

I am passing values from a form to an asp page that has the code to update underlying records with all changes. How can I update blank fields that are remaining blank or may have been just blanked out? The updates are bombing and it tells me I have to assign default input parameters for all fields. I don't want fields filled with info when they don't need info. Anyone have a workaround for this?...

  1. #1

    Default Problem with nulls

    I am passing values from a form to an asp page that has
    the code to update underlying records with all changes.
    How can I update blank fields that are remaining blank or
    may have been just blanked out?

    The updates are bombing and it tells me I have to assign
    default input parameters for all fields. I don't want
    fields filled with info when they don't need info.

    Anyone have a workaround for this?
    Bob Guest

  2. #2

    Default Re: Problem with nulls

    No I have not tried that, but don't think that will work. The input
    default parameters have to be defined on the asp page were generated
    using the database interface wizard. By stepping through the database
    results to tweek them, there is a point where you can select options and
    it allows you to define the defaults for all the fields.

    If I just typed in dbull.value I'm sure it would take it as a text
    string and enter that into a field that was passed as empty.

    I was just reading a Frontpage 2002 book and noticed the use of % as a
    default for search forms and may try that. I just don't know if there is
    anything that can be stuck in that box to pass nothing along.

    Maybe I need to regroup and dump data directly into the database and
    accept the funky update message that frontpage generates. It of course
    comes across without any formatting or theme.

    I'll give what you suggested a shot, but am not very optimistic based on
    what is has done to me so far.

    Thanks for your rapid response.

    Bob



    *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
    Don't just participate in USENET...get rewarded for it!
    Robert Lambrecht Guest

Similar Threads

  1. Webcontrol nulls values?
    By DrBytes in forum ASP.NET Building Controls
    Replies: 1
    Last Post: March 18th, 12:39 PM
  2. How to return default value for NULLs?
    By sblue in forum Coldfusion Database Access
    Replies: 6
    Last Post: October 10th, 07:42 PM
  3. empty strings vs nulls
    By Eric Walker in forum Perl / CGI
    Replies: 5
    Last Post: November 25th, 02:16 AM
  4. Casting nulls
    By Carl Furst in forum PHP Development
    Replies: 3
    Last Post: September 24th, 11:39 PM
  5. dealing with nulls....
    By Ken Schaefer in forum ASP
    Replies: 3
    Last Post: July 7th, 05:49 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