Oracle and getting Milliseconds from Sysdate… [Systimestamp]

First, you can’t.

Sysdate doesn’t support going to milliseconds.  However, starting with Oracle 9, you can getting milliseconds from another system source : SYSTIMESTAMP.

SELECT to_char(sysdate, 'HH24:MI:SS'), to_char(systimestamp, 'HH24:MI:SS.FF6') FROM dual;

Powered by Qumana

Oracle SELECT with an array using an IN

SELECT with an array with an IN

declare

    – CREATE OR REPLACE TYPE PROD_TYPES.TYPE_NUMBER_ARRAY AS TABLE OF NUMBER
    nt_src     prod_types.type_number_array := PROD_TYPES.TYPE_NUMBER_ARRAY();    – Constructor     
    nt_dest     prod_types.type_number_array := PROD_TYPES.TYPE_NUMBER_ARRAY();    – Constructor     

begin

    – Test data (no order)
    select
        product_version_id
    bulk collect
    into
        nt_src
    from product_version v
    where v.product_version_id between 138120 and 140000;

    – select * from table(sys.dbms_debug_vc2coll(1,2,’a')) order by 1 desc
    
    – Data ordered
    select
        product_version_id
    bulk collect
    into nt_dest
    from
         product_version
    where
        product_version.product_version_id in (select column_value from table(cast(nt_src AS prod_types.type_number_array)))
    order by
        product_version.expiration_date2 desc,
        product_version.base_price desc,
        product_version.expiration_date2 desc;

    for i in nt_dest.first .. nt_dest.last loop
        dbms_output.put_line(to_char(nt_dest(i)));
    end loop;

    exception
        when others then
            dbms_output.put_line(‘sqlerrm : ‘||sqlerrm);
end;

Powered by Qumana

ActiveSync Issues

Well, I ran into some ActiveSync issues last night.

Basically, I was working with MicroTorrent, and wanted to see what my Windows Firewall settings were.  I had the firewall off, but when Windows realized that I "looked" at the settings it decided to turn on the Firewall.  Basically, after turning the Firewall off and several reboots later I finally started syncing again.  What’s weird is that the Firewall has the entries to allow ActiveSync.

ErrorCode : 80070008

http://www.mtekk.com.au/Forums/tabid/56/forumid/17/postid/48412/view/topic/tpage/3/Default.aspx

If you are using a software firewall on your PC, you need to allow ActiveSync to use TCP/IP.
ActiveSync uses the programs WCESCOMM.EXE, WCESMGR.EXE, RAPIMGR.EXE, and CEAPPMGR.EXE.

TCP/IP ports:

•  990 (RAPI)

• 999 (Status)

• 5678 (Legacy Replication)

• 5679 (Legacy Replication)

• 5721 (Desktop Passthrough)

• 26675 (AirSync)

The WM5 ‘Device’ is the DHCP server, thus the device has the IP address of 169.254.2.1 (Default) and the PC obtains the IP address of 169.254.2.2 (Default) [thanks to Brian for the update].

Powered by Qumana

WindowsMobile Links to Review

• http://www.pocketthinker.com/ptppc.html Outliner (WindowsMobile and Desktop)
• http://www.softtrends.com/products/livepvr/livepvrwmsp.htm Personal Voice Recorder…
• http://www.jetwaremobile.com/index.htm The JETware Hands-free Extension provides additional functionality to the built-in Windows Mobile support for the Bluetooth Hands-Free Profile.
• http://www.softwareandson.com/SuperTasks/screenshots.php

Powered by Qumana

WindowsMobile Links of Relevance

• Jason Langridge’s WebLog – MR Mobile! (http://blogs.msdn.com/jasonlan/default.aspx)

Powered by Qumana

Determine IP address of a VM Ware Player sessions running a Linux distribution

Recently, I started playing with VMWare Player (http://www.vmware.com/products/player/).  I do some work in Unix/Linux, but not a lot.  I’ve always been able to do what I needed, however I couldn’t remember what it took to determine what the IP address of machine was.  The documentation said : "http://your.vm.ip.address/".  Damn, how?

Hence this post,

Command line: ifconfig eth0

Powered by Qumana

T-Mobile Accessories

Well, I can say that I am very disappointed that I can’t find anyone that carries a silicon case for US version of the MDA.  If anybody finds one, leave me a post / comment.

Powered by Qumana

T-Mobile MDA Program Installation and CAB Files

It took me a minute to understand how to install CAB files on the MDA.  I found the answer here : http://www.microsoft.com/windowsmobile/articles/findapps.mspx#3.

Powered by Qumana

T-Mobile MDA Saga… Part 3 of aahhhh…

Okay, as a software developer it pains me to have to give in and call tech support. …but I did.  And, well, I can happily say my MDA is working like a charm.

First, if you have just bought an MDA or are thinking about it… install the upgrade ROM [it wipes out all data... you've been warned!].  I haven’t used it, but SpriteBackup claims to be able to move data between ROM upgrades http://www.spritesoftware.com/backup.php.

Summary: I couldn’t sync, and the ROM upgrade fixed all my problems.  URL : http://www.t-mobile.com/wmupgrade/

Detail : ActiveSync 4.1 would just sit and say "Connecting…" and then finally come back and say device not connected, but there were no errors.  Somewhere in the guts of the ActiveSync network code, it was not working.  Why they chose those model as the default rather than simple USB, I don’t know.  Anyway, I quickly got transfer up the support chain to someone that knew the magic buttons to press to force simple USB connectivity to install the ROM.  Exactly, I need to patch, but I couldn’t connect to patch, but I needed to patch to connect.

Hardcode Reset : If your MDA wont budge, try this: Enter Bootloader, – hold the "camera" (bottom right) and briefly press the reset button, don’t release "camera" until you can see colour screen, connect USB cable, see "USB" on the bottom of the screen, and start to re-flash the ROM.

Powered by Qumana

T-Mobile MDA Saga… Part 2 of #*$%!

Well, I’m officially annoyed.  I can’t get ActiveSync 4.2 to work.  And, now I’ve discovered that there is a ROM upgrade.

With hindsight,

1. Set a system restore point in Windows XP.
2. Use the ActiveSync that comes with your phone… 4.1 in my case.  There are way too many news postings about not upgrading because of issues with the latest and greatest..
3. Install the latest ROM for the phone.  This wipes out the phone, so you don’t want to do this later.

Powered by Qumana