the geek sista

CR Keeping together the group and the detail

2011-12-19T01:12:00.000-08:00

In Crystal Report, in order to keep together the group and the detail, pls follow the following setting:

Not Working

Report -> Section Expert -> Select Group -> Enable Keep together

Working

Report Group Section -> Change Group-> Options -> Keep Group Together

If you want the Group name to be displayed on the new page, you may tick on the 'Repeat Group Header on Each Page'

Ref: here

javascript startsWith() and endsWith()

2011-12-05T01:46:00.001-08:00

Javascript function startsWith
String.prototype.startsWith = function(str)
{return (this.match("^"+str)==str)}

Javascript function endsWith
String.prototype.endsWith = function(str)
{return (this.match(str+"$")==str)}

Usage:
var myStr = “ Earth is a beautiful planet ”;
var myStr2 = myStr.trim();
//==“Earth is a beautiful planet”;

if (myStr2.startsWith(“Earth”)) // returns TRUE

if (myStr2.endsWith(“planet”)) // returns TRUE

if (myStr.startsWith(“Earth”))
// returns FALSE due to the leading spaces…

if (myStr.endsWith(“planet”))
// returns FALSE due to trailing spaces…

Ref: here

SQL Precision (Float vs Decimal) and Computation

2010-11-26T00:17:00.000-08:00

If we have a computation of (a/b*c), in decimal SQL datatype it will not give the same result as (a*c/b)
Correct value can be obtained using this sequence: multiply first then divide ( (a*c/b).
Trying the computation in calculator, the actual value will be value of (a*c/b)

Here's the sample:


DECLARE @a as DECIMAL(38,10), @b as DECIMAL(38,10), @dec as decimal(38,10)
declare @flt as float
SET @a = 5094450
SET @b = 5225985.8002
SET @dec=  2504000
SET @flt=  2504000
SELECT @dec*@b/@a -- 2568651.855195
SELECT (@dec/@a)*@b -- 2568650.410585
SELECT @flt*@b/@a -- 2568651.85519552

Sharing permission vs security

2010-06-15T19:29:00.000-07:00

The Security Tab is the NTFS permissions.
Sharing permissions only apply when a user accesses a share via the network.

If the person is not given write permissions at the sharing level, then no matter the NTFS permissions, they will not be able to write to the folder.

Folder/NTFS permissions apply to a local logon or network access. If sharing
permissions conflict with folder/NTFS permissions for a network user, the
most restrictive permission will apply to the user. In other words if a user
has only read access in the sharing permission but full control to the folder/NTFS
permissions. That user will only have to read/list/execute access over the
network for the share contents.

Reference: 1 2

System account in Windows

2010-06-15T19:20:00.000-07:00

The system account and the administrator account (Administrators group) have the same file privileges, but they have different functions. The system account is used by the operating system and by services that run under Windows.
By default, the system account is granted full control to all files on an NTFS volume.
The system account's permissions can be removed from a file but it is not recommended.
Reference: here

Change the database source without changing the fields

2010-03-30T00:28:00.000-07:00

In CR, in order to change the data source/sp without changing the whole crystal report format, here's what we can do.
1) Go to the menu on top, under Database, select Set Data source Location ...
2) Select your data source to be changed and select new data source
3) Click update

Viola.. that's all it takes!
Reference: here

connection string in .net

2010-03-22T00:54:00.000-07:00

In .net we can separate the connection string from the config file (app.config/web.config).
Here's how to do it:
1) Create ConnectionString.config, place this file in the same file as your config file.
Copy and paste the connection string from your config file to this file.

<connectionstrings>
<add name="AIConnectionString" connectionString="VsE02TxJgFtwnFegSRgcJtT9lrEl4ZFtSY+"  providerName="System.Data.SqlClient" />
</connectionStrings>

2) In your config file, replace the connection string with this:

<connectionstrings configSource="ConnectionString.config"/>

Thinking of consolidating all your other batches to use one connection string file only?
This is not possible, pls see the reference below.
Reference: here

How to refresh the SP table field in Crystal Report?

2010-03-04T01:05:00.000-08:00

When we have made changes to the SP in the database, the crystal report (version 10) does not reflect the changes I made even when I have closed and re-opened the report.
In order to refresh this, we can go to the Database in the menu, select Verify Database to update this.
Reference: here

SQL Tree Hierarchy

2010-03-03T22:53:00.000-08:00

How to construct the tree hierarchy using SQL???
I was searching for this and found a great link, so I followed and it works!

Here's the snippet for my codes:

declare @AITree table 
(Node int NOT NULL IDENTITY(100, 1), AIType int,
parent varchar(20), child varchar(20), 
depth int NULL, lineage varchar(1000))

--insert whatever inside your table, u can ignore the AIType
insert into @AITree (AIType, child)
select AIType, ID from AI_Grouping 
WHERE effstartdate<=@treeDate and effendDate>=@treeDate
order by AIType, parent, child

--updating parent using the node (not my table)
UPDATE T
SET T.Parent=P.node
FROM @AITree T 
INNER JOIN AI_Grouping C ON T.child=C.ID and T.AIType = C.AIType 
INNER JOIN AI_Grouping PT ON C.parent=PT.child and C.AIType = PT.AIType 
INNER JOIN @AITree P ON PT.ID=P.child and P.AIType = PT.AIType 
WHERE C.effstartdate<=@treeDate and C.effendDate>=@treeDate AND
PT.effstartdate<=@treeDate and PT.effendDate>=@treeDate 

-- updating the top parent
UPDATE @AITree SET Lineage='/', Depth=0 WHERE parent Is Null

