Recent content by minsan

Hey everyone, I hope someone has some prior experience on this one... Here's what I wanted to do. I want to trigger events in a presentation-like Flash movie using dynamic mp3 files. So, in Flash MX, I created a sound object from a dynamically loaded mp3 file. Using the sound.position...

duns, You might be on to something. How do I create that lookup table that combines the data from the two tables? minsan

tleish, I think my reply to your second suggestion was inaccurate. I must have left off the cfparam line or something. Anyway, I tried your suggestion again and it only works if I search for an individual employee. When I search for ALL, I get 16 results. Here's the SQL statement from the...

To this forum's experts... Can somebody at least tell me whether the problem I described above has a possible solution? Maybe I can stop looking for answers if there isn't any. Thanks. minsan

tleish, I tried your suggestion and here are the results. When I enter an individual employee, it works. I entered 102 and it picked out Projects 1, 2, and 3. But when I entered 0 for ALL, I got 0 results. It didn't error out, but no records were found. I think it might be because of this line...

I tried IN instead of LIKE, but I got an error saying cannot convert '101,102,104' to data type int. Unofortunately, because of the way the system is set up, projects.employee_id must be a string data type and employees.id must be an integer data type. So, I just can't change the data types...

I'm having trouble using the LIKE operator in one of my cfqueries. Here's some background info. I have two tables, namely, Projects and Employees, like so: PROJECTS Table index title employee_id 1 Build DB 102 2 Create Graphics 101,102,104 3 Write Code...

Thanks! I didn't know crypt() is a one way function.

I have a simple question. What is the opposite of the crypt() function? minsan

I think that just did the trick. Thanks very much!! minsan

I've searched this forum's archive and found a thread back in May that was similar to my problem, but that was left unanswered. So I'd like to re-open the issue. Hopefully someone can help this time around. I'm trying to move or copy a file from a Cold Fusion server (running Win2000) using...

Vic It looks like strchr() and strrchr() will only find the needle. What I really need is a function that will replace the needle. As far as replacing the nth occurence, has anybody out there written a custom function like this before? I've searched the forum archives with no luck. minsan

Is there a way to customize the str_replace function so that instead of replacing ALL occurences of the string needle, it will only replace the first occurence? or maybe the last occurence? or the n th occurence? Any ideas would be appreciated. minsan

What is the simplest or quickest way to make a form button download a file that's in the same directory as the php file? Is there one such function? I'm trying to make a button open up the File Download dialog box that the browser pops up when it's about to download a file.

Thanks! I didn't know about that trick. Now I can create my list using a loop.