Manipulate the DPI with cfimage?

2008-01-03 Thread Carsten Klement
Hello, i use a Linux Server with CF8 an want to read out or manipulate the dpi of pictures with cfimage. I have found it only in the function ImageGetEXIFMetaData, but not every picture have the Exif Data. Is it right, that this function is not supported in CF8? Thanks! Carsten

RE: Manipulate the DPI with cfimage?

2008-01-03 Thread Andy Matthews
When you're dealing with images for display on computer screens, there's really no such thing as dpi. It all has to do with the pixel dimensions. If you have a 1600x1200 image, then it would be 22in x 16in at 72dpi (on a monitor) or 5in x 4in at 300dpi. -Original Message- From:

OT:Flex Training

2008-01-03 Thread Qasim Rasheed
Sorry for being slightly OT. Does anyone has recommendations for Flex training with emphasis on using ColdFusion at the back end? Thanks -- Qasim Rasheed (IM qasimrasheed AT yahoo, msn or GTalk) ~| Adobe® ColdFusion® 8

RE: mssql pagination

2008-01-03 Thread Dan G. Switzer, II
Jonathon, Here's a stored procedure you can use in MSSQL 2k for pagination: http://blog.pengoworks.com/index.cfm/2006/6/19/MSSQL-2k-Stored-Procedure-for -Pagination It doesn't use #temp tables and it will only return the pages of data you're after. I've used it on tables with several millions

CF 5 and DAO

2008-01-03 Thread Chad Gray
I am so use to using MX and CFCs that now I have to work on a CF5 server for a client and Is there a good way of setting up a DAO in CF5 so I can reuse SQL code and not have to retype the CFQueryies each time I need them? Should I use CFModule? CFInclude? A custom tag CF_ProductDAO?

sql question: contains space' '

2008-01-03 Thread morchella
hey guys. this is a 2 parter. i have a table i need to fix. i have no real idea how to do this. the problem is the Contact filed. the first several thousand entries combine fnme lname into this one field from a xls file. then maybe 20,000 entries only have a name with a space in the Contact

Re: Manipulate the DPI with cfimage?

2008-01-03 Thread Rick Root
On 1/3/08, Andy Matthews [EMAIL PROTECTED] wrote: When you're dealing with images for display on computer screens, there's really no such thing as dpi. It all has to do with the pixel dimensions. I've argued many times myself (as author of ImageCFC) that DPI is not a function of the image

Re: OT:Flex Training

2008-01-03 Thread Rick Root
On 1/3/08, Qasim Rasheed [EMAIL PROTECTED] wrote: Sorry for being slightly OT. Does anyone has recommendations for Flex training with emphasis on using ColdFusion at the back end? Qasim - One of my coworkers took flex training at Figleaf in DC and found it to be very helpful. I myself am

Re: sql question: contains space' '

2008-01-03 Thread morchella
but what if i want like '% '; and not like '% money' where money could be any last name or character. On Jan 3, 2008 10:17 AM, Greg Morphis [EMAIL PROTECTED] wrote: the SQL statement like requires a %.. for example.. select * from froo where name like 'G%' will return all names that starts

RE: OT:Flex Training

2008-01-03 Thread Chad Gray
I don't know of any training. I have had to do my own experimentation with the help docs and the 'Adobe Flex 2 training from the source' book to figure out how to communicate with CFCs and the flash remoting mechanism on the CF server.

Re: sql question: contains space' '

2008-01-03 Thread Greg Morphis
the SQL statement like requires a %.. for example.. select * from froo where name like 'G%' will return all names that starts with G.. So try something like select * from tbl where name like '% '; That will catch anything with a trailing space. Just a heads up.. On Jan 3, 2008 9:03 AM, morchella

Re: sql question: contains space' '

2008-01-03 Thread Greg Morphis
'% ' shouldnt return ' money' it should only return enteries with a trailing space.. for example create table testtbl ( name varchar2(10)); insert into testtbl values ('Greg '); insert into testtbl values ('Greg M'); insert into testtbl values ('Greg Mo'); insert into testtbl values ('Gary ');

RE: mssql pagination

