I'm not an expert on MySQL or can address any of the tuning issues you bring
up. I will say this, you are not totally correct in how ACCESS is
retrieving records. VB and Microsoft Jet retrieve dynasets which is
basically the primary key in its entirety. When you move to the next screen
ACCESS r
What Rick said is absolutely correct and you probably are obsessing about
something that doesn't matter. But I would venture you are using an
auto-number field as the primary key when you could easily change it to a
function something similar to: set ID = MAX(ID) + 1.
-Original Message-
Try
SELECT
pd.ANSWER_TEXT, pr.*, COUNT(*) as NUM
FROM
pollresponse left join polldata on pd.QUESTION_ID = pr.QUESTION_ID
WHERE
pd.VOTE_ID = pr.RESPONSE
GROUP BY pr.RESPONSE
Something like that will work better...probably you have to massage it a
little. Note that you were not getting any
Did you try SQRT(id)? Should rank things the way you want if it's legal
(*_*)
-Original Message-
From: David Mackay [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 11, 2002 7:08 PM
To: 'David Turner'; David Mackay
Cc: '[EMAIL PROTECTED]'
Subject: RE: ORDER BY an ABSolute value
Thanks
Read through the man doc lcalero gave you it tells everything you need to
know. Below is a basic example to help get you started:
#!/usr/bin/perl
use CGI;
use DBI;
$hostname = 'www.hostname.com';
$database = 'nameofdatabase';
$user = 'username';
$password
Sounds like an UPDATE:
http://www.mysql.com/doc/U/P/UPDATE.html
UPDATE TABLE
SET columnname1 = columnname2
where KEY = KEY
Something like that probably. If it was me I would copy the whole table so
I had a backup...UPDATES and DELETES can be destructive if writting
improperly (*_*)
-Origi
DL,
Thank you very much for the response I really appreciate it. I did follow
your suggestions and then simplified things a bit more. I posted the next
two queries below so you could see where the query goes wrong. I guess I'm
not really looking for a 'quick-fix' solution but rather I am missi
I have the below query that returns the correct records but the
POINTFUND.description field is all NULL while it has values in the table.
Any idea why? Thanks.
SELECT
RACES.RACE_ID,
RACES.sequence,
TYPES.typelong,
SCHEDULE.event,
SCHEDULE.date,
PARTY.lname,
POINTFUND.description
FROM
TYPES LE
Did you try SQRT(id)? Should rank things the way you want if it's legal
(*_*)
-Original Message-
From: David Mackay [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 11, 2002 7:08 PM
To: 'David Turner'; David Mackay
Cc: '[EMAIL PROTECTED]'
Subject: RE: ORDER BY an ABSolute value
Thanks
I have the below query that returns the correct records but the
POINTFUND.description field is all NULL while it has values in the table.
Any idea why? Thanks.
SELECT
RACES.RACE_ID,
RACES.sequence,
TYPES.typelong,
SCHEDULE.event,
SCHEDULE.date,
PARTY.lname,
POINTFUND.description
FROM
TYPES LE
10 matches
Mail list logo
