Recent content by LongHorn

My Oracle DBA has set up an account that must be activated by the application program. She said to execute the following code to enable the application update role : EXECUTE DBMS_SESSION.SET_ROLE(TSEC.SROLE('<application_name>')); I don't know where to issue this command from my CF APP. I am...

Hi, How do I update the field's value that has type char(10)? For instance I want to change the value from 4535 to 4535AR. I tried update nsr_pmt set pmt_id = pmt_id + 'AR' , but I got an error. Thanks, Longhorn

Hello, What caused the error &quot;Invalid file descriptor&quot;? Thanks, Longhorn

I loaded Apache 1.3.14 on my Windows2000 laptop. It said that Apache is running... when I started the service. The problem is that I can't get the CF server to work. When I tried to open CF Administrator, it thought that I was trying to download the index.cfm file from 127.0.0.1. Why is this? I...

Thank you, tleish. Your reply gave me the clue as to where the error lies. The entire array was passed as an URL variable and I didn't have it URLEncodedFormatted.

I have an array and want to put the elements into variables. One of the elements has the ampersand in it. Thus causing all the elements after it to be unassigned/undefined. <cfset attributes.contact_id = #attributes.projectarray[1]#> <cfset attributes.contact_name =...

I want to save the result of a query to an application variable so I don't have to run the query multiple times. I'm using Fusebox methodology. Where should I put my query to run for the first time? Where do I set the application variable? In application.cfm? Please help.

Thank you very very much, Phil, that trim suggestion works like a charm.

Thank you, Phil, but it didn't work. I think you left off the closing parentheses and the pound sign in your iff statement. Your code returns everything in List 1 but with nothing selected.

I have a list L1 of (A,B,C,D,E,F,G) and a second list L2 of (B,E,G). I want to display a select box of everything in list L1 but with all items in list L2 highlighted. I don't know how to use Listfind function. The double quotes is where I'm confused. Here is my code: <cfset...

Has anyone used cfx_debug that came with the Ben Forta cold Fusion CD? I tried it but I can't turn the debugging information stuff off. And the CF Administrator won't do it in CF Admin because other people are using the same CF box. I need to turn off the debugging displays. Help please...

I'm trying to reduce the response time of my queries. Don't know what this &quot;fetch data in background&quot; option in CF Administrator will do. Would someone please help. I use MS Visual FoxPro as the database and was told that everytime I issue a SQL statement from my CF application...

Hi David, Thank you very much. that was what I was hoping for. Do you know what is the max char I can assign to txtoutput? LH

I want to use CFLOCK to guarantee that the file can be written by one user at a time. OUTFILE is a static name, it is used in a macro therefore the file name can't be changed to be more random. I want to write over an existing file, so the action must be WRITE, but that would overwrite what was...

I want to make sure that the key_value is unique for each user who accesses this application. Do I put a CFLOCK tag around the Select Query and another CFLock tag around the Update SQL statement? But I don't know what the scope should be? Application, server or Session? <CFLOCK...