MySQL Forums
Forum List  »  Microsoft Access

Re: Ahh..you're not an ASP guy...sorry!
Posted by: Nick Roper
Date: August 03, 2004 03:14PM

Jim,

Aha, now the mist is beginning to clear... You are quite correct - although I have an O'Reilly 'ASP in a nutshell' - I've never actually read it, so excuse my lack of understanding.

> Also I do not understand (my turn?) what you mean by "updating the table with a 5 letter name directly from the mysql prompt.." either what you mean or how to try same???

OK, what I'm talking about is using the mysql command-line client to connect to the server and then trying to execute an INSERT statement. For example, on a windows box, it would go something like this:

c:\> mysql -u username -p
Enter Password: ********
Welcome....

mysql>

(at this point you are connected to the server - note, if the mysql executable isn't in $PATH you may have to use the full path:
c:\> c:\mysql\bin\mysql -u username -p

)

mysql> USE databasename;

Database changed
mysql> INSERT INTO VISITORS (Visitor, VistDate, IP) VALUES (etc...) ;

See: http://dev.mysql.com/doc/mysql/en/INSERT.html for the syntax

If you can insert 5 char names by this method, then it 'aint the MySQL engine that is causing the problem - so it would suggest that the problem is something in the front-end - maybe mySQLFront

To quit the mysql client:

mysql> \q

Let me know...

Cheers,

Nick



--
Nick Roper

Options: ReplyQuote


Subject
Views
Written By
Posted
4501
July 29, 2004 02:46PM
2691
July 29, 2004 03:39PM
2858
July 29, 2004 05:21PM
2523
July 30, 2004 12:40AM
2839
July 30, 2004 07:43AM
2511
July 30, 2004 08:11AM
2570
July 30, 2004 03:17PM
2540
July 31, 2004 02:06AM
2554
July 31, 2004 12:07PM
2627
August 01, 2004 09:12AM
2531
August 02, 2004 06:15PM
2541
August 03, 2004 01:49PM
2687
August 03, 2004 01:48PM
Re: Ahh..you're not an ASP guy...sorry!
2651
August 03, 2004 03:14PM


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.