-- updating the rest of the nodes
UPDATE T SET T.depth = P.Depth + 1, 
T.Lineage = P.Lineage + Ltrim(Str(T.Parent,6,0)) + '/' 
FROM @AITree AS T 
INNER JOIN @AITree AS P ON (T.Parent=P.Node) 
WHERE P.Depth>=0 
AND P.Lineage Is Not Null 
AND T.Depth Is Null

WHILE EXISTS (SELECT * FROM @AITree WHERE Depth Is Null) 
UPDATE T SET T.depth = P.Depth + 1, 
T.Lineage = P.Lineage + Ltrim(Str(T.Parent,6,0)) + '/' 
FROM @AITree AS T 
INNER JOIN @AITree AS P ON (T.Parent=P.Node) 
WHERE P.Depth>=0 
AND P.Lineage Is Not Null 
AND T.Depth Is Null

--try this to output the treee
SELECT Space(T.Depth*2) + 
    case depth when 0 then '-' else '' end + 
    G.child AS Name
FROM AI_Grouping G INNER JOIN @AITree T 
ON G.ID = T.child 
ORDER BY T.Lineage + Ltrim(Str(T.Node,6,0))

Enjoy!
Reference: here

To get the number of occurrence of a character in SQL

2010-03-03T22:48:00.000-08:00

Wonder how to get the number occurrence of a character in MS SQL?
Here's a trick on how to do it

declare @char varchar(1), @str varchar(100)
SET @char ='/'
SET @str = '/102///111/'
SELECT LEN(@str)-LEN(REPLACE(@str,@char,''))

Wala.. there u go, u will get 5 for the scenario above.

SQL Query case sensitive

2010-03-02T20:07:00.000-08:00

How to make the case sensitive query?
There are 2 records in the database with currAbbr = ZAR and ZAr, in order to get the correct case sensitive comparision, u can use BINARY_CHECKSUM.

try this query:
select * from MYTable
where BINARY_CHECKSUM(currAbbr) = BINARY_CHECKSUM('ZAR')
select * from MYTable
where BINARY_CHECKSUM(currAbbr) = BINARY_CHECKSUM('ZAr')

SQL Joins

2010-02-12T00:52:00.001-08:00

This is a good website to illustrate the SQL joins.
http://www.codinghorror.com/blog/archives/000976.html

check .net version installed in your computer

2010-01-28T05:51:00.000-08:00

to do this, simply create a html page and copy the content.

<Html>
<body>
<script>
alert(navigator.userAgent)
</script>
</body>
</html>

Then open the page on IE, it will prompt the .NET version.

Reference: here

ASP.NET Dropdown SelectedValue does not change?

2010-01-05T19:30:00.000-08:00

Problem:
My dropdown selected value does not change.
It will always return the initialized value.

Solution:
Check if you put the initialization within the page.ispostback criteria.

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        If Not Page.IsPostBack Then
            ddl.SelectedValue = "1"
        End If
    End Sub

'Sys' is undefined - ASP.NET 2.0 Ajax Control Toolkit

2009-12-28T00:50:00.000-08:00

To fix this:
1. Open your web.config
2. Add this in between

<httpHandlers> </httpHandlers>

section

<add verb="GET" path="ScriptResource.axd" type="Microsoft.Web.Handlers.ScriptResourceHandler" validate="false"/>

Reference: here

The above would work fine, however it will give the following error:

 Could not load type 'Microsoft.Web.Handlers.ScriptResourceHandler'.
ScriptResource.axd

Some suggested to change the code added to the following

<add verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" validate="false"/>

(Change the word Microsoft to System)

But it gave me this javascript error:
Sys.ArgumentTypeException. Object of type 'Sys._Application' cannot be converted to 'Sys._Application'

In order to solve this will need to add this ScriptMode="Release" on the ScriptManager tag, like this:

<asp:ScriptManager id="ScriptManager1" runat="server" ScriptMode="Release">
</asp:ScriptManager>

Reference: here

Access is denied in Ajax Control Toolkit 1

2009-12-28T00:37:00.000-08:00

Here's what you have to do.
Change the following in the MicrosoftAjax.js
between this line :
case Sys.Browser.InternetExplorer:
and this line :
case Sys.Browser.Safari:

The code to be used:

