Professional Web Applications Themes

ASP & Mysql - Problem with blank text fields - ASP Database

I hadn't realized I had invalid information in my mail client, I have updated it and have re-posted to provide accurate information. "Test" <johndoebright.net> wrote in message news:sStWa.7646$Ly2.1226193cletus.bright.net... > I am moving an asp database driven webpage over from a linux server to a > windows 2000 server running iis. When an attempt is made to read an empty > text field into variable, the following error results: > > ------------------------------------------------------------ > > Microsoft OLE DB Provider for ODBC Drivers error '80040e21' > > Multiple-step OLE DB operation generated errors. Check each OLE DB status > value, if available. No ...

  1. #1

    Default Re: ASP & Mysql - Problem with blank text fields

    I hadn't realized I had invalid information in my mail client, I have
    updated it and have re-posted to provide accurate information.

    "Test" <johndoebright.net> wrote in message
    news:sStWa.7646$Ly2.1226193cletus.bright.net...
    > I am moving an asp database driven webpage over from a linux server to a
    > windows 2000 server running iis. When an attempt is made to read an empty
    > text field into variable, the following error results:
    >
    > ------------------------------------------------------------
    >
    > Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
    >
    > Multiple-step OLE DB operation generated errors. Check each OLE DB status
    > value, if available. No work was done.
    >
    > /focus.asp, line 38
    >
    > ------------------------------------------------------------
    >
    > Here is a sample of the code:
    >
    > ------------------------------------------------------------
    >
    > '================================================= ===========
    > ' DECLARE QUERY, PULL DATA
    > '------------------------------------------------------------
    > strQ = "SELECT * FROM gallery WHERE page = '" & ingallery & "' AND id = '"
    &
    > inid & "'"
    > Set IQ = connect.Execute(strQ)
    > While Not IQ.EOF
    > outid = IQ.Fields(0)
    > outfilename = IQ.Fields(1)
    > outpage = IQ.Fields(2)
    > outcaption = IQ.Fields(3)
    > IQ.Movenext
    > Wend
    >
    > ------------------------------------------------------------
    >
    > Line 38 is "outcaption = IQ.Fields(3)". I have also tried listing the
    > fields in the mysql query instead of using '*', but that doesn't seem to
    > help.
    >
    >
    >

    Joel Guest

  2. #2

    Default Re: ASP & Mysql - Problem with blank text fields

    Something else I've noticed:

    Originally, the caption fields were 'not null' fields. If I set them to
    allow null and set all captions that were '' to null, I don't get any
    errors. However, as soon as I set one to '', it results the the error I
    mentioned earlier.

    Some sort of dsn setting I can change perhaps?

    "Joel" <joelsephwatchtv.net> wrote in message
    news:eUtWa.7647$Ly2.1226051cletus.bright.net...
    > I hadn't realized I had invalid information in my mail client, I have
    > updated it and have re-posted to provide accurate information.
    >
    > "Test" <johndoebright.net> wrote in message
    > news:sStWa.7646$Ly2.1226193cletus.bright.net...
    > > I am moving an asp database driven webpage over from a linux server to a
    > > windows 2000 server running iis. When an attempt is made to read an
    empty
    > > text field into variable, the following error results:
    > >
    > > ------------------------------------------------------------
    > >
    > > Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
    > >
    > > Multiple-step OLE DB operation generated errors. Check each OLE DB
    status
    > > value, if available. No work was done.
    > >
    > > /focus.asp, line 38
    > >
    > > ------------------------------------------------------------
    > >
    > > Here is a sample of the code:
    > >
    > > ------------------------------------------------------------
    > >
    > > '================================================= ===========
    > > ' DECLARE QUERY, PULL DATA
    > > '------------------------------------------------------------
    > > strQ = "SELECT * FROM gallery WHERE page = '" & ingallery & "' AND id =
    '"
    > &
    > > inid & "'"
    > > Set IQ = connect.Execute(strQ)
    > > While Not IQ.EOF
    > > outid = IQ.Fields(0)
    > > outfilename = IQ.Fields(1)
    > > outpage = IQ.Fields(2)
    > > outcaption = IQ.Fields(3)
    > > IQ.Movenext
    > > Wend
    > >
    > > ------------------------------------------------------------
    > >
    > > Line 38 is "outcaption = IQ.Fields(3)". I have also tried listing the
    > > fields in the mysql query instead of using '*', but that doesn't seem to
    > > help.
    > >
    > >
    > >
    >
    >

    Joel Guest

Similar Threads

  1. Problem with acrobat 9 when validating text fields
    By Reitinger_Alfred@adobeforums.com in forum Adobe Acrobat SDK
    Replies: 3
    Last Post: November 4th, 08:32 PM
  2. PDF with text fields problem (illustrator)
    By Lance_Elliottt@adobeforums.com in forum Adobe Acrobat Macintosh
    Replies: 1
    Last Post: September 22nd, 02:50 AM
  3. Replies: 0
    Last Post: June 16th, 11:22 PM
  4. blank spaces in text fields in form
    By kb'sbuddy in forum Macromedia ColdFusion
    Replies: 1
    Last Post: April 20th, 06:27 PM
  5. PHP & MySQL :- and input text fields -perlexing!!!
    By Portfar in forum PHP Development
    Replies: 3
    Last Post: June 25th, 10:40 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