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 Rhinorhino 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
  • Content: Threads
  • 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 ?

    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...
  3. 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
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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
  10. 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...
  11. 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"...
  12. 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...
  13. Exie

    Backup with UFSDUMP - How to include remote machine ?

    Hi, I've got a backup script on Solaris 9 that looks like so: for fsystem in $FSYSTEMS do echo "\nBacking up $fsystem to $TD - `date`...\n" ufsdump 0uf $TD $fsystem echo "\n$fsystem backed up to $TD - `date`." done ... this seems to work ok, but I now have a new server that I want to...
  14. Exie

    RHEL 5.1 licence - Sockets vs Cores ?

    Hi Folks, I've got a nice new server lined up with 2 x quad core Xeon's in it. I want to put RHEL5.1 on it and sit Oracle on top. My question is, there are 2 flavors of RHEL5.1 Basic and Advanced Platform. I'd normally pick the Basic one, but it said its limited to 2 sockets .... technically...
  15. Exie

    Which oracle ?

    Hey Folks, I've got a new Sun x4150 which we loaded Solaris 10 (64bit) on. It's working great. Now I need to load Oracle 9.2.0.1.0 on it (same as on a Sun Sparc V440) to migrate a DB over. Which version of Oracle should I install ? I suspect Oracle 64bit for SPARC Solaris is right, although...
  16. Exie

    Fixed with string manipulation with sed or awk ?

    Hi, I've got a fixed with data file, and I need to alter 1 field before it gets processed. The last field has ( and ) and _ in it, and we need to take them out. I started with echo "word1word2wo(r)d3_ " | tr -d '()_' This has 2 problems (apart from been somewhat risky if it affects other...
  17. Exie

    Some VPN client connections fail with error 433

    Hi, We've got a Cisco 1841 here which has been working good. However I've noticed that most clients connect fine, including people using VPNC, but theres a handful that just cant connect. I've confirmed the username is right, and all the details are correct, but it just wont go. Looking at...
    • Exie
    • Thread
    • Replies: 0
    • Forum: Cisco
  18. Exie

    VPN Client - Instant dropouts.

    Hi Folks, I have a problem where 90% of people can connect to the office using the Cisco VPN client fine, but I have 3 people in particular that get connected for like 2 seconds and then it drops out. I've disabled their firewalls and everything, tried different versions of the client, but...
    • Exie
    • Thread
    • Replies: 1
    • Forum: Cisco
  19. Exie

    Improving Script Performance

    Hi Folks, I have the following primitive shell script, which works cool, except its freak'n slow. Can anyone suggest some tips to speed it up ? #!/bin/ksh dataFile=$1 sourcePDFFile=$2 pdfOffset=0 while read line; do startTag=`echo $line | grep -c "<DESPATCH>"` if [[ $startTag -eq 1 ]]...
  20. Exie

    Self-Joining Check constraint ?

    Hi Folks, I have a table with orders in it, I'd like to have a constraint so that order lines MUST have a order header record. eg. ID LINE REF 6 0 MYORDER101 6 1 MYORDER101 6 2 MYORDER101 7 1 MYORDER102 7 2 MYORDER102 7 3 MYORDER102 In this... Order...

Part and Inventory Search

Back
Top