Sys.UI.DomElement.getLocation = function Sys$UI$DomElement$getLocation(element) {
            if(element.self||element.nodeType===9)
          return new Sys.UI.Point(0,0);
       var d = element.getClientRects();
      if(!d || !d.length) 
        return new Sys.UI.Point(0,0);
 
      var inFrame = false;
      // Get the first bounding rectangle in screen coordinates
      var screenRects = element.getClientRects();
 
      if (!screenRects || !screenRects.length) {
          return new Sys.UI.Point(0,0);
      }
 
      var first = screenRects[0];
      // Delta between client coords and screen coords
      var dLeft = 0;
      var dTop = 0;
 
      try
      {
        inFrame = a.ownerDocument.parentWindow.frameElement;
      }
      catch(ex)
      {
        inFrame = true;
      }
 
      if(!inFrame)
      { 
        var e=a.ownerDocument.parentWindow; 
        var g=e.screenLeft - top.screenLeft - top.document.documentElement.scrollLeft + 2; 
        var h=e.screenTop - top.screenTop - top.document.documentElement.scrollTop + 2; 
        var c=e.frameElement||null; 
        if(c) 
        { 
          var b=c.currentStyle; 
          g+=(c.frameBorder||1) * 2 + (parseInt(b.paddingLeft) || 0) + (parseInt(b.borderLeftWidth) || 0) - a.ownerDocument.documentElement.scrollLeft; 
          h+=(c.frameBorder||1) * 2 + (parseInt(b.paddingTop) || 0) + (parseInt(b.borderTopWidth) || 0) - a.ownerDocument.documentElement.scrollTop; 
        } 
        var f=d[0]; 
        return new Sys.UI.Point(f.left-g,f.top-h); 
      } 
      else 
      { 
        // Get the bounding rectangle in client coords 
        var clientRect = element.getBoundingClientRect(); 
        if (!clientRect)
        { 
          return new Sys.UI.Point(0,0);
        } 
        // Find the minima in screen coords 
        var minLeft = first.left; 
        var minTop = first.top;
 
        for (var i = 1; i < screenRects.length; i++)
        { 
          var r = screenRects[i]; 
          if (r.left < minLeft) 
          { 
            minLeft = r.left; 
          } 
          if (r.top < minTop)
          { 
            minTop = r.top;
          }
 
        }
 
        // Compute the delta between screen and client coords 
        dLeft = minLeft - clientRect.left; 
        dTop = minTop - clientRect.top;
 
        // Subtract 2px, the border of the viewport (It can be changed in IE6 by applying a border style to the HTML element, 
        // but this is not supported by ASP.NET AJAX, and it cannot be changed in IE7.), and also subtract the delta between 
        // screen coords and client coords
 
        var ownerDocument = element.document.documentElement; 
        return new Sys.UI.Point(first.left - 2 - dLeft + ownerDocument.scrollLeft, first.top - 2 - dTop + ownerDocument.scrollTop); 
      } 
    };
        break;

Reference:
here and here

Date (no time) in SQL

2009-12-14T00:29:00.000-08:00

To get date only, u can use this:
select Convert(datetime, Convert(VARCHAR, getdate(), 101) , 101)
alternatively
select cast (floor (cast (createddate as float)) as datetime)
Reference: here
Complete reference: here

Could not find file 'Microsoft.Windows.CommonLanguageRuntime, Version=2.0.50727.0'

2009-12-10T00:01:00.000-08:00

Problem:
Encountered this error in Microsoft Visual Studio 2005 while building the web project.
Error 123 Could not find file 'Microsoft.Windows.CommonLanguageRuntime, Version=2.0.50727.0'.

Resolution:
Do not use project reference, but use the dll or exe reference instead.
Then try to compile again.
It should work.

Reference: here

extjs - ajax.net

2009-12-08T02:13:00.000-08:00

Use ajax combined with .net
You can use AjaxPro to get the json data.
Reference: here

EXTJS Tree panel with .NET

CheckedChanged does not work!

2009-12-07T23:42:00.000-08:00

While I was coding, it was very hard to debug as the CheckedChanged for my Checkbox event was not working.

Found out that the AutoPostBack field was set to FALSE, it is supposed to be TRUE if you want to use the CheckedChanged event.

Obtain return value from stored procedure back to code

2009-12-07T21:42:00.000-08:00

sqlCmd.Parameters.Add(New SqlParameter("RETURN_VALUE",SqlDbType.Int)).Direction = ParameterDirection.ReturnValue

Dim i as integer = CType(sqlCmd.Parameters("RETURN_VALUE").Value, Integer)

Reference: here

Free Tree for ASP.NET

2009-12-04T02:15:00.000-08:00

astreeview

Add blank item at the top of dropdownlist

2009-12-03T21:16:00.000-08:00

drpList.Items.Insert(0, new ListItem(String.Empty, String.Empty));
drpList.SelectedIndex = 0;

Reference: here

Insert Record into Database via Dataset

2009-12-03T21:15:00.001-08:00

Click here

VB.NET Class

2009-12-03T19:51:00.000-08:00

If the class inherit another class, you may use the baseclass sub new as follows:

Class ChildClass
  Inherits BaseClass
  Public Sub New(text As String)
    MyBase.New(text)
  End Sub
End Class

Reference: Here

More inheritance lessons

Microsoft Enterprise Library Exception Logging error

2009-12-03T19:49:00.000-08:00

Did you encounter this error?

The type 'Microsoft.Practices.EnterpriseLibrary.ExceptionHandling.Logging.LoggingExceptionHandler, Microsoft.Practices.EnterpriseLibrary.ExceptionHandling.Logging, Version=3.1.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' cannot be resolved. Please verify the spelling is correct or that the full type name is provided.

Simply add Microsoft.Practices.EnterpriseLibrary.ExceptionHandling.Logging.dll as the reference to your project.

Reference: here

Remove Identity column in a table

2009-12-01T22:48:00.000-08:00

Reset Identity in MS SQL

Remove the IDENTITY Property from an Existing Column in SQL Server 2000

Removing IDENTITY from existing column

Subquery sample

2009-12-01T22:46:00.001-08:00

create table T3 (a int unique clustered, b int)

insert T1 values(0, 0, 0)
insert T1 values(1, 1, 1)

select
    case
        when T1.a > 0 then
            (select T3.b from T3 where T3.a = T1.b)
        else
            T1.c
    end
from T1

Reference: here

Append string in front to StringBuilder

2009-07-02T02:37:00.000-07:00

Here's how to append string in front for StringBuilder

StringBuilder sb = new StringBuilder();
sb.Append("sample");
sb.Insert(0, "firststring ");
string s = sb.ToString();

Reference: here

A potentially dangerous Request.Cookies value was detected from the client

2009-06-30T00:22:00.000-07:00

