Doug Boude
Edit Page
Report
Scan day: 16 February 2014 UTC
49
Virus safety - good
Description: Weblog of a ColdFusion developer.
Doug Boude (rhymes with 'loud') (I promise not to follow you home) You may also be interested in... One Shot Query to Recalculate Orderby Field - MySQL In my app, a 'listing' can have one or more photos associated with it. These photo records live in their own table...listingImages. I allow the user to decide in what order the photos should be displayed, so I have a field in the table called 'imageOrder' that stores a number to sort by when outputting. When a user edits a listing and decides to delete one or more photos, I need to update the table's 'imageOrder' field for the remaining photos. Now, if I did NOT do this, the images would still be sorted in the correct order (I think), but I would much prefer to have an imageOrder value list that begins with 1.
Size: 814 chars
Contact Information
Email: —
Phone&Fax: —
Address: —
Extended: —
WEBSITE Info
Page title: | Doug Boude (rhymes with 'loud') |
Keywords: | Coldfusion,SQL,Programming,Object Oriented,OO,Doug Boude,frameworks,MVC,San Antonio,Texas |
Description: | [Powered by BlogCFM, www.blogcfm.org] |
IP-address: | 65.175.112.206 |
WHOIS Info
NS | Name Server: NS5.HOSTEK.COM Name Server: NS6.HOSTEK.COM |
WHOIS | Status: clientTransferProhibited |
Date | Creation Date: 10-aug-2005 Expiration Date: 10-aug-2015 |