[Re:] RE: ] RE: cached query

2002-03-14 Thread FARRAH NG
date.cfm) > >> > datasource="testingDB"> >>select * from Welcome >> > >The select expires the cache and then when the next person hits the home >page it will be recached for two days > >John. > >> -Original Messa

[Re:] RE: cached query

2002-03-13 Thread FARRAH NG
want. > >John. > >> -Original Message- >> From: FARRAH NG [mailto:[EMAIL PROTECTED]] >> Sent: 13 March 2002 21:34 >> To: CF-Talk >> Subject: cached query >> >> >> hi all, >> i have built a website for a client where the home page is

cached query

2002-03-13 Thread FARRAH NG
hi all, i have built a website for a client where the home page is totally dynamics ( the cfm file has almost 10 queries accessing 10 different tables in order to populate the page). Now the client is complaining about the slow load time. they told me they don't need to have the home page access

detecting broswer encryption

2002-02-28 Thread FARRAH NG
Need help with an issue. I need to be able to detect the users encryption level set in there browser. If the users browser does not support 128 bit encryption, I'm gonna bump them to a page telling them to upgrade their browser. I know there is a cgi environment variable (https_keysize), but

client side disable cookies

2002-02-01 Thread FARRAH NG
Hi all, i believe most of the CF login sites need to have client side browser cookie-enable in order the user can manaeuver freely after login. how can can take care of the situation where the client has disable the cookie in their browser ? does anyone has the experience of building a login s

oracle brings the server down

2001-10-05 Thread FARRAH NG
I am having a serious problem with oracle. It looks like everytime the CF query make a connection to the tables in the oracle database the connection is not closed. The numbers of connection keep growing till the server is brought down. Does anyone have any idea how to fix this problem ? plea

cfhttp connection failure

2001-09-19 Thread FARRAH NG
hi everybody, i am developing a email outbound system in which the "send out email page" uses CFHTTP to grap a dynamic page ( data from oracle database ) from the same website ( the CF server and the CF source codes are on the same server, but the oracle database is on a different server ). Ev

[Re:] Twoselectrelated preselect

2001-09-10 Thread FARRAH NG
hi again, does anyone have any idea ? On 9/5/01 2:32:53 PM [EMAIL PROTECTED] wrote: >hi everybody, >I need help to modify CF_TwoSelectRelated. > >does anyone has ever modify CF_TwoSelectsRelated so it can take >preselected values, like the assigning values to default1/default2 >parameters in

Twoselectrelated preselect

2001-09-05 Thread FARRAH NG
hi everybody, I need help to modify CF_TwoSelectRelated. does anyone has ever modify CF_TwoSelectsRelated so it can take preselected values, like the assigning values to default1/default2 parameters in CF_ThreeSelectsRelated. If anyone has this experience please give me a hand. thanks

sorting verity search results

2001-07-31 Thread FARRAH NG
hi all, i am working on the CF verity search engine. In my CFSearch i have 9 collections and the search results returned is in a kind of random order. Is there a way to display the search result in a sorted order? thanks everybody. --

how to kill session

2001-06-11 Thread FARRAH NG
hi all, i am developing the admin section for my client site and is having a problem with killing the login sessin. Users has to login to the admin section. My problem after the user has login in, but if they close the broswer without logging out first, and then reopen the browser, it will bring

[Re:] RE: defining french table in oracle

2001-05-18 Thread FARRAH NG
u do the same query and add the NLS specifier >SELECT TO_CHAR(sale_date,'Day DD Month >HH24:MI:SS','NLS_DATE_LANGUAGE=FRENCH') as nice_sale_date >FROM sales >WHERE sales_id=3939 > >you get it in français > >Nice_sale_date >------ >

defining french table in oracle

2001-05-17 Thread FARRAH NG
Hi everybody, Does anyone has the experience of creating a oracle database to store french characters ? Please give me advise of how to do this, if anyone has this experience before. thanks -- Global Internet phone cal

[Re:] RE: ] RE: oracle LOB query problem

2001-05-14 Thread FARRAH NG
dave, thank you. I have enable the long text retrieval setting but i am still getting the SQL error " Data Access Error Unknown Data Access Error. " from the CF server when it runs the CF query in my action page. My query is very simple, as follow" select Cust_Info from company where Cust_id =

