tag:blogger.com,1999:blog-72746362024-03-12T19:53:37.645-07:00La Vita è BellaThis is where I share my knowledge to all who seeks them. Jackhttp://www.blogger.com/profile/06200715368697291111noreply@blogger.comBlogger36125tag:blogger.com,1999:blog-7274636.post-79698735016907611852013-10-21T18:01:00.003-07:002013-10-21T18:08:35.501-07:00Extract Month/Year from dates in OracleThis is how to extract month or year from Oracle (placing it here so I don't forget)<br />
<br />
By Month -<br />
SELECT EXTRACT(month FROM order_date) "Month",<br />
COUNT(order_date) "No. of Orders"<br />
FROM orders<br />
GROUP BY EXTRACT(month FROM order_date)<br />
ORDER BY "No. of Orders" DESC;<br />
<br />
<br />
By Year -<br />
SELECT EXTRACT(YEAR FROM DATE '1998-03-07') FROM DUAL;<br />
<br />
<br />
For more info, look at this page:<br />
<a href="http://docs.oracle.com/cd/B19306_01/server.102/b14200/functions050.htm">http://docs.oracle.com/cd/B19306_01/server.102/b14200/functions050.htm</a><br />
<br />
<br />
See PDF for more SQL References:<br />
<a href="http://docs.oracle.com/cd/B19306_01/server.102/b14200.pdf">http://docs.oracle.com/cd/B19306_01/server.102/b14200.pdf</a>Jackhttp://www.blogger.com/profile/06200715368697291111noreply@blogger.com2tag:blogger.com,1999:blog-7274636.post-60737334543114089392013-09-24T00:32:00.000-07:002013-09-24T00:32:00.290-07:00Microsoft Access 2007 - VBA functions breaks with missing referenceI have had some issues with applications written in Microsoft Access 2007. I was wondering why all of a sudden this functions will break and would have missing references. Had a bit of research on this error and find this URL from Microsoft :<br />
<br />
<h1 class="title" id="mt_title">
<a href="http://support.microsoft.com/kb/283806">Visual Basic for Applications (VBA) functions break in a database with missing references</a></h1>
<div>
<br /></div>
<div>
The resolution the page had to remove the missing reference is to follow these steps:</div>
<div>
<ol>
<li>Open your database.</li>
<li>Press ALT+F11 to open the Visual Basic Editor.</li>
<li>On the <b>Tools</b> menu, click <b>References</b>. </li>
<li>Click to clear the check box for the type library or object library marked
as <b>MISSING: <referencename>.</referencename></b></li>
</ol>
</div>
Jackhttp://www.blogger.com/profile/06200715368697291111noreply@blogger.com0tag:blogger.com,1999:blog-7274636.post-71035079252196845592012-02-28T20:12:00.002-08:002012-02-28T21:55:40.618-08:00The symbolic meaning of seventy times sevenI was looking for the meaning of the following scripture:<br />Matthew 18:21-22 (NKJV) - Then Peter came to Him and said, "Lord, how often shall my brother sin against me, and I forgive him? Up to seven times?" Jesus said to him, "I do not say to you, up to seven times, but up to seventy times seven.<br /><br />The interesting thing about this verse is that Jesus is not saying that we should forgive 490 times or simply a lot of times for that matter. I came to understand recently that there is a very specific meaning when we look behind the symbolism of those numbers.<br /><br />In the Bible, the number "7" symbolises completeness or a finished work, while the number "70" signifies 'perfect spiritual order carried out with all spiritual power and significance' (E.W.Bullinger, Number in Scripture, Its Supernatural Design and Spiritual Significance, 1921, p.235).<br /><br />Therefore, 490, being the product of 70 x 7, signifies spiritual perfection of perfect order and completeness. Peter asked Jesus how often he should forgive someone and eagerly offered an answer to his own question. He thought that forgiving completely would suffice. But Jesus responded by saying that it wasn't good enough to just forgive completely but to forgive to the point of spiritual perfection!<br /><br />Footnote:<br /><a href="http://www.biblebelievers.org.au/number17.htm#70">http://www.biblebelievers.org.au/number17.htm#70</a>Jackhttp://www.blogger.com/profile/06200715368697291111noreply@blogger.com0tag:blogger.com,1999:blog-7274636.post-51114979713472341932012-02-07T22:22:00.000-08:002012-02-07T22:26:40.676-08:00AutoNumbering in InfoPath forms when submitted to a SharePoint LibraryYou can accomplish this functionality as follows:<br /><br /><br /><br /><ol><br /><br /><li>In SharePoint, create a form library to submit your forms to.</li><br /><br /><li>In InfoPath, create a new (browser-compatible) InfoPath form template.</li><br /><br /><li>Add a Text Box control to the form template and name it autonumber.</li><br /><br /><li>On the Tools menu, click Data Connections.</li><br /><br /><li>On the Data Connections dialog box, click Add, and <a href="http://www.bizsupportonline.net/infopath2007/how-to-add-data-connection-sharepoint-list-library.htm">create a Receive data connection to the SharePoint library</a> that you created in step 1. In step 5 of the data connection wizard, uncheck all fields and then check the ID field. In the last step of the data connection wizard, uncheck Automatically retrieve data when form is opened, name the data connection RetrieveIDs, and click Finish.</li><br /><br /><li>On the Data Connections dialog box, click Add, and create a Submit data connection to the SharePoint library that you created in step 1. In step 3 of the data connection wizard, click the formula button behind the File name field.</li><br /><br /><li>On the Insert Formula dialog box, type max( and then click Insert Field or Group.</li><br /><br /><li>On the Select a Field or Group dialog box, select RetrieveIDs from the Data source drop-down list box, expand all the nodes, click ID, and then click OK.</li><br /><br /><li>On the Insert Formula dialog box, type ) + 1 and click OK.</li><br /><br /><li>On the Data Connection Wizard dialog box, the expression in the File name field should resemble: max(@ID) + 1 </li><br /><br /><li>On the Data Connection Wizard dialog box, click Next, name the data connection Main submit, and then click Finish.</li><br /><br /><li>On the Data Connections dialog box, click Close.</li><br /><br /><li>On the Tools menu, click Submit Options.</li><br /><br /><li>On the Submit Options dialog box, check the Allow users to submit this form checkbox, select the Perform custom actions using rules option, click Advanced, select Close the form from the After submit drop-down list box, and then click Rules.</li><br /><br /><li>On the Rules dialog box, click Add.</li><br /><br /><li>On the Rule dialog box, add an Action that says: Query using data connection: RetrieveIDs </li><br /><br /><li>On the Rule dialog box, add a second Action that says: Set a field's value: autonumber = max(@ID) + 1 Note: @ID is selected from the RetrieveIDs secondary data source in the same way you selected it in step 8. </li><br /><br /><li>On the Rule dialog box, add a third Action that says: Submit using data connection: Main submit </li><br /><br /><li>Click OK when closing all dialog boxes that are currently open.</li><br /><br /><li>Publish the form template to the library you created in step 1. </li></ol><br /><br /><p><br />You should now be able to fill out a form and submit it. The next available number in the form library will be automatically saved in the autonumber field of the form when the form is submitted and this number will also be used for the Name of the form. This solution works for both forms that are filled out through the InfoPath client application as well as those that are filled out through the browser.</p>Jackhttp://www.blogger.com/profile/06200715368697291111noreply@blogger.com0tag:blogger.com,1999:blog-7274636.post-51677897710370345142012-01-15T20:38:00.001-08:002012-01-15T20:40:15.802-08:00The Pledge (2001)I stayed up late watching a suspense detective story directed by Sean Penn and had been released on film last 2001, that will be roughly 11 years ago. I was enticed by the story wanting to know who the killer of all those 8-year old girls killed across the surrounding places. I was also drawn by an all star cast of characters, Jack Nicholson, Benicio del Torro, Helen Mirren, Aaron Eckhart, Sam Sheppard, Robin Wright Penn, etc. It was a good movie but at the end, I never got the chance to see who the killer was which still leaves a big question mark in my head. This is really a good mind-boggling movie.<br /><br /><strong>Synopsis:</strong><br />It started with a discovery of the body of an 8-year old girl named Ginny in the snow by a boy who had his snow mobile malfunctioned. He saw a man leaving the area, scared and in a hurry. Jerry (Jack Nicholson) is a detective nearing his retirement. He only got a few days left from his office when this case struck him. When they informed the parents of the girl about the misfortune, the mother was devastated by the news. Jerry uttered his comforting words to the mother that he will find the killer, and he was asked to swear on the cross which he did. Meanwhile the police caught up the guy who was seen rushing to leave the scene of the crime. He was an American Indian guy who has a brain of a child and mentally incapacitated. Jerry’s partner (Aaron Eckhart), immediately spurs out a confession from the guy and whilst taking him on the cell, he grabbed the gun of the arresting officer and shoots himself. Everybody thought that the case is closed except for Jerry who is noticing something is not right. He investigates further and found out that there are two unsolved cases from the neighbouring towns that are suspiciously similar to his own. Further inquiries reached an older woman who had led him to the grandmother of the girl. He saw the dead girl’s drawing which depicts a tall man handling little porcupines and a black station wagon to which he kept as evidence. He had presented his findings to his colleagues to which they rebut. Jerry was too smart to realize that his colleagues may have him committed to investigate case. So he appears to be living a life of an old retired man. He calculated the place where the killer might struck again. He rented a cabin near the lake. When he saw an old gas station, he offered the owner an opportunity to sell it to him which he eventually gained. So he lived on the house at the back of the gas station and tends to the business as should be. He met and befriends a not-so-lucky-in-love waitress named Lory (Robin Wright Penn) in the restaurant bar. She had an 8-year-old daughter named Chrissy. When the waitress was battered by her husband, she sought comfort from Jerry. In turn, Jerry took them in his house with no commitments. Soon after, he had grown affection on Chrissy and Lori noticed it so she fell in love with him eventually. They had lived a good life but Jerry is still adamant to catch the killer so she warned Chrissy to tell him when she got the chance to meet the tall guy from Ginny’s drawing. One day, Chrissy revealed to Jerry that he had encountered the guy and he even gave him porcupine-like chocolates. The man told her not to tell her parents about the encounter but since Jerry is not related to her, she thought it would be OK without breaking her promise. Jerry immediately knew that this is the guy. Chrissy even asked Jerry if she could meet her on the big playground which he agrees as he was planning to catch the guy by using the girl as bait without the mother knowing all about it. Jerry immediately contacted his colleagues and they followed Chrissy on the big playground as she waits for the man in patient. The team is getting impatient as they wait for the killer and Jerry sense that something is not right again. They had their altercations on the situation to which they left Jerry to look after the girl instead and wait for the killer to show up. Meanwhile, the killer who was riding the black station wagon with a porcupine on the car mirror has all the intention to see and meet Chrissy but was caught by a car accident and burnt to death. Jerry’s team had run into the accident but the car and the person inside are beyond recognisable. When the mother learned Jerry is using the girl as bait to catch the killer, she got so furious and left him for good. Jerry lost his mind as what he thought as a perfect plan to catch the culprit has made him lost his good life. He never learned the mishap the killer had gone through.Jackhttp://www.blogger.com/profile/06200715368697291111noreply@blogger.com0tag:blogger.com,1999:blog-7274636.post-50521158184002910182012-01-10T20:09:00.000-08:002012-01-10T20:47:59.633-08:00Copying or Moving SharePoint ListsHere are some helpful tips on how to copy or move SharePoint lists in MOSS 2007. There are two ways to accomplish this:<br /><br /><ol><br /><li>By using list templates - This is only possible when you meet the following criteria: a) if the data you want to move/copy is less than 10MB; b) You must be a member of a site group with the Manage Lists right on the source site and on the destination site; and c:) The source site and the destination site must be based on the same site template</li><br /><li>By exporting a list to a spreadsheet</li></ol><br /><p><strong>Copy or move a list by using a list template</strong></p>First things first, make sure that the size of the list (if you will import the data as well) must not exceed 10MB, use the Site Settings > Site Administration > View Storage Space Allocations and filter with Document lists to check and locate the target list.<br /><br />To create a list template, go to Documents and Lists and select the list. On the list, select Settings > List Settings and under Permissions and Management click on "Save list as template". Give it a name (filename and template name). Select the Include content check box to include the data. Hit OK. This will appear in your site collection list template gallery.<br /><br />To view the site collection list template gallery, click on Site Actions > Site Settings > Modify All Site Settings. Under Galleries, select list templates.<br /><br />If your sites are not in the same site collection, download the list template from the source site by clicking on the list and saving it on a network drive.<br /><br />On the destination site open the list template gallery on the target site collection. In that page, click on upload and search for the list template you have saved earlier on a network drive.<br /><br />To create a copy of the list, on the destination web site, click on Site Actions > Site Settings > Modify All Site Settings, under Site Administration click on Site libraries and lists. On that page select "Create New Content" and look for the list under Custom Lists.<br /><br />For more information, please visit:<br /><a href="http://office.microsoft.com/en-us/windows-sharepoint-services-help/copying-or-moving-sharepoint-lists-HA001154562.aspx">http://office.microsoft.com/en-us/windows-sharepoint-services-help/copying-or-moving-sharepoint-lists-HA001154562.aspx</a>Jackhttp://www.blogger.com/profile/06200715368697291111noreply@blogger.com0tag:blogger.com,1999:blog-7274636.post-63171689027476394122012-01-08T22:12:00.000-08:002012-01-08T22:16:20.414-08:00SharePoint Custom List with Custom Content Types and Custom Display FormsI got stuck with having multiple content types having custom forms. I could not bind the content types other than the default one. I came accross with a solution on the internet which I would like to add here on my post for future reference (but I am hoping Microsoft will rectify this bug on their end):<br /><br /><a href="http://joshmccarty.com/2011/02/sharepoint-custom-list-with-custom-content-types-and-custom-display-forms/comment-page-1/#comment-1166">http://joshmccarty.com/2011/02/sharepoint-custom-list-with-custom-content-types-and-custom-display-forms/comment-page-1/#comment-1166</a><br /><br />The trick is to make the other content types as default before binding them in the list properties - supporting file. A cumbersome work but it paid off.Jackhttp://www.blogger.com/profile/06200715368697291111noreply@blogger.com0tag:blogger.com,1999:blog-7274636.post-26130097037288664592012-01-05T20:05:00.000-08:002012-01-05T20:14:05.243-08:00SharePoint - The column name you have entered is already in use or reserved. Choose another nameWhen you’re creating columns either the Site Columns or the List Columns in SharePoint, suddenly it might show a message stating “The column name that you entered is already in use or reserved. Choose another name.” Here is the fix for this issue.<br /><br />1. Goto Site Actions > Site Settings > Modify All Site Settings<br />2. Under Galleries, choose Site Content Type<br />3. Select the content type and choose the column<br />4. Edit the column in new window<br />5. On your browser address bar, type the following and enter:<br />javascript:g_FieldName={};alert('Successfully cleared forbidden columns');<br />6. Be sure you get the 'Successfully cleared forbidden columns' alert before proceeding, if not then something is wrong.<br />7. Change the column name and Hit OK<br /><br />I sort of got frustrated with this as I could not return back the column name to its original settings but then thanks to this article as I was relieved from any trouble.<br /><br /><a href="http://blog.weareon.net/fix-for-the-column-name-that-you-entered-is-already-in-use-or-reserved-choose-another-name/">http://blog.weareon.net/fix-for-the-column-name-that-you-entered-is-already-in-use-or-reserved-choose-another-name/</a>Jackhttp://www.blogger.com/profile/06200715368697291111noreply@blogger.com0tag:blogger.com,1999:blog-7274636.post-70561642020432108692012-01-02T15:14:00.000-08:002012-01-02T15:15:58.970-08:00Consider this scenarion in SharePoint webpart:<br />"An unexpected error occured"<br /><br />To work around this issue, use one of the following methods:<br /><br />Recover the broken Web site. To do this, use one of the following methods:<br />1. Access the Web Part Page Maintenance Web page by adding the ?contents=1 query parameter to the Windows SharePoint Services site URL. Verify the Web Part, and then click Delete or Close to remove the Web Part.<br />2. Visit the page library for the Windows SharePoint Services site. Typically, the URL for the page library is as follows:<br />http://SiteName/pages/forms/allitems.aspxOn the menu of the affected Web page, click Discard check out item, and then click Delete or Close.<br />3. Open the Windows SharePoint Services Web site by using SharePoint Designer. On the menu of the affected Web page, select the Web part, click Discard check out item, and then click Delete or Close.Jackhttp://www.blogger.com/profile/06200715368697291111noreply@blogger.com0tag:blogger.com,1999:blog-7274636.post-11073884875913543742011-09-22T20:16:00.000-07:002011-09-22T20:21:19.644-07:00InfoPath om MOSS 2007 Current User ProfileHere is a blog to get the current user information without having to write a code and it works like a charm. Keeping a link here to for reference:<br /><br /><a href="http://blogs.microsoft.co.il/blogs/itaysk/archive/2007/04/05/InfoPath-_2D00_-Get-the-current-user-without-writing-code.aspx">InfoPath - blog from Itay Shakury</a><br /><br /><a href="http://claytoncobb.wordpress.com/2009/06/21/userprofileservice-extended/">InfoPath - Get user information without writing code (extended) - Clayton Cobb</a>Jackhttp://www.blogger.com/profile/06200715368697291111noreply@blogger.com0tag:blogger.com,1999:blog-7274636.post-69834666838749377432011-03-31T21:32:00.001-07:002011-03-31T21:32:03.949-07:00Excel Tip – Show Hyperlinks<span xmlns=''><p><span style='font-family:Courier New; font-size:10pt'>How to extract Hyperlinks in EXCEL. Create a module (User-Defined function) as described below. Save and use it as you would like a formula.<br /></span></p><p><br /> </p><p><span style='font-family:Courier New; font-size:10pt'>Function GetURL(rng As Range) As String<br /></span></p><p><span style='font-family:Courier New; font-size:10pt'> On Error Resume Next<br /></span></p><p><span style='font-family:Courier New; font-size:10pt'> GetURL = rng.Hyperlinks(1).Address<br /></span></p><p><span style='font-family:Courier New; font-size:10pt'>End Function<br /></span></p><p><br /> </p></span>Jackhttp://www.blogger.com/profile/06200715368697291111noreply@blogger.com0tag:blogger.com,1999:blog-7274636.post-13203354120957823722010-12-14T21:11:00.001-08:002010-12-14T21:11:46.459-08:00Modifying the FrontPage Date/Time Web Component<span xmlns=''><p><br /> </p><p>I thought this might be something useful in the future as I deal with MS Frontpage and Sharepoint designer at the moment.<br /></p><p><a href='http://blogs.msdn.com/b/lisawoll/archive/2004/12/17/323871.aspx'>http://blogs.msdn.com/b/lisawoll/archive/2004/12/17/323871.aspx</a><br /> </p><p>A good reference to look up to.<br /></p></span>Jackhttp://www.blogger.com/profile/06200715368697291111noreply@blogger.com0tag:blogger.com,1999:blog-7274636.post-32965426668479693022010-09-22T18:06:00.001-07:002010-09-22T18:07:01.439-07:00CSS Hover EffectI find this article informative so I am linking the site to my blog so I won't forget:<br /><br /><a href="http://veerle-v2.duoh.com/blog/comments/css_hover_effect/">http://veerle-v2.duoh.com/blog/comments/css_hover_effect/</a>Jackhttp://www.blogger.com/profile/06200715368697291111noreply@blogger.com0tag:blogger.com,1999:blog-7274636.post-20409512000191396712010-04-29T18:12:00.000-07:002010-04-29T18:22:47.500-07:00Tool for uploading Excel file in Coldfusion<p class="MsoNormal"><o:p><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;">This tool needs to be purchased before using it but this is really cool. For all CF enthusiasts who needs to upload from excel files, check this out.</span></span></o:p></p> <p class="MsoNormal"><b><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;">What Is CFX_Excel2Query?</span></span><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;"><o:p></o:p></span></span></b></p> <p class="MsoNormal"><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;">Transform a Microsoft Excel file into a ColdFusion query without installing Excel on your server! This tag is written in 100% java, so there is no need for the dreaded COM. This tag works best with simple Excel files, but many have had luck with extremely complex files.</span></span></p> <p class="MsoNormal"><strong><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;">Usage</span></span></strong></p> <p class="MsoNormal"><span style="color:maroon;"><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;"><cfx_excel2query<br /> file=</span></span></span><span style="color:blue;"><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;">"[path_to_xls_file]"</span></span></span><span style="color:maroon;"><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;"><br /> firstRowIsHeader=</span></span></span><span style="color:blue;"><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;">"[true|false]"</span></span></span><span style="color:maroon;"><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;"><br /> sheet_name=</span></span></span><span style="color:blue;"><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;">"[worksheet_name]"</span></span></span><span style="color:maroon;"><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;"><br /> sheet_num=</span></span></span><span style="color:blue;"><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;">"[worksheet_number]"</span></span></span><span style="color:maroon;"><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;"><br /> startRow=</span></span></span><span style="color:blue;"><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;">"[starting_row]"</span></span></span><span style="color:maroon;"><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;"><br /> maxRows=</span></span></span><span style="color:blue;"><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;">"[max_rows]"</span></span></span><span style="color:maroon;"><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;"><br /> longNames=</span></span></span><span style="color:blue;"><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;">"[true|false]"</span></span></span><span style="color:maroon;"><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;"><br /> r_qResults=</span></span></span><span style="color:blue;"><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;">"[query_variable_name]"</span></span></span><span style="color:maroon;"><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;">><o:p></o:p></span></span></span></p><p class="MsoNormal"><span style="color:maroon;"><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;"><br /></span></span></span></p> <p class="MsoNormal"><span style="color:maroon;"><o:p><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;"> </span></span></o:p></span></p> <p class="MsoNormal"><o:p><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;"> </span></span></o:p></p> <table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="574" style="width:430.55pt;mso-cellspacing:0in"> <tbody><tr style="mso-yfti-irow:0;mso-yfti-firstrow:yes;height:13.1pt"> <td style="background:#6B755A;padding:.75pt .75pt .75pt .75pt;height:13.1pt"> <p class="MsoNormal"><b><span style="font-family:Tahoma;color:white;"><span class="Apple-style-span" style="font-size:small;"><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;">Attribute</span></span></span></span></b><span style="font-family:Tahoma;"><span class="Apple-style-span" style="font-size:small;"><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;"><o:p></o:p></span></span></span></span></p> </td> <td style="background:#6B755A;padding:.75pt .75pt .75pt .75pt;height:13.1pt"> <p class="MsoNormal" align="center" style="text-align:center"><b><span style="font-family:Tahoma;color:white;"><span class="Apple-style-span" style="font-size:small;"><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;">Req'd</span></span></span></span></b><span style="font-family:Tahoma;"><span class="Apple-style-span" style="font-size:small;"><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;"><o:p></o:p></span></span></span></span></p> </td> <td style="background:#6B755A;padding:.75pt .75pt .75pt .75pt;height:13.1pt"> <p class="MsoNormal"><b><span style="font-family:Tahoma;color:white;"><span class="Apple-style-span" style="font-size:small;"><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;">Description</span></span></span></span></b><span style="font-family:Tahoma;"><span class="Apple-style-span" style="font-size:small;"><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;"><o:p></o:p></span></span></span></span></p> </td> </tr> <tr style="mso-yfti-irow:1;height:14.1pt"> <td width="104" valign="top" style="width:77.8pt;padding:.75pt .75pt .75pt .75pt; height:14.1pt"> <p class="MsoNormal"><b><span style="font-family:Tahoma;"><span class="Apple-style-span" style="font-size:small;"><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;">file</span></span></span></span></b><span style="font-family:Tahoma;"><span class="Apple-style-span" style="font-size:small;"><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;"><o:p></o:p></span></span></span></span></p> </td> <td width="45" valign="top" style="width:34.05pt;padding:.75pt .75pt .75pt .75pt; height:14.1pt"> <p class="MsoNormal" align="center" style="text-align:center"><span style="font-family:Tahoma;"><span class="Apple-style-span" style="font-size:small;"><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;">Yes<o:p></o:p></span></span></span></span></p> </td> <td valign="top" style="padding:.75pt .75pt .75pt .75pt;height:14.1pt"> <p class="MsoNormal"><span style="font-family:Tahoma;"><span class="Apple-style-span" style="font-size:small;"><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;">full path the Microsoft Excel file<o:p></o:p></span></span></span></span></p> </td> </tr> <tr style="mso-yfti-irow:2;height:14.1pt"> <td width="104" valign="top" style="width:77.8pt;padding:.75pt .75pt .75pt .75pt; height:14.1pt"> <p class="MsoNormal"><b><span style="font-family:Tahoma;"><span class="Apple-style-span" style="font-size:small;"><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;">r_qResults</span></span></span></span></b><span style="font-family:Tahoma;"><span class="Apple-style-span" style="font-size:small;"><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;"><o:p></o:p></span></span></span></span></p> </td> <td width="45" valign="top" style="width:34.05pt;padding:.75pt .75pt .75pt .75pt; height:14.1pt"> <p class="MsoNormal" align="center" style="text-align:center"><span style="font-family:Tahoma;"><span class="Apple-style-span" style="font-size:small;"><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;">Yes<o:p></o:p></span></span></span></span></p> </td> <td valign="top" style="padding:.75pt .75pt .75pt .75pt;height:14.1pt"> <p class="MsoNormal"><span style="font-family:Tahoma;"><span class="Apple-style-span" style="font-size:small;"><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;">the variable in which to store the resulting query<o:p></o:p></span></span></span></span></p> </td> </tr> <tr style="mso-yfti-irow:3;height:27.2pt"> <td width="104" valign="top" style="width:77.8pt;padding:.75pt .75pt .75pt .75pt; height:27.2pt"> <p class="MsoNormal"><b><span style="font-family:Tahoma;"><span class="Apple-style-span" style="font-size:small;"><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;">firstRowIsHeader</span></span></span></span></b><span style="font-family:Tahoma;"><span class="Apple-style-span" style="font-size:small;"><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;"><o:p></o:p></span></span></span></span></p> </td> <td width="45" valign="top" style="width:34.05pt;padding:.75pt .75pt .75pt .75pt; height:27.2pt"> <p class="MsoNormal" align="center" style="text-align:center"><span style="font-family:Tahoma;"><span class="Apple-style-span" style="font-size:small;"><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;">No<o:p></o:p></span></span></span></span></p> </td> <td valign="top" style="padding:.75pt .75pt .75pt .75pt;height:27.2pt"> <p class="MsoNormal"><span style="font-family:Tahoma;"><span class="Apple-style-span" style="font-size:small;"><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;">specifies whether or not the first row of the Microsoft Excel file should be used for the column names in the query<o:p></o:p></span></span></span></span></p> </td> </tr> <tr style="mso-yfti-irow:4;height:27.2pt"> <td width="104" valign="top" style="width:77.8pt;padding:.75pt .75pt .75pt .75pt; height:27.2pt"> <p class="MsoNormal"><b><span style="font-family:Tahoma;"><span class="Apple-style-span" style="font-size:small;"><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;">sheet_name</span></span></span></span></b><span style="font-family:Tahoma;"><span class="Apple-style-span" style="font-size:small;"><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;"><o:p></o:p></span></span></span></span></p> </td> <td width="45" valign="top" style="width:34.05pt;padding:.75pt .75pt .75pt .75pt; height:27.2pt"> <p class="MsoNormal" align="center" style="text-align:center"><span style="font-family:Tahoma;"><span class="Apple-style-span" style="font-size:small;"><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;">No<o:p></o:p></span></span></span></span></p> </td> <td valign="top" style="padding:.75pt .75pt .75pt .75pt;height:27.2pt"> <p class="MsoNormal"><span style="font-family:Tahoma;"><span class="Apple-style-span" style="font-size:small;"><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;">specifies a specific worksheet name (case sensitive) to use from the Microsoft Excel file<o:p></o:p></span></span></span></span></p> </td> </tr> <tr style="mso-yfti-irow:5;height:28.2pt"> <td width="104" valign="top" style="width:77.8pt;padding:.75pt .75pt .75pt .75pt; height:28.2pt"> <p class="MsoNormal"><b><span style="font-family:Tahoma;"><span class="Apple-style-span" style="font-size:small;"><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;">sheet_num</span></span></span></span></b><span style="font-family:Tahoma;"><span class="Apple-style-span" style="font-size:small;"><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;"><o:p></o:p></span></span></span></span></p> </td> <td width="45" valign="top" style="width:34.05pt;padding:.75pt .75pt .75pt .75pt; height:28.2pt"> <p class="MsoNormal" align="center" style="text-align:center"><span style="font-family:Tahoma;"><span class="Apple-style-span" style="font-size:small;"><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;">No<o:p></o:p></span></span></span></span></p> </td> <td valign="top" style="padding:.75pt .75pt .75pt .75pt;height:28.2pt"> <p class="MsoNormal"><span style="font-family:Tahoma;"><span class="Apple-style-span" style="font-size:small;"><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;">specifies a worksheet by a number (zero-based; first sheet is zero, second sheet is 1, etc) - If sheet_num and sheet_name are both specified, sheet_num is used.<o:p></o:p></span></span></span></span></p> </td> </tr> <tr style="mso-yfti-irow:6;height:27.2pt"> <td width="104" valign="top" style="width:77.8pt;padding:.75pt .75pt .75pt .75pt; height:27.2pt"> <p class="MsoNormal"><b><span style="font-family:Tahoma;"><span class="Apple-style-span" style="font-size:small;"><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;">columnlist</span></span></span></span></b><span style="font-family:Tahoma;"><span class="Apple-style-span" style="font-size:small;"><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;"><o:p></o:p></span></span></span></span></p> </td> <td width="45" valign="top" style="width:34.05pt;padding:.75pt .75pt .75pt .75pt; height:27.2pt"> <p class="MsoNormal" align="center" style="text-align:center"><span style="font-family:Tahoma;"><span class="Apple-style-span" style="font-size:small;"><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;">No<o:p></o:p></span></span></span></span></p> </td> <td valign="top" style="padding:.75pt .75pt .75pt .75pt;height:27.2pt"> <p class="MsoNormal"><span style="font-family:Tahoma;"><span class="Apple-style-span" style="font-size:small;"><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;">the list of column names in their original order is returned to the variable you choose here (especially useful when firstRowIsHeader)<o:p></o:p></span></span></span></span></p> </td> </tr> <tr style="mso-yfti-irow:7;height:14.1pt"> <td width="104" valign="top" style="width:77.8pt;padding:.75pt .75pt .75pt .75pt; height:14.1pt"> <p class="MsoNormal"><b><span style="font-family:Tahoma;"><span class="Apple-style-span" style="font-size:small;"><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;">startRow</span></span></span></span></b><span style="font-family:Tahoma;"><span class="Apple-style-span" style="font-size:small;"><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;"><o:p></o:p></span></span></span></span></p> </td> <td width="45" valign="top" style="width:34.05pt;padding:.75pt .75pt .75pt .75pt; height:14.1pt"> <p class="MsoNormal" align="center" style="text-align:center"><span style="font-family:Tahoma;"><span class="Apple-style-span" style="font-size:small;"><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;">No<o:p></o:p></span></span></span></span></p> </td> <td valign="top" style="padding:.75pt .75pt .75pt .75pt;height:14.1pt"> <p class="MsoNormal"><span style="font-family:Tahoma;"><span class="Apple-style-span" style="font-size:small;"><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;">The row number, starting at 1, you would like to start from<o:p></o:p></span></span></span></span></p> </td> </tr> <tr style="mso-yfti-irow:8;height:13.1pt"> <td width="104" valign="top" style="width:77.8pt;padding:.75pt .75pt .75pt .75pt; height:13.1pt"> <p class="MsoNormal"><b><span style="font-family:Tahoma;"><span class="Apple-style-span" style="font-size:small;"><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;">maxRows</span></span></span></span></b><span style="font-family:Tahoma;"><span class="Apple-style-span" style="font-size:small;"><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;"><o:p></o:p></span></span></span></span></p> </td> <td width="45" valign="top" style="width:34.05pt;padding:.75pt .75pt .75pt .75pt; height:13.1pt"> <p class="MsoNormal" align="center" style="text-align:center"><span style="font-family:Tahoma;"><span class="Apple-style-span" style="font-size:small;"><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;">No<o:p></o:p></span></span></span></span></p> </td> <td valign="top" style="padding:.75pt .75pt .75pt .75pt;height:13.1pt"> <p class="MsoNormal"><span style="font-family:Tahoma;"><span class="Apple-style-span" style="font-size:small;"><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;">The total number of rows from startRow that you want to return<o:p></o:p></span></span></span></span></p> </td> </tr> <tr style="mso-yfti-irow:9;mso-yfti-lastrow:yes;height:14.1pt"> <td width="104" valign="top" style="width:77.8pt;padding:.75pt .75pt .75pt .75pt; height:14.1pt"> <p class="MsoNormal"><b><span style="font-family:Tahoma;"><span class="Apple-style-span" style="font-size:small;"><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;">longNames</span></span></span></span></b><span style="font-family:Tahoma;"><span class="Apple-style-span" style="font-size:small;"><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;"><o:p></o:p></span></span></span></span></p> </td> <td width="45" valign="top" style="width:34.05pt;padding:.75pt .75pt .75pt .75pt; height:14.1pt"> <p class="MsoNormal" align="center" style="text-align:center"><span style="font-family:Tahoma;"><span class="Apple-style-span" style="font-size:small;"><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;">No<o:p></o:p></span></span></span></span></p> </td> <td valign="top" style="padding:.75pt .75pt .75pt .75pt;height:14.1pt"> <p class="MsoNormal"><span style="font-family:Tahoma;"><span class="Apple-style-span" style="font-size:small;"><span class="Apple-style-span" style="font-family:'trebuchet ms';"><span class="Apple-style-span" style="font-size:small;">Use zero padding on column names (i.e. column001,column002,..,columnN)<o:p></o:p></span></span></span></span></p> </td> </tr> </tbody></table> <p class="MsoNormal"><o:p> </o:p></p>Jackhttp://www.blogger.com/profile/06200715368697291111noreply@blogger.com0tag:blogger.com,1999:blog-7274636.post-35117856639745872252010-04-13T19:43:00.000-07:002010-04-13T19:44:05.470-07:00How to get the first day of the week in SQL ServerCREATE FUNCTION [dbo].[udf_GetFirstDayOfWeek]( <br />@pInputDate DATETIME <br />)<br />RETURNS DATETIME<br />BEGIN<br /><br />SET @pInputDate = CONVERT(VARCHAR(10), @pInputDate, 111)<br />RETURN DATEADD(DD, 1 - DATEPART(DW, @pInputDate),<br /> @pInputDate)<br /><br />END<br />GOJackhttp://www.blogger.com/profile/06200715368697291111noreply@blogger.com0tag:blogger.com,1999:blog-7274636.post-56303867494169964392010-03-30T21:47:00.000-07:002010-03-30T21:50:17.240-07:00Code samples of JQuery Events<a href="http://jetlogs.org/2007/09/03/jquery-select-boxes-and-change-events/">Select Boxes and change() events</a>Jackhttp://www.blogger.com/profile/06200715368697291111noreply@blogger.com0tag:blogger.com,1999:blog-7274636.post-58270802047725442562009-11-04T07:49:00.000-08:002009-11-04T12:08:19.994-08:00jqGrid Documentation<p><br />The link is for <a href="http://www.secondpersonplural.ca/jqgriddocs/index.htm">jgGrid 3.4 version</a><br /><br />This is a good source of information for all developers who are using jQuery jqGrid plugin.<br /></p>Jackhttp://www.blogger.com/profile/06200715368697291111noreply@blogger.com0tag:blogger.com,1999:blog-7274636.post-76609249573244356762009-11-04T07:47:00.000-08:002009-11-04T12:07:22.984-08:00MS SQL Military and Standard Time Format<p><br />There are times that you want to display non-Military or AM/PM time format. The standard Convert formats do not have an option to return the time in this format. The SQL below will return only the time portion of the current date/time in the AM/PM format. <br /><br /><br /><br /><em>SELECT substring(convert(varchar(20), GetDate(), 9), 13, 5) + ' ' + substring(convert(varchar(30), GetDate(), 9), 25, 2)<</em>br /><br /><br /><br />However, when you want to retrieve the military time format:<br /><br /><br /><br /><em>SELECT CONVERT(CHAR(10),GETDATE(),108)</em><br /><br /><br /><br />You can replace the GetDate function with any datetime field to return the time portion of that field.<br /><br /></p>Jackhttp://www.blogger.com/profile/06200715368697291111noreply@blogger.com0tag:blogger.com,1999:blog-7274636.post-88704229371360018112009-10-28T09:57:00.000-07:002009-10-28T10:02:30.675-07:00Web Page OptimizationA good reference for overall site speed: <blockquote><a href="http://developer.yahoo.com/performance/rules.html">Best Practices for Speeding Up Your Web Site at Yahoo</a></blockquote>It describes some important techniques in keeping a site loading quickly.Jackhttp://www.blogger.com/profile/06200715368697291111noreply@blogger.com0tag:blogger.com,1999:blog-7274636.post-21326557351643827092009-09-07T03:15:00.000-07:002009-09-07T03:19:52.099-07:00Philippine Holidays for 2009Gloria Macapagal Arroyo signs Philippine Proclamation no. 1699 outlining the Philippine Holidays for 2009. Isn't it great to live in the Philippines as you get more holidays. <br /><br />Check this out: <a href="http://www.op.gov.ph/directives/Proc1699.pdf">Proclamation no. 1699</a>Jackhttp://www.blogger.com/profile/06200715368697291111noreply@blogger.com0tag:blogger.com,1999:blog-7274636.post-78706202344966856962009-04-29T06:18:00.000-07:002009-04-29T06:21:02.716-07:00Start of Something GoodNow those who had been scattered went about preaching the word. – Acts 8:4 <br /><br />When Margaret first came to the U.S., she didn’t speak English well. She needed money so she went out looking for a job. She lied about her age so she could be hired as a waitress. After going through several jobs, she became the head waitress at a vegetarian hotel in New York.She took up law and after graduating in 1976, she found it difficult to find a good job. She was Asian and there were very few Asian women practicing law. She got fired several times but each time she learned something. Now, she is a successful immigration lawyer and has her own law firm.In today’s first reading, a severe persecution of the church broke out in Jerusalem. The Christians were scattered “throughout the countryside of Judea and Samaria.” But their sufferings brought about the spreading of the Gospel. We may not understand why things happen. They may appear to be tragedies or misfortunes but God can bring good out of it in order to fulfill His purposes. We just have to trust His heart for He knows what’s best. - by Judith Concepcion <br /><br />REFLECTION: Are you suffering right now? Maybe God is working something in you. He will bring great results out of your suffering. <br /><br />Lord, help me to trust in YouJackhttp://www.blogger.com/profile/06200715368697291111noreply@blogger.com0tag:blogger.com,1999:blog-7274636.post-3349547945355214952009-03-04T10:10:00.001-08:002009-03-04T10:10:13.023-08:00WAIT<span xmlns=''><p><span style='font-family:Arial; font-size:10pt'> </span>People nowadays would prefer to accomplish many things within a short period of time. They treat time as something very precious and valuable. Some of them would even prefer to shorten their meal times by eating instant and ready-to-eat food so that they can save time. Students also have a quick, easy and instant access to information through the Internet. This would require them a smaller amount of time to spend in research. These are just some realities that make our lives more convenient. These realities spare us from waiting for a long time to accomplish things through the long and traditional processes. <br /></p><p style='text-align: justify'>But there are certain tasks in life that require us to take the long process and wait. And I think this is what Jesus was referring to when He said, "Ask and it will be given to you, search and you will find, knock and the door will be opened to you." When Jesus said these words, He does not mean that we can easily get what we pray for, just like eating instant noodles. When we come to meet Jesus in prayer and ask for something, He does not readily give us the answer to our prayer. Instead, He gives us certain situations in life that form part of the process in achieving what we pray for.<br /></p><p style='text-align: justify'>Why does God want us to undergo the long process? Perhaps it is because He wants to teach us something that we might miss if He would readily give us the answer to our prayers. It is the waiting and going through the process that matter most. We are not mere passive recipients. And this is what Jesus taught us. In the desire of God to save us from our sins, He chose to undergo the long process of becoming man like us. He chose to suffer and to experience the excruciating pains as He was nailed to the cross. God had the option to save us by just a single stroke of His hand. But He did not choose that. He chose to wait and to undergo the long and hard process so that people may truly learn and believe in Him. <em>Fr. Joel O. Jason</em><br /> </p><p style='text-align: justify'> <br /> </p><p style='text-align: justify'><strong>Reflection Questions:</strong><br /> </p><p style='text-align: justify'>How willing am I to wait and to choose the long process?<br /></p><p style='text-align: justify'> <br /> </p><p style='text-align: justify'><em>Lord, help me to learn Your ways. May I be patient enough to wait and to choose the long process so that I may learn more the lessons You want to teach me. Amen. </em><br /> </p></span>Jackhttp://www.blogger.com/profile/06200715368697291111noreply@blogger.com0tag:blogger.com,1999:blog-7274636.post-50710557300934096192009-03-02T15:03:00.001-08:002009-03-02T15:03:44.069-08:00Closing Cycles<span xmlns=''><p><em>By Paulo Coelho</em><br/><span style='font-size:10pt'><br/><br/></span>One always has to know when a stage comes to an end. If we insist on <br/>staying longer than the necessary time, we lose the happiness and the <br/>meaning of the other stages we have to go through.<br/><br/>Closing cycles, shutting doors, ending chapters whatever name we give <br/>it, what matters is to leave in the past the moments of life that have <br/>finished. Did you lose your job? Has a loving relationship come to an <br/>end? Did you leave your parents' house? Gone to live abroad? Has a <br/>long-lasting friendship ended all of sudden?<br/><br/>You can spend a long time wondering why this has happened. You can tell <br/>yourself you won't take another step until you find out why certain <br/>things that were so important and so solid in your life have turned into dust, just like that. But such an attitude will be awfully stressing for everyone involved: your parents, your husband or wife, your friends, your children, your sister, everyone will be finishing chapters, turning over new leaves, getting on with life, and they will all feel bad seeing you at a standstill.<br/><br/>None of us can be in the present and the past at the same time, not even when we try to understand the things that happen to us. What has passed will not return: we cannot for ever be children, late adolescents, sons that feel guilt or rancor towards our parents, lovers who day and night relive an affair with someone who has gone away and has not the least intention of coming back.<br/><br/>Things pass, and the best we can do is to let them really go away. That <br/>is why it is so important (however painful it maybe!) to destroy souvenirs, move, give lots of things away to orphanages, sell or donate <br/>the books you have at home.<br/><br/>Everything in this visible world is a manifestation of the invisible <br/>world, of what is going on in our hearts and getting rid of certain <br/>memories also means taking some room for other memories to take their place.<br/><br/>Let things go. Release them. Detach yourself from them. Nobody plays <br/>this life with marked cards, so sometimes we win and sometimes we lose. <br/>Do not expect anything in return, do not expect your efforts to be appreciated, your genius to be discovered, your love to be understood. Stop turning on your emotional television to watch the same program over and over again, the one that shows how much you suffered from a certain loss: that is only poisoning you, nothing else. Nothing is more dangerous than not accepting love relationships that are broken off, work that is promised but there is no starting date, decisions that are always put off waiting for the ideal moment. Before a new hapter is begun, the old one has to be finished: tell yourself that what has passed will never come back. Remember that there was a time when you could live without that thing or that person. Nothing is irreplaceable. A habit is not a need. This may sound so obvious, it may even be difficult, but it is very important.<br/><br/>Closing cycles. Not because of pride, incapacity or arrogance, but <br/>simply because that no longer fits your life. Shut the door, change the <br/>record, clean the house, shake off the dust. Stop being who you were, <br/>and change into who you are.<br /></p></span>Jackhttp://www.blogger.com/profile/06200715368697291111noreply@blogger.com0tag:blogger.com,1999:blog-7274636.post-71250063284810243802008-10-31T08:44:00.001-07:002008-10-31T08:44:11.621-07:00Discovering the Secret Echo<span xmlns=''><p><em><strong>By Margaret Feinberg</strong><br /> </em></p><p><br/><br/>When God really wants to get your attention, He doesn't just say something once. He echoes. The same scripture, idea, or theme will reappear until you can't help but wonder if a greater something, or Someone, is at work. <br/><br/>The persistent voice of God in our lives--the sacred echo--is available if we take time to slow down and really listen. But do you begin to hear God's voice in your life?<br/><br/><strong>1. Take Time to Seek God</strong><br/><br/>The first step is to take time to seek God. What does it look like to seek Him? Well, King David displayed his search for God in his life, his leadership, and even the songs he wrote. In Psalm 63, he wrote, "Oh God, you are my God, earnestly I seek you; my soul thirsts for you, my body longs for you, in a dry and weary land where there is no water." <br/><br/>So how can you seek God? Through prayer--which is simply talking to God. Spend time letting God know your concerns, your questions, your doubts. Ask God to speak to you. At the same time, don't forget to take time to thank God for who He is and all that He has done. <br/><br/><br/><br/><strong><br/><br/><br/>2. Be Honest, Be Dependent</strong><br/><br/>In our modern world, it's easy to think you can do things on your own. But if you want to begin hearing God's voice, you need to seek Him and recognize your dependence on Him. <br/><br/>That means being honest with Him. Admit your need for Him. Confess your disappointment with Him. Ask Him to give you ears to hear and eyes to see the ways in which He is speaking. And ask Him for the ability to discern His voice apart from your own. <br /><div style='text-align: right'><table border='0' style='border-collapse:collapse'><colgroup><col style='width:0px'/></colgroup><tbody valign='top'><tr><td vAlign='middle'> </td></tr></tbody></table></div><p><strong>3. Hear God in Scripture</strong><br /> </p><p style='text-align: right'><br /> </p><p>Next, it's essential to spend time in scripture. The Bible is like God's megaphone for His people. That's why Hebrews 4:12-13 describes the Word of God as "living" and "active." If you want to hear God's voice in every aspect of your life, then you need to spend time in the Word, because scripture provides balance, confirmation and direction. <br/><br/>Many times a scripture will be an actual sacred echo. For example, you may read Matthew 5, which says, "Blessed are the peacemakers, for they will be called sons of God" and find a much needed reminder on the attitude you need to deal with a conflict in your life. God may use scripture to expose an area of sin, compel you to give or serve, or confirm something He's already spoken to your heart. <br /></p><p style='text-align: right'><br /> <table border='0' style='border-collapse:collapse'><colgroup><col style='width:0px'/></colgroup><tbody valign='top'><tr><td vAlign='middle'> </td></tr></tbody></table><p style='text-align: right'>I<br /></p><p><strong><br/>4. Ask God Questions</strong><br/><br/>As you're spending time in the Bible, consider prayerfully asking God questions. It may seem simple, but asking God a question implies humility and dependency. Ask God to give you insight. Ask Him to reveal things that are hidden. Ask Him to show you how to pray. Ask Him to reveal Himself to you. Ask and keep asking. <br/><br/>You may even want to write down small question marks next to scriptures that you don't understand. These portions can be explored later in commentaries and in discussions with members of your spiritual community.<br/><br/>(<em>I specifically like this, it seems futile that these are all questions the picture speaks for itself. But I trust that the answer is something worth waiting for....</em>.that excites me more than anything else yay!)<br/><br/><br/><br/><br/><br/><strong><br/>5. Be Quiet, and Listen</strong><br/><br/>As you're spending time in scripture and asking God questions, it's essential to take time to listen. <br/><br/>You may find that a certain issue or person keeps coming to your mind. Spend time praying about that situation and individual. Or you may find that a verse or passage applies perfectly to the circumstances in your life. Thank God for the His wisdom. Or you may feel compelled to drop a note or call someone out of the blue. Be sure to follow through on these nudges. You may discover that God is speaking to you--convicting, revealing, exhorting, and communicating with you! <br /><div style='text-align: right'><table border='0' style='border-collapse:collapse'><colgroup><col style='width:0px'/></colgroup><tbody valign='top'><tr><td vAlign='middle'> </td></tr></tbody></table></div><p><strong>6. Practice Hearing the Echoes</strong><br /> </p><p style='text-align: right'><br /> </p><p>After you've tried these things, if you still find yourself struggling to hear God's voice, try some very practical steps. <br/><br/>Find a quiet place where you can unplug from the busyness of the day. You may discover that the challenge of Psalm 46:10 to "Be still, and know that I am God" takes practice. <br/><br/>In addition, you may find distractions of to-do's filling your mind. Keep a pen and pad of paper nearby to write those things down as they flutter through your mind. Then intentionally return to the time of stillness. <br/><br/>Finally, you may discover that spending more time in worship--whether through music or scripture read aloud--can be a helpful tool to drawing your focus to God and what He has for you. <br /></p><p><br/><strong><br/>7. How to Know if it's God</strong><br/><br/>As you begin to hear things, you may find yourself wondering, "Was that God or not?" That's why the scripture is so important. If you feel something that goes against God's commands, then it isn't from Him. Remember that He's in the business of loving and redeeming mankind. <br/><br/>Some questions to ask yourself when evaluating the echo: <br /></p><ul><li>Does what I heard line up with the vision God has for my life? <br /></li></ul></p><ul><li>Does what I heard line up with the wise counsel in my life? <br /></li></ul></p><ul><li>Does what I heard leave me with a sense of peace? <br /></li></ul></p><ul><li>Is what I heard blanketed with love? <br /></li></ul><p><br/><br/><br/><strong>Be Patient--Speak, Listen, and Wait</strong><br /> </p><p>Along the journey of hearing from God, don't lose heart or patience. Developing any spiritual discipline takes time. It requires a measure of hard work and waiting. Remember that prayer has three parts: speaking, listening, and waiting. Take time with each one. <br/><br/>As Philippians 4:6 encourages, "Be anxious for nothing, but in everything by prayer and supplication with thanksgiving let your request be made known to God." When you do, you may be surprised and delighted that God is speaking to you more than you ever imagined.</p></span>Jackhttp://www.blogger.com/profile/06200715368697291111noreply@blogger.com0tag:blogger.com,1999:blog-7274636.post-74776243197242643952008-10-30T10:13:00.001-07:002008-10-30T10:13:10.862-07:00Coldfusion Administrator Resetting of Password <span xmlns=''><p>I am thinking this might be useful and handy in the future, so let me put this in my blog as entry. I keep on forgetting password I specify so I would know how to reset them eventually. This one is for ColdFusion Administration for versions ColdFusion 6 MX, ColdFusion 7 MX, and ColdFusion 8:<br /></p><p><br /> </p><p>-Stop the "ColdFusion MX Application Server" Service <br /></p><p>-Open the "neo-security.xml" file contained at %CFMXInstallRoot%\lib <br /></p><p>-Find the line: "<var name='admin.security.enabled'><boolean value='true'/></var>" and change the true to false, then save the file <br /></p><p>-Restart the "ColdFusion MX Application Server" Service <br /></p><p>-Go to the ColdFusion Administrator again and set a password<br /></p></span>Jackhttp://www.blogger.com/profile/06200715368697291111noreply@blogger.com0