Sample connection string for ASP folks

If you are planning on making a database call from the web the first thing you will need to do is plan on making a "Database Connection". Here are some sample database connection strings to help you get started.


Sample Database Connection Strings

What is rich

Last night my eldest daughter ask me:

" Mama, what you will do when you rich,are you going to do the same thing,wrapping things for people?"

She asked when she saw me so busy wrapping all the customers order for this week.This few weeks are such a chalenging weeks as i have to coop to my paid job, my master degree and my side business(http://www.melur.com).

Rich...is so subjective...when i first graduated and heard some seniors can earn at least 2 to 2.5 k a month..wow ..that's a big money..never think about it.Then when i start work at a pay of 2700/month 2500 seems a very small amoount of money.Life is getting tougher when you have to coop with your marriage,newborn baby , new house, new cars and so many new commitment.Bak kata orang melayu "besar periuk besarlah keraknya"

so what is rich...? Now ten years have passed since the first time i hold my first salary with pride.Money is never enough but The most important thing is to seek for keberkatan of that money we earn.Never think litle about those who is less fortunate than you dan always willing to give.For me ich is when you can help people around you and never think yourself as rich.

Convert elements in multidimensional array to single dimensional array

function to_single_array(aelement,arr_col)
' convert multidimension array to single array
if isarray(aelement) then
for i=0 to ubound(aelement,2)
strval=strval & aelement(arr_col,i) & ","
next
strval=left(strval,len(strval)-1)
to_single_array=split(strval,",")
'response.write strval & "strval"
end if
end function

aelement is the name of multi dimensional array while arr_col is the column number which we want to converts into single array
this is the example of the multidimensional array

tr>

Name	Age

Amy Jefferson

17




Mark Tan

25




John Grissam

29



Kathleen Rowling

35




so if the array name is ainfo, the way to extract the name into a single dimension array is
ainfo2=to_single_array(ainfo,0)

ainfo2 elements to will be:

Amy Jefferson
Mark Tan
John Grissam
Kathleen Rowling

any errors or feedback forward it to : nor@melur.com

Single Dimension Array concatenation

Single dimension array

Most of the time you will find that you need to concatenate 2 or more arrays.Somehow in classic asp there's no built in function that can combine array in one command. At least not that i know. Fill with the desperation to do it most of the time i wrote a simple function to concatenate 2 or more arrays

First i create a function call concat:

Function concat(array1,array2)
str1=join(array1,",")
str2=join(array2,",")
str3=str1 & "," &
str2 concat=split(str3,",")
end function

then I call the function anywhere when you need to concatenate arrays. For example, you want concatenate single dimension array

aitem1=array("A1","A1","A3")
aitem2=array("A4","A5","A6")

using this function:
aitem3=concat(aitem1,aitem2)

The elements for aitem3 are: "A1","A1","A3","A4","A5","A6"

I AM THE AUTHOR

Noraida Arifin
16 years  programming experience and  still learning.
spent 13 years of my life span as a software engineer
in a multinational company

Currently  a retire programmer.
Feedback are welcome.

Contact me at :
https://www.facebook.com/makcikprogrammer

Gloomy days

I feel so tired. All the energy has flow to my paid job that slowly dragging my attention from other thing. Sometime i wonder what is the priority in life? huh... live to work or work to live? The only good thing that happen last week is another one of the few plants from my husband US seed has bloomed.I think this flower is the prettiest among those which has bloom.So far only 4 out of 6 has bloomed.Have a look on the picture. It is know by the scientific name coreopsis tinctoria. the common name is golden tickseed or some call it calliopsis.The flower last quiet long. It can still beautifully bloom for more than 2 weeks.Seed is produced from the dried flower.It is an annual plant and will flowering between june to september.

below is the wikipedia link for golden tickseed:
http://en.wikipedia.org/wiki/Coreopsis_tinctoria

I really love the color and shape...savy...:)

God's gift

