Re: help me please
Hello. The start point for you in such kind of problems should be researching the output of the following statement: SHOW VARIABLES LIKE '%char%'; Please, run it from different environments (PHP, MySQL Query Browser), and send results to the list. Include the CREATE statement for you tables which hold Latvian characters. Aleksejs Pavlans wrote: Hellou! I have MySQL(charset is utf-8) + PHP 5.0.5. Latvian symbols(auczsnsczikl) not correctly viewed in MySQL Query Browser, but in 'phpmyadmin' its ok. When i use php to viewed data with latvian symbols in IE, then latvian symbols(aui.) is converted to ? symbols. Please Help! Ar cienu, Aleksejs! -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
help me please
Hellou! I have MySQL(charset is utf-8) + PHP 5.0.5. Latvian symbols(auczsnsczikl) not correctly viewed in MySQL Query Browser, but in 'phpmyadmin' its ok. When i use php to viewed data with latvian symbols in IE, then latvian symbols(aui.) is converted to ? symbols. Please Help! Ar cienu, Aleksejs!
Fwd: Help me, please! Problems with relationship between tables!!!
Hi, I need to make relationishp between 4 tables in my system. I just don´t know how to make. Somebody could help me, please? The tables are: Order, Employee, ItensOrder and Unit. My objective: to program a report of Order that appears in the screen the fields ( id_order, name_employee, date_order, name_unit and status_order). I am sending an archive in annex explaining better. Please, it´s urgent! Thank you very much. Priscilla. - Yahoo! Messenger 6.0 - jogos, emoticons sonoros e muita diversão. Instale agora! __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ATTACHMENT part 2 application/msword name=tables_sql.doc __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
Re: Fwd: Help me, please! Problems with relationship between tables!!!
The attachment describing your tables didn't come through. However, here's roughly how your SELECT statement might look: SELECT Order.id_order, Employee.name_employee, ItemsOrder.date_order, Unit.name_unit, ItemsOrder.status_order FROM Order, Employee, ItemsOrder, Unit WHERE Order.id_order=ItemsOrder.id_order AND Order.emp_id=Employee.emp_id AND ItemsOrder.unit_id=Unit.unit_id; Notice that you link the tables together in the WHERE clause based on common columns between pairs of tables. The columns don't have to have the same name, just the same information. For instance, if the Order table has a column called emp_id and the Employee table has a table called rec_id and both are the employee's identification number, you would link those two tables together with an equal-sign in the WHERE clause. For any columns with the same names, put the table name and a dot before the column name (e.g., Employee.emp_id). On Thu, 2004-11-04 at 10:34, Priscilla Labanca wrote: The tables are: Order, Employee, ItensOrder and Unit. My objective: to program a report of Order that appears in the screen the fields ( id_order, name_employee, date_order, name_unit and status_order). -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Fwd: Help me, please! Problems with relationship between tables!!!
I prefer to explicitly declare my INNER JOINs (not to imply them by using commas to make a list of tables). That way I avoid accidentally creating any Cartesian products of any tables by leaving out a WHERE condition. Missing ON conditions are much easier to spot (IMHO). http://dev.mysql.com/doc/mysql/en/JOIN.html SELECT Order.id_order, Employee.name_employee, ItemsOrder.date_order, Unit.name_unit, ItemsOrder.status_order FROM Order INNER JOIN Employee ON Order.emp_id=Employee.emp_id INNER JOIN ItemsOrder ON Order.id_order=ItemsOrder.id_order INNER JOIN Unit ON ItemsOrder.unit_id=Unit.unit_id; Shawn Green Database Administrator Unimin Corporation - Spruce Pine Spenser [EMAIL PROTECTED] wrote on 11/04/2004 11:59:16 AM: The attachment describing your tables didn't come through. However, here's roughly how your SELECT statement might look: SELECT Order.id_order, Employee.name_employee, ItemsOrder.date_order, Unit.name_unit, ItemsOrder.status_order FROM Order, Employee, ItemsOrder, Unit WHERE Order.id_order=ItemsOrder.id_order AND Order.emp_id=Employee.emp_id AND ItemsOrder.unit_id=Unit.unit_id; Notice that you link the tables together in the WHERE clause based on common columns between pairs of tables. The columns don't have to have the same name, just the same information. For instance, if the Order table has a column called emp_id and the Employee table has a table called rec_id and both are the employee's identification number, you would link those two tables together with an equal-sign in the WHERE clause. For any columns with the same names, put the table name and a dot before the column name (e.g., Employee.emp_id). On Thu, 2004-11-04 at 10:34, Priscilla Labanca wrote: The tables are: Order, Employee, ItensOrder and Unit. My objective: to program a report of Order that appears in the screen the fields ( id_order, name_employee, date_order, name_unit and status_order). -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Help me - please
i added ulimit -n 1024 in mysql_install_db, i can't to install. Appear the error again. Please again!!! On Thu, 18 Dec 2003, Chris Elsworth wrote: On Thu, Dec 18, 2003 at 05:28:30PM -0200, Carlos Andr? Moura de Amorim wrote: 031217 14:32:34 Warning: setrlimit couldn't increase number of open files to more than 256 (request: 510) It might be worth putting a ulimit -n 1024 (or some other decent number) in the rc.d script that starts mysql; then (assuming the kernel is going to allow it) mysql will be able to change the number of file descriptors it can open, to the best of my knowledge. -- Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Help me - please
You must be 'root' to do a ulimit -n 1024. Marc. -Message d'origine- De : Carlos André Moura de Amorim [mailto:[EMAIL PROTECTED] Envoyé : vendredi 19 décembre 2003 14:55 À : Chris Elsworth Cc : [EMAIL PROTECTED] Objet : Re: Help me - please i added ulimit -n 1024 in mysql_install_db, i can't to install. Appear the error again. Please again!!! On Thu, 18 Dec 2003, Chris Elsworth wrote: On Thu, Dec 18, 2003 at 05:28:30PM -0200, Carlos Andr? Moura de Amorim wrote: 031217 14:32:34 Warning: setrlimit couldn't increase number of open files to more than 256 (request: 510) It might be worth putting a ulimit -n 1024 (or some other decent number) in the rc.d script that starts mysql; then (assuming the kernel is going to allow it) mysql will be able to change the number of file descriptors it can open, to the best of my knowledge. -- Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Help me - please
what distro are you using? what is running on this server? another server is runnin' on the same machine? what hardware are you using? is it heavy loaded? On Fri, 2003-12-19 at 09:54, Carlos Andr Moura de Amorim wrote: i added ulimit -n 1024 in mysql_install_db, i can't to install. Appear the error again. Please again!!! On Thu, 18 Dec 2003, Chris Elsworth wrote: On Thu, Dec 18, 2003 at 05:28:30PM -0200, Carlos Andr? Moura de Amorim wrote: 031217 14:32:34 Warning: setrlimit couldn't increase number of open files to more than 256 (request: 510) It might be worth putting a ulimit -n 1024 (or some other decent number) in the rc.d script that starts mysql; then (assuming the kernel is going to allow it) mysql will be able to change the number of file descriptors it can open, to the best of my knowledge. -- Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- .. * _ _ __ __ .. * \ \ \ | | __ \ /\ | | || Victor E Medina M * \ \ \ | |__ | |__) / \ | | || Linux - Java - MySQL * | __| | ___/ /\ \ | | || Dpto. Sistemas - Ferreteria EPA * / / / | || | / \|_| || www.superferreteria.com.ve * /_/_/ |__|_| /_/\_(_) || [EMAIL PROTECTED] * || geek by nature - linux by choice .. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Help me - please
i'm root!! *** Carlos Andre Moura de Amorim -- Funcionario UNCISAL -- Tecnico de Informatica CEFET-AL -- Acad. de Mecicina UNCISAL -- Fone: (0xx82) 9904-0117 *** On Fri, 19 Dec 2003, Mechain Marc wrote: You must be 'root' to do a ulimit -n 1024. Marc. -Message d'origine- De : Carlos André Moura de Amorim [mailto:[EMAIL PROTECTED] Envoyé : vendredi 19 décembre 2003 14:55 À : Chris Elsworth Cc : [EMAIL PROTECTED] Objet : Re: Help me - please i added ulimit -n 1024 in mysql_install_db, i can't to install. Appear the error again. Please again!!! On Thu, 18 Dec 2003, Chris Elsworth wrote: On Thu, Dec 18, 2003 at 05:28:30PM -0200, Carlos Andr? Moura de Amorim wrote: 031217 14:32:34 Warning: setrlimit couldn't increase number of open files to more than 256 (request: 510) It might be worth putting a ulimit -n 1024 (or some other decent number) in the rc.d script that starts mysql; then (assuming the kernel is going to allow it) mysql will be able to change the number of file descriptors it can open, to the best of my knowledge. -- Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Help me - please
Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables 031217 14:32:34 Warning: setrlimit couldn't increase number of open files to more than 256 (request: 510) 031217 14:32:34 Warning: Changed limits: max_connections: 100 table_cache: 73031217 14:32:35 ./bin/mysqld: Shutdown Complete To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: ./bin/mysqladmin -u root password 'new-password' ./bin/mysqladmin -u root -h gray.ecmal.br password 'new-password' See the manual for more instructions.You can start the MySQL daemon with: cd . ; ./bin/mysqld_safe You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory: cd sql-bench ; perl run-all-tests Please report any problems with the ./bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at https://order.mysql.com please, somebody help me!!! *** Carlos Andre Moura de Amorim -- Funcionario UNCISAL -- Tecnico de Informatica CEFET-AL -- Acad. de Mecicina UNCISAL -- Fone: (0xx82) 9904-0117 *** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Help me - please
On Thu, Dec 18, 2003 at 05:28:30PM -0200, Carlos Andr? Moura de Amorim wrote: 031217 14:32:34 Warning: setrlimit couldn't increase number of open files to more than 256 (request: 510) It might be worth putting a ulimit -n 1024 (or some other decent number) in the rc.d script that starts mysql; then (assuming the kernel is going to allow it) mysql will be able to change the number of file descriptors it can open, to the best of my knowledge. -- Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
help me please .... deplome project
Hi every one : i'm trying to make a db program using Mysql cbuilder6 . on my table a have fields named patient_Id . its an auto_increment value but i got problem . the problem is when i try to get the value of that fields i got nothing just 0 although i execute the commands SQLClientDataSet-Append(); SQLClientDataSet--Insert(); how can i solve this problem ??
help me, please
Hello, i am new in mysql. I got a problem. I try write my C program with mysql API.I have 5 field in table.No,Name,Phone,Date,Time. How can i take one row where the No is bigger? Thanks for help. __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: help me, please
select * from your_table order by no desc limit 0,1 -Original Message- From: mustakim abas [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 12:07 PM To: [EMAIL PROTECTED] Subject: help me, please Hello, i am new in mysql. I got a problem. I try write my C program with mysql API.I have 5 field in table.No,Name,Phone,Date,Time. How can i take one row where the No is bigger? Thanks for help. __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: help me, please
On Thu, 19 Dec 2002, mustakim abas wrote: Hello, i am new in mysql. I got a problem. I try write my C program with mysql API.I have 5 field in table.No,Name,Phone,Date,Time. How can i take one row where the No is bigger? Thanks for help. Provided I understand your question, then I would suggest: SELECT * FROM mytable WHERE No somevalue LIMIT 1; Then 'somevalue' would be the value of 'No' from your last query. Thomas -- sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: help me, please
At 8:06 -0800 12/19/02, mustakim abas wrote: Hello, i am new in mysql. I got a problem. I try write my C program with mysql API.I have 5 field in table.No,Name,Phone,Date,Time. How can i take one row where the No is bigger? Thanks for help. Bigger than what? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: help me, please
Select max(No) from table Marcos Henke - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: mustakim abas [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, December 19, 2002 1:51 PM Subject: Re: help me, please At 8:06 -0800 12/19/02, mustakim abas wrote: Hello, i am new in mysql. I got a problem. I try write my C program with mysql API.I have 5 field in table.No,Name,Phone,Date,Time. How can i take one row where the No is bigger? Thanks for help. Bigger than what? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: help me, please
At 8:06 -0800 12/19/02, mustakim abas wrote: Hello, i am new in mysql. I got a problem. I try write my C program with mysql API.I have 5 field in table.No,Name,Phone,Date,Time. How can i take one row where the No is bigger? Thanks for help. Bigger than what? Maybe SELECT No, Name, Phone, Date, Time FROM tablename ORDER BY No DESC LIMIT 1 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: help me please with mysqlgui
Bas, Thursday, July 04, 2002, 9:43:07 PM, you wrote: BM When I start mysqlgui on my mandrake 8.2 machine the program starts, but BM I get an error message: BM Can't connect to local MySQL server through socket'/tmp/mysql.sock'(2) BM I don't know what to do and I cannot acces the help file or find BM documentation on MySQLserver. Do you fill up entries in the Options dialog box? If no, please do it, then save and re-connect. BM Please tell me how I can solve this and/or where I can find BM documentation on MySQLGui README file that comes with MySQLGUI -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
help me please with mysqlgui
When I start mysqlgui on my mandrake 8.2 machine the program starts, but I get an error message: Can't connect to local MySQL server through socket'/tmp/mysql.sock'(2) I don't know what to do and I cannot acces the help file or find documentation on MySQLserver. Please tell me how I can solve this and/or where I can find documentation on MySQLGui Kind regards, Bas Mooyman - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: help me please with mysqlgui
You might have your socket files in /var/lib/mysql/. Search for the socket file and create a symlink in the /tmp directory as such: ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock Regards, Bhavin. - Original Message - From: Bas Mooyman [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 04, 2002 11:43 AM Subject: help me please with mysqlgui When I start mysqlgui on my mandrake 8.2 machine the program starts, but I get an error message: Can't connect to local MySQL server through socket'/tmp/mysql.sock'(2) I don't know what to do and I cannot acces the help file or find documentation on MySQLserver. Please tell me how I can solve this and/or where I can find documentation on MySQLGui Kind regards, Bas Mooyman - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
help me..please!
hi i was just wondering.is it posible to manipulate flat file databases with My SQL?.if it is..where can i get more info on this?. i really don't have any idea how to use MySQL with flat file databases. thanks. __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Help me please
Hi, I want to insatll Mysql in my station, i have Debian (linux 2.2),i installaed all the package of mysql, and after when i Write command : mysqladmin -u user create db , It ansers, mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)' Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! If you know what's the problem, help me please thank u = E . K . A ___ Do You Yahoo!? -- Pour faire vos courses sur le Net, Yahoo! Shopping : http://fr.shopping.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Help me please
Hi. On Wed, Jun 13, 2001 at 11:12:02AM +0200, [EMAIL PROTECTED] wrote: [...] Hi, I want to insatll Mysql in my station, i have Debian (linux 2.2),i installaed all the package of mysql, and after when i Write command : mysqladmin -u user create db , It ansers, mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)' Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! If you know what's the problem, help me please thank u Well, the error message tells what to do, doesn't it? If you did follow the instructions, what where the results? I.e. do you have assured that MySQL runs? Does '/var/run/mysqld/mysqld.sock' exist? By the way, this error (as all common ones) and how to resolve it is documented and explained in detail in the fine manual: http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html Bye, Benjamin. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Help me please !!
I use mysql-jdbc-java. I connect java with my database and I've this message : DBLocationHandler: Figuring out the locations and names! (This is a one-time operation!) *** ERROR *** DBLocationHandler:SQL Exception: Column Index out of range * java.sql.SQLException: Column Index out of range at org.gjt.mm.mysql.ResultSet.getString(ResultSet.java) at org.gjt.mm.mysql.ResultSet.getFloat(ResultSet.java) at com.bbn.openmap.layer.location.db.LocationData.init(LocationData.java:70) at com.bbn.openmap.layer.location.db.DBLocationHandler.createData(DBLocationHandler.java:222) at com.bbn.openmap.layer.location.db.DBLocationHandler.get(DBLocationHandler.java:300) at com.bbn.openmap.layer.location.LocationLayer.prepare(LocationLayer.java:387) at com.bbn.openmap.layer.location.LocationLayer$LocationWorker.construct(LocationLayer.java:148) at com.bbn.openmap.util.SwingWorker$2.run(SwingWorker.java:105) at java.lang.Thread.run(Thread.java:484) Why ? Thanks for your assistance.