SQL statement giving me an error when requesting certain field

Hello everyone,

I'm using a MySQL server as a game server for a MMORPG that I'm developing.  Everything for the game is working correctly, but I've decided to allow the players to log into their account through the website (using ASP) to pay their bill, purchase in game items, etc.  The problem I'm having is actually in the Admin area of the website.

Here's the error:
Script error detected at line 17.
Description: Variable uses an Automation type not supported in VBScript

Here's the line of code:
response.write "<tr><td><a href=characters.asp?account_id="&rs("account_id")&">"&rs("username")&"</a></td><td>"&rs("password")&"</td><td>"&rs("email")&"</td><td>"&rs("isdm")&"</td><td>"&rs("isbanned")&"</td></tr>"

Now, when I change the rs("account_id") to any other field, the line of code works fine, so, here's the SQL statement that  created this table, the problem field is account_id:

CREATE TABLE `rc_accounts` (
  `account_id` int(11) unsigned NOT NULL auto_increment,
  `username` varchar(32) NOT NULL default '',
  `password` varchar(32) NOT NULL default '',
  `email` varchar(32) NOT NULL default '',
  `isdm` tinyint(4) NOT NULL default '0',
  `isbanned` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`account_id`)
) TYPE=MyISAM;

If all I do is response.write rs("account_id") and nothing else in the line, it prints.  As soon as I add other things to this line of code, I get the error.

Here's my question:
How can I view the data in the account_id field without having to change the field type?
Start Free Trial