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
4520
July 29, 2004 02:46PM
2720
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
2578
July 31, 2004 12:07PM
2646
August 01, 2004 09:12AM
2552
August 02, 2004 06:15PM
2561
August 03, 2004 01:49PM
2712
August 03, 2004 01:48PM
Re: Ahh..you're not an ASP guy...sorry!
2673
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.