Sorry if this e-mail is rather long but I want to give all code I am using
as to make sure that everyone has all the information they need.
Machine info:
MySQL for Win 2000
IIS5
The Table:
CREATE TABLE Players (
pid INT AUTO_INCREMENT NOT NULL,
RealFullName CHAR(70) NOT NULL,
RealAge INT NOT NULL,
EMAIL CHAR(50) NOT NULL,
Login CHAR(50) NOT NULL,
Password CHAR(50) NOT NULL,
UserLevel TINYINT NOT NULL,
lastip CHAR(20) NOT NULL,
lastlogindate DATE NOT NULL,
lastlogintime TIME NOT NULL,
rank INT NOT NULL,
turns INT NOT NULL,
money BIGINT NOT NULL,
commission INT NOT NULL,
bodyguards INT NOT NULL,
associates INT NOT NULL,
soldiers INT NOT NULL,
captains INT NOT NULL,
hitmen INT NOT NULL,
glocks INT NOT NULL,
shotguns INT NOT NULL,
mguns INT NOT NULL,
srifles INT NOT NULL,
food INT NOT NULL,
fid INT NOT NULL,
Voted TINYINT NOT NULL,
Frozen TINYINT NOT NULL,
Squelched TINYINT NOT NULL,
PRIMARY KEY (pid),
UNIQUE (Login),
UNIQUE (EMail)
);
The ASP Code:
set dbs = CreateObject ("ADODB.Connection")
dbs.Open "gamedb"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.open "SELECT * FROM Players", dbs, 3,3
rs.addnew
rs("pid") = lastpid + 1
rs("RealFullName") = request.form("FullName")
rs("RealAge") = request.form("RealAge")
rs("EMail") = request.form("EMail")
rs("Login") = request.form("usrname")
rs("Password") = request.form("usrpassword")
rs("UserLevel") = 1
session.contents("UserLevel") = 1
if request.form("usrname") = "Kewlb" or _
request.form("usrname") = "Strike" then
rs("UserLevel") = 5
session.contents("UserLevel") = 5
end if
rs("LastIP") = Request.ServerVariables("REMOTE_ADDR")
rs("LastLoginDate") = date
rs("LastLoginTime") = time
rs("rank") = 0
rs("turns") = 355
rs("money") = 7500
rs("commission") = 10
rs("bodyguards") = 5
rs("associates") = 0
rs("soldiers") = 0
rs("captains") = 0
rs("hitmen") = 0
rs("glocks") = 0
rs("shotguns") = 0
rs("mguns") = 0
rs("srifles") = 0
rs("food") = 500
rs("fid") = 0
rs("voted") = 0
rs("frozen") = 0
rs("Squelched") = 0
session.contents("LoggedIn") = true
rs.update
dbs.close
ASP ERROR:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)
Multiple-step OLE DB operation generated errors. Check each OLE DB status
value, if available. No work was done.
/mafiastar/doregister.asp, line 53
if I try to manually (via mysqlgui) add a new record I get the following:
column count doesn't match value count
Any help would be great, once again sorry for the really long e-mail
Brian Clark - A+, Net+, CCA, MCP, CCNA
Systems Anyalsis
Expanets Direct
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
