In our team of developer’s we use a tracking system, to track work orders, bug fixes, feature requests, and the status of those projects… One of my recent assignments was to create a “Recently Updated List” This list will contain the trackID, and a Title… it will sort by the date in descending order so [...]

read more from this topic.....

I have a page that grabs a list of numbers, either from a series of checkboxes, or a multiple select box, and it passes the Value of the item… <select name=“Seminars” multiple=“multiple” size=“10″> <cfloop query=“somequery”> <option value=“#seminarid#”>#title#</option> </cfloop> </select>

read more from this topic.....

At work I always get confused on good practice of using joins… here is an example of a practical join. <cfquery name=“getConcernDetails” datasource=“#someDSN#”> SELECT C.concernID, C.ClientID, C.DateCreated, C.Status, C.ClientEmail, C.isConcern, C.ownerID, C.ownerGroupID, a.userID, a.username, s.label FROM unmc_Concerns C JOIN WLTAdminusers a ON c.ownerID = a.userid JOIN WLTsecurity s ON C.ownerGroupID = s.secid WHERE C.ConcernID = [...]

read more from this topic.....

I wrote this query for use on my site beta.killtheheart.com When you click on the hotlist tab you will see the query version 1: Problems… i was including the date in my query using a group by <cfquery datasource=“#variables.dsn#” name=“qHotList”> SELECT   l.artistID, l.AlbumID, l.Date, count(l.ArtistID) as recordCount, art.Artist, alb.Title FROM tblLogger l, tblArtists art, tblAlbums alb [...]

read more from this topic.....

Consider having the following tables. (Microsoft RMS) -Item -id -cost -SupplierList -itemID -supplierCost when using RMS, You have an Item, it has it’s own cost… maybe that cost is an average cost, or something like that, and that item may have multiple suppliers, and each supplier has an itemcost associated with it, this sucks with [...]

read more from this topic.....