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
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
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
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
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
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
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
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
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