help.net

<font size="2"><br />Musing on .Net</font>

  • Pivot nightmare


    I am quite busy actually on this b*** school census. It's a questionnaire that schools filled and sent back to us about a lot of things on ICT and their usage.

    On the paper it's not so bad, divided in 6 parts from A to G,and about 60 questions per section, sometime more.

    After some database coding, I have now the really painful task to export this database to be analyze by SPSS.

    Well I don't know anything about this tool, not being myself a statistician, but apparently the version we have (10 I think) don't allow too much table manipulation.

    Unfortunatly I absolutluy need to pivot my data, and it's truely slow boring and... painful !

    The first idea is that our guy in charge of the stats ask first to have a huge unique table with evrything in it.
    No way to do that,as I said to him, SQL or Access have some limitations on the numbers of fields.

    Strangely, SPSS seems to be able to accept a very large number of columns(I don't remember exactly how much).

    So actually I am going to create 6 tables multiply by 3 types of schools. Well,a bit more than that because I ran out of memory very quickly when I create the Pivot table in Access, and export this to Excel.

    So I divided again in small data chunks, something like 4 to 6 parts each section, and I am going to merge that in Excel.

    I said before that I ran out of memory and I have actually 768 Mb on my machine ! It's amazing now how much you need to manipuilate some big database.

    It's a bit annoying that Access provide only an export to Excel from a pivot table.
    I know I can write a Transform in the Querydef, but I would like to see Access give me automatically the SQL statement when I switch from Pivot view to Sql view.
    Actually Access give me back my initial select statement :-(

    OK now time to go back to finish this before I transform myself as a mad pivoting chair !

  • .Net Framework 1.1

    Assemblies originating from the Internet zone—for example, Microsoft Windows® Forms controls embedded in an Internet-based Web page or Windows Forms assemblies hosted on an Internet Web server and loaded either through the Web browser or programmatically using the System.Reflection.Assembly.LoadFrom() method—now receive sufficient permission to execute in a semi-trusted manner. Default security policy has been changed so that assemblies assigned by the common language runtime (CLR) to the Internet zone code group now receive the constrained permissions associated with the Internet permission set. In the .NET Framework 1.0 Service Pack 1 and Service Pack 2, such applications received the permissions associated with the Nothing permission set and could not execute.

    Somebody know some examples on how to embed Windows Forms controls in a Web page ?
    I'm wonder if this works like a Java applet.

    Update:
    I received some nice comments on this subject. I didn't know that it was there on the 1.0.

  • PS2


    New version of the PS2 in Japan.
    This is the official new ad targeted for the teenagers ;-)

    La nouvelle version de la PS2 cible les ados japonais (DR) - 15.4 ko

    This version can read now DVD-RW,so you can read now your own movies.

  • Dell XPS

    The Dimension XPS is built around Intel's new 875P chipset. Our version came equipped with the fastest Pentium 4 currently available, 1GB of dual-channel, 400-MHz DDR memory, and SATA support courtesy of a Promise FastTrack S150 TX2 controller. Dell also gave us an early treat by enabling a RAID 0 setup using a pair of 120GB Seagate Barracuda SATA V drives. Dell says it'll begin offering SATA RAID options with the Dimension XPS within a month or so of launch.

    Specs: Pentium 4 3-GHz (800-MHz FSB); 1GB 400-MHz DDR; 2X 120GB SATA 7,200-rpm (RAID 0); Sound Blaster Audigy 2; 128MB Radeon 9800 Pro; DVD+RW; CD recorder.

    Source: Techtv

    Dell XPS Gaming PC

  • Cardboard PC

    lupopcbox.jpgFrom Japanese company Lupo, the PCBox, a computer case made of cardboard that you can fold and put together yourself. Just be careful to make sure it doesn't overheat
    and catch fire.


    Read on Gizmodo

  • Electronic Paper


    "In a step toward electronic newspapers and wearable computer screens, scientists have created an ultra-thin screen that can be bent, twisted and even rolled up and still display crisp text. The material, only as thick as three human hairs, displays black text on a whitish-gray background with a resolution similar to that of a typical laptop computer screen. The screen is so flexible it can be rolled into a cylinder about a half-inch (1 centimeter) wide without losing its image quality."

    Source:
    PocketPCThoughts

    20030507 EInk DigitalPaper

  • VPC

    How about the butterflies you get in your stomach as you watch the OS installation format our virtual hard disk.

    It's so freaky, yet it's so beautiful.

    Works great. I've now got to install VS 2003 on this VPC.

    Read on ScotG

  • Access

    Amazingly  enough, all versions of Access prior to Access 2003 have no "Import XML" option!. Really. None. Nada. Zip. Zilch. It seems someone at MSFT just overlooked it , since it is such a legitimate feature. Access 2003 ,on the other hand, handles this import easily, with no problems. It was a breeze to do and saved me the hours of coding a custom transformation and import tool (Not to mention more hours to come when the requirements or XML schema would change and so on..)

    Roy Osehrove

    Well Roy I think this is totally normal for a product which has is last real new version from 2000. XML at this time was not critical in business.

  • .Net Framework 1.1

    Assemblies originating from the Internet zone—for example, Microsoft Windows® Forms controls embedded in an Internet-based Web page or Windows Forms assemblies hosted on an Internet Web server and loaded either through the Web browser or programmatically using the System.Reflection.Assembly.LoadFrom() method—now receive sufficient permission to execute in a semi-trusted manner. Default security policy has been changed so that assemblies assigned by the common language runtime (CLR) to the Internet zone code group now receive the constrained permissions associated with the Internet permission set. In the .NET Framework 1.0 Service Pack 1 and Service Pack 2, such applications received the permissions associated with the Nothing permission set and could not execute.

    Somebody know some examples on how to embed Windows Forms controls in a Web page ?
    I'm wonder if this works like a Java applet.