Search results for query: *

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

I use MS Visual Fox Pro 6. Let me modify my query a little bit. The affil_id is confusing, but believe me, there is a stored procedure used to insert the next id whenever you do an insert. I used the loop to demonstrate the insertion of more than one records, this is not the real query I use...

Hello, I have a stored procedure that will insert the next id into the table when doing insert. I want to insert 3 records into the same table and put this insert statement inside the CFTRANSACTION tag, will the database know to grab the next id 3 times, or will it insert the same next id...

Thank you, duns. That works great.

This is the error I received when trying to list the contents of the directory. 550 /*.*: The filename, directory name, or volume label syntax is incorrect. What does this error mean? Here is my code (the same as the one in the CF Help References) <--- open FTP connection ---> <CFFTP...

I have an application that uses the login form to authenticate user. On the form I also have a guest button, if a user is logged on as guest, I don't want the app to read the cookie data already on the computer. Because someone else may come to my computer, log on as guest, and the app will...