If err.number <> 0 probs in subroutine

Greywacke · March 4th, 2004, 07:12 AM

okay... i have gone though the code, sifted as much as possible, and as a result the following code only writes the line numbers...

Code:

Response.Write "1723:"
With Response
    .Write "<TABLE WIDTH=100% BORDER=0 CELLSPACING=10 CELLPADDING=0>" & vbCrLf
    .Write "    <TR>" & vbCrLf
    .Write "        <TD CLASS=err><B>The transaction failed setting up while withdrawing " & gwRS("str_rpgname") & " chips from your account (error #" & err.number & ": " & err.description & " [" & err.source & ", line " & err.line & "]).  Please try again at a later time.</B></TD>" & vbCrLf
    .Write "    </TR>" & vbCrLf
    .Write "</TABLE>"
End With
Response.Write "1731:"

just writes 1723:1731 to the page, no details about the error that was raised in the first place...now why would the err object not be working as i have always used it?

Sincerely,
Pierre du Toit.

Greywacke · March 4th, 2004, 07:34 AM

hmmm... commented on error resume next, that with response bit ain't writing cause of gwRS not being instantiated. now i get the following error:

Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 4.

fine, i have seen expected 1 before, but never expected 4...

could anyone please try shed some light on the subject?

Sincerely,
Pierre du Toit.

Greywacke · March 4th, 2004, 07:35 AM

nevermind, found prob, but now it gives Expected 2 o.0

will have to find out yet what the numbers mean in that expected N part of the error...

Sincerely,
Pierre du Toit.

kumarpa · March 4th, 2004, 09:29 AM

In Access DB if field data type is text, data should be inclosed with in ' ' single quotes.

Expected.. N is number of fields not having '' around them.

Greywacke · March 4th, 2004, 04:13 PM

sorry, but i have to strongly argue... works fine now, and the problems were incorrect field names, as one of the developers changed the mdb... i counted the incorrect field names, and yes, there were 4, 2 and 1 respectavely of them however before i fixed the sql string... i was comparing fields to fields, not fields to values...

Sincerely,
Pierre du Toit.