A potentially dangerous Request.Cookies value was detected from the client (AppEvtStat="Deal...").

Description: Request Validation has detected a potentially dangerous client input value, and processing of the request has been aborted. This value may indicate an attempt to compromise the security of your application, such as a cross-site scripting attack. You can disable request validation by setting validateRequest=false in the Page directive or in the configuration section. However, it is strongly recommended that your application explicitly check all inputs in this case.

To resolve this:
Add validateRequest="false" on the Page element like below

<%@ Page validateRequest="false" %>

Reference: here

Firefox enable windows authentication

2009-06-29T21:08:00.000-07:00

To enable windows authentication on your domain.

1. Open Firefox

2. Enter on url textbox: about:config

3. Locate the following preference names and put as the value the comma separated values of the address roots.

network.automatic-ntlm-auth.trusted-uris
network.negotiate-auth.delegation-uris
network.negotiate-auth.trusted-uris

Your value should look something like this: localhost, server1, server2, serverX, something.com

Reference: here

Thread was being aborted.

2009-06-29T01:05:00.000-07:00

Error: Thread was being aborted. Stack Trace : at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.End() at System.Web.HttpResponse.Redirect(String url, Boolean endResponse) at System.Web.HttpResponse.Redirect(String url)

Response.Redirect is added within a try-catch block by ONLY providing a url will cause the above error.

An exception will be thrown, even though it can still redirect to the URL that you want. (you can track this error in debug mode)

To resolve this:

Response.Redirect(url,false)

add a boolean indicator to end the response

Reference: here

RUN command shortcuts

2009-06-22T01:08:00.000-07:00

Accessibility Controls : access.cpl
Add Hardware Wizard : hdwwiz.cpl
Add/Remove Programs : appwiz.cpl
Administrative Tools : control admintools
Automatic Updates : wuaucpl.cpl
Bluetooth Transfer Wizard : fsquirt
Calculator : calc
Certificate Manager : certmgr.msc
Character Map : charmap
Check Disk Utility : chkdsk
Clipboard Viewer : clipbrd
Command Prompt : cmd
Component Services : dcomcnfg
Computer Management : compmgmt.msc
Date and Time Properties : timedate.cpl
DDE Shares : ddeshare
Device Manager : devmgmt.msc
Direct X Control Panel (If Installed)* : directx.cp
Direct X Troubleshooter : dxdiag
Disk Cleanup Utility : cleanmgr
Disk Defragment : dfrg.msc
Disk Management : diskmgmt.msc
Disk Partition Manager : diskpart
Display Properties : control desktop
Display Properties : desk.cpl
Display Properties (w/Appearance Tab Preselected) : control color
Dr. Watson System Troubleshooting Utility : drwtsn32
Driver Verifier Utility : verifier
Event Viewer : eventvwr.msc
File Signature Verification Tool : sigverif
Findfast : findfast.cpl
Folders Properties : control folders
Fonts : control fonts
Fonts Folder : fonts
Free Cell Card Game : freecell
Game Controllers : joy.cpl
Group Policy Editor (XP Prof) : gpedit.msc
Hearts Card Game : mshearts
Iexpress Wizard : iexpress
Indexing Service : ciadv.msc
Internet Properties : inetcpl.cpl
IP Configuration (Display Connection Configuration) : ipconfig /all
IP Configuration (Display DNS Cache Contents) : ipconfig /displaydns
IP Configuration (Delete DNS Cache Contents) : ipconfig /flushdns
IP Configuration (Release All Connections) : ipconfig /release
IP Configuration (Renew All Connections) : ipconfig /renew
IP Configuration (Refreshes DHCP & Re-Registers DNS) : ipconfig /registerdns
IP Configuration (Display DHCP Class ID) : ipconfig /showclassid
IP Configuration (Modifies DHCP Class ID) : ipconfig /setclassid
Java Control Panel (If Installed) : jpicpl32.cpl
Java Control Panel (If Installed) : javaws
Keyboard Properties : control keyboard
Local Security Settings : secpol.msc
Local Users and Groups : lusrmgr.msc
Logs You Out Of Windows : logoff
Microsoft Chat : winchat
Minesweeper Game : winmine
Mouse Properties : control mouse
Mouse Properties : main.cpl
Network Connections : control netconnections
Network Connections : ncpa.cpl
Network Setup Wizard : netsetup.cpl
Notepad : notepad
Nview Desktop Manager (If Installed) : nvtuicpl.cpl
Object Packager : packager
ODBC Data Source Administrator : odbccp32.cpl
On Screen Keyboard : osk
Opens AC3 Filter (If Installed) : ac3filter.cpl
Password Properties : password.cpl
Performance Monitor : perfmon.msc
Performance Monitor : perfmon
Phone and Modem Options : telephon.cpl
Power Configuration : powercfg.cpl
Printers and Faxes : control printers
Printers Folder : printers
Private Character Editor : eudcedit
Quicktime (If Installed) : QuickTime.cpl
Regional Settings : intl.cpl
Registry Editor : regedit
Registry Editor : regedit32
Remote Desktop : mstsc
Removable Storage : ntmsmgr.msc
Removable Storage Operator Requests : ntmsoprq.msc
Resultant Set of Policy (XP Prof) : rsop.msc
Scanners and Cameras : sticpl.cpl
Scheduled Tasks : control schedtasks
Security Center : wscui.cpl
Services : services.msc
Shared Folders : fsmgmt.msc
Shuts Down Windows : shutdown
Sounds and Audio : mmsys.cpl
Spider Solitare Card Game : spider
SQL Client Configuration : cliconfg
System Configuration Editor : sysedit
System Configuration Utility : msconfig
System File Checker Utility (Scan Immediately) : sfc /scannow
System File Checker Utility (Scan Once At Next Boot) : sfc /scanonce
System File Checker Utility (Scan On Every Boot) : sfc /scanboot
System File Checker Utility (Return to Default Setting) : sfc /revert
System File Checker Utility (Purge File Cache) : sfc /purgecache
System File Checker Utility (Set Cache Size to size x) : sfc /cachesize=x
System Properties : sysdm.cpl
Task Manager : taskmgr
Telnet Client : telnet
User Account Management : nusrmgr.cpl
Utility Manager : utilman
Windows Firewall : firewall.cpl
Windows Magnifier : magnify
Windows Management Infrastructure : wmimgmt.msc
Windows System Security Tool : syskey
Windows Update Launches : wupdmgr
Windows XP Tour Wizard : tourstart
Wordpad : write

