Recent content by GoSooJJ

Sorry if my original question wasn't clear. Anyways, I fixed it out. Here is an example that I just tested and works fine. <cfoutput> <cfset str = '200909' /> <cfset str = '20090903' /> <cfif len(str) EQ 6> <cfset str = dateFormat(parseDateTime(reReplace(str, "([0-9]{4})([0-9]{2})$", "\1/\2"...

This can be simple but I'm trying to find out best way of converting string integer to date format. Maybe use regular expression for this? there is input string which is 6, or 8 numeric characters. if 6 characters then first 4 digit is year and last 2 digit is month. If 8 characters then first...

Okay I figured it out ^_^ 1. Cleaned up the table values from '<=$100,>$1000' to '<= 100,> 1000' for all 2. Get 1st query by given constant values such as company name, company address, and so on. 3. Loop the query to evaluate the given value '2100' with queried values. For example, with '<=...

I'm not sure if this is possible but I hope someone can help me out. Basically I have a table with company information and conditional values. Conditional Values can be '<=$100,>$1000' or '>$200,<$500'... In my application, I will pass a company information and value arguments. For example, if...

Wow many many thanks to you r937!!

Can I sort by given values? Assume that I have column call EMP_ID with range from 1 to 6 then I want to sort by this order (1,3,5,6,4,2). Is there such way to do it easily? TIA

I have a client who use Coldfusion 5 and the pages are encoded with Shift_JIS character set. I'm testing the internal site with CF 8 right now but facing many problems. First the client does not want to convert both cfm pages and database to UTF-8 so I have to use existing setup. Since CF5 used...

I'm currently running Coldfusion 5 with Oracle US7ASCII character set database. I have been stored data in Shift_JIS (Japanese), Big5 (Chinese), and EUC-KR (Korean). Now I installed MX 8 on development server and tried to work with existing Oracle database but everything display as garbage...

I need to make popup layer which when customer mouseover(hoover) to product then popup layer show up with other similar products then user can add to shopping cart directly. I'd like to have something similar to http://optspots.com/advertisers.html. Is there any script that I can use or have an...

Thank you for your reply Harm. I understand now. It's security reason that you can not copy to File type field. Looks like there's no short-cut.

Assume that I have 20 images with sequence number like "happy_1.jpg" to "happy_20.jpg" then I need to upload all 20 images to server. However I don't like to click 20 times to enter the images into File field. Is there anyway that I can generate them in javascript and fill into the each File...

I'm trying to figure if there's way to check file exist from the download server before I download? I only need to check file exist or not but cfhttp is trying to download files... Anyone know easy way? FYI i'm using CF 5.0.

I'm having little hard time to figure out how to replace URL encoded characters to original characters. For example I have this cookie from Coldfusion and it displays: SESSION_INFO=12345%7C%7C1%7C%7C123%7C%7C10%2E6; which is 12345||1||123||10.6 Can anyone show me how to convert SESSION_INFO...

Again, thank you very much!!!!!

Thanks for the great answer cpjust. However, can you show me the example of what you just described? I just can not make sure that I'm doing right (I'm guessing too many times). Please help me one more time if you can :) TIA