Anders Norrbring skrev:
Brent,
you put me on the right track.. ;) Reading up a bit on syntax for
variables, I came up with the following, which seems to work.
SET @tid:=(SELECT tid FROM objects WHERE shortname = %s);
SET @vid:=(SELECT vid FROM itemtypes WHERE itemtype LIKE %s);
SELECT (count(*
You could use a view:
CREATE VIEW all_scores
SELECT s.tid, s.vid, s.uid, s.highScore
FROM score s
JOIN objects o
ON s.tid = o.tid
JOIN itemtypes it
ON s.vid = it.vid
JOIN users u
ON s.uid = u.uid
WHERE o.shortname = %s /* Should these ANDs really be ORs? */
AND i.itemtype LIKE %s;
SELECT highSco
Brent Baisley skrev:
You're right that wouldn't work because you can't assign the query
results to a variable. You want to put the variables in the query and
assign them to the value of the field.
...WHERE s2.tid = (SELECT @tid:=tid AS tid FROM objects WHERE shortname = %s)...
That should work b
Brent,
you put me on the right track.. ;) Reading up a bit on syntax for
variables, I came up with the following, which seems to work.
SET @tid:=(SELECT tid FROM objects WHERE shortname = %s);
SET @vid:=(SELECT vid FROM itemtypes WHERE itemtype LIKE %s);
SELECT (count(*)+)/(SELECT COUNT(*) FROM
Brent Baisley skrev:
You might be able to use variables to store the result of the query.
Although I've never tried assigning the result of a query to a
variable, only field values.
SELECT (count(*)+)/(SELECT COUNT(*) FROM score AS s2
WHERE s2.tid = @tid:=(SELECT tid FROM objects WHERE shortname
Moon's Father skrev:
Just a look at your sql query at first.
Your like key word's right must like this:
like 's%', then it'll use the index you created for your table.
The second try you may use temporary table to replace your own query like "
(SELECT uid FROM users WHERE username = %s)
"
Well
Hi.. I'm struggling with a query that I'm trying to simplify as much as
possible, but I can't seem to get rid of using the very same subqueries
several times.
Would there be a way to optimize the following so I get rid of
subqueries that do the exact same thing more than once?
SELECT (count(*
Martijn Tonies schrieb:
> Hi,
>
>> I have a rather basic problem I would be glad to get some help:
>> What I intend to do is:
>> - create a person-list
>> - create a buddy-list
>> each entry in the person-list can have 0 to many buddies
>> - when an entry in the person-list is deleted, I would
Hi,
> I have a rather basic problem I would be glad to get some help:
> What I intend to do is:
> - create a person-list
> - create a buddy-list
> each entry in the person-list can have 0 to many buddies
> - when an entry in the person-list is deleted, I would like to
> have correspnding ent
hi there,
I have a rather basic problem I would be glad to get some help:
What I intend to do is:
- create a person-list
- create a buddy-list
each entry in the person-list can have 0 to many buddies
- when an entry in the person-list is deleted, I would like to
have correspnding entries in
If you mean a slave that replicates more than one master, that is not
possible --
ie, this is not possible:
Master1 --
|--> Slave
Master 2 -
However, if you mean:
Master 1 <---> Master2
Then all you have to do is set up replication so Master2 is a slav
hello ！
Has anybody used of Multiple-master replication?
How to set up?
How to modify the my.cnf file?
Thank you very much!!!
[EMAIL PROTECTED]
2006-02-10
Hi Daniel,
> Jigal, thank you very much. However, this does not resolve my issue.
>
> even when querying:
> SELECT * FROM ae_articles AS art LEFT JOIN ae_articlesections AS sec ON
> art.ID=sec.articleID WHERE art.title LIKE '%bush%' AND sec.sectionID IN
(1,2)
> AND sec.sectionID NOT IN (3)
What *
yntax.
You can find info on joins at:
http://dev.mysql.com/doc/mysql/en/join.html
Regards, Jigal.
- Original Message -
From: "Dan Duris" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, March 23, 2005 10:35 AM
Subject: mysql exclusion query with JOIN (request for help)
> Anyon
Anyone knows who to make exclusion query when table is referenced via JOIN:
SELECT * FROM ae_articles AS art
LEFT JOIN ae_articlesections AS sec ON art.ID=sec.articleID
LEFT JOIN ae_articlesections AS sec2 ON art.ID=sec2.articleID
LEFT JOIN ae_articlesections AS sec3 ON art.ID=sec3.articleID
WHERE
> > That is ONE way to store a tree structure :-)
>
> > Another would be:
>
> > ITEMS
> > (ItemID INT AUTO_INCREMENT PRIMARY KEY NOT NULL,
> > other stuff)
>
> > ITEM_PARENT
> > (ItemID int,
> > ParentID int
> > primary key (ItemID, ParentID)
> > )
>
>
> > I prefer the latter.
>
> The latter is n
In article <[EMAIL PROTECTED]>,
"Martijn Tonies" <[EMAIL PROTECTED]> writes:
> That is ONE way to store a tree structure :-)
> Another would be:
> ITEMS
> (ItemID INT AUTO_INCREMENT PRIMARY KEY NOT NULL,
> other stuff)
> ITEM_PARENT
> (ItemID int,
> ParentID int
> primary key (ItemID, ParentID
Hello,
> The only difference is that you have moved parent outside main table.
> No benefits at all. You have to create two records I two tables instead of
> one. You have to make joins to see what is the parent of particular child.
> I am strongly against this.
Why?
1) relational theory clearly
Egor, others,
> It's really clear what you want. Please specify.
>
> If what you basicaly want is just a tree structure, then it's done like
that:
>
>
> CREATE TABLE something (
> id INT AUTO_INCREMENT PRIMARY KEY NOT NULL,
> parent INT NOT NULL,
> data1 CHAR(255),
> data2 CHAR(255),
> ...
>
> );
Teng Wang <[EMAIL PROTECTED]> wrote:
It's really clear what you want. Please specify.
If what you basicaly want is just a tree structure, then it's done like that:
CREATE TABLE something (
id INT AUTO_INCREMENT PRIMARY KEY NOT NULL,
parent INT NOT NULL,
data1 CHAR(255
Teng,
how is this different than a foreign key?
On Oct 14, 2004, at 11:27 PM, Teng Wang wrote:
I wanna setup a tree structure. Each node in this tree is a
table. Each table has a "link" field. For each record, the
data in this field is a pointer to another table or null.
I read mysql manual but don
I wanna setup a tree structure. Each node in this tree is a
table. Each table has a "link" field. For each record, the
data in this field is a pointer to another table or null.
I read mysql manual but don't find any clues that SQL
supports such a "link" field. Does anyone has an idea about
that?
community for helping newcomers on the
hackerscene
-Oorspronkelijk bericht-
Van: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Chadley
Wilson
Verzonden: vrijdag 30 januari 2004 13:28
Aan: [EMAIL PROTECTED]
Onderwerp: [Mysql-discussions] Newbie call for HELP!
Hello
I need to know how to get
Hello
I need to know how to get data base connectivity to a windows SQL2000
server from linux based app.
Are there any tools that I need.
When I try to connect I get this error
"DBMS MSS Microsoft SQL Server 6.x is not supported in your current
installation"
I am sure that it is just client conne
Hi all,
I am a newbie(student) to mysql in linux environment.
I was trying to install the mysql-3.23.51-pc-linux-gnu-i686.tar.gz on my
linux - mandrake 8.2 from sourceforge.net. When I type in ./configure, it
says, there is no need to configure for binary..., then the mysqld starts
and close
I will buy a book of the helpers choice from Amazon.com (within reason
up to $50ish) for help solving my problem:
I need to do something kinda odd that I'm hoping to get help
with...except for any suggestions of changing my base table structure.
(Although if there was someway to
: Sunday, September 01, 2002 3:35 AM
Subject: Request for help - Table Crashing
> Hello,
>
> This is my 2nd post, not to sound pushy, just raising the urgency of my
> dilemna. My table is crashing way to often (I'd like it to not crash at
> all).
> I'm not sure w
Hello,
This is my 2nd post, not to sound pushy, just raising the urgency of my
dilemna. My table is crashing way to often (I'd like it to not crash at
all).
I'm not sure what to do, how to trouble shoot, and how to fix my problem. I
will post the structure of the table here, as well as the pert
list archive as quota issues come up regularly and
you may find an answer there.
Bye,
Benjamin.
On Sat 2002-06-01 at 17:54:43 +0800, [EMAIL PROTECTED] wrote:
> mysql database quota solution for help!!
--
[EMAIL P
mysql database quota solution for help!!
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EM
ql and all worked fine.
Cheers
John
> -Original Message-
> From: John Parsons [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 04, 2002 9:52 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: DESPERATE NEED FOR HELP!
>
>
> I have just been a complete mup
D]
Subject: DESPERATE NEED FOR HELP!
I have just been a complete muppet and trashed the tables in my database and
don't have a recent backup.
The database is used for the phpBB system and still functions when I visit
the site via a web browser since the database is still cached. Is ther
From: Balteo <[EMAIL PROTECTED]>
> Why don't you create a php script that generates SQL instead of HTML; i
> will repopulate your database acting as a dump?
Not a bad idea. John, be carefull not to mess up whatever cache is currently in place
by changing something that will confuse the cache.
Why don't you create a php script that generates SQL instead of HTML; i
will repopulate your database acting as a dump?
I know it will take some time to develop...
Balteo,
John Parsons wrote:
>I have just been a complete muppet and trashed the tables in my database and
>don't have a recent b
I have just been a complete muppet and trashed the tables in my database and
don't have a recent backup.
The database is used for the phpBB system and still functions when I visit
the site via a web browser since the database is still cached. Is there any
way I can recover the database using the
Venu wrote:
>>-Original Message-
>>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>>Sent: Saturday, March 30, 2002 12:40 PM
>>To: [EMAIL PROTECTED]
>>Subject: Begging for help.
>>
>>
>>Hi all,
>>
>>Begging for help.
>&
At 15:45 -0500 3/30/02, [EMAIL PROTECTED] wrote:
>Hi all,
>
>Begging for help.
>
>Newbie so please keep solutions as simple as possible please.
>
>I wish to have an ODBC connection from my win98 machine to my RH 6.1 machine
>running mysql version 3.23.44.
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, March 30, 2002 12:40 PM
> To: [EMAIL PROTECTED]
> Subject: Begging for help.
>
>
> Hi all,
>
> Begging for help.
>
> Newbie so please keep solutions as simpl
Hi all,
Begging for help.
Newbie so please keep solutions as simple as possible please.
I wish to have an ODBC connection from my win98 machine to my RH 6.1 machine
running mysql version 3.23.44.
What steps do I take ?
Unfortunately do not know enough about linux and Mysql to understand
Hi all,
Begging for help.
Newbie so please keep solutions as simple as possible please.
I wish to have an ODBC connection from my win98 machine to my RH 6.1 machine
running mysql version 3.23.44.
What steps do I take ?
Unfortunately do not know enough about linux and Mysql to understand
Andreas,
If anyone else is interested, I have solved the problem in stepwise/tutorial fashion
below (best viewed using a
fixed font).
If anyone is skilled in the user of FROM...JOINs, (I'm sure Andreas, and) I'd welcome
a critique/any
improvements!
I have taken a look at this problem, and bein
That would be great. Thanks!
Sincerely,
Steven Roussey
http://Network54.com/?pp=e
> -Original Message-
> From: Brian P. Austin [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 12, 2002 10:45 pm
> Subject: RE: Request for help in testing new replication code in 4.0.2
Is there anyone who could help me with this "simple" query.
Did i ask anything in a wrong way because I still got no answers to my
request?
SELECT at.name, av.value, at.unit, at.id, a.product_id
FROM attribute_type at
LEFT OUTER JOIN attribute a on (at.id = a.type_id)
LEFT OUTER JOIN attrib
it up if it's something you might find useful.
-Original Message-
From: Steven Roussey [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 12, 2002 12:41 PM
To: 'Sasha Pachev'
Cc: 'Mysql'
Subject: Re: Request for help in testing new replication code in 4.0.2
&g
X]
> Sent: Sunday, February 10, 2002 3:28 PM
> To:
> Subject: Re: Request for help in testing new replication code in 4.0.2
>
>
> On Sun, Feb 10, 2002 at 10:24:30PM +0100, Fournier Jocelyn
> [Presence-PC] wrote:
> > Hi,
> >
>
> > * If you want to do it this very moment, read the instructions at
> >http://www.mysql.com/doc/I/n/Installing_source_tree.html and
install a
> > pre-release 4.0.2 MySQL on your test server. You may also wait until
4.0.2 is
> > released, but in that case, replication in 4.0.2 may have a bug
On Sat, Feb 09, 2002 at 09:41:25PM -0700, Sasha Pachev wrote:
>
> So I need your help with field testing of my code. For those of you
> who are wondering why you should - this will help us stabilize 4.0 a
> lot of faster, and not only replication, but also the general SQL
> features. So if you de
I don't actually see the error message in the output you sent. but I found a
similar problem yesterday and have the following work around:
= myisamchk.c 1.69 vs edited =
*** /tmp/myisamchk.c-1.69-20535 Thu Feb 7 17:21:33 2002
--- edited/myisamchk.c Sat Feb 9 22:48:57 2002
uot; <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, February 10, 2002 10:20 PM
Subject: Re: Request for help in testing new replication code in 4.0.2
> On Sat, Feb 09, 2002 at 09:41:25PM -0700, Sasha Pachev wrote:
> > Dear MySQL users
On Sun, Feb 10, 2002 at 10:24:30PM +0100, Fournier Jocelyn [Presence-PC] wrote:
> Hi,
>
> In myisamchk.c replace the following line :
>
>if (argument && *argument == '0')
> DBUG_POP();
> else
> DBUG_PUSH(argument ? argument : "d:t:o,/tmp/myisamchk.trace");
>
> by
>
> if
uot; <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, February 10, 2002 10:20 PM
Subject: Re: Request for help in testing new replication code in 4.0.2
> On Sat, Feb 09, 2002 at 09:41:25PM -0700, Sasha Pachev wrote:
> > Dear MySQL users
Dear MySQL users,
I have just pushed my latest changes in the replication code in our 4.0
development tree, which change the slave to use two threads - I/O thread that
gets the data from the master and logs it, and SQL thread which processes the
logged data. I have tested it extensively, and i
On Sat, Feb 09, 2002 at 09:41:25PM -0700, Sasha Pachev wrote:
> Dear MySQL users,
>
> I have just pushed my latest changes in the replication code in our
> 4.0 development tree, which change the slave to use two threads -
> I/O thread that gets the data from the master and logs it, and SQL
> thre
> * If you want to do it this very moment, read the instructions at
>http://www.mysql.com/doc/I/n/Installing_source_tree.html and install a
> pre-release 4.0.2 MySQL on your test server. You may also wait until 4.0.2
is
> released, but in that case, replication in 4.0.2 may have a bug you cou
On Sunday 10 February 2002 02:20 pm, Jeremy Zawodny wrote:
> I run `BUILD/compile-pentium --prefix=/home/mysql` and it fails after
> several minutes. ?The output is large, so I've posted it here:
>
> ? http://public.yahoo.com/~jzawodn/mysql-build.log
>
> (the good stuff is at the end, of course.
On Sunday 10 February 2002 01:17 am, you wrote:
> I can't get it to start replicating.
>
> Note, the master (db1.tias.com) is a 3.23 server. The slave is 4.0.2
> (noritake.tias.com).
>
> On the master I get:
>
> mysql> show master status;
> +---++--+
On Sunday 10 February 2002 06:06 pm, Jeremy Zawodny wrote:
> One question:
>
> ? Can you explain the relay log a bit. ?Does it shrink eventually? ?I
> ? see it growing and growing, so I don't know if the space is
> ? recycled, or if I need to do something to periodically flush the
> ? executed qu
On Sunday 10 February 2002 01:17 am, you wrote:
> I can't get it to start replicating.
>
> Note, the master (db1.tias.com) is a 3.23 server. The slave is 4.0.2
> (noritake.tias.com).
>
> On the master I get:
>
> mysql> show master status;
> +---++--+
On Sat, Feb 09, 2002 at 09:41:25PM -0700, Sasha Pachev wrote:
>
> So I need your help with field testing of my code. For those of you
> who are wondering why you should - this will help us stabilize 4.0 a
> lot of faster, and not only replication, but also the general SQL
> features. So if you de
I don't actually see the error message in the output you sent. but I found a
similar problem yesterday and have the following work around:
= myisamchk.c 1.69 vs edited =
*** /tmp/myisamchk.c-1.69-20535 Thu Feb 7 17:21:33 2002
--- edited/myisamchk.c Sat Feb 9 22:48:57 2002
On Sun, Feb 10, 2002 at 10:24:30PM +0100, Fournier Jocelyn [Presence-PC] wrote:
> Hi,
>
> In myisamchk.c replace the following line :
>
>if (argument && *argument == '0')
> DBUG_POP();
> else
> DBUG_PUSH(argument ? argument : "d:t:o,/tmp/myisamchk.trace");
>
> by
>
> if
uot; <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, February 10, 2002 10:20 PM
Subject: Re: Request for help in testing new replication code in 4.0.2
> On Sat, Feb 09, 2002 at 09:41:25PM -0700, Sasha Pachev wrote:
> > Dear MySQL users
On Sat, Feb 09, 2002 at 09:41:25PM -0700, Sasha Pachev wrote:
> Dear MySQL users,
>
> I have just pushed my latest changes in the replication code in our
> 4.0 development tree, which change the slave to use two threads -
> I/O thread that gets the data from the master and logs it, and SQL
> thre
> * If you want to do it this very moment, read the instructions at
>http://www.mysql.com/doc/I/n/Installing_source_tree.html and install a
> pre-release 4.0.2 MySQL on your test server. You may also wait until 4.0.2
is
> released, but in that case, replication in 4.0.2 may have a bug you cou
Dear MySQL users,
I have just pushed my latest changes in the replication code in our 4.0
development tree, which change the slave to use two threads - I/O thread that
gets the data from the master and logs it, and SQL thread which processes the
logged data. I have tested it extensively, and i
Thanks for all the help with counting up numer. values.
Thanks also to Richard, and Eskom for providing us the power to drive not
only our PC's but also powering solutions to our DB problems ! ;-)
Regards
Anton (JHB, RSA)
Richard Ellerbrock writes:
> select sum(colnam) as x from table w
Date |Tue, 28 Aug 2001 12:30:25 -0400
>From |<[EMAIL PROTECTED]>
Hello!
N> I am trying to install the "dbf2mysql" converter and really
N> getting a headache. Someone told me that I need to
N> install the "Include files and libraries for MySQL" and I
N> have been searching frantically all over
I am trying to install the "dbf2mysql" converter and really
getting a headache. Someone told me that I need to
install the "Include files and libraries for MySQL" and I
have been searching frantically all over the web for the
source for this. All I have been able to find is the RPM's.
I am on
<[EMAIL PROTECTED]>
> Sent: Monday, June 11, 2001 6:08 AM
> Subject: Re: Pornographer will trade for Help with web based MySql
>
> > I've got some sweeping up around the office you might be able to do.
> That'd be alot
> > of sweeping to meet my hourly rate.
.
Also, if you do need to ask the list for help and you need to post some
code, please ensure that the content is ummm... let's say "suitable
for children". I mean, this list is for people to get assistance with
mysql problems, it is not an adult's only chat room.
At 06:13 PM 6/10/2001 -0700, John 'TPG' Smith wrote:
>I am interested in learning MySql and cgi.
>
>I want to trade my services for this help.
>
>I want to be able to make custom web based applications.
>
>I am a pornographer.
>
>
>TPG
>
>[EMAIL PROTECTED]
I don't even want to know what services
I am interested in learning MySql and cgi.
I want to trade my services for this help.
I want to be able to make custom web based applications.
I am a pornographer.
TPG
[EMAIL PROTECTED]
-
Before posting, please check:
Hello, everyone. Some of you may be aware that MySQL source and binary
distribution comes with a public test suite. Some documentation on it is
available at http://www.mysql.com/doc/M/y/MySQL_test_suite.html. But it is
terribly lacking, as evidenced by the fact that we have not had one user
su
Thanks for advices. As I got the error message, I thought the server has not
been started. It runs really!
Frank Tu
>From: Miguel Angel Solórzano <[EMAIL PROTECTED]>
>To: Paul DuBois <[EMAIL PROTECTED]>,"tu tuande" <[EMAIL PROTECTED]>,
>[EMAIL PROTECTED]
>Subject: Re: Mysql and Windows ME?
>Da
Sorry it is the first time, i write for help...
So,
i have : -Linux Redhat 6.2 with Kernel 2.2.14-5.0 i586
-MySQL-3.22.32-1.i386.rpm.rpm
-MySQL-client-3.22.32-1.i386.rpm
-mysqladmin ver 8.0 ditrib 3.22.32 for pc-linux
-mysqld is running
Sorry it is the first time, i write for help...
So,
i have : -Linux Redhat 6.2 with Kernel 2.2.14-5.0 i586
-MySQL-3.22.32-1.i386.rpm.rpm
-MySQL-client-3.22.32-1.i386.rpm
-mysqladmin ver 8.0 ditrib 3.22.32 for pc-linux
-mysqld is running
You are first suppose to start the daemon through safe_mysqld which is under the mysql
bin/ directory, or through mysql.server which is under mysql's share/ directory (info
about both on the webpage)
Running one of these will actually get your deamon running (and create the desired
/tmp/mysql.s
Which Version of MySQL? Where would you find one that old?
Whate platform?
What Linux Distribution?
What Linux version?
Which RPM? Client? Server? Both? What were their names?
Posts like this don't encurage helpful responses.
More information is needed.
Is the server running? It creates the so
I 'have installed Mysql 3.22.13 and Mysql client under Linux by RPM.
But when i do "mysqldmin -u root password " there is a message telling about *.sock
under /tmp missing or not present.
What can i do to create it ?
Since upgrading to mysql 3.23 and using MYIAM tables, I'm experiencing a
problem which is becoming more and more common. When conducting queries
which take more than about 15 seconds to run (ie mass deletes, mysqldumps,
check table etc), I end up with corrupt tables. The database server is the
bac
on 3/6/01 9:35 PM, Chris Toth at [EMAIL PROTECTED] wrote:
> Ok, I've been battling this SELECT statement for the better part of the day.
>
> The SELECT statement is this:
>
> SELECT DISTINCT request.id AS requestid, request.date, request.type,
> request.status,
> faculty.f_name, faculty.l_name,
I do not think that this can be solved using only SQL. Your system design my
require you to use one query for the display and another
for edit checking in order to achieve your goal.
Chris Toth wrote:
> Kentj
>
> Ok, I understand. I thought DISTINCT only worked on the field listed
> directly aft
Your query selects eight fields. Your Display shows five fields. The distinct verb
works on all eight fields and
apparently some of the fields not displayed are different. Limit the query for the
display to the five fields displayed
and the distinct verb should eliminate the duplicates from the d
I rearranged the query a little: SELECT DISTINCT request.id AS requestid,
request.date, request.type, request.status,
faculty.f_name, faculty.l_name, action.id AS actionid, faculty.id AS
facultyid FROM faculty, request, action WHERE request.id=action.request_id
AND request.requested_by=facult
It looks like the addition of the distinct verb should do the job if in fact your
query only showed the fields on the display.
>From your Sql however you are selecting more fields than are displayed and some
of those are different which distinct
will still display.
Chris Toth wrote:
> Ok, I've b
Ok, I've been battling this SELECT statement for the better part of the day.
The SELECT statement is this:
SELECT DISTINCT request.id AS requestid, request.date, request.type,
request.status,
faculty.f_name, faculty.l_name, action.id AS actionid, faculty.id AS
facultyid FROM faculty, request
My set-up:
MySQL server 3.23.30 with MSAccess97 via MyODBC 2.50.36 (all latest patches
to everything)
I have no trouble running this set up, BUT...
Even when I am the only person connected (after flush and restart of
server) and I open my Access database and go directly to edit one
particular t
87 matches
Mail list logo