taken from here

Find Last day of the month

2009-04-08T19:57:00.000-07:00

To find the last day of the month in SQL:

—-Last Day of Previous Month
SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE()),0))
LastDay_PreviousMonth
—-Last Day of Current Month
SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE())+1,0))
LastDay_CurrentMonth
—-Last Day of Next Month
SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE())+2,0))

Source: here

Learn 3dMax, Adobe etc Online

2009-04-02T18:02:00.000-07:00

Website: lynda.com

Need to pay $25 but unlimited, with video quicktime and a good teaching structure.
if you signed up with premium, practice file will be given.

Get list of all tables in SQL and its approximate row count

2009-03-23T00:36:00.001-07:00

Here's the SQL to do this.

SELECT
[TableName] = so.name,
[RowCount] = MAX(si.rows)
FROM
sysobjects so,
sysindexes si
WHERE
so.xtype = 'U'
AND
si.id = OBJECT_ID(so.name)
GROUP BY
so.name
ORDER BY
2 DESC

Kewl, huh!?
Reference: here

Bracket Plus Sign (+) in SQL

2009-03-19T03:24:00.000-07:00

SELECT *
FROM TABLE1 a, TABLE2 b
WHERE a.CODE = b.CODE(+)

This bracket plus sign (+) indicates a LEFT OUTER JOIN. It includes all records from TABLE1 and from TABLE2 that has CODE field value match.

Click here for more information

Clear Browsing History in IE7

2009-03-16T23:02:00.000-07:00

Create batch file (for example: New_IE.bat)

Fill the file with this:

C:\Progra~1\Intern~1\iexplore.exe
RunDll32.exe InetCpl.cpl,ClearMyTracksByProcess 255

When we exit Internet Explorer, System will clear all the history.
This only works for IE 7.

anonymizer
nph-proxy: website that will not write the history to the proxy.
http://www.bpcd.net/cgi-bin/nph-proxy.cgi
enter URL on the site, open all sites, only that url will show in the nph-proxy

or you can use this so that won't keep the history.
chrome: incognito
ie8 (beta): sorry, forgot the name
firefox: there's an option to clear

Identity after inserting

2009-03-11T02:10:00.000-07:00

How is exactly to get the identity after inserting in MS SQL?
If the table u are inserting have identity set to YES.
Hence you can use this.

declare @theid as bigint
insert into tablename select myvalue1, myvalue2
set @theid=@@IDENTITY

So the new ID is kept in the variable @theid now.

Reference: here

BCP function

2009-03-10T23:06:00.000-07:00

You can use this BCP function easily to import/export from the MS SQL database.

usage: bcp {dbtable | query} {in | out | queryout | format} datafile
[-m maxerrors] [-f formatfile] [-e errfile]
[-F firstrow] [-L lastrow] [-b batchsize]
[-n native type] [-c character type] [-w wide character type]
[-N keep non-text native] [-V file format version] [-q quoted identifier]
[-C code page specifier] [-t field terminator] [-r row terminator]
[-i inputfile] [-o outfile] [-a packetsize]
[-S server name] [-U username] [-P password]
[-T trusted connection] [-v version] [-R regional enable]
[-k keep null values] [-E keep identity values]
[-h "load hints"]

Here's an example to export the data from the database.
- with trusted connection

bcp "dbname.dbo.tablename" out "dev_tablename.bcp" -e error.log -c -S servername -T -k

- with username and password

bcp "dbname.dbo.tablename" out "dev_tablename.bcp" -e error.log -c -S servername -U username -P password -k

Here's an example to import the data to the database.
- with trusted connection

bcp "dbname.dbo.tablename" in "dev_tablename.bcp" -e error.log -c -S servername -T -k

- with username and password

bcp "dbname.dbo.tablename" in "dev_tablename.bcp" -e error.log -c -S servername -U username -P password -k

- with username and password and order clause

bcp "dbname.dbo.tablename" in "dev_tablename.bcp" -e error.log -c -S servername -U username -P password -k -h "ORDER (TheDate DESC)"

Select Nth Row

2009-02-16T17:14:00.000-08:00

SQL Query:

SELECT TOP 1 name FROM (SELECT TOP 9 name FROM master..syslogins ORDER BY name ASC) sq ORDER BY name DESC -- gets 9th row

MSSQL Injection Cheat Sheet

Looping in MSSQL

declare @index integer
set @index = 0
while @index < 10
begin
select 'loop counter = ', @index
set @index = @index + 1
end

Find computer using IP

2009-02-06T00:01:00.001-08:00

On command prompt we can type this:

NSLOOKUP

