RE: Import from Excel to MySQL

2003-08-19 Thread Landers, Jason
I am also working on something like this but am taking a different approach. Basically I'm creating an Excell Add-in in VBA that adds a button to the Excel toolbar. When a user clicks it I take the highlighted rows and columns and verify that they are in the proper format and everything looks good

RE: Cache problem in 4.1

2003-08-19 Thread Landers, Jason
than good? -Original Message- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 19, 2003 11:18 AM To: [EMAIL PROTECTED] Subject: Re: Cache problem in 4.1 "Landers, Jason" <[EMAIL PROTECTED]> wrote: > My web site is pulling from several tables tha

RE: Cache problem in 4.1

2003-08-19 Thread Landers, Jason
some other problem? Thanks. -Original Message- From: Landers, Jason [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 19, 2003 10:57 AM To: '[EMAIL PROTECTED]' Subject: Cache problem in 4.1 My web site is pulling from several tables that don't change all that often and seems

Cache problem in 4.1

2003-08-19 Thread Landers, Jason
My web site is pulling from several tables that don't change all that often and seems to be an ideal candidate for query caching. I tried to enable it by copying the my-medium.cnf to /etc/my.cnf and restarted the service. From my query editor I typed SHOW VARIABLES LIKE 'QUERY_CACHE_TYPE' and it re

Subquery IN+SELECT blues

2003-08-14 Thread Landers, Jason
I have two tables, meetings and tasks. In the meetings table I have meeting information and a meeting index called id. In the tasks table I have task information that is associated with various meetings. In the tasks table I have a meetingid column that corresponds with the id in the meetings table

RE: Subquery IN+SELECT blues

2003-08-14 Thread Landers, Jason
st 14, 2003 2:58 PM To: [EMAIL PROTECTED] Cc: Landers, Jason Subject: Re: Subquery IN+SELECT blues * Landers, Jason > I have two tables, meetings and tasks. In the meetings table I > have meeting information and a meeting index called id. In the > tasks table I have task information that is a