Tuesday, 13 September 2011

String feed Literals

String Literals:
      \n - new line
      \b - backspace
      \0 - null space
      \r - carriage return
      \a - alarm

[Note:]
     These can be used in the string for indented alignment and arrangement of the text
in the string.

One or more Activex Controls is not running....


Issue: 
One or more activex controls could not be displayed because either:
1. your current security settings prohibit running activex
controls on this page, or
2. you have blocked a publisher of one of the controls.
as a result, the page may not display correctly.

Soln: 
    i. Go-->Run-->regedit.exe
    ii. Go-->HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Internet Settings\Zones\
    iii. Find the key 'L' and take a backup.
    iv. Delete the extra the key and its subkeys with no mercy.
    v. Press 'F10' to refresh the registry.
    vi. Go-->Run-->services.msc
    vii. Cheers!! It works.

Saturday, 27 August 2011

BSNL-Broadband Speed Test


To Find the download/upload speed of your DSL Connection, you could check from ISP (BSNL).


The Link for the speed test centre is,
 http://www.broadbandindia.com/speedtest/

Friday, 26 August 2011

Activation Failure

Issue:
       Activation context generation failed for "C:\Windows\WinSxS\x86_microsoft.vc80.mfc_..." found in the Event Viewer.

Soln:
       I fixed the error and get no more of the exact same eventvwr error with this download and install:
http://www.microsoft.com/downloads/details.aspx?FamilyID=200B2FD9-AE1A-4A14-984D-389C36F85647&displaylang=en
then update to 2008 SP1.

[Note] 
Instructions

  1. Important: Make sure you have the latest service pack and critical updates for the version of Windows that you are running. To find recent security updates, visit Windows Update.
  2. Click the Download button on this page to start the download
  3. Do one of the following:
    • To start the installation immediately, click Run.
    • To save the download to your computer for installation at a later time, click Save.
    • To cancel the installation, click Cancel.

IMPORTANT: If you have installed previous pre-release versions of Visual C++ 2005 or Visual Studio 2005, such as Beta 1, Beta 2 or Community Technical Preview (CTP) builds, then you must uninstall these versions via Add/Remove Programs in Control Panel before installing the final released version.

Wednesday, 10 August 2011

Tricky whitespace handling in XSLT



Whitespace in a text string
             <description> This    is a test. </description>

normalize-space()
            normalize-space(description)
 translate() and replace()
            translate(description, '&#x20;&#x9;&#xD;&#xA;', ' ')
Whitespace-only text nodes
           <test>
                             <item/>
                        <item/>
             <item/>
</test>
Why strip whitespace-only text nodes
           <xsl:strip-space  elements="*"/>
xsl:strip-space and position()
           Input XML

<test>
  <item/>
  <item/>
  <item/>
</test>
XSLT stylesheet

<xsl:stylesheet  xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
  <xsl:template  match="/">
    <test>
      <xsl:apply-templates/>
    </test>
  </xsl:template>
  <xsl:template  match="item">
    <no>
      <xsl:value-of  select="position()"/>
    </no>
  </xsl:template>
</xsl:stylesheet>
           
            Output XML

<test>
  <no>2</no>
  <no>4</no>
  <no>6</no>
</test>
xsl:strip-space and xsl:preserve-space
            <xsl:preserve-space elements="…"/>

Whitespace-only in mixed content
            <para>I <strong>love</strong> <name>Mozart</name></para>
<xsl:preserve-space  elements="resume headline para"/>
Whitespace in the XSLT stylesheet
            <xsl:value-of  select="firstname"/>
<xsl:text> </xsl:text>
<xsl:value-of  select="lastname"/>


<xsl:value-of  select="firstname"/>
<xsl:text> </xsl:text>
<xsl:value-of  select="lastname"/><xsl:for-each  select="item">
  <xsl:value-of  select="."/>,
</xsl:for-each>

<xsl:for-each  select="item">
<xsl:value-of  select="."/>, <xsl:text/>
</xsl:for-each>


<xsl:for-each  select="item">
  <xsl:value-of  select="."/>, <br/>
</xsl:for-each>

<xsl:for-each  select="item">  <xsl:value-of  select="."/>, <br/>&#160;</xsl:for-each>

Monday, 8 August 2011

SQL Commands for Retrieving Row Number


Issue:
     To Retrieve the Row Number for a particular record in the database.

Soln:
     Create table temp (name varchar(30));

     insert into temp values('ashok');
     insert into temp values('king');
     insert into temp values('tekken');
     insert into temp values('manik');
     insert into temp values('DayLight');

     ALTER TABLE temp
     ADD rownumber number null;

     UPDATE temp SET rownumber= ROWNUM;

     SELECT rownumber, NAME FROM temp WHERE NAME LIKE 'tekken';

     ALTER TABLE temp DROP COLUMN rownumber;

Saturday, 6 August 2011

Internal Server Error

Issue:
    500 Internal Server Error when starting an Oracle Web Service.
     "Node ID does not exist for the current application server id"
Solution:
     If You have executed the 'autoconfig.cmd', check whether it is completely executed.
     Execution stops by failure, it is recommended to restart the system.
     Then, try running the 'autoconfig.cmd' for successful execution.
     Command Script Name: adautocfg.cmd
            For DB: E:\oracle\VIS\db\tech_st\10.2.0\appsutil\scripts\VIS_vmoraclesrv03
            For Apps: E:\oracle\VIS\inst\apps\VIS_vmoraclesrv03\admin\scripts\

  
    After the autoconfig.cmd executed properly, restart the machine. Then connect the Oracle Apps.
    It actually works.