it will show the computer name.

Cannot delete file: cannot read from source file or disk

2009-02-03T01:44:00.000-08:00

When we receive this kind of error what to do??
The files within this folder is somehow corrupted.
First step is to fix it.
1. Open command prompt (Start -> Run -> cmd)
2. Type chkdsk /F E:\
It will fixed by itself.

PHP Get User Information

2009-01-08T05:42:00.000-08:00

Class features:
* Get User Browser.
* Get User Operating System.
* Get User IP.
* Get User Country.
* Get User Referral + Search Engine.
* Get User Language.
* Check if Flash enabled.
* Check if JavaScript enabled.
* Check user speed (bandwidth).

Download the file.

Reference: here

Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 134 bytes)

2009-01-08T05:25:00.000-08:00

When you received this kind of error in PHP

Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 134 bytes) in /home/www/domains/www.salzwimmer.at/html/gb/PYG.php on line 181

Here's how to resolve in xampp:
1. Enable the Rewrite module.
Open %XAMPP%\apache\conf\httpd.conf in notepad and search for mod_rewrite. You will find a line like:

#LoadModule rewrite_module modules/mod_rewrite.so

Remove the # from the beginning. It will now look:

LoadModule rewrite_module modules/mod_rewrite.so

Restart the Apache web server through XAMPP control panel.

2. Find php.ini in your folder
Change the memory_limit to 64M
Here are the files that I changed:
%XAMPP%\php\php.ini
and
%XAMPP%\apache\bin\php.ini

Find a line like:

memory_limit = 32M ; Maximum amount of memory a script may consume (16MB)

Change to

memory_limit = 64M ; Maximum amount of memory a script may consume (16MB)

Save the file and restart the Apache web server.
You should be able to resolve this error.

To check on the configuration:
1. Go to localhost/xampp
2. Click on the phpinfo()
3. Find for memory_limit
4. See if it's 64M instead of 32M

Sun Ray Effect

2008-12-12T00:19:00.000-08:00

This is what I have been searching for long....
At last, i found it.

Click here to view the tutorial.

Key column information is insufficient or incorrect. Too many rows were affected by update.

2008-11-27T00:00:00.000-08:00

In MS SQL 2000, in a table with no primary key/index/constraint, whenever there is duplicate record, we cannot delete any of the duplicate record, it will give this error:

"Key column information is insufficient or incorrect. Too many rows were
affected by update."

So how is the trick to remove this duplication?
I was searching and finally found something.

here's what we can do:
1. find out which are the duplicate records

SELECT col1, col2, count(*)
FROM t1
GROUP BY col1, col2
HAVING count(*) > 1

2. delete the duplicate by using this sql

set rowcount 1
delete from t1
where col1=1 and col2=1

it works!

Reference: here

Access violation at address 10002593 in module ‘LIBMYSQL.dll’ read at address 00000000.

2008-11-26T08:16:00.000-08:00

Yeah I continuously got this error after installing xampp.
Maybe u got this too?
Here's how to solve the problem:
1. Choose Start > All Programs > Startup > WinMySQLadmin
2. Click on the my.ini Setup tab in the WinMySQLadmin window. This can be tricky because the error message windows keep popping up on top the WinMySQLadmin window.
3. In the my.ini Setup tab, there’s a big text box and at the bottom, you’ll see
user=root
password=password
4. Delete the second ‘password’ so that those two lines look like this:
user=root
password=
5. Click the ‘Save Modification’ button in the left area of the window, and confirm that you want to save your changes.
6. The error messages should stop now.

Reference: here

Unable to read the project file 'something.vbproj'. The system cannot find the path specified

2008-11-19T01:26:00.000-08:00

I have encountered this error and tried to debug it for quite sometime.
It's kinda annoying as I cannot open the web application.