[Re:] RE: oracle LOB query problem

2001-05-14 Thread FARRAH NG
You may want to read KB article 16259, "Best Practice: Enabling Retrieval of >Long Text Fields with CF 4.5", >http://www.allaire.com/Handlers/index.cfm?ID=16259&Method=Full >-David > >On Friday, May 11, 2001 9:31 AM, FARRAH NG [SMTP:[EMAIL PROTECTED]] wrote: >>

oracle LOB query problem

2001-05-11 Thread FARRAH NG
I have defined a column as CLOB in an oracle 8i table and when CF return "Unknown Data Access Error" when i do an query on this table. If i remove the CLOB column from the table the query works fine. Anyone has suggestions to resolve this problem. thanks

limiting text entry to textarea

2001-05-03 Thread FARRAH NG
I need to limit the maximum number of character entered to a textarea box to 100, and i am not too sure how to do it. Is there anyone have any idea ? or had done something similar to this before ? I will appreciate all suggestions. thanks

[Re:] Re: pass form.variable by URL

2001-05-02 Thread FARRAH NG
2001 06:22:20 -0400 Jon Hall wrote: >Since the variable part of the url in the popup, the variable is now in the >url scope and is called msg. Try referencing the variable without a scope >with #msg# or with the correct scope #url.msg#. Both should work. > >jon >- Origina

[Re:] Re: pass form.variable by URL

2001-05-02 Thread FARRAH NG
he popup, the variable is now in the >url scope and is called msg. Try referencing the variable without a scope >with #msg# or with the correct scope #url.msg#. Both should work. > >jon >- Original Message - >From: "FARRAH NG" <[EMAIL PROTECTED]> >T

pass form.variable by URL

2001-05-01 Thread FARRAH NG
I am trying to pass a form.variable to another cfm page but with no success. I have a form variable call INFO and my code of trying to pass the variable through window.open using URL is like : and CF server returns an error since it does not recognize #form.info# within the window.open. I tr

send html page using CFMAIL

2001-04-27 Thread FARRAH NG
I am working on a web page in which there is a "send this page to your friend" feature. If there is anyone who had worked on this before please give me some idea how it can be done with CFMAIL. My coding in the action page is like : * but i am wondering where i should p

autonumbering in oracle

2001-04-24 Thread FARRAH NG
I tried to use the download custom CF_max_id to do the autonumbering for inserting a new row into a oracle database table but the custom tag failed. I am wondering if anyone knows oracle have idea how to do it. I have the first column in the table named "ContentId" defined with datatype "number"

CF_threeSelectsRelated

2001-01-22 Thread FARRAH NG
I have a problem using the custom tag CF_ThreeSelectsRelated. I try to set a value to default1 and default2 and the result is the third box is not populated according to the value of default2. The third box just being populated with the first row value of box 2, instead of using the default2 val

[Re:] RE: CF vs. Lotus Domino App Server

2001-01-05 Thread FARRAH NG
hi all, lotus notes and domino is a pure IBM in house product which is out of sync with today's web technology. I even don't understand why they use flat file system in notes in the very beginning. The way it works is totally like old IBM technology, wrapped within a so called 'web sever'. The

java sript error on CF_ThreeSelectsRelated

2000-12-28 Thread FARRAH NG
hi everybody, My problem with CF_ThreeSelectsRelated again. I have the javascript error : if statement too large when my CF_ThreeSelectsRelated box is populated. When i selected the second item in the first list box, i have another javascript error "OneA is not defined". Anyone has any experie

CF_ThreeSelectsRelated

2000-12-11 Thread FARRAH NG
Hi Nate Weiss, I have download the CF_ThreeSelectsRelated you have created. I ran a SQL server query to retrieve the Section ID, Department ID and the name of the Manager belongs to that department and section. The problem some of the names in our SQL server has quote or double quotes, like 0'Con

CF_ThreeSelectsRelated

2000-12-11 Thread FARRAH NG
Hi everybody, I am using the custom tag CF_ThreeSelectsRelated and have a problem with it. I ran a query which selected the division, department name and manager name and put these 3 fields to CF_ThreeSelectsRelated custom tag. My problem is the manager name column returns name with double quo