Hi Rick,
> many people have a very shallow understanding of SQL - particularly
> [he says generalising like crazy] people who 'fall into it' from
> (say) PHP programming... This shallow understanding means that
> 'they' will tend to do too much in PHP (assuming they know it better)
> in prefere
At 12:53 PM + 1/7/02, George Pitcher wrote:
>
>One of the features of the FMPro solution is that when a user is looking at
>a list of resources (in fact, university course packs) each row will display
>the number of associated records from the 'books' database. Now which is the
>best method to
** Reply to note from "DL Neil" <[EMAIL PROTECTED]> Thu, 10 Jan 2002
14:48:02 -
> many people have a very shallow understanding of SQL - particularly
> [he says generalising like crazy] people who 'fall into it' from
> (say) PHP programming... This shallow understanding means that
> 'they'
David,
> =there's a bunch of fast-mover jockies and helo boys who never have to pay
for their drinks when any of my guys
> are around...
>
Air Traffic Control was my area, though we did have to put up with some of
your lot when Ark Royal was in dock as we were a Buccaneer base.
>
> =Sorry, misun
> > =ex-Navy guys are always "at sea" - however they never let me near the
> ships, but I guess that's another
> > story...
> ex RAF myself (almost 30 years ago though), so I suppose I might be all 'up
> in the air'?
=there's a bunch of fast-mover jockies and helo boys who never have to pay for t
David,
> =ex-Navy guys are always "at sea" - however they never let me near the
ships, but I guess that's another
> story...
ex RAF myself (almost 30 years ago though), so I suppose I might be all 'up
in the air'?
>
> > > level). Once again we draw boxes (I have some wonderful s/w for doing
> >
Hi George,
> > =I'm feeling a little 'at sea' here, because we had established that you
> want to learn more about "joining", yet
> > you recognise the word "normalisation" straight off...
> Feel free to realign my approach...
> No need to feel at sea. After an earlier response from either you or
Olinux,
> Haven't been following and not sure if this is what
> you're after, but these are some great data models:
> http://www.databaseanswers.com/data_models/index.htm
Thanks for this. I came across this site/these diagrams before, but thought them to be
too 'introductory' and
vague for use
> You wouldn't happen to have a spare ELH diagram (or two) lying around
> that one could take a look at, would you?
Hah TIM now you've got me!
I 'do' diagrams. I don't 'do' neat! [no need to move over Matisse]
The longer answer is that I have diagrams coming out of my ears (well, computer), but
David,
> =I'm feeling a little 'at sea' here, because we had established that you
want to learn more about "joining", yet
> you recognise the word "normalisation" straight off. I don't want to
insult you by 'talking down'/teaching
> grandma to suck eggs... Please be sure it is not another one of
m: DL Neil
> [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, January 09, 2002 7:23 AM
> > To: George Pitcher; [EMAIL PROTECTED]
> > Subject: Re: [PHP-DB] Concept help required
>
>
> > =The purpose of an ELH diagram is to take a piece
> of data
> > (i
From: DL Neil [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, January 09, 2002 7:23 AM
> To: George Pitcher; [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] Concept help required
> =The purpose of an ELH diagram is to take a piece of data
> (in your case, because we are assuming/checking
> nor
George,
=I was pleased to hear from Miles. There are likely to be as many suggestions for how
things should be done, as
there are developers. I'll be interested to hear from others - personally (cf on the
list) if the comments might
'interfere'/argue a case (and thus risk muddying your waters)
David,
> =Prevailing wisdom in system design suggests that the data should be
'designed' first, and 'code'/processing
> only later (relational or structured design philosophy, even
object-oriented design). Accordingly I recommend
> considering which parts of your current files should be converted
For DL Neill:
Like the "3 box" approach. A very strong image for separating the
functionality. Why don't you write it up as an article for DevShed or
WebMonkey? If you look at the traffic on the list there are lots of people
who just see PHP pages as "happening" and have no clear understandi
leave now to pick the kids up from school as the wife is ill.
> I'll see your comments tomorrow when I get back in.
=I have similar issues. I'll be around tomorrow (Wed) morning (GMT), but unlikely to
get back during the
afternoon.
=Regards,
=dn
> - Original Message -
ur comments tomorrow when I get back in.
Regards
George
- Original Message -
From: "DL Neil" <[EMAIL PROTECTED]>
To: "George Pitcher" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, January 08, 2002 1:07 PM
Subject: Re: [PHP-DB] Concept help
George,
> > =As a general comment, it is always dangerous to "replicate" when shifting
> platforms, better to reverse engineer
> > and then implement anew and taking advantages of the strengths of the new
> tools. This particularly when moving
> > into the relational field...
> Perhaps the use of
DL Neil,
Thanks for your response.
> =As a general comment, it is always dangerous to "replicate" when shifting
platforms, better to reverse engineer
> and then implement anew and taking advantages of the strengths of the new
tools. This particularly when moving
> into the relational field...
P
George,
> >In trying to learn PHP (and MySQL), I am attempting to replicate a
> >database-web solution built previously using Filemaker Pro and Lasso (on
> >NT). I am currently working with PHP/MySQL on NT and will be moving this to
> >Linux before the end of January.
=As a general comment, it i
t;
To: "George Pitcher" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, January 07, 2002 1:29 PM
Subject: Re: [PHP-DB] Concept help required
>
> George,
>
> Suggestions interspersed below
>
> Miles
>
> At 12:53 PM 1/7/2002 +, George Pitcher
George,
Suggestions interspersed below
Miles
At 12:53 PM 1/7/2002 +, George Pitcher wrote:
>Hi all,
>
>In trying to learn PHP (and MySQL), I am attempting to replicate a
>database-web solution built previously using Filemaker Pro and Lasso (on
>NT). I am currently working with PHP/MySQL on
22 matches
Mail list logo
