Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

192.168.1.41:8000, Www.xxxcon., %s wwwxxxcon, %s wwwxxxcon, www.xxxcon, xxxxdup, bitlord outgoing port settings, ckowwwxxx, 192.168.1.41:8000/nor-482.html, php.ini "Unable to initialize module"

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