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: *

  • Users: Exie
  • Order by date
  1. Exie

    CMD script to search/replace & in file

    Hi Folks, I know this isnt the right forum, I searched, but couldnt find the right spot, so hopefully powershell is close enough. My need is, to have a basic CMD script run a command, that pops out a flat XML file, but within some of the elements is the & symbol. This needs to be changed to...
  2. Exie

    Execute VBA for each row in continuous form ?

    Thanks folks. Not quite sure how to do that though. Perhaps the attached screen shot would help ? My current code refers directly to a control on the form like: [Forms]![ForecastForm]![SKU].Value There is a query, which is bound to the form. I tried to access it, but dont really know where...
  3. Exie

    Execute VBA for each row in continuous form ?

    Sorry MajP, To try and clarify.... I have 1 linked table (ODBC) to Oracle. I have this connected to my form and it lists the records correctly. In the header of my form, I have some combo boxes which control filters on the data. The extra information has to come from a COM object which is...
  4. Exie

    Execute VBA for each row in continuous form ?

    Hi Folks, I have a table, bound to a continuous form. This works fine. However when I load the form, I want to execute code in a module and put the result in a control on that row. Eg. My table/result set might have 5 rows, each row has a part number. For the first row, product 021055 I want...
  5. Exie

    Using RichFaces for web project

    Sorry, to clarify the above question... this is the error I get: org.apache.jasper.JasperException: /list.jsp(40,38) PWC6228: #{...} not allowed in a template text body. I'm not sure what this means....
  6. Exie

    Using RichFaces for web project

    Hi, I have a small app and would like to use Rich Faces to boost up the UI a bit. I found this component here: http://www.jboss.org/file-access/default/members/jbossrichfaces/freezone/docs/devguide/en/html/extendedDataTable.html And used this code here: <f:view> <ui:composition...
    • Exie
    • Thread
    • Replies: 1
    • Forum: Java
  7. Exie

    Pivot Query - Columns to Rows

    Hi, Before anyone jumps up and down about not trying to search for an answer, I HAVE! I found alot of talk about going from multiple rows into a single row with multiple columns, but cant find anything about going the other way. I basically have a wide table with 12 columns (JAN, FEB, MAR...
  8. Exie

    CASE statement in MView wont refresh ?

    Hi Folks, This one is driving me nuts! I create a materialized view like so... CREATE MATERIALIZED VIEW DWH.MERGESALESFIGURES_JS_MV TABLESPACE USERS CACHE LOGGING NOCOMPRESS PARALLEL ( DEGREE 2 INSTANCES 2 ) BUILD IMMEDIATE REFRESH COMPLETE ON DEMAND WITH PRIMARY KEY AS SELECT blah, blah...
  9. Exie

    Outer Join with a Subquery problem

    ho-hum... thanks Dagon I see what your getting at.. my problem is my subquery needs to sumarize WITH a filter from another table... so theres sort of 3 tables involved... table1 = table2 where (sumarized table1 = table3) By making it an outer join ... what I'm aiming for is ... table1 may or...
  10. Exie

    Outer Join with a Subquery problem

    Hi, I've got a long query which needs a difficult table that is structured like so: UB,1,000123,1,"99973245" ... in order to get the correct row, I need to use a subselect and a crap conversion to get the number into a valid date format. The problem is ... some records will not have an entry...
  11. Exie

    Table not found when creating MView

    Yep, the SQL runs fine as user "dwh" or "sys" ... I think I might have found the problem though... the SQL query was extract data across the DB Link from a view I created in the remote DB. I sucked the guts out of the view definition, and put that into the MView query so that it runs against...
  12. Exie

    Table not found when creating MView

    I created a DB link to another server, and developed an SQL which queries a view through the DB Link. This works ok, but when I try to create a materialized view with the query, I always get: ORA-00942: table or view does not exist ORA-06512: at "SYS.DBMS_SNAPSHOT_UTL", line 960 ORA-06512: at...
  13. Exie

    SQL with dates - How do I do this ?

    Hi, I have 2 tables with dates like so: TableA ------- ProductID Date Value TRUCK 16/10/08 $5 TRUCK 10/10/08 $4.5 TRUCK 03/10/08 $4 CAR 15/10/08 $4.25 TableB ------- SaleId Customer ProductID SaleDate 1010 Customer1 TRUCK 11/10/08 1011 Customer2...
  14. Exie

    SimpleDateFormat() help....

    Hi Folks, I'm trying to genrate a date string like so: [Time].[All Times].[FY2009].[Q2].[OCT].[10] ... so I'm trying to use the simple date formatter like so: String formatter = new SimpleDateFormat("'[Time].[All Times].[FY'yyyy'].[Q1].['MMM'].['dd']'").format(new Date()); Here's my problem...
    • Exie
    • Thread
    • Replies: 1
    • Forum: Java
  15. Exie

    Pl/SQL Error: ORA-06550

    Hi, Trying to run some code like this: --/ CREATE OR REPLACE PROCEDURE UTDELETE is DECLARE mystr varchar2(20); BEGIN for c1 IN ( select table_name as tb from sys.all_tables where owner = 'MTMS' order by table_name ) LOOP...
  16. Exie

    MDX filter on column value ?

    Hi I have a cube that looks like so: <Dimension name="Customers"> <Hierarchy hasAll="true"> <Level name="Customer Group" column="CUST_GROUP" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never"> </Level> <Level name="Customer" column="PARENT_ID"...
  17. Exie

    Tablespace &amp; Raid setup

    Mufasa, Sounds great, but what does "well striped" mean ? I've got 4 disks, with an on-board caching raid controller, whats the best setup ? I started with 2 drives, so went a simple mirror to start with, and then added another 2 (different size). If it were possible to add another 2 72GB's...
  18. Exie

    Tablespace &amp; Raid setup

    Hi, I know I shoudlve read all the manuals before I started, but I'm in the thick of it now. :) I've got 2 raid 1 mirros. 2 x 146GB drives for OS, Tablespace & Indexes 2 x 72GB drives for redo logs and temp tablespace. What I'm wondering is, should I move the Indexes over as well to balance...
  19. Exie

    Backup with UFSDUMP - How to include remote machine ?

    Just a quick update, used SCP to rip 7.5GB in about 6:30 which by my crude calculation makes 18925KB/s .. alot faster than the 2170 above. Will need to find some space and will then try ufsdump over the network to a file, see how that goes.
  20. Exie

    Backup with UFSDUMP - How to include remote machine ?

    Thanks folks, Annihilannic's answer sorted it, the pipe was been processed on the originating box. My only issue now is performance... not sure if theres much I can do about this as its running over a 1GB lan. Here's how the performance runs from local disk to the tape: .. here's the dump...

Part and Inventory Search

Back
Top