My solution has reference to this vbproj file as etp file.
I have checked that the reference path to this vbproj file is correct in the etp file (http://localhost/something).
I have tried adding the virtual directory 'something' manually on IIS, but yet it didn't work.

How to work around this problem?
There is a file that contains the visual studio settings for the solution. Not sure what it holds. Things like startup project, page.

If the solution is called mysolution.sln then the file is mysolution.suo. It is a hidden file so you will need to turn on the display of hidden files in windows explorer or use dos.

Delete it and all will be fine. VS will create a new one.
Make a backup of the whole directory if it makes you more comfortable.

Reference: here

And I tried that.. and wala... I can open successfully.

Autocomplete control with dropdown

2008-11-11T22:25:00.000-08:00

Besides extjs, here's what I found to be useful as dropdown.

Featuring auto-complete dropdown, or auto-complete textarea like Gmail's one, also country listing (PHP)

Reference: here

Resources for date picker: here

Download the code here.

SQL - Drop, Truncate and Delete

2008-10-30T03:38:00.000-07:00

Yeah.. basic things but it might be asked on the interview for Application Consultant position at Barclays.

What is the difference between Drop, Truncate and Delete?
Drop is to remove the whole table including the structure.
Truncate is to clean the table, delete all the data within the table.
Delete is to delete a record from the table.

So delete from table and truncate is the same?
The answer is no.

Delete will lock the table, but truncate will not.
That's the main difference!

Inserting Large Amount of Data - Bulk Insert

2008-10-10T02:39:00.000-07:00

In order to pass a large amount of data, in VB.NET we can use Bulk Insert, here's the article for more information on the sample too.
Bulk insert sample in vbs file, click here.

If you need to create an XML from the Dataset, then u can click here.

Here's a sample on reading XML format in stored procedure:

DECLARE @idoc int

DECLARE @doc varchar(1000);

Select @doc ='
<ROOT>
<Customer CustomerID="1" ContactName="John 1"/>
<Customer CustomerID="2" ContactName="John 2"/>
<Customer CustomerID="1" ContactName="John 3"/>
<Customer CustomerID="2" ContactName="John 4"/>
</ROOT>'

EXEC sp_xml_preparedocument @idoc OUTPUT, @doc

SELECT    *
FROM       OPENXML (@idoc, '/ROOT/Customer',1)
            WITH (CustomerID  varchar(10),
                  ContactName varchar(20))

EXEC sp_xml_removedocument @idoc

Please take note that this is not reading from the physical XML file, this can only be used for reading table field with the value of XML formatted text.
More info on feeding XML to Stored Procedure, click here.

This is a sample of reading physical file from the stored procedure, but I have not tested it as I do not have this permission in my office development environment.
EXECUTE permission denied on object 'sp_OACreate', database 'master', owner 'dbo'.
I guess this action requires sysadmin rights.

declare @objFSys int
declare @objFile int
declare @blnEndOfFile int
declare @strLine varchar(4000)

exec sp_OACreate 'Scripting.FileSystemObject', @objFSys out

-- Change the file path to the one that is passed to your stored procedure
exec sp_OAMethod @objFSys, 'OpenTextFile', @objFile out, 'C:\test.txt', 1
exec sp_OAMethod @objFile, 'AtEndOfStream', @blnEndOfFile out
while @blnEndOfFile=0 begin
  exec sp_OAMethod @objFile, 'ReadLine', @strLine out
  -- Here you got one line from the file
  select @strLine
  exec sp_OAMethod @objFile, 'AtEndOfStream', @blnEndOfFile out
end
exec sp_OADestroy @objFile
exec sp_OADestroy @objFSys

Running SQL in bat file

2008-10-09T01:35:00.000-07:00

For MS SQL Server 2000, we can use osql.
click here and here for some samples.

For MS SQL Server 2005, we can use sqlcmd.
Click here for more info

For Oracle, we can use sqlplus.

Stored Procedure QUOTED_IDENTIFIER and ANSI_NULLS

2008-09-30T01:26:00.000-07:00

SET QUOTED_IDENTIFIER (Transact-SQL)

Causes SQL Server to follow the ISO rules regarding quotation mark delimiting identifiers and literal strings. Identifiers delimited by double quotation marks can be either Transact-SQL reserved keywords or can contain characters not generally allowed by the Transact-SQL syntax rules for identifiers.

When SET QUOTED_IDENTIFIER is ON, identifiers can be delimited by double quotation marks, and literals must be delimited by single quotation marks.

When SET QUOTED_IDENTIFIER is OFF, identifiers cannot be quoted and must follow all Transact-SQL rules for identifiers. Literals can be delimited by either single or double quotation marks.

Reference: here

SET ANSI_NULLS

Specifies SQL-92 compliant behavior of the Equals (=) and Not Equal to (<>) comparison operators when used with null values.

When SET ANSI_NULLS is ON, a SELECT statement using WHERE column_name = NULL returns zero rows even if there are null values in column_name. A SELECT statement using WHERE column_name <> NULL returns zero rows even if there are nonnull values in column_name.

When SET ANSI_NULLS is OFF, the Equals (=) and Not Equal To (<>) comparison operators do not follow the SQL-92 standard. A SELECT statement using WHERE column_name = NULL returns the rows with null values in column_name. A SELECT statement using WHERE column_name <> NULL returns the rows with nonnull values in the column. In addition, a SELECT statement using WHERE column_name <> XYZ_value returns all rows that are not XYZ value and that are not NULL.

Reference: here

Send Ctrl+Alt+Del to Remote Desktop

2008-09-24T19:12:00.000-07:00

In order to change the account password in Windows Server via Remote Desktop, we can use Ctrl+Alt+Del.

How to send this command via Remote Desktop?
Press Ctrl+Alt+END

SQL Store Procedure CURSOR

2008-09-23T02:16:00.001-07:00

I just learnt stored procedure with cursor pointer.

Here's an example:

BEGIN
    DECLARE @MyID AS BIGINT
    DECLARE MyIDCursor CURSOR FOR
        SELECT ID FROM MyTable
    OPEN MyIDCursor

    FETCH NEXT FROM MyIDCursor INTO @MyID
    WHILE @@FETCH_STATUS=0 -- this is necessary to loop
    BEGIN
        -- print it out
        print '@MyID'
        print @MyID
        -- to assign to the next value, without this, it will loops forever!
        FETCH NEXT FROM MyIDCursor INTO @MyID 
    END

    CLOSE MyIDCursor
    DEALLOCATE MyIDCursor
END

Actually this method is not recommended, look here.

MSSQL Multiplication and Division Limitation

2008-09-22T22:38:00.000-07:00

There was a case at work, the number is not precise enough for multiplication of data type decimal (38,10).

The result will give up to 6 decimal place precision and the rest 4 decimal place follows it will be truncated, replaced with 0.

Here's the sample in SQL Query Analyzer:

DECLARE @CrossRate as decimal(38,10)
DECLARE @ExchRate1 as decimal(38,10)
DECLARE @ExchRate2 as decimal(38,10)

SET @ExchRate1 = 1.3159643631
SET @ExchRate2 = 1.3663000000

SET @CrossRate = @ExchRate1/@ExchRate2
print '@ExchRate1: '
print @ExchRate1
print '@ExchRate2: '
print @ExchRate2
print '@CrossRate: '
print @CrossRate

And here's the result:

@ExchRate1:
1.3159643631
@ExchRate2:
1.3663000000
@CrossRate:
0.9631590000

However for data type decimal (18,10), multiplication result of the two data types will give the same precision - decimal(18,10).

The CrossRate result of decimal (18,10) is
0.9631591620

I am still not yet known how to solve this, as the requirement that we have is for data type decimal (38,10) instead of decimal (18,10). If you have any idea on how to solve this, please let me know. Thanks.

Some updates
My colleague just said that we can use float.
However there are some things to take note:

Float is Approximate-number data type, which means that not all values in the data type range can be represented exactly.

Decimal/Numeric is Fixed-Precision data type, which means that all the values in the data type reane can be represented exactly with precision and scale.

Converting from Decimal or Numeric to float can cause some loss of precision.

Reference: here

Fixing NS_ERROR_XPC_JS_THREW_STRING

2008-08-19T23:08:00.001-07:00

In htmls using ExtJs, most of the times I encountered this error in firebug:

"Exception: The request to read the property 
HTMLDivElement.nodeType was denied, when calling method:
[nsIDOMEventListener::handleEvent]" nsresult: "0x8057001e 
(NS_ERROR_XPC_JS_THREW_STRING)" location: "<unknown>" 
data: no]"

