Okay....

[Jim Rudnick]

Hello Nick..

Um...fine. Here's the entire code for the asp page that is supposed to record who enters the website. It's still under dev, so it's on my dev box...but I use IIS5 and w2kPro and have dev asp sites for 5 years or so by now...

Here's that page...
=========================================================
<%
nDate=date()
nTime=time()
'set var to the date and time functions built into asp

%>
<!--#Include file ="dbConn.asp"-->
<%
' get passed var to use for visitors name...

visitorName = Request.QueryString("Visitor")

' find out the visitors IP here...
comeFrom = Request.ServerVariables("REMOTE_ADDR")

' create the SQL query here....

SQL = "SELECT * FROM Visitors"

' connect to mySQL and get queried items...

rs.open SQL, conn, 2,3

' write new visitor to dbase to record this visit...

rs.AddNew

rs.Fields("Visitor") = visitorName

rs.Fields("VisitDate") = nDate & " " & nTime

rs.Fields("IP") = comeFrom

rs.Update

Response.Redirect("index.asp")
%>
============================================================

Heres' the source code for the table that is supposed to HOLD this visitors list...

CREATE TABLE `visitors` (
`Id` int(6) unsigned NOT NULL auto_increment,
`Visitor` varchar(15) NOT NULL default '',
`VisitDate` datetime NOT NULL default '0000-00-00 00:00:00',
`IP` varchar(20) NOT NULL default '',
PRIMARY KEY (`Id`)
) TYPE=MyISAM;

==========================================================
And a reminder, that when I use a 3 char name/password like Jim/tvr it works perfectly, and I can see the proper visitors listing showing that login.

It's when I try to use David/qqq that it fails with that damn error...and I've no idea why?

Jim