mysql 5.0.67

--001636c5a82f1be3cb046b726fa6
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

Hi

I'm using version 5.0.67 and have a strange problem. I have a text field
and have a query which returned 193 characters (with spaces). In the mySQL
query browser I can see the field content fine.

However on my classic ASP page, I get nothing when I reponse the data to the
screen. Infact if I try to perform a replace function on the field data I
get


Microsoft VBScript runtime error '800a005e'

Invalid use of Null: 'replace'



Any ideas what the problem might be ?
Cheers
Neil

--001636c5a82f1be3cb046b726fa6--

RE: mysql 5.0.67

Niel,

I don't use ASP, but it sounds more like a syntax error in your script.
http://classicasp.aspfaq.com/general/how-do-i-prevent-invali d-use-of-null-e=
rrors.html

However, if you're still having problems, please give us the exact query yo=
u're running, the table structure, and the Code snippet from your script.

Regards,
Gavin Towey

-----Original Message-----
From: Tompkins Neil [mailto:neil.tompkins@googlemail.com]
Sent: Wednesday, June 03, 2009 7:26 AM
To: [MySQL]
Subject: mysql 5.0.67

Hi

I'm using version 5.0.67 and have a strange problem. I have a text field
and have a query which returned 193 characters (with spaces). In the mySQL
query browser I can see the field content fine.

However on my classic ASP page, I get nothing when I reponse the data to th=
e
screen. Infact if I try to perform a replace function on the field data I
get


Microsoft VBScript runtime error '800a005e'

Invalid use of Null: 'replace'



Any ideas what the problem might be ?
Cheers
Neil

The information contained in this transmission may contain privileged and c=
onfidential information. It is intended only for the use of the person(s) n=
amed above. If you are not the intended recipient, you are hereby notified =
that any review, dissemination, distribution or duplication of this communi=
cation is strictly prohibited. If you are not the intended recipient, pleas=
e contact the sender by reply email and destroy all copies of the original =
message.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: mysql 5.0.67

--001636c5aa41175a2f046b817339
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

Hi

After further investigation it would appear that I needed to update the
mySQL ODBC connnecter to the latest version.

Thanks
Neil

On Wed, Jun 3, 2009 at 6:43 PM, Gavin Towey wrote:

> Niel,
>
> I don't use ASP, but it sounds more like a syntax error in your script.
>
> http://classicasp.aspfaq.com/general/how-do-i-prevent-invali d-use-of-null-errors.html
>
> However, if you're still having problems, please give us the exact query
> you're running, the table structure, and the Code snippet from your script.
>
> Regards,
> Gavin Towey
>
> -----Original Message-----
> From: Tompkins Neil [mailto:neil.tompkins@googlemail.com]
> Sent: Wednesday, June 03, 2009 7:26 AM
> To: [MySQL]
> Subject: mysql 5.0.67
>
> Hi
>
> I'm using version 5.0.67 and have a strange problem. I have a text field
> and have a query which returned 193 characters (with spaces). In the mySQL
> query browser I can see the field content fine.
>
> However on my classic ASP page, I get nothing when I reponse the data to
> the
> screen. Infact if I try to perform a replace function on the field data I
> get
>
>
> Microsoft VBScript runtime error '800a005e'
>
> Invalid use of Null: 'replace'
>
>
>
> Any ideas what the problem might be ?
> Cheers
> Neil
>
> The information contained in this transmission may contain privileged and
> confidential information. It is intended only for the use of the person(s)
> named above. If you are not the intended recipient, you are hereby notified
> that any review, dissemination, distribution or duplication of this
> communication is strictly prohibited. If you are not the intended recipient,
> please contact the sender by reply email and destroy all copies of the
> original message.
>

--001636c5aa41175a2f046b817339--