Chhaya Dhanani

Ranch Hand
+ Follow
since Apr 11, 2001
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Chhaya Dhanani

Hi Ben, thanx for the prompt reply,
The file is actually to be created dynamically on click of the hyperlink and saved on the client machine. The file is a .ARTask file which is used by Remedy Tool.
The jsp page is actually a part of CLarify CRM 12.5 thin client web architecture.
Can u help me as to how to set the type of file to something which the browser won't understand and hence force a save-file dialog box?
Also, is it possible to have a specified location say "c:\clarify" to appear in the dialog box as default ?

Thanx a lot in advance,
Appreciate your prompt reply ..
17 years ago
Hi all,
This is a functionality whwich i want to achieve in IE6.0 using javascript.
How do i run/execute a .exe placed in c:\App folder of the client machine.
I found some code for Netscape which which uses something like Privilege class, but i need something for IE.
Also, i came across WHscript which is an ActiveX object.
I do not want to use Activex controls..
is there any other work around for this using pure javascript?

Please reply This is an SOS!!
thanx in advance
hi all,
I am developing pages for Clarfy 12.5 CRM web application.
We are using Weblogic app server 8.1.

One of my requirements is, on click of hyperlink, a file is to be created dynamically and downloaded at a particular location on the client's machine.
In case the file is already present, it has to be over written.

is there any way where we can access the client's system and store the file at the required folder?
I feel one cannot access the client machine when the code is being executed on the server..
Is there a way, we can force the download dialog to appear and ask the end-user to choose the location??

Please help me on this. This is an SOS!!

Thanx in advance..
17 years ago
Hi all,
It is understood that the container checks the last modified timestamp for a jsp page and then loads it. Which means, if i modify a jsp today, which was written and tested yesterday, the container will check for the lastmodifiedDate and recompile the jsp to give new output.
This works fine.

Suppose i back date the system date and change the jsp, the new output is not shown..
Does this mean, that the web container only checks for the timestamp and has no other way of knowing that a jsp page has been modified??

is it then not a danger that my new jsp pages will not come into effect, in case i back date my system..???

How does the container handle this?

Any inputs will be highly appreciated.

Thanx in advance,
Chhaya
18 years ago
JSP
Why are the System.out.println()(SOPs) statements not printed on my console when they are included in the init and destroy methods.?
If i write SOPs in my doGet and doPost , they get printed.?
Also , i would like toknow whether a servlet and can have acinstructor written? what would be the impact of this contructor on the servlet life cycle?
Thanx in advance,
Chhaya
18 years ago
Hi all,
I have to generate a gantt chart using jfreechart and cewolf.
Checked out the jfreechart api , but have found no leads as to how do i
write code for doing the same.
Can someone share their examples or code snippets as to how to generate a gantt chart and display it in a jsp using cewolf...
Time running out as always..
Thanx in advance
Chhaya
18 years ago
Hi all,
This is an SOS.
I am writing a trigger on table CUSTOMER whoch has a column ACCOUNTNUMBER.
I want to write a trigger such that if the ACCOUNTNUMBER is already present in he tbale, i want to append 'A' to the accountnumber and then insert it.
for eg: ACCOUNTNUMBER 123 already exists iin the table
when i try to insert again , in trigger shud make it as '123A'
again itf i try to insert it shud increment the alphabet and insert it as '123B'. till 'Z'.
How can i go about doing this..
pls help me sson as i have a deadline to meet. and i am new to oracle...
Thanx in advance
Chhaya
18 years ago
hi all,
i am trying and still unable to figure out how to go about creating a dynamic query..
i have a before insert trigger on table "One"
in that trigger depending upon "categoryId"
i have to update different tables. How do i use DBMS_SQL package in my trigger to do this?
for eg:
depending upon categoryID, my dynamic query would be as follows:
update catgeoryId_master set status='SCHEDULED' where userid=variable;
here both the table name i.e categoryID_master and userid will be dynamic
how do i accomplish this?
This is an SOS.. reply soon
Thanx in advance..
Oh! wat would i do if not for Javaranch??
Chhaya
19 years ago
hi all,
i am having a slight problem manipulating dates
The code requires a inpout odf date in string format (yyyymmdd) eg 20021218
what i need is a function which will calculate one day less from the given day i.e 20021217
if it is 20030101 .. it should give me 20021231
also take care of feb and leap year..
i need this asap ..
deadlines to meet consider this as an SOS
Thanx in advance
Chhaya
19 years ago
hi all,
i want to write a trigger ona table. but dont know how to write it
reqts as follow:
table name: customer
column name: accountnumber which has to be unique, not null
i want a trigger such that on insert or update on the table, a value is appended to the accountnumber table which is a running serial number.
for example i enter accountnumber as "Toni" then the trigger should insert it as "Toni(1)".
it should read the last value and increment it by one.
for example in case i want to add another accountnumber "jack", it shud insert it as "jack(2)" as "toni(1)" is existing.
in short, increment the number in parenthesis and appended it to the accountnumber value.
Pls help me in this
Consider this as an SOS.. deadlines u know abt them ..rite..
Thanx in advance
Chhaya
19 years ago
HI ALL,
I HAVE A SLIGHT PROBLEM IN MY APLICATION.
I WANT TO STORE THE USERIDS CURRENTLY IN SESSION. IF THEY TRY TO LOG IN AGGAIN, THEY SHUD BE DISPLAYED A MESAGE SAYING"THEY ARE ALREADY LOGGED IN". HOW DO I GO ABOUT DOING THIS?
ALSO, IF THEY LOG OUT, I AM INVALIDATING THEIR SESSION AND REMOVING THEIR USERID FROM THE LIST, BUT HOW WILL KNOW WHEN THE USER INSTEAD OF LOGGING OUT JUST CLOSES THE BROWSER WINDOW?
WILL HIS SESSION STILL BE RUNNING?
HOW CAN I INVALIDATE HIS SESSION WHEN HIS CLOSES HIS BROWSER WINDOW?
PLS REPLY ASAP... DEAD LINE IS THERE..
THANX IN ADVANCE
CHHAYA
19 years ago
hi all,
i have written a procedure which will read from a table and insert into another two tables.
when i run it it keeps throwing the following error:
Warning: Procedure created with compilation errors.
the procedure is as follows:
create or replace procedure cbaoffline_activation
as
Cursor cbacur is select accountnumber,userid,billerid,categoryid,billername
from customer_biller_account
where substr(userid,1,3) in (select micrcitycode from city_info)
and activation_status='PEND';
cbarec customer_biller_account%ROWTYPE;
Begin
Begin transaction;
Open cbacur;
Loop
Fetch cbacur into cbarec;
Insert into activation_log values('||cbarec.userid||','admin','ACTIVE','||cbarec.accountnumber||',sysdate,'||cbarec.billerid|
|','||cbarec.categoryid||','||cbarec.billername||','||substr(cbarec.userid,1,3)||');
Exit when cbacur%notfound;
END LOOP
Close cbacur;
Update customer_biller_account set activation_status='ACTIVE' where activation_status='PEND'
and substr(userid,1,3) in (select micrcitycode from city_info) and activation_status='PEND';
Commit transaction;
end;
Pls help me with this as soon as possible...SOS
Thanx in advance
Chhaya
19 years ago
Thanx both of you..
Chhaya
19 years ago
hi al,
i need to write a trigger whicj will remove prepnding zeros froma values before insert or update
i need this on urgent basis
eg. 000123 should be entered as 123 in the amount colmun of payments table on insert as well as update
Can anyone help me with the trigger.
THIS IS AN SOS!!
thanx in advance
Chhaya
19 years ago