MySQL Forums
Forum List  »  Microsoft Access

Re: But..
Posted by: Nick Roper
Date: July 31, 2004 02:06AM

Jim,

You included the code that prepares and sends that statement:

-----------------------------------------------------------

' 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

-----------------------------------------------------------

but can you give example of the actual SQL strings that are sent to MySQL when rs.Update is called for a 3 letter or 5 letter name. For example:

"INSERT INTO visitors etc.....;"

Presumably the string is stored in a variable somewhere as it is being prepared, and then passed to the update process.

In your last message you talk about adding the name/pw/IP - but there is no password field in the table that stores the IP address.

As I say, I took your table definition and created the table and was then able to add the name OK. Have you tried updating the tables manually via the mysql client. Then you will know whether it is a problem with MySQL or with the interface.

We can't really go much further until we get a feel for what the SQL statements actually look like...

Cheers,

Nick



--
Nick Roper

Options: ReplyQuote


Subject
Views
Written By
Posted
4505
July 29, 2004 02:46PM
2694
July 29, 2004 03:39PM
2862
July 29, 2004 05:21PM
2524
July 30, 2004 12:40AM
2840
July 30, 2004 07:43AM
2514
July 30, 2004 08:11AM
2571
July 30, 2004 03:17PM
Re: But..
2542
July 31, 2004 02:06AM
2556
July 31, 2004 12:07PM
2629
August 01, 2004 09:12AM
2534
August 02, 2004 06:15PM
2544
August 03, 2004 01:49PM
2689
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.