2008-01-03 Thread Jonathon Stierman
Thanks Dan, Adam, and Eric! I haven't played around with stored procedures much, so this will give me a chance to give them a whirl. As for 2000 being out of date, I hear you there -- I'll have to push to get the budget for it. At least now I have some leverage (a problem that can't easily be

Re: sql question: contains space' '

2008-01-03 Thread Ian Skinner
You may need to get into database character functions. I believe they all have them, but they all implement them slightly differently. You will need to consult appropriate documentation for you database management system. But you should be able to do something like this concept. SELECT

Re: sql question: contains space' '

2008-01-03 Thread Paul Ihrig
just fond out why man this db is so messed up... 'Joe Garth ' so i would i look for NOT LIKE '% % ' ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial

Re: sql question: contains space' '

2008-01-03 Thread Jim Wright
On 1/3/08, Paul Ihrig [EMAIL PROTECTED] wrote: just fond out why man this db is so messed up... 'Joe Garth ' so i would i look for NOT LIKE '% % ' OR... ltrim(rtrim(contact)) NOT LIKE '% %' ~| Adobe® ColdFusion® 8

Re: mssql pagination

2008-01-03 Thread Jim Wright
On 1/2/08, Jonathon Stierman [EMAIL PROTECTED] wrote: You can see in the All Samples section that records 20-30 should be: [147, 148, 149, 150, 63, 36, 40, 382, 383, 384]. But the Total Wrapper query returns: [146, 147, 148, 149, 150, 63, 382, 383, 384, 440]. What happened to record 40? It's

RE: sql question: contains space' '

2008-01-03 Thread Mark Kruger
If what you are trying to do is eliminate trailing spaces why not just do: Update contacts set contact = rtrim(ltrim(contact)) -Original Message- From: morchella [mailto:[EMAIL PROTECTED] Sent: Thursday, January 03, 2008 9:03 AM To: CF-Talk Subject: sql question: contains space' '

Re: sql question: contains space' '

2008-01-03 Thread morchella
ok.. thank you! SELECT id, Contact, Address, City, State, Zip FROM Leads WHERE (Contact LIKE '') OR (Contact LIKE ' ') OR (Contact NOT LIKE '% % ') AND (LTRIM(RTRIM(Contact)) NOT LIKE '% %') ORDER BY id now to fix 20,000+ records!

Re: 2008 conferences of interest

2008-01-03 Thread Sean Corfield
On Jan 2, 2008 6:27 AM, Andy Matthews [EMAIL PROTECTED] wrote: I'm really leaning towards this one. I've heard that it's a little more in-depth than CFUnited is. Can anyone confirm this? Well, I'm content chair for cf.Objective() so I may be a little biased (but I'm also on the advisory board

Re: CF 5 and DAO

2008-01-03 Thread Ben Doom
We always used includes, although cfmodule would probably be better. We just broke each inline query out into an include, then called it as necessary. --Ben Doom Chad Gray wrote: I am so use to using MX and CFCs that now I have to work on a CF5 server for a client and Is there a good

Re: sql question: contains space' '

2008-01-03 Thread morchella
Mark i am trying to find where only the lastname was added to the field Contact. some 2000+ records. then do a match on a known field like email or phone then update the Contact field with the combined 'fname lname' from a xls spread sheet. then after all the names are combined i will just add 2

Re: Manipulate the DPI with cfimage?

2008-01-03 Thread Claude Schneegans
I've argued many times myself (as author of ImageCFC) that DPI is not a function of the image itself, but the meta-data of the image, as the DPI is *ONLY* used for print. or scanning, I couldn't agree more. The resolution is a quality of instruments, images have no resolution. and DPI

RE: 2008 conferences of interest

2008-01-03 Thread Andy Matthews
Thanks for the feedback Shawn. I've put in my request for either WebManiacs or CFObjective. CFObjective because it does have a lot to offer for more advanced developers. WebManiacs because what it offers for the price is too good to pass up. andy -Original Message- From: Sean Corfield

Re: CF 5 and DAO

2008-01-03 Thread Greg Luce
Stored procedures. :-) On Jan 3, 2008 11:33 AM, Ben Doom [EMAIL PROTECTED] wrote: We always used includes, although cfmodule would probably be better. We just broke each inline query out into an include, then called it as necessary. --Ben Doom Chad Gray wrote: I am so use to using MX

RE: Manipulate the DPI with cfimage?

2008-01-03 Thread Mark Kruger
Claude, Hmmm Ok this is interesting to me. The argument below seems semantic So I think I am missing something. I'd like to get my head around this. Visually DPI represents dots per inch - it's a measure of density in printing. The higher the DPI the better the quality of printing -

RE: CF 5 and DAO

2008-01-03 Thread Chad Gray
I though about that, but I am forced to use Access and too my knowledge you can't do Stored Procedures. -Original Message- From: Greg Luce [mailto:[EMAIL PROTECTED] Sent: Thursday, January 03, 2008 11:52 AM To: CF-Talk Subject: Re: CF 5 and DAO Stored procedures. :-) On Jan 3, 2008

Re: CF 5 and DAO

2008-01-03 Thread Aaron Rouse
We did cfincludes as well and in this same manner. I have seen where people have done a cfinclude of a series of UDFs and each UDF is a query more or less. Seems like it would not be the most efficient of ways to do things. On Jan 3, 2008 10:33 AM, Ben Doom [EMAIL PROTECTED] wrote: We always

RE: Manipulate the DPI with cfimage?

2008-01-03 Thread Andy Matthews
Mark... You're also confusing image quality (compression) with DPI (or pixel dimensions). At it's heart, a bitmapped (or raster) image, is simply a series of 1 pixels blocks with specific color assignments. An image doesn't know what quality (compression) it is. It also doesn't know what

Re: CF 5 and DAO

2008-01-03 Thread Eric Cobb
Actually, you can. Sort of. http://intersuite.com/client/index.cfm/2007/11/8/Stupid-MS-Access-Tricks This was tested on CF 7, but I would think that it would work with CF 5 Hope this helps! Eric Chad Gray wrote: I though about that, but I am forced to use Access and too my knowledge you

Re: CF 5 and DAO

2008-01-03 Thread Dominic Watson
Personally, I would do it in a way where you can set the name of the variable that is going to store the query in the calling code. i.e. I would avoid something like this as it can lead to ambiguity over where the qry_users variable is set: cfinclude template=queries/QRY_getusers.cfm cfloop

Re: Manipulate the DPI with cfimage?

2008-01-03 Thread Rick Root
On 1/3/08, Mark Kruger [EMAIL PROTECTED] wrote: Ok So compression is the best measure of quality? Yes, in a world of compressed images. However, your average print shop would rarely used compressed graphics for printed material. dots per inch is a reasonable measure of quality when you

Re: mssql pagination

2008-01-03 Thread Jochem van Dieten
Jonathon Stierman wrote: As for 2000 being out of date, I hear you there -- I'll have to push to get the budget for it. At least now I have some leverage (a problem that can't easily be fixed otherwise). How about mainstream support ends this year?

RE: Manipulate the DPI with cfimage?

2008-01-03 Thread Mark Kruger
Ok So compression is the best measure of quality? -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Thursday, January 03, 2008 11:24 AM To: CF-Talk Subject: RE: Manipulate the DPI with cfimage? Mark... You're also confusing image quality (compression) with DPI

Re: Manipulate the DPI with cfimage?

2008-01-03 Thread Claude Schneegans
Visually DPI represents dots per inch - it's a measure of density in printing. The higher the DPI the better the quality of printing - right? Exact. It's a density. The definition of a resolution is the size of the smallest element the instrument can measure, -- if the instrument sees or

Re: Manipulate the DPI with cfimage?

2008-01-03 Thread Claude Schneegans
I think Claude's usage of the term density is an excellent choice. Humbly, it's not really my choice, this is the way I learned it when I was student in physics. I just hope the translation is correct, in French, we call it densité ;-) -- ___ REUSE CODE!

