How To’s | Colors and Spices

Changing URL Sites

By: Lique

07-10-2010

Dear Readers,

Kung napansin nyo, nag semi-down yung website ko. And I was so depressed-frustrated-anxious-whatever dahil sa nangyare. Ano nga ba nangyare? Eto kwento ko po.

That day na nag emergency leave ako from office kase I had to undergo series of check-ups, nung kinahapunan na wala na ako magawa at ang dami ko inspirasyon para magsulat ng blog at busisiin ang wordpress ay sya ring araw na nasabi ko “Sana pumasok na lang ako” at “Badtrip huhuhu” at “ano ba yun simpleng config lang”.

Eto kase yung nangyare. Sa sobrang ka-curious-an ko, tinry ko magchange ng mga settings sa admin page.

Original Settings

After changes. Curious lang naman kase sabi nga sa

field, wordpress URL. why not!

What’s Up McKinley

By: Lique

11-09-2010

How To's

When VM, our HR Rep, told us(startgroup) during the New Joiners’ Orientation that we will be deployed in McKinley, I said “Noooo Wayy!”. Even before my first day in Accenture, umaasa akong hindi mapapunta sa McKinley. Ok na ko sa MSE or sa Cybergate. Wag lang talaga McKinley. But it failed me. My words then was “napatapon kami sa McKinley”. But after almost a year and a half, I’m thankful that I am in McKinley. I mean, there’s just so many things in McKinley that are not in Makata, Ortigas, Cubao or Eastwood. Ok na ko dito =) Now.. moving forward…

What’s in McKinley:

Kung hindi ka nagtatrabaho within McKinley, malamang ang dinadayo mo dito ay ang Piazza. It is patterned obviously after Venice. Small Concerts and commercial/MTV shootings are usually held here. This place is deal for people who would like to go away from people-polluted(populated :) ) and busy streets of Makati and Ortigas. Also perfect for family reunions or even just plain family dinners as it also has a plaza that’s very cozy and where toddlers could play around. It’s really perfect for families.

mckinley hills, the fort, piazza

How to use Read More Button in WordPress

By: Lique

23-05-2010

How To's

I just love wordpress codex. :P It has helped me several times. Well that’s what it’s supposed to do anyway, ayt?

The Codex ended my agony with changing permissions.
Restore back my wordpress posts to my new domain.
And now, how to use read more in wordpress. I know it might be silly but I really didn’t know that the button between the Unlink and ToggleSpellchecker on the wordpress admin post page is actually a More Button. I have been using wordpress fo quite some time and I just got to know what it’s all about.

Another way making use of the Read More Button applied in all posts in your wordpress:

Go to your index page(index.php)

Find(Ctrl+F) <?php the_content(”); ?> and replace with <?php the_excerpt(”); ?> and voila!

For those using the Color Paper Theme(like me), you might be having a hard time fixing your layout for the “featured space” because your post is tool long and posts are overlapping. Now it’s either you’d like to have only the featured post on “READ MORE” or you’d like all posts to have the “Read More” feature(so that viewers will have to click the button if they are really interested in your posts & more hits too, I guess).

To configure the layout to be in “Read More” status(meaning with the Read More Button) , change only the <?php the_content(”); ?> into <?php the_excerpt(”); ?> on your index.php

<div class=”featured-content”>

<?php query_posts(‘showposts=1′); if (have_posts()) : while (have_posts

()) : the_post(); ?>

<h3><a href=”<?php the_permalink() ?>” rel=”bookmark”

title=”Permanent Link to <?php the_title_attribute(); ?>”><?php the_title(); ?

></a></h3>

<?php the_excerpt(”); ?>

Now if you’d like to make all your posts with the “READ MORE” button without using the Insert More Tag, make the following code change on this part:

<div>

<div><span><?php the_time(‘M’);

?> </span><span><?php the_time(‘d’); ?> </span></div>

<h4><a href=”<?php the_permalink() ?>” rel=”bookmark”

title=”Permanent Link to <?php the_title_attribute(); ?>”><?php the_title(); ?

></a></h4>

<?php the_content(”); ?>

I did some manipulations on the css(deleting the image and featured content itself) but ended up messed-up color paper theme. It took me like 4 hours to make this thing working. :D

Fill: SelectCommand.Connection property has not been initialized.

By: Lique

20-05-2009

How To's

I got this error on the program I am creating. After reading some forums and same problems on the net, I’ve finalyy figured out what the problem is..

The errors appears when I try to get records from the database. The code looks like:

SqlCommand cmd = new SqlCommand();

cmd.CommandType = CommandType.Text;
cmd.CommandText = “SELECT * FROM ProfileTable ORDER By MemberNo;”;

da = new SqlDataAdapter();
da.SelectCommand = cmd;

ds = new DataSet();
da.Fill(ds, “ProfileTable”);

what I missed out was this line:

cmd.Connection = cn;

Connection was not initialized. OK.

The code now looks like:

SqlCommand cmd = new SqlCommand();

cmd.Connection = cn;

cmd.CommandType = CommandType.Text;
cmd.CommandText = “SELECT * FROM ProfileTable ORDER By MemberNo;”;

da = new SqlDataAdapter();
da.SelectCommand = cmd;

ds = new DataSet();
da.Fill(ds, “ProfileTable”);

Blogger to WordPress

By: Lique

29-04-2009

How To's

yey! i have imported my old post in my blogger account to wordpress :)

how? in your dashboard, just click tools, import. click the blogger link, then you’ll be asked to log-in then authenticate, set authors, WAIT. and VOILA!

wordpress to another wordpress.

original wordpress account: dashboard>tools>export>download the file.

new account: dashboard>tool>import>click the wordpress link>upload the file.

:) Enjoy

— Colors and Spices

Changing URL Sites

What’s Up McKinley

How to use Read More Button in WordPress

Fill: SelectCommand.Connection property has not been initialized.

Blogger to WordPress

Categories