Recent content by hmoner

Hi r937 Yes, I'm using mySQL I've tried the following and worked: SELECT category.id, COUNT(product.fk_category) AS product_count, category.name, category.description FROM product RIGHT JOIN category ON category.id = product.fk_category GROUP BY category.id ORDER BY category.name ASC Which...

Hi guys I'm not having a nice time trying to make this query work I have 2 tables category product I want to list the following way CATEGORY.NAME | CATEGORY.DESC | PRODUCT_COUNT The following query works, but it doesn't list the categories that doesn't have products added. I'd like (if...

Hi guys Please look at this image http://xs217.xs.to/xs217/07271/smsbackup.jpg I've done that simple gui with a TJvFileListBox a TMemo this gui reads *.txt files (they are from a sms backup software) and when u dblclick those txt it loads in the tmemo, but I should do instead: 1) process...

Wow ! Thanks Rudy, the query worked perfect ! You're right, this is simpler, and it works in mySQL 4.1.x also... great !!!

Hi PHV Did I tell you that you're GOD ? The query worked GREAT ! but well, I get a null when user has no exam yet, but I will be able to manage this. Thanks A LOT again !!!

Hi guys I've these tables: - PERSON (id,name,age,....) - EXAM (id,date,note,exam_type,id_user) One person has 0 or more exams. I have to do this report: name, age, date, note, exam_type This looks easy, but I have to list for each person, his/her LAST EXAM GIVEN. I mean, only the last exam...

hi guys I'd like to know how to install linux-abi modules to run unix sco's rmcobol I already patched the kernel... I compile and all fine, until i get insmod: abi-sco: no module by that name found insmod: abi-util: no module by that name found insmod: abi-ibcs: no module by that name found etc...