Re: Manipulate the DPI with cfimage?

2008-01-03 Thread Claude Schneegans
Ok So compression is the best measure of quality? except that it is a reverse measure: the higher the compression is, the lower the quality. Some softwares use % compression, some others % in quality. A 10% compressed image is equivalent to a 90% quality, etc. --

Struct Issue

2008-01-03 Thread Adkins, Randy
I have a CFC which returns a query based listing of error messages. Here is the CFC: cffunction name=getMessage access=public description=Returns either a structure containing all system messages, or an array containing one or more messages corresponding to the messageID passed in from the

RE: mssql pagination

2008-01-03 Thread Jonathon Stierman
That will definitely help my footing as well! Arguably even more than my fringe case that I couldn't work around. ;) Thanks, Jochem! Jonathon ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to

CF 4.5 MS Access Data Source Name

2008-01-03 Thread Ian Skinner
Flash from the past. On a CF 4.5 (Hopefully soon to be replaced) server does one need to do something special to set up an Access data source name? I'm looking at the data sources panels in the Administrator and I do not see any options for Access. I see Merant drives for dBase/FoxPro, IBM

Re: CF 4.5 MS Access Data Source Name

2008-01-03 Thread Ian Skinner
Now that I wake up a bit and realize that this 4.5 server I am looking it is a Unix box. I probably figured out why I am not seeing the built in Microsoft Access database driver as well as that no matter how much access I have to the box, I am unlikely to find a Microsoft ODBC administration

Re: Struct Issue

