Search results for query: *

Thanks.. I thought of that too.. But one could deliberately rename the extension to a valid image extension. Any other thoughts?

As titled, I wonder if anyone has tried to detect whether a file (which is residing in the server) is an image file. I've sort of downloaded file attachments in my inbox using CFPOP tag and now I would like to know which of these attachments are images. Any help is greatly appreciated. Cheers...

Hi.. Am currently using CFPOP to retrieve email messages with the attribute "attachmentpath='C:\temp\'". Just wonder if there'a way to download only the attachment(s) that comes with an email message instead of downloading both the email message and the attachment and later delete the email...

Thanks to BillyRayPreachersSon... and my apologies to BabyJeffy for my inappropriateness. Cheers.

Hi.. Need somebody to explain to me the following.. - screen.width - screen.height - screen.availWidth - screen.availHeight - document.body.clientHeight - document.body.clientWidth - window.outerHeight - window.outerWidth Thanks in advance. Cheers, Jason

Thanks r937! It works perfectly fine now.[thumbsup2] Cheers.

Nothing seems wrong with the IIF... Basically it means to include some conditions.. in the following syntax.. SELECT QryMonoTones.ID AS ID, QryMonoTones.name AS name, QryMonoTones.artist AS artist, QryMonoTones.status AS status, QryMonoTones.created AS created, QryMonoTones.last AS last...

Hi.. Just wondering if what is wrong with this SQL statement.. ( SELECT mch.ID AS mchID, m.ID AS monoID, m.name, m.artist, mch.dlCode, mch.price, mch.created, mch.last, 'top' AS whQuery FROM tbl_mono m, tbl_monochannel mch WHERE mch.channelID = 2 AND mch.adID = 1 AND mch.monoID = m.ID )...

Thanks for the fast reply. I didn't join the 2 queries because both are referring to different datasource name. LCase didn't seem to work either. Query Manipulation Error Code = 0 Error: LCASE is not a number I've also tried putting it inside single and double quotes, surrounded with hash...

Hi.. Am trying to convert string to lowercase using LOWER but I was prompted with this error: Query Manipulation Error Code = 0 Error: LOWER is not a number This is my query: <cfquery name=&quot;QryMonoTones&quot; datasource=&quot;#Attributes.dsn#&quot...

Thanks for the quick reply.. I haven't create a view before. It would be great if you can provide a example or point me to some URLs perhaps. Cheers.

Hi.. Currently I have a sql statement using UNION as follow: ( SELECT a, b, c FROM tbl_A, tbl_B WHERE (some conditions) ) UNION ( SELECT a, d AS b, e AS c FROM tbl_C WHERE (some conditions) ) Is there a way to another way to achieve the same result without using the UNION cos I...