Error Type: Microsoft VBScript compilation (0x800A0411) Name redefined

peony88 · July 27th, 2010, 08:30 AM

The data is actually getting to the database; but the page is not returbning proper page and info.

peony88 · July 27th, 2010, 09:23 AM

Technical Information (for support personnel)

Error Type:
ADODB.Recordset (0x800A0CC1)
Item cannot be found in the collection corresponding to the requested name or ordinal.
/asp/dtsAddRequest.asp, line 947

Browser Type:
Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; InfoPath.2; .NET CLR 1.1.4322; MS-RTC EA 2; MS-RTC LM 8)

Page:
POST 463 bytes to /asp/dtsAddRequest.asp

POST Data:
cf=1&TicketNubmer=&CreationDate=&userType=1&Machin e=&Manager=&ReceivedBy=&Source=&AssignedTo=&Priori ty=&Hardware=&Software=&Status=&InformedUser=&Time Solved=&StaffNT=&NTEstimatedTime=&DoneNT=&MoreInfo . . .

Time:
Tuesday, July 27, 2010, 9:24:52 AM

Old Pedant · July 27th, 2010, 02:08 PM

First of all, fix your browser.

Click on the TOOLS menu.
Click on the INTERNET OPTIONS menu item.
Click on ADVANCED tab.
*UN*check "Show friendly HTTP error meesages"
OK

Now you will get the actual ASP errors, instead of the useless 500 crud that MSIE generates.

*************

The error you are seeing means that you are trying to get the value of a field from the recordset when that field does not exist in the record.

Example:

Code:

SQL = "SELECT name, address FROM people WHERE id = " & id
Set RS = conn.Execute( SQL )
Response.Write RS("phone")

The SELECT statement only selected the field name and address so you can't then ask for the "phone" field.

To fix the problem, you need to add "phone" to the list of fields in the SELECT:

Code:

SQL = "SELECT name, address, phone FROM people WHERE id = " & id

Of course it is also possible that you are simply misspelling the name of the field in your ASP code. Or or or...

Since I have no idea which is line 947, I'll let you find that line and diagnose the problem.

peony88 · July 27th, 2010, 02:10 PM

Thanks, b ut the thread has progressed beyond this already.

Old Pedant · July 27th, 2010, 02:13 PM

Amazingly enough, I *THINK* I found your error:

Code:

strTicketNumber = rsAddRequest("TicketNubmer")
Session("TICKETNUMBER") = strTicketNubmer

Two different places where you spelled "number" wrong.

peony88 · July 27th, 2010, 02:16 PM

Surprisingly they did that on purpose.

Old Pedant · July 27th, 2010, 02:48 PM

Quote:

Originally Posted by peony88

Thanks, b ut the thread has progressed beyond this already.

No idea what that is supposed to mean.

Old Pedant · July 27th, 2010, 02:51 PM

Quote:

Originally Posted by peony88

Surprisingly they did that on purpose.

I don't think I believe that. There is no such variable on the page as strTicketNubmer (there is an oft-used variable named just TicketNubmer, but that's not the same variable...no "str" on the front).

Granted, there could be a field name misspelled in the DB. So maybe the first of those two lines is on purpose. But the second one is clearly wrong.

In any case, I guess I don't care. When/if you figure out which line is 947 then we will know the culprit.

peony88 · July 27th, 2010, 03:04 PM

Hi,
I've tried the spelling both ways, and receive the same message fir the line below:
This is line 947:
[code]
strTicketNumber = rsAddRequest("TicketNubmer")
[\code]

The error reads:
Error Type:
ADODB.Recordset (0x800A0CC1)
Item cannot be found in the collection corresponding to the requested name or ordinal.
/asp/dtsAddRequest.asp, line 947

Browser Type:
Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; InfoPath.2; .NET CLR 1.1.4322; MS-RTC EA 2; MS-RTC LM 8)

Page:
POST 439 bytes to /asp/dtsAddRequest.asp

Old Pedant · July 27th, 2010, 03:44 PM

Well, I guess you'll just have to find out what the result of executing the stored procedure query is.

No, I'll tell you what: Let's put in some DEBUG code.

Bur first, FIX YOUR BROWSER as I suggested!! Stop getting those meaningless MSIE junk fake error messages.

*TEMPORARILY* replace line 947 with this code:

Code:

Dim fnum, ffld 
For fnum = 0 To rsAddRequest.Fields.Count-1
    Set ffld = rsAddRequest.Fields(fnum)
    Response.Write ffld.Name & "::" & ffld.Value & "<br/>"
Next
Response.End

That will dump out all the field names (and their values) in that recordset. If the name you need isn't in there, then you'll have to go look at that stored procedure (it_AddRequest) to find out why not.