RE: Problem with Query in ASP

I like cheese

-----Original Message-----
From: Anthony Johnston . Antix [mailto:tech@xxxxxxxxxxx]
Sent: Wednesday, February 19, 2003 11:24 AM
To: MySQL Win32
Cc: john@xxxxxxxxxxxxxxxxxxxx
Subject: RE: Problem with Query in ASP


Yup,  must be a driver bug,  don't know why.
It works fine if you set the text field to 'allow null'

Ant.

>-----Original Message-----
>From: John Winningham [mailto:john@xxxxxxxxxxxxxxxxxxxx]
>Sent: 19 February 2003 16:10
>To: Anthony Johnston . Antix
>Subject: RE: Problem with Query in ASP
>
>
>I do have a few long text fields.  They are set to default to a blank
field.
>having it that way causes problems with ASP queries?  What kind of problem
>did you have?
>
>Thanks for your help,
>John
>
>
>-----Original Message-----
>From: Anthony Johnston . Antix [mailto:tech@xxxxxxxxxxx]
>Sent: Wednesday, February 19, 2003 7:57 AM
>To: john@xxxxxxxxxxxxxxxxxxxx
>Subject: RE: Problem with Query in ASP
>
>
>do you have any large text fields in the table?
>
>if so make sure you make them allow Null,  sounds
>like you have a similar problem to one I had.
>
>Ant.
>
>>-----Original Message-----
>>From: John Winningham [mailto:john@xxxxxxxxxxxxxxxxxxxx]
>>Sent: 18 February 2003 23:07
>>To: win32@xxxxxxxxxxxxxxx
>>Subject: Problem with Query in ASP
>>
>>
>>I am having a problem creating a query.  I have a MySQL database table
that
>>apparently I can only do aggregate calculations on.  When I try and
perform
>>a search to return a record set, it consistently comes back with no
records
>>(even though I have checked the queries, and they are valid, and do return
>>records in MySQLFront).  I have also run the exact same code using a
>>different table, and it returns records.  I'm not sure whether there's
>>something in my table that ASP doesn't like or what, I'm kind of at a
loss.
>>Any help or insight in solving this problem would be appreciated.
>>
>>Thanks,
>>John
>>
>>
>>---------------------------------------------------------------------
>>Please check "http://www.mysql.com/Manual_chapter/manual_toc.html"; before
>>posting. To request this thread, e-mail win32-thread10568@xxxxxxxxxxxxxxx
>>
>>To unsubscribe, send a message to the address shown in the
>>List-Unsubscribe header of this message. If you cannot see it,
>>e-mail win32-unsubscribe@xxxxxxxxxxxxxxx instead.
>>
>

---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html"; before
posting. To request this thread, e-mail win32-thread10574@xxxxxxxxxxxxxxx

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail win32-unsubscribe@xxxxxxxxxxxxxxx instead.

---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html"; before
posting. To request this thread, e-mail win32-thread10575@xxxxxxxxxxxxxxx

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail win32-unsubscribe@xxxxxxxxxxxxxxx instead.