Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
CF & ORACLE Package procedue
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... -
update a column of type char9
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- LongHorn
- Thread
- Replies: 1
- Forum: Oracle: All versions
-
Invalid file descriptor error
Hello, What caused the error "Invalid file descriptor"? Thanks, Longhorn- LongHorn
- Thread
- Replies: 2
- Forum: Microsoft: FoxPro
-
apache & CF server
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... -
listtoarray and ampersand
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. -
listtoarray and ampersand
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 =... -
saving a query to an application variable
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. -
listfind & option selected
Thank you very very much, Phil, that trim suggestion works like a charm. -
listfind & option selected
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. -
listfind & option 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... -
cfx_debug
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... -
fetch data in background in CF Administrator
I'm trying to reduce the response time of my queries. Don't know what this "fetch data in background" 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... -
write multiple lines to a file with single cffile statement?
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 -
write multiple lines to a file with single cffile statement?
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... -
CFLOCK & unique ID update
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... -
cftransaction & stored procedure
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... -
cftransaction & stored procedure
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... -
-
CFFTP error- what it means?
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... -
unset cookie
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...
