2. ASPRunnerPro General questions
  3. Microsoft VBScript runtime error '800a01c9'
This topic is locked

Microsoft VBScript runtime error '800a01c9'

 		3/27/2006 9:06:59 PM
ASPRunnerPro General questions
L
 larryreed author

<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=2688&image=1&table=forumtopics' class='bbc_emoticon' alt=':(' />
Any idea why I would be getting this error?
Microsoft VBScript runtime error '800a01c9'
This key is already associated with an element of this collection
/output/_tournamentsignups_add.asp, line 651
Admin 3/28/2006

Larry,
It seems that your query returns duplicate field names.

Try to use the field alias.

For example

select

table1.name

table2.name as name2
L
 		larryreed author 3/28/2006

Larry,

It seems that your query returns duplicate field names.

Try to use the field alias.

For example


Why does this error not show up on my local machine?, Only when on the remote server?
Its using all of the same output files, and database.
Admin 3/28/2006

Please zip and send generated ASP files to support@xlinesoft.com along with project file and your sample database for investigation.

I'll find what's wrong with your project running it on my test box.
L
 		larryreed author 3/29/2006

I have posted the project to a different website and the problem has gone away, must be a problem with the other domain. I will be deleting the other domain and re-adding. Thanks for you recent offer to test it on your test box.
Larry