After searching a long time, here's what i found on how to fix it:
One of them saying it will be fixed by adding autocomplete="off" to all text fields.
I tried this however it doesn't really work!

And after I look at this ExtJs forum thread, I tried adding this trackMouseOver:false on my ExtJs grid.
And so far I did not have that error anymore :)
Yay!

ExtJs messagebox sample

Flash Overlay Problem

2008-07-16T18:13:00.000-07:00

There is a problem when embedding flash into a web page.
For example if you have dropdown, the dropdown values will be covered by the flash.
Hence you won't be able to view all the images like the picture below.

Here's what we need add

for Flash tag embed

<param name=WMode value=Opaque>

for Javascript

fo.addParam("wmode", "opaque");

and wala.. here's the result...

However, this apparently does not work in Linux.

Reference: here

Hide/Show FieldLabel in ExtJs form

2008-07-09T19:53:00.000-07:00

This is an overriding function to enable hide/show fieldLabel in ExtJs field form.
The current release of ExtJs 2.1 does not support it.

You can use the function hideItem and showItem in order to show/hide the form field.

Put this function in a javascript file eg. ext-override.js
Then include this file into your html file containing ExtJs form.

Ext.override(Ext.form.Field, {
    hideItem :function(){
        this.formItem.addClass('x-hide-' + this.hideMode);             
    },

    showItem: function(){
        this.formItem.removeClass('x-hide-' + this.hideMode);             
    },
    setFieldLabel: function(text) {
    var ct = this.el.findParent('div.x-form-item', 3, true);
    var label = ct.first('label.x-form-item-label');
    label.update(text);
  }
});

Pre-populate combo values

2008-07-03T20:18:00.000-07:00

This sample is to populate combo values in html form using javascript.

For manually insertion of the Option values into the combobox.

<script type="text/javascript"> 
function prepopulate(reportType){
    document.form1.report_view.options.length = 0;
    if (reportType ==  "Pie_Chart" || reportType == "Bar_Graph"){
        document.form1.report_view.options[0] = new Option("Adobe Reader (.pdf)","pdf");
        document.form1.report_view.options[1] = new Option("Open Office (.odt)","odt");
    }else{
        document.form1.report_view.options[0] = new Option("Adobe Reader (.pdf)","pdf");
        document.form1.report_view.options[1] = new Option("Microsoft Excel (.xls)","xls");
        document.form1.report_view.options[2] = new Option("Open Office (.odt)","odt");
    }
}
</script>

In the html part:

<select name="report_type" id = "report_type" onChange="javascript:prepopulate(this.value)">
    <option value="Consolidated_Comments">Consolidated Comments</option>
    <option value="Pie_Chart">Consolidated Result - Pie Chart</option>
    <option value="Bar_Graph">Consolidated Result - Bar Graph</option>
    <option value="Individual_Results_Comments">Individual Results (Comments)</option>
    <option value="Individual_Results_FreeText">Individual Results (Free Text)</option>
    <option value="List_of_Questions">List of Questions</option>
    <option value="Individual_Comment">Individual Result</option>
</select>
<select name="report_view">
</select>

Whenever the report type selected is bar graph or pie chart, it will not display the excel report view, else it will return all three report views.

reference: here

Format source code for blogging

2008-07-03T20:17:00.000-07:00

Taken from here. Applicable only for the first 25 lines of codes.

This is an example of what your text will look like.
    • Tabs are converted to spaces.
    • Quotes and other special characters are converted to HTML.
    • Everything is enclose in HTML's 'pre' and 'code' tags.
    • Style is set:
        • Fixed width font.
        • Shaded box.
        • Dotted line border.

the geek sista

2008-07-03T20:15:00.000-07:00

geek Slang.
–noun
1. a peculiar or otherwise dislikable person, esp. one who is perceived to be overly intellectual.
2. a computer expert or enthusiast (a term of pride as self-reference, but often considered offensive when used by outsiders.)
3. a carnival performer who performs sensationally morbid or disgusting acts, as biting off the head of a live chicken.
[Origin: 1915- 20; prob. var. of geck (mainly Scots) fool < D or LG gek]

the geek refers to the second meaning.

this blog will contains anything related to programming languages, new technologies, to simple html, etc..

all for the programming knowledge only..