This topic has been archived. It cannot be replied.
-
工作学习 / 学科技术讨论 / Totally a shock! In Mysql, if you run SELECT count(*) as cnt FROM table_name WHERE xxx = xxx in SQL editor, it shows return one row for cnt and value is 0, but in Java using MySql JDBC, resultset returns NULL.Am I stupid for now and need more sleep???
-nicetomeetyou(_);
2009-3-3
{42}
(#5090353@0)
-
need sleep
-ttl(麦子店);
2009-3-3
(#5090363@0)
-
I think it should return one row with one column named "CNT" and value is "0", am I wrong? So I have to modify business tier code. ..Never pay attention to jdbc for SQL server and Oracle..... who tried?
-nicetomeetyou(_);
2009-3-4
(#5091201@0)
-
i am not sure, if it returns a object which value is 0 should be NULL? help u ding.
-ttl(麦子店);
2009-3-4
(#5091203@0)
-
Resultset returns NULL object. No row at all. --- My sql 5.1
-nicetomeetyou(_);
2009-3-4
(#5091220@0)
-
It looks like it’s database accessing error (the most possible reason is wrong/improper parameter(s) for the database access object). BTW, I’m just wondering why you don’t have any exception handling logic to catch error message.
-deep_blue(BLUE);
2009-3-4
(#5091666@0)
-
There was no SQL exception caught, and the complete SQL can be run in SQL Editor successfully. I will check any syntax problem, but no error shown for sure.
-nicetomeetyou(_);
2009-3-4
(#5091950@0)
-
Not only correct Sql statement, but also connecting database properly (correct server, database, user id, and password info) makes you get data from database.
-deep_blue(BLUE);
2009-3-4
(#5092070@0)
-
Those are not questions at all, because system works fine for other SQLs, and raises correct exception error code when there is any problem, either from user, or from system.
-nicetomeetyou(_);
2009-3-4
(#5092489@0)
-
Why don't you try existing record? It return value 1 or more.
-deep_blue(BLUE);
2009-3-5
(#5093707@0)
-
This is one building example of my framework. It works fine. (#5093550@0). My SMB application will have various skin definitions.
-nicetomeetyou(_);
2009-3-5
(#5093558@0)
-
现在全美TOPXX的大公司也开始用上MySQL啦？好奇ing。
-bdbs(布丁本色);
2009-3-4
(#5092123@0)
-
Do you know what Google uses? Also do you know what MySQL belongs to?
-zixstudio(what's SSH?);
2009-3-4
(#5092311@0)
-
open resource 都是趋势
-vetra(豆泡果 之 多泡泡);
2009-3-4
(#5092327@0)
-
open source
-bdbs(布丁本色);
2009-3-4
(#5092381@0)
-
哦，偶错了
-vetra(豆泡果 之 多泡泡);
2009-3-4
(#5092386@0)
-
看来我莫名惊诧了，把它给忘了。
-bdbs(布丁本色);
2009-3-4
(#5092384@0)
-
I am developing my own HR/ERP system using open source.
-nicetomeetyou(_);
2009-3-4
(#5092446@0)
-
你家就几头牛，还用HR
-vetra(豆泡果 之 多泡泡);
2009-3-4
(#5092460@0)
-
管牛的不叫HR，叫CR。
-bdbs(布丁本色);
2009-3-4
(#5092484@0)
-
Yeah. In ERP system, there is a common module call "CRM" which means Cow Relationship Management.
-whereismyid(到处找ID);
2009-3-4
(#5092782@0)
-
MySQL is terrible in dealing with nulls
-zjoy(Joy);
2009-3-4
(#5093196@0)
-
Right. I am using EMS Manager for MySql database tool, and it expires month later. I remember there is a php program for free, but setup is complex. Anyone can recommend a good, free tool? Thanks!
-nicetomeetyou(_);
2009-3-4
(#5093217@0)