|
 |
asp_databases thread: Works with SQL Server,MS Access but not with MYSQL
Message #1 by "vivek" <vivsandela@h...> on Fri, 27 Sep 2002 21:15:52
|
|
Hi this code works fine on SQL Server,MS ACcess but not on MYSQL.,
<%
if rs1("mem_Description")="" then
result_store=0
else
result_store=1
end if
%>
<%
if not Replace(rs1("mem_Description"),"%COMMON%","../Images")="" then
reason=Replace(rs1("mem_Description"),"%COMMON%","../Images")
answer_text=Replace(rs1("txt_optiontext"),"%COMMON%","../Images")
%>
It gives error at this line:
if rs1("mem_Description")="" then
Error:
error '80020009'
Exception occurred.
mem_Description is a medium_text datatype(mysql). Any help i woul
appreciate. Thanks.
~Chints
Message #2 by "Peter Foti (PeterF)" <PeterF@S...> on Fri, 27 Sep 2002 16:38:42 -0400
|
|
My guess would be that rs1("mem_Description") is Null (which is different
than empty string "").
Try this:
if Not isNull(rs("mem_Description")) Then
if rs1("mem_Description")="" then
result_store=0
else
result_store=1
end if
else
result_store=0
end if
Hope this helps.
Pete
> -----Original Message-----
> From: vivek [mailto:vivsandela@h...]
> Sent: Friday, September 27, 2002 9:16 PM
> To: ASP Databases
> Subject: [asp_databases] Works with SQL Server,MS Access but not with
> MYSQL
>
>
> Hi this code works fine on SQL Server,MS ACcess but not on MYSQL.,
> <%
> if rs1("mem_Description")="" then
> result_store=0
> else
> result_store=1
> end if
> %>
> <%
> if not Replace(rs1("mem_Description"),"%COMMON%","../Images")="" then
> reason=Replace(rs1("mem_Description"),"%COMMON%","../Images")
> answer_text=Replace(rs1("txt_optiontext"),"%COMMON%","../Images")
> %>
>
> It gives error at this line:
> if rs1("mem_Description")="" then
>
> Error:
> error '80020009'
> Exception occurred.
>
>
> mem_Description is a medium_text datatype(mysql). Any help i woul
> appreciate. Thanks.
>
> ~Chints
>
Message #3 by "vivek" <vivsandela@h...> on Fri, 27 Sep 2002 22:01:07
|
|
Pete.,
I tried it but its still not working.,giving me the same error!
:(
chints
> My guess would be that rs1("mem_Description") is Null (which is different
than empty string "").
Try this:
if Not isNull(rs("mem_Description")) Then
if rs1("mem_Description")="" then
result_store=0
else
result_store=1
end if
else
result_store=0
end if
Hope this helps.
Pete
> -----Original Message-----
> From: vivek [mailto:vivsandela@h...]
> Sent: Friday, September 27, 2002 9:16 PM
> To: ASP Databases
> Subject: [asp_databases] Works with SQL Server,MS Access but not with
> MYSQL
>
>
> Hi this code works fine on SQL Server,MS ACcess but not on MYSQL.,
> <%
> if rs1("mem_Description")="" then
> result_store=0
> else
> result_store=1
> end if
> %>
> <%
> if not Replace(rs1("mem_Description"),"%COMMON%","../Images")="" then
> reason=Replace(rs1("mem_Description"),"%COMMON%","../Images")
> answer_text=Replace(rs1("txt_optiontext"),"%COMMON%","../Images")
> %>
>
> It gives error at this line:
> if rs1("mem_Description")="" then
>
> Error:
> error '80020009'
> Exception occurred.
>
>
> mem_Description is a medium_text datatype(mysql). Any help i woul
> appreciate. Thanks.
>
> ~Chints
>
Message #4 by "Peter Foti (PeterF)" <PeterF@S...> on Fri, 27 Sep 2002 17:26:38 -0400
|
|
Hmm... can you write out the contents of rs1("mem_Description")? Comment
out all of that other code and just do this:
Response.Write( "[" & rs1("mem_Description") & "]")
So if rs1("mem_Description") equals "hello world", then this should print
out:
[hello world]
See if that works.
Pete
> -----Original Message-----
> From: vivek [mailto:vivsandela@h...]
> Sent: Friday, September 27, 2002 10:01 PM
> To: ASP Databases
> Subject: [asp_databases] RE: Works with SQL Server,MS Access but not
> with MYSQL
>
>
> Pete.,
> I tried it but its still not working.,giving me the same error!
> :(
>
> chints
>
>
>
>
>
>
>
> > My guess would be that rs1("mem_Description") is Null
> (which is different
> than empty string "").
>
> Try this:
>
> if Not isNull(rs("mem_Description")) Then
> if rs1("mem_Description")="" then
> result_store=0
> else
> result_store=1
> end if
> else
> result_store=0
> end if
>
>
> Hope this helps.
> Pete
>
>
> > -----Original Message-----
> > From: vivek [mailto:vivsandela@h...]
> > Sent: Friday, September 27, 2002 9:16 PM
> > To: ASP Databases
> > Subject: [asp_databases] Works with SQL Server,MS Access
> but not with
> > MYSQL
> >
> >
> > Hi this code works fine on SQL Server,MS ACcess but not on MYSQL.,
> > <%
> > if rs1("mem_Description")="" then
> > result_store=0
> > else
> > result_store=1
> > end if
> > %>
> > <%
> > if not
> Replace(rs1("mem_Description"),"%COMMON%","../Images")="" then
> > reason=Replace(rs1("mem_Description"),"%COMMON%","../Images")
> > answer_text=Replace(rs1("txt_optiontext"),"%COMMON%","../Images")
> > %>
> >
> > It gives error at this line:
> > if rs1("mem_Description")="" then
> >
> > Error:
> > error '80020009'
> > Exception occurred.
> >
> >
> > mem_Description is a medium_text datatype(mysql). Any help i woul
> > appreciate. Thanks.
> >
> > ~Chints
> >
>
Message #5 by "Peter Foti (PeterF)" <PeterF@S...> on Fri, 27 Sep 2002 17:32:37 -0400
|
|
You might also take a look at some of the info at Microsoft's website like
this:
http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q175239&LN=EN-US&SD
gn&FR=0
or do a Google search:
http://www.google.com/search?hl=en&ie=ISO-8859-1&q=80020009+Exception
These might yield better results.
Regards,
Pete
> -----Original Message-----
> From: vivek [mailto:vivsandela@h...]
> Sent: Friday, September 27, 2002 10:01 PM
> To: ASP Databases
> Subject: [asp_databases] RE: Works with SQL Server,MS Access but not
> with MYSQL
>
>
> Pete.,
> I tried it but its still not working.,giving me the same error!
> :(
>
> chints
>
>
>
>
>
>
>
> > My guess would be that rs1("mem_Description") is Null
> (which is different
> than empty string "").
>
> Try this:
>
> if Not isNull(rs("mem_Description")) Then
> if rs1("mem_Description")="" then
> result_store=0
> else
> result_store=1
> end if
> else
> result_store=0
> end if
>
>
> Hope this helps.
> Pete
>
>
> > -----Original Message-----
> > From: vivek [mailto:vivsandela@h...]
> > Sent: Friday, September 27, 2002 9:16 PM
> > To: ASP Databases
> > Subject: [asp_databases] Works with SQL Server,MS Access
> but not with
> > MYSQL
> >
> >
> > Hi this code works fine on SQL Server,MS ACcess but not on MYSQL.,
> > <%
> > if rs1("mem_Description")="" then
> > result_store=0
> > else
> > result_store=1
> > end if
> > %>
> > <%
> > if not
> Replace(rs1("mem_Description"),"%COMMON%","../Images")="" then
> > reason=Replace(rs1("mem_Description"),"%COMMON%","../Images")
> > answer_text=Replace(rs1("txt_optiontext"),"%COMMON%","../Images")
> > %>
> >
> > It gives error at this line:
> > if rs1("mem_Description")="" then
> >
> > Error:
> > error '80020009'
> > Exception occurred.
> >
> >
> > mem_Description is a medium_text datatype(mysql). Any help i woul
> > appreciate. Thanks.
> >
> > ~Chints
> >
>
|
|
|
View Cart
