Re: Exception error

From: Bob Barrows [MVP] (reb01501_at_NOyahoo.SPAMcom)
Date: 12/30/04 

Date: Thu, 30 Dec 2004 10:06:53 -0500

Please reply to and include a quote from the message to which you are
replying. You do not have to quote the whole message, in fact, it is best to
trim the parts of the message which are not relevant, as I will do below.

Lakrom wrote:
> Thanks but already I have proven that the registry does not come
> vacio, I have done it with Response.Write(dRs("fecha")) and
> Response.End() asi that I believe that the exception must be of
> another side.

>> Set dRs=dConn.Execute("select * from solicitud_canje_gte_temp where
>> rut='"&session("Rut")&"' ORDER BY month(fecha)")
>> do until dRs.eof

I did miss this line. OK, your recordset contains records.

>> * Do until month(dRs("Fecha"))<>month(VFech) (Line of error)
>> (0x80020009)

What happens if you simply do

Response.Write month(VFech)

? Are you certain VFech contains a valid date? If you get an error, try
explicitly converting it to a date using CDate:

Response.Write month(CDate(VFech))

Bob Barrows 

-- 
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

Relevant Pages

  • Re: times today and sunblock
    ... You posted your reply above the point to which you were replying which is generally considered to be bad form in usenet. ... It just refers to writing the reply above the point to which you are replying rather than after the point so that it appears in context, it is nothing to do with starting a new thread. ... reach everyone who is in a newsgroup. ... We did discuss how to explain it better but that was the best we could come up with at the time however the following humorous quote may help to explain it better than I can. ...
    (uk.rec.scouting)
  • Re: slow xp perf. on compaq machine
    ... You'll find it easier to get help in a newsgroup if you quote the message to ... which you are replying. ... > I am aware of the reputation of these machines.... ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: Programs to download...
    ... please always quote when replying. ... By neglecting to do so you ... > make the newsgroup more difficult to follow. ...
    (comp.sys.palmtops.pilot)
  • Re: net.Passport problems
    ... > trying to figure out how to get this to quote auto like. ... >> Please quote the message to which you are replying. ... >> Ken Blake - Microsoft MVP Windows: ... >> Please reply to the newsgroup ...
    (microsoft.public.windowsxp.general)
  • Re: Exception error
    ... with CDate function and is the same error. ... You do not have to quote the whole message, in fact, it is best ... OK, your recordset contains records. ... > quicker response by posting to the newsgroup. ...
    (microsoft.public.inetserver.asp.general)
Loading