How do I write a query to only pull 1 year (2009 lets say) from the DB that has a date field?
would I do something like where datestarting like "%09" ? I mean, that MAY work, but is there a less kludgy way of doing it? Dave l wrote: > "Ah, so eps is more like a 'psd' file rather than a 'png' file." > yes.. you can export an image file from it but it is more of a graphics file > than an image. Even if you could display it there is no reason to actually do > so since the files are huge. > > "Now don't be rude" > I wasn't actually trying to.. that is just the way it comes out. > > "I had thought that maybe 'eps' was a proprietary format similar to 'gif' is" > It is mostly made for print work using vector drawings and since printing > takes a lot higher quality the file size isn't optimized for a smaller foot > print. And really the resulting image needs to be flattened for web work. > It like a psd is a layer format which makes it more difficult for the web, > although png & tiff can be layered. > > Don't get me wrong I wasn't saying it was impossible to do anything with the > file, I was just saying cfimage won't do it and that is why it isn't listed > under the supported formats. > > You could always upload it and run a command line to open it in illustrator, > convert it and then have cfm do whatever with it. > > > >> <<Try to use an eps in a reg html img tag and see if it displays on web... >> it won't because IT IS NOT an image format.>> >> Ah, so eps is more like a 'psd' file rather than a 'png' file. >> >> << So would you hook up your garden hose and fill your tank with water and >> expect it run?>> >> That would be pretty cool though, wouldn't it? I don't think that will be >> too far off in the future... maybe a few decades? >> >> << time understanding that if it isn't on the supported formats then it >> isn't going to be supported then I would assume you won't be doing any java >> .>> >> Now don't be rude. >> >> Recently I was reading the blog of my webhost where they announced that they >> would be supporting .dwt as a text/html delivered file. They rationalized >> that since it was possible to do it, that they would support the customer >> who requested it. Personally I prefer to teach the uninitiated rather than >> divert the river for them, but its not my company or my call. >> >> I had thought that maybe 'eps' was a proprietary format similar to 'gif' is >> (was?). Hence the reason why I requested more information on the topic. >> >> After doing a (very) brief review of the google 'coldfusion convert .eps to >> .jpg', it appears that there was a tag available in the cf5 - cf6 days that >> was capable of doing the conversion: >> CFXImage tag from Gafware >> >> http://tinyurl.com/4e2zb4 >> >> ---------------------------------- >> William Seiter >> IT Web Developer / Consultant >> >> >> ::-----Original Message----- >> :: >> ::Sent: Wednesday, October 15, 2008 7:46 PM >> ::To: cf-talk >> ::Subject: Re: : Re: Getting cfimage to read .eps file >> :: >> ::No >> :: >> ::You guys need to understand that that cfimage is meant to work with >> ::images, hence the "image" part of the name and and eps IS NOT an image, so >> ::if it is not an image how can it read it? You'll have just as much luck >> ::uploading a zip file and trying to use cfimage to get it's info. >> :: >> ::Unless you are saying to just physically change the the eps to an image >> ::file and the answer would still be no, changing the postfix doesn't change >> ::the file type. Try to use an eps in a reg html img tag and see if it >> ::displays on web... it won't because IT IS NOT an image format. >> :: >> ::You know how on your car right by the gas cap it says "unleaded fuel >> ::only"? >> ::So if the fuel is the format then they are telling you that it will only >> ::work with unleaded fuel. So would you hook up your garden hose and fill >> ::your tank with water and expect it run? After all they are both liquid but >> ::does that mean they are the same? >> :: >> ::You could hook into command line and run it against a conversion program >> ::or like Mark said maybe a java class and return it but if you have a hard >> ::time understanding that if it isn't on the supported formats then it isn't >> ::going to be supported then I would assume you won't be doing any java >> ::programming. >> :: >> :: >> ::>I have been watching an I am curious. I don't have a ton of experience >> ::with >> ::>the cfimage tag, just simple implementations, so maybe some of you might >> ::>know this. >> ::> >> ::>In regards to this question, would it be possible to have cfimage change >> ::the >> ::>'image' type from .eps to .gif or .jpg? >> ::> >> ::>If it is possible, then he could do a conversion and then read the >> ::converted >> ::>file for the required data. >> ::> >> ::>Any thoughts? >> ::> >> ::>William >> ::> >> ::>---------------------------------- >> ::>William Seiter >> ::>IT Web Developer / Consultant >> ::> >> ::>Is your income limited by the red tape and paperwork? Let SoftEx >> ::BackOffice >> ::>help you. They know how to take care of the 'busy work' of your >> ::contracts >> ::>and let you focus on the 'WOW' factor. >> ::>http://www.softexconsulting.com/softex_office.cfm >> ::> >> ::>::-----Original Message----- >> ::>:: >> ::>::Sent: Wednesday, October 15, 2008 6:18 PM >> ::>::To: cf-talk >> ::>::Subject: Re: : Re: Getting cfimage to read .eps file >> ::>:: >> ::>::dammit wrote a long answer and it cut it off. >> ::>:: >> ::>::bottom line is this... >> ::>::An eps file is not an image file, it's an encapsulated postscript file >> ::or >> ::>::something but it's technically not an image just like a pdf isn't an >> ::image >> ::>::or a psd isn't an image and ai isn't an image, they aren't supported >> ::types >> ::>::either. >> ::>:: >> ::>::If the file types isn't in the supported types then it isn't supported, >> ::it >> ::>::is pretty clear cut. >> ::>:: >> ::>::You can upload any type of file you want but cfimage isn't going to >> ::give >> ::>::you the results you want because the file type isn't supported. cffile >> ::can >> ::>::give you some of what you might need but cfimage won't. >> ::>:: >> ::>:: >> ::>:: >> ::>:: >> ::>:: >> ::>::>@Dave - That is an option to not allow our users upload that format, >> ::but >> ::>::the >> ::>::>my Client would like to allow the .eps format to be uploaded. If that >> ::>::>format is allowed to be uploaded, I need to be able to pull the >> ::>::information >> ::>::>of the file out, like height, width, etc... >> ::>::> >> ::>::>So I'm just fishing to see anyone has use the <cfimage> tag to pull >> ::info >> ::>::on >> ::>::>a .eps file. If so, how did they do it. >> ::>::> >> ::>::>;) >> ::>::> >> ::>::> >> :: >> :: > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313989 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