Gift from god
When i was young, to be exact when i was nine and above after dad's business colapse , life was very hard , we survive mainly
on food from nature. we got the protein from fish that we caught from nearby bendang or taliair.Vegies from nearby bush.
Things that always made mum worried was what if we run out of rice, sugar and salt.The rest , we can always found it somewhere
around.
One of my favorite vegetable was / is pucuk pulut musang as my mother call it.My fathers kampung folk used to call it kerak
nasi or kerak-kerak nasi.It is a small plant, so much resemble to a very popular ornamental plant, chinese evergreen. Infact
, the first time i saw the chinese evergreen i thought it is the pulut musang plant and until now i still wonder, whether the
young shoot of the chinese evergreen can turn into a very delicious and mouth watering vegetable as the pucuk pulut musang
is.Never dare to try, perhaps i should i try it... who knows...:)
the part from the plant that can be cook is the young shoot.My mother used to cook it into a very delicious soup.She pounded
the black paper, grilled fish, shallot and garlic together. While pounding the ingridient, she told us the story when she was
young.My mum is the youngest among her siblings.When she was young she used to follow her father travel from place to place,
open new land, in the jungle.Along her journey she learnt many thing about various kind of plants which she always told
me.That's how i develop my interest in herbs and plant.My mum is like a walking plant library for me.
back to the delicious soup.After pounding the ingridient, she boiled it with water until the vegetable got tender.Any other
sayur kampung cannot challenge the sweetness of the plant.
recently when i visit one of my herbs collector, the pakcik show me this plant which he call pecah kelambu, i've saw a few
plant that is called pecah kelambu befor.Some even call galak tua (stemona tuberosa) as pecah kelambu too. but this one
really rang a bell in me.After more than 15 years i never see this plant , it is really like a deja vu for me. It's like you
see an old good friend...hehehe... too much? but that's how i feel...The pakcik told me ... this plant should be the woman
best companion.. why? because it is very beneficial to increase woman sexual desire ...(hahhhhh alamak , really??? , i have
ate so much of this plant during my young days, is there any side effect?) especially for the elder woman. the effect,
according to him is almost the same as kacip fatimah (No wonder the fruit looks almost the same...any direct relation? dont know...
:P)
Then, a litle chat with dad also gave me knowledge that this plant also can cure hemarrhoid(buasir).According to dad , one of
my aunt recovered from her severe hemarrhoid after drink the soup everyday for a few weeks.HOOOO.... it's so beneficial... i
never know...the only thing that i knew last time is it tasted good.
so i grab a few bags an try to nurture it in my garden.One thing about this plant is you can never expose it to the direct
sunlight.In a few days it will....die.You need to grow it under the shade or under a tree as the original habitat is in the
bush.
The great thing that i should always remember is Allah is great, with HIS Love and guide we (me and my siblings) grow up
healthily and happily during the very hard time in our life.Alhamdulillah.No matter how far we go or how many types of food
we eat, the food that give us life is always the most delicious food ever.
enclose is the picture of the plant botanically know as Terenia polygonaides

Bunga Mayang Sari

Here is another snapshop of the white fragrant Flower. Please help me with the name of this flower

The flowers name is mayang sari

White Fragrant Flower

It's quite sometime since my last blog.It's not i'm lazy or busy (since both words are so subjective...:). Perhaps the new layout and interface of the blog make me sick...Hmmm... it takes time to get use to this new look.

so today... here i am again, with new flower. I dont really know the name of this flower but i really love the smell. Wanginye....I try to figure out the name from friends and few other newsgroup. All that i found out is some of them said the flower is from genus Duranta (which i doubt it so much as the leave is totally different) The flower looks alike though....Some of them said it's duranta repens. The only duranta Erecta that bloom in my garden right now is deep purple in color...It's from the hybrid called "Geisha Girl". In contrast with this one, the purple duranta has a very mild smell (almost cannot be detect at all).

So i think this is not Duranta. Some said it is also called Bunga sundal malam... a typical Malay tag for the flower that has a strong fragrant at night.Some said it is called bunga kerak nasi..like bunga kesidang also called bunga kerak nasi.

so until i finish my quest for the real name for this white lady... do enjoy the picture...

greenest regards
Nor

Kesidang (vallaris glabra)

my kesidang (vallaris glabra) is blooming. Every night when i reach home, the rich sweet pandan smell is in the air. Some people who like the pandan smell will really love it.My mother hate the smell, infact she said the smell will trigger her migrain. The smell of the kesidang flower is said to be resemble to the rice smell, describe why in nothern region of Malaysia it is called kerak nasi which literally means rice leftover.The flower also known in western as bread flower, perhaps because of the white color? hahh... just my wild guest.

Kesidang is a climber which make it a very nice companion to your trellis or pergola.It can be easily propagated by layering technic.Layering can be done by pull the branch until it touch the ground or the medium , then put something heavy , like a brick on the branch to make it always touch the ground. after +- 2 weeks, new root will come out for the part that touch the ground. Cut the branch and plant it somewhere else. It can be grown in a pot too...Other way to propagate is grafting. although stem cutting will grow into new plant if you are lucky, by the chance to stem cutting to root is quite low. A little help from root hormone might increase the chances to survive...:)

The leave is quite big, from a far it look like mango leave...:) the leave surface is shiny.Kesidang leave can easily turn yellow and drop if you give not enough water, esp in dry season like now. This the kesidang photo from my garden... Really love the clean white flower with the unique petals and the smellll.....so refereshing....My mother will hate me for this. Next time when she come to visit I'll make sure no buds is allow to bloom....:)

p/s: kesidang is said to be the symbol of malay folks, whic always rich with adab, budi bahasa dan kesopanan.

Do you believe in healing effect of the Gemstones?

I just bought a new bracelet, made from garnet gemstone, the seller claimed that this stone has the healing effect such as it will make you feel healthier and has more evergy.I never believe in this kind of thing. They said scientifically the vibration of the gemstone molecule will make your blood run smoothly. Though never believe in this theory, i bought it because i really like the color. Look at the photos, nice color ...emm??

