Help needed with SQL...

2003-02-25 Thread M Wells
Hi All, I'm having problems creating a query to return a recordset from the following situation: I have two tables, one which contains member details, and the other which contains details re: the groups to which the member belongs. When a member logs into a particular part of my site, I want to

Access XP crashes regularly when linked to MySQL via MyODBC

2003-01-28 Thread M Wells
Hi All, My MySQL Server is 3.23.53-max-nt. I'm linking to it via MyODBC 3.51.05.00 and accessing its tables via Access XP linked tables. For some reason, Access XP crashes regularly in this setup. No meaningful error messages, just crashes and reloads after a repair. Even more odd (and I only hav

Workable solution: writing program to communicate with remote internet MySQL server

2003-01-25 Thread M Wells
Hello All, Just thought I'd report back with what seems to be a simple, elegant solution to my previous inquiry re: writing a program to connect with the MySQL server that powers my internet site from my desktop PC. Yesterday I downloaded the latest release of PHP (ver 4.3.0) and, while reading t

RE: Writing program to communicate with remote internet MySQL server?

2003-01-24 Thread M Wells
erver over the internet and to > manipulate tables on the remote server as though they were recordset > objects, similarly to how you might achieve this on a local server using > MyODBC? > > The end goal is to develop a program I can fire as a Windows XP > scheduled task to

Writing program to communicate with remote internet MySQL server?

2003-01-23 Thread M Wells
tables on the remote server as though they were recordset objects, similarly to how you might achieve this on a local server using MyODBC? The end goal is to develop a program I can fire as a Windows XP scheduled task to synchronize the remote database with the local one. Any help appreciated! Regards

RE: solution for opposite of this join / join from this subselect

2003-01-23 Thread M Wells
tion for my version indicates FULL JOINs are expected in ver 4.0 or 4.1). Now, to go back to your original question, the people / events / attendance example employed both a LEFT JOIN and a RIGHT JOIN because the attendance table was acting as an intermediary between the people and events tables. Fr

RE: opposite of this join

2003-01-21 Thread M Wells
Hi Josh, I'm hesitant to make the following suggestion, mainly because I'm not terribly clued up with SQL myself, however the following APPEARS to deliver something close to what you're looking for. It relies on breaking your recordsets into 3 tables, as your situation appears to already do, 1 for

RE: MySQL Database Design

2003-01-10 Thread M Wells
Hi Brian, By no means am I a MySQL guru (or any other database server environment guru, for that matter), but could you simply have a reference table that indicates the percentage of the grape used in the relevant wine? So, you might have three tables, Wines, GrapeVariety, Wines_GrapeVarietiesUse

RE: MySQL as a desktop DB

2002-09-29 Thread M Wells
Hi Arthur, Which version of MySQL / MyODBC are you using? I tried building an app with an Acc2000 frontend and a MySQL backend using MyODBC and kept running into a problem where the record being edited would become 'locked' and wouldn't allow me to update (from memory it was something along the l