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

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.

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

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

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

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

If the f_182 is &quot;T&quot;, then I want the checkbox to be checked, else uncheck it when this page is displayed the first time. But the user can change value from T to F or from F to T . But this final value is not captured in my form. Does anybody know why? I know that the parameter does...

I would like to use the loop index as part of the input nameI'm using fusebox methodology, so I'm passing the parameters to another form that will process these values. But I can't get the value out of the passed parameters. Here is part of my code: <CFFORM...

Hi, I would like to use CFCASE statement for multiple values,but don't know how. For example, <CFCASE VALUE=&quot;Cat&quot; OR VALUE=&quot;DOG&quot; OR VALUE = &quot;BIRD&quot; > I hate to have the same CFCASE block for each of the values. Please advise. Thanks. Longhorn

I have an application in CF4.5 and now they want to upgrade it to CF 5. Does anyone know of any side effects if the conversion takes place? Thanks, Longhorn

Hi, How do I minimize the spaces between table rows? The table is not compact if I use Netscape, the spaces between the rows are huge. IE displays the table just great. Longhorn

I'm using MSFoxPro Visual Studio 6 as the database. Would someone explain the difference between SESSIONTIMEOUT anc CFLOCK TIMEOUT for me, please. Below is the code in my Application.cfm. When I log out of my CF App, I guess I still have some kind of locks on the database, because when I...