[Fwd: GRANT/REVOKE deny only 1 table in db from a user]

2008-05-15 Thread Philip M. Gollucci
[take 2] -- Philip M. Gollucci ([EMAIL PROTECTED]) o:703.549.2050x206 Senior System Admin - Riderway, Inc. http://riderway.com / http://ridecharge.com 1024D/DB9B8C1C B90B FBC3 A3A1 C71A 8E70 3F8C 75B8 8FFB DB9B 8C1C Work

Re: Selecting my data first

2008-05-12 Thread Philip M. Gollucci
le_id) - -- - Philip M. Gollucci ([EMAIL PROTECTED]) o:703.549.2050x206 Senior System Admin - Riderway, Inc. http://riderway.com / http://ridecharge.com 1024D/DB9B8C1C B90B FBC3 A3A1 C71A 8E70 3F8C 75B8 8FFB DB9B 8C1C Work like you don't need the money, love like you'll never get

GRANT/REVOKE deny only 1 table in db from a user

2008-05-12 Thread Philip M. Gollucci
IED BY 'X' obviously this doesn't work as there is no grant defined like that. I'm trying to avoid doing something that I have to update everytime a table is added/deleted. - -- - ---- Philip M. Gollucci

Crystal Reports XI on W2k3 Server SP2 x64 (fwd)

2007-09-30 Thread Philip M. Gollucci
[take 2] Nobody has any comments ? -- Forwarded message -- Date: Wed, 26 Sep 2007 12:19:21 -0400 (EDT) From: Philip M. Gollucci <[EMAIL PROTECTED]> To: mysql@lists.mysql.com Subject: Crystal Reports XI on W2k3 Server SP2 x64 Hi All, I'm trying to get Crystal Reports

Crystal Reports XI on W2k3 Server SP2 x64

2007-09-26 Thread Philip M. Gollucci
ogling, I have a hunch they are right but I can't fathom why. -- ------------ Philip M. Gollucci ([EMAIL PROTECTED]) 323.219.4708 Senior System Admin - Riderway, Inc. http://riderway.com 1024D/EC88A0BF 0DE5 C55C 6BF3 B235 2DAB B89E 1

Re: example when indexing hurts simple select?

2006-06-11 Thread Philip M. Gollucci
? -- Philip M. Gollucci ([EMAIL PROTECTED]) 323.219.4708 Consultant / http://p6m7g8.net/Resume/resume.shtml Senior Software Engineer - TicketMaster - http://ticketmaster.com 1024D/A79997FA F357 0FDD 2301 6296 690F 6A47 D55A 7172 A799 97F "It takes a minute to have a crush on so

Re: Newbie: MYSQL nested query question

2005-03-31 Thread Philip M. Gollucci
Graham Anderson wrote: What is the proper way to say this ? SELECT C.City, N.Distance FROM Cities C JOIN Nearbycities N ON C.CityId =ci N.PrimaryCityId WHERE N.CityId = (SELECT Cities.CityId FROM Cities WHERE Cities.city = 'Los Angeles') AND N.distance < 20 I am trying to enter in a city and get a