Thanks Rob
This gives me an idea. My problem was really how to pass the parameter from commandline and make excel understand that this value was a parameter and how to evaluate it.
I can update the value of the ein from the wrapper java code into a table, and as you suggested, pick up the...
HI,
I am really VB challenged. I am hoping some of you can help me.
I am writing a Macro from Excel which simply executes a query with one parameter dynamic:
With ActiveSheet.QueryTables.Add(Connection:= _
"ODBC;DRIVER={Microsoft ODBC for...
Hi,
I need to get a list of variables using the imput # function from a file having fields separated by "~". Does anyone know how to do this?
Input #1, Sac, Sac_Desc, District, Site, Time_Period, Call_Type, Call_Group, No_Of_Calls, Revenue, Duration, Dummy
The above are the list of variables...
Thanks CadGuyExtraOrdinaire,
yes that was the answer I was looking for.
One more question
since patterns are grouped together in () ,to me it looks like $4 should be the the pattern grouped as (?:eq|in).
But this is not so.From the output it is obvious that the group
(?(-?\d+:?\d*)\) is $4...
Thanks Duncan.
I know about the $1 $2 $3 $4 concept.
I was looking for an explanation of the regexp.
How is :? interpreted?
Is there any special significance of &, #, % and £?
There is a :?, a ?: and -? towards the end.
What do they signify?
-Anukta
Hi
I have a rather complicated pattern matching code which I am not able to figure out.
open (LU, "> lookup.txt");
open (NONLU, "> lookup.rej");
open (WISLU, "wisdom.qsl");
while (<WISLU>)
{
if (/n01/)
{
if...
Hi all,
Is there a way to create charts (say, line charts) in Excel 2000 based on Pivot tables, but which won't be pivot Charts?
I want simple charts (Like it used to be in excel 97) taking its data source from a Pivot Table.
-Anukta [ponytails]
I just realized that this occurs only when the data soiurce I am using is a Pivot table. When the data source is a normal excel range it does not have a problem.
This happens only in 2000. Any ideas?
-Anukta [sadeyes]
Hi all,
I have a bit of code for drawing a chart using a macro. This is a part of an Application we have.
The code is
x=0
y=0
width=750
height=300
Set co = Sheets(Chapter).ChartObjects.Add(x, y, width, height)
co.Chart.ChartWizard Source:=Worksheets(Chapter_2_1).Range("A32:I92")...
Thanks everyone.
It worked when I set one of the servlets in the ACTION attribute, and the other servlet in the ONSUBMIT attribute.And also setting the TARGET attribute.
You are right when you said that it did not work when the form did not have any action associated with it. It needed at least...
I had no action associated with the form because initially I wanted two servlets to run when I submitted the form.
something like this:
function submitpage()
{
var vsac=document.frm_GetSite.sac_code.value;
var servletpath1="/BusinessReview/servlet/br_srv_DisplaySite?sac_code="+vsac...
I had no action associated with the form because initially I wanted two servlets to run when I submitted the form.
something like this:
function submitpage()
{
var vsac=document.frm_GetSite.sac_code.value;
var servletpath1="/BusinessReview/servlet/br_srv_DisplaySite?sac_code="+vsac...
Hi,
I have a page, which consists of a top frame, and two side-by-side frames at the bottom:
<HTML>
<HEAD>
</HEAD>
<FRAMESET ROWS="30%,70%" BORDER=0>
<FRAME SRC="/BusinessReview/html/br_top.html" NAME="DisplaySite_frm" noresize scrolling="no">...
I am on Actuate version 6.0 SP1. Whenever I try to compile a report i get an error "Compiler failed to execute".
Any ideas what causes this?
-Anukta c.
Hi,
I have two tables SITE_MASTER and MODIFIED_SITES.
The structures are as follows:
SITE_MASTER
---------------------
site_no varchar2(8) primary key,
adress varchar2(50)
same for MODIFIED_SITES.
My query should be like this:
select site_no,address from SITE_MASTER if there is no matching...
Hi,
I have a really huge table (CALLS_DATA) which has 584 million records. The table has a non-unique b-tree index on (district,site).
This is what the table looks like:
district, site,call_ designation,calling_number,called_number, call_charge, call_duration
I have to find the top 30 called...
I modified the procedure, and this one now works in 2.5 min [2thumbsup]
CREATE OR REPLACE procedure intersite_b_2_a_update_1
as
cursor c1 is select
i2.no_of_calls,
i1.rowid myrowid
from intersite i1, intersite i2
where i1.calling_site=i2.called_site
and i1.called_site=i2.calling_site...
Using rowid to update the table, instead of the where clause, improved the time considerably. Now the time is 12 min.
Thanks all you guys for your help.
-Anukta
Hi Sem, u were right....bulk collects are not helping, because of loading the whole 1 million rows into memory .
I have 4 rollback segs (other than sys), which are all of the same size.It won't help, will it?
I am now trying updating by rowid.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.