Re: Rare fout bij ASP

Article View: nl.comp.programmeren

Article #143

Back to nl.comp.programmeren Previous Next

#143

From: MTI | Johan
Date: Sun, 21 Aug 2005 13:52

27 lines
1687 bytes

Ik zou eens zien welke waarde catID heeft wanneer het die error genereerd.

function getCount(catID)
    on error resume next
    if not isnull(catID) and catID<>"" then
        getCount = "select count(*) as counter from table where catID = " &
catID
    else
        getCount = ""
    end if
    if err<>0 then
        response.write catID & " - " & getCount
        response.end
    end if
end function


> varX = session("varX")
>
> of
>
> function getCount(catID)
>    q = "select count(*) from table where catID = " & catID
> end function
>
> Ik krijg daar mijn error op de q = "select...." lijn.
> Weet iemand raad?

Technical Details

Message-ID: <fG%Ne.4317$ih4.822@fe02.lga>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!cyclone1.gnilink.net!gnilink.net!hwmnpeer01.lga!hwmedia!hw-filter.lga!fe02.lga.POSTED!53ab2750!not-for-mail

References: <1124309236.879909@bru-ix-srv240>

Show Full Headers

Complete Article Headers

X-Google-Thread: 107324,22166f304e05a8b8
X-Google-Thread: fcea4,22166f304e05a8b8
X-Google-Attributes: gid107324,gidfcea4,public
X-Google-Language: DUTCH,ASCII-7-bit
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!cyclone1.gnilink.net!gnilink.net!hwmnpeer01.lga!hwmedia!hw-filter.lga!fe02.lga.POSTED!53ab2750!not-for-mail
From: "MTI | Johan" <mti@mti.com>
Newsgroups: nl.comp.programmeren,be.comp.programming
References: <1124309236.879909@bru-ix-srv240>
Subject: Re: Rare fout bij ASP
Lines: 29
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1506
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
Message-ID: <fG%Ne.4317$ih4.822@fe02.lga>
X-Trace: ejlmlnpfppkfdepliikigjdpjlgffccobodhknpdajapbafgebnfacecoakomcikecnkhklpcemckmdflieclemhakbmaigonlpldggfjgoihifghmilompedifeandabcfagklmibllijll
NNTP-Posting-Date: Sun, 21 Aug 2005 06:52:11 MST
Date: Sun, 21 Aug 2005 08:52:21 -0500

Reply to Parent Message