From the start Dreamweaver can help you get your first professional-looking pages up on the web. Getting started with Dreamweaver involves jumping into the tutorials (available at www.adobe.com/products/dreamweaver.html) or taking one of the web design courses on _Dummies_ website (www.dummies.com).

Expertise Our team W&M are expert marketers and social media professionals, with broad experience across all brands, sectors and industries. We combine expertise in the media, creative, media relations, commerce, engineering, technology, government, utilities, energy, mining, manufacturing, retail, food, and services sectors. As media agencies, we can help with marketing and media planning and buying as well as social media, digital, SEO and content strategy. We are known for our creativity and work through hard-to-define technology to help our clients navigate an increasingly complex digital landscape. We use cookies to ensure that we give you the best experience on our website. By continuing to use this site you consent to the use of cookies on your device as described in our cookie policy unless you have disabled them.OkRead moreQ: NSNumber format without zeroes I use NSNumber *i = [NSNumber numberWithInteger:i]; to format an NSNumber. However, NSNumber automatically adds zeroes if the number of digits exceed three. However, I only use three decimal digits. How can I get rid of them? Example: NSNumber *i = [NSNumber numberWithInteger:2.9]; i.stringValue // 2.90 A: My guess is that this is the result of the “excess digits” feature of NSNumber. As you mentioned, your problem occurs when you try to print four or more characters of “excess” (just another way of saying zeros). It does this by setting the first three characters to zero. One possible solution to your problem is to truncate the number before displaying it. In other words, do the following (in pseudo-code): decimal = 2.9; number = [NSNumber numberWithFloat:decimal]; truncated = number.stringValue; This will result in a string value of “2.9” even when the original number contained 4 or more characters. Q: Does it make sense to use SQL Server’s local diskspace for BLOBs? We’ve got the following setup: GigE with a dedicated 50Gb/s throughput port. A SQL Server 2008 Express SP2 installation (default configuration) on 2x4Gb of RAM. A database mainly used for generic CRUD operations.

Q: MySQL: group rows based on partial value I have a MySQL table with a few thousand rows, one of the columns is lastName. Each row represents a person’s last name. I need to group the rows based on last name, and return a list of those last names. For example, I would like to get a list of all the people who have the last name of “Smith” but not the last name of “Jones”. I don’t want rows with “Smith, Jones, Zipp” in my resultset. What I’m trying now is something like this: SELECT * FROM People WHERE lastName LIKE ‘Smith’ OR lastName NOT LIKE ‘Jones’; But it’s returning all the rows that match “Smith” or “Jones”. I’ve tried variations on this approach, but they only get me part of the way there. I think the more elegant solution is to do this in SQL, but I can’t figure out how to express this as a where clause. Any help would be greatly appreciated! A: Try using the group_concat() function. Something like this: SELECT GROUP_CONCAT(lastName) FROM People WHERE lastName = ‘Smith’ OR lastName ‘Smith’ OR lastName = ‘Jones’ Edit to Add: In case you want to only return rows where the number of “Smith”s and “Jones”s in the list are equal, then use a HAVING clause instead: SELECT GROUP_CONCAT(lastName) FROM People WHERE lastName = ‘Smith’ OR lastName ‘Smith’ OR lastName = ‘Jones’ HAVING COUNT(*) = (SELECT COUNT(lastName) FROM People WHERE lastName = ‘Smith’) A: Let’s say that table’s name is People. You need to combine two conditions: where there is ‘Smith’ last name and there is no ‘Jones’ last name. So, your query might look like: select * from people p1 where lastname