RE: Count and group by problems

2002-08-16 Thread Menard, Inc. Information Systems
elp. Help. Thanks Jake -Original Message----- From: Menard, Inc. Information Systems [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 14, 2002 5:26 PM To: David Kramer; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Count and group by problems For an example let's say that I

RE: Count and group by problems

2002-08-14 Thread Menard, Inc. Information Systems
st 09, 2002 5:59 PM To: 'Menard, Inc. Information Systems'; [EMAIL PROTECTED] Subject: RE: Count and group by problems Im not sure I understand what it is that you are trying to do here??? Im assuming your using PERL/SomeScriptingLang on something on NT to connect to mysql using

Count and group by problems

2002-08-09 Thread Menard, Inc. Information Systems
Evening I think I'm losing my mind. I have a very simple query that works fine in MySQLFront but will not work when I connect using ADO: select booger, count(*) from nose group by booger If I try the above query with one record It works fine. Once I try it with more records, nothing returns. I

RE: SQL Problems

2002-06-27 Thread Menard, Inc. Information Systems
ll one body part out of another before I send an email. Thanks Jake -Original Message- From: Mikhail Entaltsev [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 27, 2002 9:33 AM To: Menard, Inc. Information Systems; [EMAIL PROTECTED] Subject: Re: SQL Problems > When I run this comman I

SQL Problems

2002-06-27 Thread Menard, Inc. Information Systems
Help!! I'm completly confused with the below sql command: insert into ur_rights select c.rc_id, u.uid, c.sys_id, r.theright, r.value from ur_rightchoices c, user_right r, ur_users u, ur_systems s where c.theright = r.theright and s.sys_name = r.system and s.sys_id = c.sys_id and upper(u.usernam

Which Language to use

2002-06-11 Thread Menard, Inc. Information Systems
Afternoon We are currently using MySql to drive our web server. We are in the process of pondering the thought of using it for our meat and potatoes applications. The problem/blessing is that our current database is Informix which comes with its own 4gl. In order for us to move to MySql we would

RE: Newbie--Easy data loading question

2002-05-24 Thread Menard, Inc. Information Systems
er, why would I have to do that??? Thanks Jake -Original Message----- From: Menard, Inc. Information Systems [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 8:26 AM To: Jay Blanchard; [EMAIL PROTECTED] Subject: RE: Newbie--Easy data loading question yes. I tried all of these methods: 1

RE: Newbie--Easy data loading question

2002-05-24 Thread Menard, Inc. Information Systems
t...that would be the next step, but I prefer not to go there. -Original Message- From: Jay Blanchard [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 8:22 AM To: 'Menard, Inc. Information Systems'; [EMAIL PROTECTED] Subject: RE: Newbie--Easy data loading question did

Newbie--Easy data loading question

2002-05-24 Thread Menard, Inc. Information Systems
Hello Forgive me for being a little naive but. I am trying to load a table with a text file using the load data infile command in mysql. I can do it if I place the text file in the db directory, but I want it to reside in a different dir. I am getting the error 13: Can't get stat on What

RE: SELECT and WHERE clause

2002-05-23 Thread Menard, Inc. Information Systems
try SELECT team_id,name FROM team WHERE deleted <> 1 ORDER BY name -Original Message- From: Steve Buehler [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 23, 2002 3:20 PM To: [EMAIL PROTECTED] Subject: SELECT and WHERE clause Ok. I can NOT find out what I am doing wrong. The book makes