ASP & Mysql - Problem with blank text fields

[Joel]

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" <johndoe@bright.net> wrote in message
news:sStWa.7646$Ly2.1226193@cletus.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]

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" <joelseph@watchtv.net> wrote in message
news:eUtWa.7647$Ly2.1226051@cletus.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" <johndoe@bright.net> wrote in message
> news:sStWa.7646$Ly2.1226193@cletus.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.
> >
> >
> >

>
>