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!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. anuktac

    passing parameter to a query

    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...
  2. anuktac

    passing parameter to a query

    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...
  3. anuktac

    How to specify a delimiter in a input # function

    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...
  4. anuktac

    help with regexp

    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...
  5. anuktac

    help with regexp

    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
  6. anuktac

    help with regexp

    Hi I have a rather complicated pattern matching code which I am not able to figure out. open (LU, &quot;> lookup.txt&quot;); open (NONLU, &quot;> lookup.rej&quot;); open (WISLU, &quot;wisdom.qsl&quot;); while (<WISLU>) { if (/n01/) { if...
  7. anuktac

    excel 2000 charts on pivot tables

    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]
  8. anuktac

    Problem with chart object in Excel 2000

    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]
  9. anuktac

    Problem with chart object in Excel 2000

    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(&quot;A32:I92&quot;)...
  10. anuktac

    Submitting a form to a different frame

    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...
  11. anuktac

    Submitting a form to a different frame

    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=&quot;/BusinessReview/servlet/br_srv_DisplaySite?sac_code=&quot;+vsac...
  12. anuktac

    Submitting a form to a different frame

    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=&quot;/BusinessReview/servlet/br_srv_DisplaySite?sac_code=&quot;+vsac...
  13. anuktac

    Submitting a form to a different frame

    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=&quot;30%,70%&quot; BORDER=0> <FRAME SRC=&quot;/BusinessReview/html/br_top.html&quot; NAME=&quot;DisplaySite_frm&quot; noresize scrolling=&quot;no&quot;>...
  14. anuktac

    Compiler failed to execute error

    I am on Actuate version 6.0 SP1. Whenever I try to compile a report i get an error &quot;Compiler failed to execute&quot;. Any ideas what causes this? -Anukta c.
  15. anuktac

    Complicated SQL Query

    Thanks it was very simple, wasn't it? I had just worked it out too....
  16. anuktac

    Complicated SQL Query

    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...
  17. anuktac

    Getting the first 30 rows for each combination

    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...
  18. anuktac

    PL/SQL large select &amp; update

    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...
  19. anuktac

    PL/SQL large select &amp; update

    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
  20. anuktac

    PL/SQL large select &amp; update

    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.

Part and Inventory Search

Back
Top