Recent content by forumposters

Let me try and explain the problem in another way. The UNION ALL only works if the two tables have the same columns. If one table has an extra column and you want to select it, then an error occurs. I want to have that extra column in table A in the rows returned from table A.

That's exactly what I needed. Thanks! One more question: If I want to also select a field from from table A that does not exist in table B, how can I do that? Is there some SQL code that will add this field to table B for this query and add a default value of my choice? So, I would have...

Thanks for bringing that to my attention. So, I actually don't want to join the two tables and I titled this thread wrong, sorry about that. I just want to get records from both of the tables. The SQL statement produces the results I want, but it takes a long time. Is there anyway to rewrite...

Here's my SQL: SELECT * FROM A, B WHERE A.address IN ('X') OR B.address IN ('X') ORDER BY B.address, A.address,B.[date], A.[date] Is there anything that sticks out here that could be improved so that this query takes less time to run?

Thanks, cfsearching. Here's the code that I've come up with after some further help from the Javamail forum: <cfset variables.b = emlFile.getBytes("iso-8859-1")> <cfset variables.byteInputStream = createObject("java","java.io.ByteArrayInputStream").init(b)/> <cfset variables.oMail =...

cfsearching, How might you parse emails from a zip file without unzipping it first? Here's what I've come up with so far which makes use of the new cfzip tag: <cfzip action="list" file="#ExpandPath( '/test/test.zip' )#" name="test" /> <cfoutput query="test"> <cfzip...

How do you set the border color of a select menu in IE?

thanks for that tip. i'm not sure how to apply it though. If I copy and paste that to the address box in my browse and hit return, it doesn't do anything.

If i want to see where all the borders are on all my divs, tds, etc I can put this line in my css: *{ border: 1px; border-style: solid; } But, I'd like to see margins and padding as well... Is this possible?

many thanks for your helpful replies... very much appreciated. you got me thinking when you explained that the browsers is not configured to open rtf files... i did some googling on this issue and found a plugin for firefox that allows me to configure this terrific browser to open rtf files...

this seems to work for images. i'm actually using jQuery to write create an iframe for each attachment like this: $('.attachDisplay').html("<iframe width='500' height='200' src='showFile.cfm?emailFilename=#url.file#&attachFilename="+$(this).attr('attachFilename')+"'></iframe>"); And...

Actually, I wasn't thinking of saving it to disk nor too a database. Can't I use the variable attribute of cfcontent instead of the file attribute?

Thanks for another helpful post. I am able to create a variable that is a byte array for each attachment. I can then use cffile with the readbinary action. I'm not sure what to do next though. Might I want to use cfcontent to display the attachments? Or, might there be a better way to...

Here's how I had to get the body of the email, and it seems to contain the attachments: <cfset content = message.getContent()> <cfset i = 0> <cfset bodyPart = content.getBodyPart(javacast("int", i))> <cfreturn bodyPart.getContent()> But, now I want to get the attachments that are in...

Thanks, that was very helpful. One thing that is giving me trouble now is trying to figure out where all the data is stored in the message object. I can't use cfdump to see where everything is store and under what function. Instead, I have to keep guessing and checking. Right now for...