I've got a weird problem that's driving me nuts. I'm updating a set of
scripts for a customer database that supports sending out software
registration codes in real time. I've had this working for some time now,
but I'm having the most frustrating problem. Data I've inserted simply
VANISHES.
I'
D AND
a.AuthorID = r.AuthorID AND
r.Royalty = pr.MaxRoyalty;
What I didn't understand was that the temporary table is simply a look-up
table for the max royalty for each utility. I use this in the WHERE clause
of the SELECT statement.
Sheryl Canter
Permutations Software
www.permut
ple data,
I'd want it to look like this:
ProgramRoyalties table (primary key is a combination of AuthorID and UtilityID):
AuthorIDUtilityIDRoyalty
--
Author1 Utility1 0.15
Author3 Utility2 0.25
Author5 Utility3 0.20
Th
Thanks for the clarification.
Is the MySQL list down? I was getting constant email before, and now I've
received nothing for almost 12 hours.
- Sheryl
- Original Message -
From: "Uttam" <[EMAIL PROTECTED]>
To: "'Sheryl Canter'" <[EMAIL
this correctly?
- Sheryl
mysql
- Original Message -
From: "Juan Nin" <[EMAIL PROTECTED]>
To: "Sheryl Canter" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, February 28, 2003 2:42 PM
Subject: Re: SELECT DISTINCT question
From: "Sheryl Ca
L PROTECTED]>
To: "Sheryl Canter" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
"Frank Peavy" <[EMAIL PROTECTED]>
Sent: Friday, February 28, 2003 12:34 PM
Subject: Re: SELECT DISTINCT question
At 11:50 -0500 2/28/03, Sheryl Canter wrote:
>Frank,
>
>Sorry tha
up so I
can identify which author name to display.
Thanks for your help.
- Sheryl
- Original Message -----
From: "Frank Peavy" <[EMAIL PROTECTED]>
To: "Sheryl Canter" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, February 28, 2003 11:22 AM
S
I have a big problem to solve on my site, and I'm not sure how to approach
it. I'm selling software that's distributed as trialware (will be--haven't
launched yet). Users will be able to unlock the time-limited versions with a
license. I want to send the license to the user after her payment has be
others know of other ways of handling this.
- Sheryl
- Original Message -
From: "Tore Bostrup" <[EMAIL PROTECTED]>
To: "Sheryl Canter" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, February 28, 2003 1:41 AM
Subject: Re: SELECT DISTINCT quest
on this list showed me
how a subselect could achieve this result, but MySQL doesn't support
subselects.
- Sheryl
>- Original Message -
>From: "Sheryl Canter" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Wednesday, February 26, 2003 11:49 A
field in the table)?
That is the one that I want.
Details on the database structure are below.
Thanks.
- Sheryl
- Original Message -
From: "Frank Peavy" <[EMAIL PROTECTED]>
To: "Sheryl Canter" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent
Didn't receive answer to message below. Could someone please take a look?
TIA.
- Sheryl
- Original Message -
From: "Sheryl Canter" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 26, 2003 11:49 AM
Subject: SELECT DISTINCT question
n for a surprise.
Regards,
Tore.
- Original Message -
From: "Sheryl Canter" <[EMAIL PROTECTED]>
To: "Tore Bostrup" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, February 26, 2003 10:29 AM
Subject: Re: index questions
> > 4: The name o
I need help with a query. I have a 'royalties' table that looks like this:
AuthorIDProgramIDRoyalty
--
Author1 Program1 0.15
Author2 Program1 0.10
Author3 Program2 0.25
Author4 Program3 0.05
Author5 Program3
I've never seen opening a table twice and then doing a join back with
itself. Am I wording this correctly? Is that how to describe what you're
doing?
Thanks for posting this to the full list.
- Sheryl
- Original Message -
From: "Don Read" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Tore,
Thanks very much for taking the time to respond! I'm not insulted by
"basic". Some things I knew, but my questions were basic.
> 1: There is no difference: KEY is a synonym for INDEX.
So these two statements are equivalent:
KEY [index_name] (index_col_name,...)
INDEX [index_name] (index_
I just received an answer to a question that I was about to post by reading
a reply to someone else's question. So in this case, replying to all has
*reduced* traffic. I don't have to post my question.
- Original Message -
From: "Bernhard Döbler" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]
please someone answer!
see below
- Original Message -
From: "Sheryl Canter" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 25, 2003 7:07 PM
Subject: index questions
I have some basic questions that are driving me nuts, and I can't find
I have some basic questions that are driving me nuts, and I can't find
answers anywhere. I've been banging my head against the wall for hours and
hours. I've searched everywhere on the internet and looked in every book I
own. I can't find the information. Here are my questions.
In the CREATE TABLE
19 matches
Mail list logo
