Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

dbf2mysql parameter, WWWXXXAPC, wwwxxxAPC, How to unsubscrube from dategen spam, docmd.close 2585, WWWXXXDOCO, nu vot, dhcpd lease file "binding state", WWWXXXDOCO, how to setup procmail to process html2text

Links

XODOX
Impressum

#1: Newbie and JOINS

Posted on 2009-04-07 23:19:02 by BobTheBowler

------=_NextPart_000_11CB_01C9B7CE.DB0EB550
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Below is the ER diagram in an exercise I am trying to do.
It's been going well so far, and several ColdFusion pages written already.=


Need to do one for a Purchase Order Report for ...
- given SupplierCode
- given StartDate and EndDate of Orders

My problem is in the CFquery - understanding what JOINS to use and in wh=
at order to use them.
(it is a MyISAM database =3D no constraints)




--
I am using the free version of SPAMfighter.
We are a community of 6 million users fighting spam.
SPAMfighter has removed 12908 of my spam emails to date.
Get the free SPAMfighter here: http://www.spamfighter.com/len

The Professional version does not have this message

------=_NextPart_000_11CB_01C9B7CE.DB0EB550--

Report this message