2008-01-03 Thread Rick Root
On 1/3/08, Adkins, Randy [EMAIL PROTECTED] wrote: Here is the call to the getMessages function: (Yes it is set as an object) cfset messageStruct = application.msgMgr.getMessage(attributes.messageId) Now I can check it this way but at times it returns an error on the initial startup: cfif

Re: Struct Issue

2008-01-03 Thread Josh Nathanson
Any idea why it would return the error or a way I can prevent it? I can not use IsStruct since it is a query rather than a true structure? It looks like a string is being returned rather than a query as you are expecting. You'll need to trace back through your code and figure out where it's

RE: Struct Issue

2008-01-03 Thread Adkins, Randy
Thanks. Sometimes the query will have multiple messages to be displayed with different messageIDs. Thus the reason I considered the dynamic query method :-) I will try isQuery but I think I have found that for some reason the initial call is not creating the dynamic query itself. -Original

Re: Struct Issue

2008-01-03 Thread Rick Root
On 1/3/08, Adkins, Randy [EMAIL PROTECTED] wrote: Thanks. Sometimes the query will have multiple messages to be displayed with different messageIDs. Thus the reason I considered the dynamic query method :-) I will try isQuery but I think I have found that for some reason the initial call is

Re: Struct Issue

2008-01-03 Thread Brian Kotek
Just a note that your method does not return a struct or an array, which is what your description attribute says. It returns a struct or a query. Also, you might want to consider refactoring this into two methods, because having it sometimes return a query and other times return a struct will

Re: onApplicationStart

2008-01-03 Thread Brian Kotek
You can just call onApplicationStart() again, but be aware that it won't be thread safe as it is when the application starts up. On Jan 3, 2008 3:01 PM, Adkins, Randy [EMAIL PROTECTED] wrote: Question: When using the onApplicationStart within an Application.cfc, lets say I wanted to restart

Re: onApplicationStart

2008-01-03 Thread Michael Dinowitz
You can have a cfif looking for a url variable such as reset. Inside the CFIF you can recall the onapplicationstart method cfif structkeyexists(url, 'reset') cfset onapplicationstart() /cfif Personally, I'd go for a separate reset page. Why have a CFIF if it will rarely, if ever used. On Jan

RE: Struct Issue

2008-01-03 Thread Adkins, Randy
Sorry I did not update the description. It now will always return a Query :-) I did find out that onApplicationStart it was not re-initiaing the application.msgMgr object for the new functions and still trying to use the old setup which did create a basic variable rather than a query. All is

Re: onApplicationStart

2008-01-03 Thread Will Tomlinson
What is another way besides creating a temp file to explicitly reset those variables? Is there a way to make the Application expire and restart (sort of speak)? Here's what I use: cffunction name=onRequestStart returntype=void output=false cfif structKeyExists(url,reinitApp) cflock

Re: onApplicationStart

2008-01-03 Thread Barney Boisvert
No, not really. I put all my initialization logic in a separate method of Application.cfc, and then invoke that method from onRequestStart if certain conditions are met (usually the presence of a reloadApplication URL param that is set to a specific value). Note that this doesn't expire the

RE: onApplicationStart

2008-01-03 Thread Adkins, Randy
Sweet.. thanks -Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: Thursday, January 03, 2008 3:00 PM To: CF-Talk Subject: Re: onApplicationStart What is another way besides creating a temp file to explicitly reset those variables? Is there a way to make the

Re: onApplicationStart

2008-01-03 Thread Mike Chabot
You can try putting most of your OnApplicationStart code into cfinclude files and call those cfinclude file in some other reload page. This has an advantage over calling OnApplicationStart again if there are some things that OnApplicationStart does that you don't want to do a second time, such as

Re: onApplicationStart

2008-01-03 Thread Raymond Camden
Just note though - that lock isn't really necessary if all you are doing is setting a bunch of simple values in the app scope. And by simple I mean things that dont' need to be single threaded. A CFC stored in the app scope is most likely fine as well. On Jan 3, 2008 1:59 PM, Will Tomlinson

Re: onApplicationStart

2008-01-03 Thread Ian Skinner
You can also temporiarly set the session timeout to 0 or some other really short time, let the application expire, then return the timeout to the desired value. ~| Adobe® ColdFusion® 8 software 8 is the most important and

onApplicationStart

2008-01-03 Thread Adkins, Randy
Question: When using the onApplicationStart within an Application.cfc, lets say I wanted to restart the Application to pickup some changes. Now I know you can cycle the CF Services but I do not have that access to the server. What is another way besides creating a temp file to explicitly reset

RE: Manipulate the DPI with cfimage?

