Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jasonwcm
  • Content: Threads
  • Order by date
  1. jasonwcm

    Detecting whether a file in a server is an image file

    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...
  2. jasonwcm

    CFPOP - download attachment files only

    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...
  3. jasonwcm

    Window/Screen Height & Width

    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
  4. jasonwcm

    SQL UNION

    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 )...
  5. jasonwcm

    How to convert string to lowercase? - URGENT

    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...
  6. jasonwcm

    Alternative to SQL UNION

    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...

Part and Inventory Search

Back
Top