Lowyat.NET: Latest topics by NewAchiever

Cold Night and Running Nose

NewAchiever — Sun, 09 Jan 2011 00:03:21 +0800

These few nights, it had been colder than usual mmm...
My nose can't take it and it had been running like tap @@ been using too much tissues

Is it me? or what do you think?

Reporting Services - Dynamic Sort

NewAchiever — Mon, 16 Nov 2009 18:11:27 +0800

I am quite new in Reporting Services
I would like to allow Sorting Choices, either sort by the ID field or Date field according to the values selected

In the dataset "COM", i have these select statement, for example:-

Select C.ID, D.Date, C.lngname, C.shrtname, C.address, D.Etc from Company C, ComDetails D
where C.ID = D.ID
Order by (Either ID or Date depending on parameter selection)

Thus, what i did is i had created a report parameter (cboSortBy) with hardcoded values (Under non-queried):
i) Label : Com ID, Value: (I had tried putting in "C.ID", "ID")
ii) Label : Date Established : (I had tried putting in "D.Date","Date")

and then i had create the Dataset Parameter, @cboSort = Parameters!cboSort.Value

and then back to my Dataset = "COM" query, it looked something like this

Select C.ID, D.Date, C.lngname, C.shrtname, C.address, D.Etc from Company C, ComDetails D
where C.ID = D.ID
Order by @cboSort

But upon execution, i get this error @@

"An error occured while executing the query. The SELECT item identified by the ORDER BY number 1 contains a variable as part of the expression identifying a column position. Variables are only allowed when ordering by an expression referencing a column name"

any advice? @@ which steps i go wrong @@, thanks...

Rain Repeller

NewAchiever — Tue, 13 Oct 2009 08:39:04 +0800

Recently i just bought a rain repeller - Rain O
But the application makes you really tired @@ not to mention that chemicalish smell... and my eyes stings

And upon wiping with cloth upon kena rain when parking the car ... The windscreen looks... dirty .. I thought it supposed to repel the rain, dust etc... mmm ... Duno wat will happen if i use the wiper on the screen applied with this substance ... haven try yet

Anyway, Do you guys use it?

What to wear - Attend a wedding

NewAchiever — Mon, 14 Sep 2009 08:20:05 +0800

Dear all,

Will be my first time attending a Malay wedding soon ~~~ is at a dewan - lunch invitation
Any suggestions on the proper yet fashionable ladies attire to wear?

How much to repair a swollen tyre?

NewAchiever — Thu, 03 Sep 2009 07:45:47 +0800

Now my tyre has around 50 cent slightly bigger - small swell at the side there ~
My car ran over something (I think is pothole or wat i am not sure) with a very loud thud sound

Planning to have it check and maybe repair later ~

Would like to know from how much to pay? And how long to wait to get the car back?

Thanks

Taxi(s) around the world

NewAchiever — Thu, 20 Aug 2009 13:29:24 +0800

I'd just riden in a booked taxi in Brunei ~~~~ back to airport
Was so impressed by the power and smoothness ~~~

Cannot tahan but to ask the taxi-man "Hey how many Cc is this engine"
Taxi Man "Huh? wat?"
Me "Oh how many Cc? of this engine"
Taxi Man "Oh! it's a 2cc Diesel engine"
Me " wah ~~~ no wonder feels the ride so powerful"
Taxi Man " Smiling" , you drive too?
Me "Yeah"
Taxi Man : Oh wat car is that?
Me "Proton Saga ~ 1.3 cc oni

Really powerful engine ~~~ really like to ride in it ~
2.0 Cc Diesel Engine Taxi yeh ~~~~

AHAHAHHAHAH

Tyre Inflation Issue

NewAchiever — Thu, 16 Jul 2009 08:09:48 +0800

As usual, went to petrol station to inflate all my tyres ~~
The pressure that i always use is 220 for front and 200 for back

The issue is this, previously able to inflate all without issue

But then today, when try to inflate the back one first ~ Saw the pressure is like 120 @@, then beep beep showing Error message ==> something like this "ERR" cannot remember

Puzzled, i go to the next back tyre and come out error AGAIN

Then i adjust to 220 i go try my left front tyre, this one, inflated Successfully Without Errors, ngam ngam 220

Then i try to inflate the right front tyres, again come out ERROR,

meaning 3 out 4 tyres have Error Message upon inflation @@

when i try to inflate those 3 tyres, the pressure indicator indicates a very alarming low pressure @@ and then beep, showing Error Message

Something wrong with my tyres? Just wan to know your opinion before i get it check later end of day
Thanks

Blind Spot Mirror

NewAchiever — Fri, 03 Jul 2009 08:04:06 +0800

Just bought a pair blind spot mirror that can rotate 360 degrees ~ (One corner juts out)
Stick it at the lower corner of the car, i dun see anything significant @@ Rotate here and there i dun think the one can rotate is a good idea @@, though i tot it's a good idea at the point of purchase ~
So i'm gonna cabut it and buy the one cannot rotate but just a flat mirror and see how ~

Question is, usually where to stick? Top corner or lower corner?

Is it good? Bad? Etc? THanks

SOS : Car engine having "humming" sound

NewAchiever — Thu, 12 Mar 2009 23:13:37 +0800

Sorry for disturbing in the middle of the night, really do not know what to do

At first i heard some "humming' sound like "ooooooooo" and i open the bonnet and it came from somewhere near the engine compartment ~

I on and off my door remote, the sound wun go off

Before that i was driving in a very heavy rain and i wade through the slightly flooded road with the water splashing all over but i made it back home ~

However, there was no sound heard at that point of time about evening~

But when i went out and i came home(with another car of course), i passed by my car and i heard some humming sound and i put my ear near my car and found that it came from my car!

and further, i found that it came from the engine ~

What's happening? I'm so worried now
is it harmless? or is it the water went inside the engine compartment?
or?

I wonder whether it's safe to drive in this condition tomorrow ~

Help!!

[addedon]March 12, 2009, 11:21 pm[/addedon]Sigh!!! ~ I went and start my engine again after a while and off agagin and the sound is still there @@ as in "oooooooooooo"

[addedon]March 12, 2009, 11:25 pm[/addedon]Called the 24 hours assist to ask questions but no response

Cacti and Succulent

NewAchiever — Wed, 18 Feb 2009 08:34:45 +0800

Here's one to start with, another old pic

Species : Mammillaria Spinosissima Cactus (With Flower)
Camera : Canon Powershot S3IS
Natural Lighting

Driving - Barefoot / With Shoe / With Sock / etc?

NewAchiever — Wed, 15 Oct 2008 13:24:52 +0800

When i drive again, i was told it's better to drive barefoot instead of stepping on the pedal with slippers ~~~
Then, someone said that it's not good and apparently illegal to drive barefoot ~~~ Mmmmmm

How about others? Would like to know more opinions about this?