2008-01-03 Thread Mark Kruger
Claude, Thanks for an enlightening foray into the world of graphics. I especially like the part about a virtual object having no size..fascinating. It made me think to myself... If a virtual tree falls in the woods... (ha). In any case, excellent stuff. I feel edicated enough to be able to say

Exception thrown and not caught - is back

2008-01-03 Thread Dustin M. Snell
Hello CF-Talk, When I try to implement the following tutorial I get the dreaded error Exception Thrown and Not Caught in IE. Quite a few people in the comments seem to have the same problem - anyone happen to know what causes this for this example?

RE: Exception thrown and not caught - is back

2008-01-03 Thread Dustin Snell [Network Automation]
I recall my question. I found I had not blocked content for .cfc requests in my OnRequentEnd. Sorry to clog the tubes with this. -Original Message- From: Dustin M. Snell [mailto:[EMAIL PROTECTED] Sent: Thursday, January 03, 2008 12:46 PM To: CF-Talk Subject: Exception thrown and not

OT: Admin SQL Server from Linux

2008-01-03 Thread Bryan Stevenson
Hey All, Tossed Windows recently for Ubuntulooking for a Linux alternative to MS SQL Server Enterprise Manager. Any ideas? I have VirtualBox installed with Win XP Pro virtualized with itso I can install Ent Mngr in there if I must (or possibly using the WINE emulator)but I'd

Re: OT: Admin SQL Server from Linux

2008-01-03 Thread Jordan Michaels
Hey Bryan, In the past I've used Aqua Data Studio from my linux desktops to work with MS SQL Server. It's a pretty nice product with a lot of features. It's written in Java which gives it the platform independence. http://www.aquafold.com/ I'm sure there are other options available, but

PDF merge works once, then fails

2008-01-03 Thread Paul Malan
I am trying to merge two separate PDF files into a single two-page file. I'm doing this as part of a loop of 125 records. And I'm losing my mind. The cfpdf merge works one time--the first time--and then returns NullPointerException. It doesn't matter which record I handle first--if I start

Re: OT: Admin SQL Server from Linux

2008-01-03 Thread Bryan Stevenson
Hey Jordan, Thanks for the linkI'll check that out. Worst case is I'll remote desktop via SSH to one of our Win 2k3 servers that has SQL Server and Ent. Mngr installed ;-) Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone:

Re: PDF merge works once, then fails

2008-01-03 Thread Paul Malan
Okay, I think there is a bug using cfpdfparam nested within cfpdf action=merge. I pulled the cfpdfparams out, opting instead for a comma-separated list in the Source attribute, and it works. This works: cfpdf action=merge

Using message bounces to manage email list?

2008-01-03 Thread Pete Ruckelshaus
Hi, I have developed an email newsletter application for one of my clients (a local bike shop). They have nearly 5,000 email addresses in the database, and we are using a shared server with crystaltech. I have created an interface that allows them to remove bounced email addresses from the

Re: onApplicationStart

2008-01-03 Thread Sean Corfield
On Jan 3, 2008 12:24 PM, Raymond Camden [EMAIL PROTECTED] wrote: Just note though - that lock isn't really necessary if all you are doing is setting a bunch of simple values in the app scope. And by simple I mean things that dont' need to be single threaded. A CFC stored in the app scope is

Re: 2008 conferences of interest

2008-01-03 Thread Sean Corfield
On Jan 3, 2008 8:42 AM, Andy Matthews [EMAIL PROTECTED] wrote: CFObjective because it does have a lot to offer for more advanced developers. WebManiacs because what it offers for the price is too good to pass up. If you make it to cf.Objective(), say Hi! :) I can't go to WebManiacs due to a

Re: CF 5 and DAO

2008-01-03 Thread s. isaac dealey
I am so use to using MX and CFCs that now I have to work on a CF5 server for a client and Is there a good way of setting up a DAO in CF5 so I can reuse SQL code and not have to retype the CFQueryies each time I need them? Should I use CFModule? CFInclude? A custom tag CF_ProductDAO?

Re: Using message bounces to manage email list?

2008-01-03 Thread J.J. Merrick
Pete, I wrote a blog post a while back with a way to do this: http://jeremiahx.com/2007/08/12/how-to-email-bounce-management/ Basically you put an ID of your user inside of the failto so it would be failto=[EMAIL PROTECTED] Create a catchall on the bounces.mydomain.com domain and then parse

Re: Using message bounces to manage email list?

2008-01-03 Thread Dave l
i do that on a site. first thing is that a lot of crystaltech's servers are on spam lists so I would check your server to see. just set up the failto address and run a scheduled task to check it and run cfpoop to check it but you need to be sure to check the header and body content for the