MySQL Forums
Forum List  »  Microsoft Access

Re: Okay....
Posted by: Nick Roper
Date: August 01, 2004 09:12AM

Jim,

OK, I'll try one more time:

Yes, I have seen the SQL = "SELECT * from Visitors" statement, but this is NOT what I am asking you for!

You have said that the problem occurs when the new visitor is added, so that is the statement that I've been asking for. e.g. something like:

"INSERT INTO VISITORS (Visitor, VistDate, IP) VALUES (etc...) ;"

Once again, I'm not doubting your asp coding, but without being able to see what the actual statement is that is being used (not the function calls are that used to build it), then it's going to be difficult to try and spot the problem.

Also, I asked if you have tried updating the table with a 5 character name directly from the mysql prompt (which I was able to do using your table definition). Have you actually tried doing this?


--
Nick Roper

Options: ReplyQuote


Subject
Views
Written By
Posted
4591
July 29, 2004 02:46PM
2765
July 29, 2004 03:39PM
2928
July 29, 2004 05:21PM
2569
July 30, 2004 12:40AM
2927
July 30, 2004 07:43AM
2584
July 30, 2004 08:11AM
2621
July 30, 2004 03:17PM
2611
July 31, 2004 02:06AM
2634
July 31, 2004 12:07PM
Re: Okay....
2691
August 01, 2004 09:12AM
2602
August 02, 2004 06:15PM
2615
August 03, 2004 01:49PM
2761
August 03, 2004 01:48PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.