joeice james

Greenhorn
+ Follow
since Jul 24, 2007
Merit badge: grant badges
For More
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 joeice james

Hi Eric,

Thanks for your reply. I tried to do it in java script using ActiveX object. But in some servers it throws 'Automation server cant create object' error.

Then I tried embedding the excel/pdf in the same page using object tag. But it will not be working in all browsers. So I am looking for some other option.

Can we do the embed excel without object/embed tag?

Regards,
Joeice
Hi,

I need to implement the below requirement. Kinldy help me whether it is feasible with java script or not.

I have a link in a web page. When I click that link it opens an excel sheet. The requirement is, I have to close the excel sheet if the user closes the web page.

Thanks in Advance,
Joeice
Hi,

I want to write a Stored Function which will return a list of value. For that i am using the FOR EACH query.. The following query is not running for me..

CREATE FUNCTION get_temp_users() RETURNING INTEGER;

DEFINE v_id INTEGER;

FOREACH temp_cursor FOR

select temp_id
into v_id
from a_user
where status = 'C';

RETURN v_id WITH RESUME;

END FOREACH

END FUNCTION;

This is not working for me. It is throwing some 'syntax error'. If i remove the FOREACH tag, the statement was executed..

Please help me..

Regards,
Joeice
Hi,

In my application i am using Informix database. In one of my table i have an indicator and a set of values for that indicator.

Eg: 4 SET{A,B}

i have a varibale X with set of values(e.g. A,B) and a single value (eg. A) in a different variable Y . I want to check whether Y is present in the set X.

I dont know how to do that..

Please help me..