I've been wearing it for almost a week now, and the funny thing is , every single night after wearing it i never feel tired. I can cook, do laundry , housekeeping , water my plant, monitor my daughters with the homework....etc, etc... I just feel wierd, but i dont want to believe in a thing without a proof. so i start my self-research in the internet ,and this is what i found....

Garnet in Mental HealingBecause of the shared similarities in physical and compositional traits, the garnet family of stones (for the most part) also share similar healing properties. In light of the above, the different colors and different chemistries of garnet varieties allow them to have some healing properties exclusive to that particular crystal. Green garnets, such as Tsavorite (a form of grossular garnet), some Andradites and African Jade (also a form of grossular garnet), are associated with bringing peace, pureness of thought, unobscured mental capacity, and creativity. Green garnets are another of the healing crystals that bring aide in meditation and focus. Orange garnets, such as Mandarin, orange Malaya, rare shades of Spessartite, orange Almandites and some Grossulars, are associated with energy of commitment. Orange garnets help an individual to solemnly dedicate themselves to any endeavor that captures the need for awaited attention. Purple-colored garnets like Mozambique and Grape possess the tenacity to make subtle anxieties and stress brought on by worry and unrest. They also make stable a mind that is not otherwise regulated. The most common form of garnets readily available and more commonly known are the various shades of red. Red garnets, like many red crystals are associated with passion. Though many red stones are found to heal the slings and arrows that love throws our way, it is not necessarily the sole healing function of this and other red healing gems. Along with being a gem the ignites and refuels the red fires of passion and romance, it also sets ablaze the inner fires of self-confidence, creativity and reflection. Since anger causes the body's physical temperature to increase, the opposing fire of positive energy from which garnet burns, can be used against tantrums and episodes of angst. Garnet has also been identified by healers as another of the vivid dreaming stones and one of past remembrance. The Garnet family, in general mental healing, is a jewel of life, love and purity enhancing vitality (the life force), commitment in indecisiveness and sexuality. It's regenerating and warming attributes help it not only to cleanse and renew, but also help to comfort, protect and inspire.
Garnet and the ChakrasWith respect to the Chakras, garnet is readily associated with (2nd) Centre and the Base/Root/Spine (1st) Centre. Garnet not only clears the blockage of negative energy from these areas, it also is used in the healing and enhancing of the activities that occur within and via the centre. Within the realm of the 2nd Chakra (that of the Navel/Sexual/Spleen), garnet has many functions. It acts as a vehicle for the passion and spirituality that are involved in emotional character of sexuality to communicate and influence the physical aspects. It aides in administering both healing and romantic energy when levels are low or difficult to obtain. For this reason, garnet is a healing stone for those who desire a spark in an existing or in beginning a relationship. It has also been highly utilized in helping to heal and energize those who feel they have been sexually weakened (by self-consciousness or other means). Physically some have used it to aide in relieving the negative energy that blocks the sexual centre related to infertility. As a stone of sexual power, garnet acts to renew, awaken and heal the sexual centre. For the Base/Root/Spine (1st Chakra), garnet helps by absorbing energy from locations in the body where there exists surplus and filters it into a fresh and positive energy that is very usable and stimulating to the Base. It not only stabilizes the foundation, it also arouses and initiates energies related to peak performance in life.
Physical HealingGarnet's emotional and mental healing associated with purification, regeneration and warmth also carry over to it's qualities of physical healing. As a healer and protector from toxins, garnet is recognized as a remedy in the body's fight against food poisoning and blood toxicity. It is also known for aiding in treatments against infection of the kidney, lung and facial (irritations, inflammation and blemishes) and area. The garnet family is also an aid to therapy for disorders of the heart (including low blood pressure), bones and spine, blood, pulmonary and even sleeping disorders. It has even been noted to provide gallstone relief and also work down to a cellular level. Because of it's warming energies, it is also used therapeutically for frostbite, aching muscles, arthritis and other discomforts relating to the joints. In early history, recordings of garnet use to treat jaundice and yellow fever were made. Today, garnet is still used by healers to treat fever and even balance antibodies and hormones.

from http://www.jewelrysupplier.com/2_garnet/garnet_healing.htm

and somemore .....

GarnetGarnet is a stone of romantic love and passion. It is used in metaphysics to enhance sensuality, sexuality, and intimacy. It is said to bring positive thoughts and boosts energy, and be excellent for manifestation. It can also assist mystically with success in one's career and building one's self-confidence. It is also a protective energy stone which is especially effective for protection from evil, and is used for gentle spiritual healing. Lore says that garnet can heal the blood, heart and lungs. Garnet is associated primarily with the root chakra, but also with other chakras depending on its color.

from: http://www.crystalsandjewelry.com/metaphysicalproperties_g.html

which never really explain it scientifically.

as a muslim, i avoid believing in anything that can be consider 'khurafat'. I just dont know , and want to know whether this thing really work and how it work?