Saturday, April 09, 2005

CFOUTPUT Maxrows

How do I get a CFOUTPUT to only return a certian number of results?

Setting the maxrows in the query tag is another option...

cfquery ... maxrows="45" this will work for small queries.. but may not be the best option to use because it returns all of the records of the query but will only show the maxrows that are specified in the query.

If you would like to make your query truly random, I'd suggest using:

ORDER BY NewId() -- This gives a unique order by each execution.

Friday, April 08, 2005

Adobe Tutorials

The Adobe site has great tutorials. I also like the Studio Exchange. It has lots of great styles, brushes, etc to download and share.

Thursday, April 07, 2005

Podcasting Articles

TopCast Awards to Recognize Podcast Industry's Top Programming Talent This Fall April 6, 2005 - PRNewswire



Plugged in - Next Big Tech Ideas May Be Small Ones April 5, 2005 - Reuters



How satellite radio is changing radio April 5, 2005 - Washington Times



iPod-radio er et hit April 5, 2005 - Berlingske



Podcasting Proves Popular April 4, 2005 - Information Week



Podcast popularity picking up April 4, 2005 - Reuters



Hello? Is this thing on? Podcasting (update) April 4, 2005 - Informantica



Six Million Podcasters and Counting April 4, 2005 - NewsFactor Network



Podcasting: Blogging Out Loud April 4, 2005 - NewsFactor Network



Los 'podcasts' se popularizan entre los usuarios de iPod- sondeo April 4, 2005 - Reuters



'Podcasts' Catching on with iPod Owners - Survey April 3, 2005 - Reuters



LIAR, LIAR. Seth Godin quizzed April 2, 2005 - HindustanTimes.com



And Now for the Next Internet Craze: ┼ĺPodcasting┬╣ April 2, 2005 - ArabNews



STEVE LAWSON'S TECH HEADS : HAVE FAITH.. April 1, 2005 - Daily Record



A sound business April 1, 2005 - Boston.com

Wednesday, April 06, 2005

Photoshop Working Space

Question: I have the "working space" in Photoshop set up and every time I open a photo from my digital camera to my hard drive, Photoshop pops up a window telling me "Embedded Profile Mismatch" and I have to click on "Convert document's colors to the working space, and THEN open the photo - every time.

Obviously my camera's settings aren't the same. Is there a way to set the preferences, so that this is automatic with each photo so that it automatically converts to my "working space"?

Do the following:

Edit > Preferences > File Handling see if the little box "Ignore EXIF profile tag" is checked

Tuesday, April 05, 2005

Coldfusion Really Unique

Quesiton: I am trying to write a file to a folder that may already contain a file of the same name. I know that if I use the NameConflict attibute and set it to MakeUnique, it works with CFFILE Action=Upload. However, NameConflict does not seem to work with CFFILE Action=Write. Is this correct? If so, is there a way to make it give the file a unique name?

Answer: CFFILE ACTION="WRITE" FILE=" #myvar#_#date#.html" OUTPUT="#stuff#" ATTRIBUTES="READONLY" NAMECONFLICT="MAKEUNIQUE"

Try #myvar#_#date#_#time#.html which will guarantee a unique name

Monday, April 04, 2005

Dreamweaver Redirect

I have a client who wants their existing url to redirect to another one. I have tried using the refresh meta but it doesn't seem to be working.

This should help you out:

meta http-equiv="refresh" content="3;URL=http://www.yoursite.com/abc6/index.cfm"

There you go...

Sunday, April 03, 2005

It's Coldfusion Time

Can someone tell me how to convert a number field in the output of a database from standard number to regular formatted time?

My database data looks like this: 1715 and I want it to output this: 5:15 PM

<cfset time="1715">
<cfset hours="1200">
<cfif time gt 1200>
<cfset newtime=time-hours>
<cfelse>
<cfset newtime=time>
</cfif>
And then put in the colon, space and PM.

OR

You just need to insert the colon in the proper place

<cfset myTime = timeFormat((Left(query.columnName, 2) & ':' & Right(query.columnName, 2)), 'hh:mm tt')>

This will work fine so long as the number is 4 characters long, if not you will have to adjust for length.

if time is 17:01:08

<cfset myTime = timeformat(query.columnName, "hh:mm:ss tt")>
this will output 05:01:08 PM

<cfset myTime = timeformat(query.columnName, "h:mm:ss tt")>
this will output 5:01:08 PM

<cfset myTime = timeformat(query.columnName, "HH:mm:ss")>
this will output 17:01:08

Masking characters that determine the format:

h: Hours; no leading zero for single-digit hours (12-hour clock)
hh: Hours; leading zero for single-digit hours (12-hour clock)
H: Hours; no leading zero for single-digit hours (24-hour clock)
HH: Hours; leading zero for single-digit hours (24-hour clock)
m: Minutes; no leading zero for single-digit minutes
mm: Minutes; a leading zero for single-digit minutes
s: Seconds; no leading zero for single-digit seconds
ss: Seconds; leading zero for single-digit seconds
l or L: Milliseconds. l gives 3 digits. L gives 2 digits.
t: One-character time marker string, such as A or P
tt: Multiple-character time marker string, such as AM or PM
short: equivalent to h:mm tt
medium: equivalent to h:mm:ss tt
long: medium followed by three-letter time zone; as in, 2:34:55 PM EST
full: same as long