RE: Search based where claused and stored proc

2009-03-27 Thread Ben Wiechman
Ben Wiechman Network Administrator Wisper High Speed Internet Office: 866.394.7737 Direct: 320.256.0184 Cell: 320.247.3224 b...@wisper-wireless.com > -Original Message- > From: Gary Smith [mailto:g...@primeexalia.com] > Sent: Friday, March 27, 2009 12:59 PM > To: mysql@lis

RE: Query Help

2009-02-10 Thread Ben Wiechman
Awesome... that works. Had to add a where clause to limit it to a specific host. The explain for that looks... interesting. Thanks -Original Message- From: ddevaudre...@intellicare.com [mailto:ddevaudre...@intellicare.com] Sent: Tuesday, February 10, 2009 12:47 PM To: Ben Wiechman Cc

RE: Query Help

2009-02-10 Thread Ben Wiechman
| Host | LoginTime | LogoutTime | +--+--+-+-+ | 0010E70A8004 | 172.17.6.100 | 2009-02-09 09:16:24 | 2009-02-10 04:42:08 | +--+--+-+-+ 1 row in set (0.

RE: Query Help

2009-02-10 Thread Ben Wiechman
he host in question the information is returned. This produces too many results as some of those users have since migrated to a different access point. -Original Message- From: Andrew Wallo [mailto:theme...@microneil.com] Sent: Tuesday, February 10, 2009 12:05 PM To: Ben Wiechman Subject: Re:

Query Help

2009-02-10 Thread Ben Wiechman
I keep hacking at this but haven't been able to get it right yet. I have two tables Userinfo contains a login, User's Name, Group Name Log contains login, host, datetime of last login What I need to do is return user information (userinfo.name/groupname) of users that have logged into

Visio Stencils

2008-05-02 Thread Ben Wiechman
Does anyone have a set of MySQL Visio stencils? Does such a beast exist? Ben Wiechman

Cisco Access Registrar & MySQL Cluster

2008-03-27 Thread Ben Wiechman
Cisco's Access Registrar supports MySQL 4.x. Does anyone have any experience trying to make it work with MySQL Cluster? Ben Wiechman Network Admin Wisper High Speed Internet [EMAIL PROTECTED]

Simple Query

2007-11-12 Thread Ben Wiechman
x27;d like to insert a row into the second with a set value. I tried this but it is not working. I'm not very familiar with subqueries as you can see. insert into table_2 ( id, value ) values ( (select id from table_1), '1' ); Ben Wiechman [EMAIL PROTECTED]