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

Re: SQL Problems

2002-06-27 Thread Mikhail Entaltsev
do you have? Mikhail. - Original Message - From: "Menard, Inc. Information Systems" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, June 27, 2002 3:43 PM Subject: SQL Problems > Help!! > > I'm completly confused with the below sql command: &g

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

Re: MySQL, mm.MySQL, and SQL Problems

2002-04-27 Thread Andy Clark
Mark Matthews wrote: > First off, let me say "Thanks" for the work you've done with the XML Parser. > I used it heavily on a project last year and it performed admirably. Cool. :) > Hmm. MM.MySQL will do this for you. Seeing your next comment leads me to > believe that you've found yourself a ve

RE: MySQL, mm.MySQL, and SQL Problems

2002-04-27 Thread Mark Matthews
> Message-ID: <[EMAIL PROTECTED]> > Date: Sat, 27 Apr 2002 18:28:57 +0900 > From: Andy Clark <[EMAIL PROTECTED]> > MIME-Version: 1.0 > To: MySQL <[EMAIL PROTECTED]> > Subject: MySQL, mm.MySQL, and SQL Problems > Content-Type: text/plain; charset=us-ascii

MySQL, mm.MySQL, and SQL Problems

2002-04-27 Thread Andy Clark
So I'm jumping back into database stuff after a long absence. (I guess you could say that I was never really *in* databases to begin with. Anyway...) I'm working with various databases and have settled on MySQL but am encountering a variety of problems that I hope the MySQL community can help me s