MySQL Forums
Forum List  »  Microsoft Access

Re: Okay....
Posted by: Jim Rudnick
Date: July 31, 2004 12:07PM

<grin> you missed the SQL by 2 lines...

Above that little code snippet is the part where I go to the dbase table and load the complete table...via this code...

SQL = "SELECT * from table Visitors"

then...

rs.Open conn SQL, 2,3

AND THEN the run thru for the items I'm adding...

rs.AddNew

rs.Fields("Visitor") = visitorName

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

rs.Fields("IP") = comeFrom

rs.Update

THIS WORKS perfectly STILL with any 3 char NAME, that exists in my security table, but NOT with any name larger than 3 chars.

Can you see, here, that the problem seems to be some kind of 'constraint' on the name field in Visitors -- that it won't accept any more than 3 chars no matter that it's a varchar at 255 chars????

This seems simple to me -- the problem that is, and while I appreciate your help, all the questions so far have been redundant. I've been asp'ing things for 5 years and I assure you my code is perfect. It runs perfectly. But not with any name bigger than 3 chars. THIS is a mySQL problem, not an asp coding problem, I assure you alll....

Could anyone else here with mySQL expertise try to get back to me with why that might be -- and yes, I've deleted the whole table, and reconstructed a brand new one that STILL will not take a name bigger than 3 chars.

Anyone?

Jim


Options: ReplyQuote


Subject
Views
Written By
Posted
4520
July 29, 2004 02:46PM
2721
July 29, 2004 03:39PM
2877
July 29, 2004 05:21PM
2535
July 30, 2004 12:40AM
2863
July 30, 2004 07:43AM
2536
July 30, 2004 08:11AM
2581
July 30, 2004 03:17PM
2558
July 31, 2004 02:06AM
Re: Okay....
2578
July 31, 2004 12:07PM
2646
August 01, 2004 09:12AM
2552
August 02, 2004 06:15PM
2562
August 03, 2004 01:49PM
2713
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.