Skip to main content

Posts

Determining how to properly call a stored procedure

Set Conn = Server.CreateObject("ADODB.Connection") ' The following line must be changed to reflect your data source info Conn.Open "data source name", "user id", "password" set cmd = Server.CreateObject("ADODB.Command") set cmd.ActiveConnection = Conn ' Specify the name of the stored procedure you wish to call cmd.CommandText = "sp_MyStoredProc" cmd.CommandType = adCmdStoredProc ' Query the server for what the parameters are cmd.Parameters.Refresh %> <Table Border=1> <TR> <TD><B>PARAMETER NAME</B></TD> <TD><B>DATA-TYPE</B></TD> <TD><B>DIRECTION</B></TD> <TD><B>DATA-SIZE</B></TD> </TR> <% For Each param In cmd.Parameters %> <TR> <TD><%= param.name %></TD> <TD><%= param.type %></TD> <TD><%= param.direction %></TD> ...
Post a Comment
Read more

user Emulator to debug Windows Mobile 6 in Vista

open Windows Mobile Device center Mobile Device Setting -> Connection Setting -> Allow connections to one of the following: Change to DMA in vs 2008, Go to Tools -> Device Emulator Manager select one from list, for example: windows mobile 6 professional emulator right on to cradle waiting for popup to establish the relationship (be sure get internet connection from Emulator)
Post a Comment
Read more

PHP Framework - CodeIgniter

create own library: http://codeigniter.com/user_guide/general/creating_libraries.html external library - if don't want to create another php file just for css or js They try this: http://codeigniter.com/forums/viewthread/101236/ If run into any URI issue: external->run(); ?> ? to /: (auto -> query_string, or try any others) $config['uri_protocol'] = "query_string";
Post a Comment
Read more

Secure messaging

Process Secure Messaging The sender writes an eMail online and sends it over a secure SSL-connection to the secure messaging server. The recipient is notified through a normal eMail that a secure message is waiting for delivery on the secure server. The recipient is invited to download the message through a link. The sender provides the recipient with a message unlock code . The code is required in order to access the pending message. If the recipient has already been in contact with the sender through secure messaging server and has registered, this step is not required. The secure message and confidential documents such as contracts, business plans, resumes or loan documents can then be accessed with the message unlock code and downloaded. MUC (Message Unlock Code) A MUC is a message password and protects a message sent to a new communication partner from being seen by erroneous recipients and is used to initiate trust. If a message is sent to a new recipient, the system generates...
Post a Comment
Read more

Disable Allow This Webpage to Access Your Clipboard

Disable Allow This Webpage to Access Your Clipboard Pop-Up Warning Message in IE7 This security feature can be disabled. To disable the pop up warning message about possible harmful or unauthorized Clipboard access, follow the steps below: Go to Tools -> Internet Options. Go to Security tab. Select “Internet” zone, then click on “Custom level…” button. Scroll down to “Scripting” section (at the bottom few). Under “Allow Programmatic clipboard access” option, check or select (tick) Enable. Default action for this option is Prompt, which cause the pop-up message whenever there is any attempt to access the Clipboard. Click Ok twice to exit from Internet Options.
Post a Comment
Read more

Read Excel Date in C#

Microsoft Excel stores dates as sequential numbers known as serial values. DateTime.FromOADate Method Returns a DateTime equivalent to the specified OLE Automation Date. public static DateTime FromOADate( double d ) double _d = double.Parse(values.GetValue(1, i).ToString()); DateTime.FromOADate(_d).ToShortDateString();
Post a Comment
Read more