Lowyat.NET: Latest topics by sixvegas09

Anyone is working in Freudenberg-NOK ST Malaysia

sixvegas09 — Mon, 15 Apr 2013 11:37:10 +0800

Hi All,

I just received interview from this company and would like to understand the working environment background, the culture, salary and etc.

Does anyone happen to work or currently work in this company before?

Position : .Net/sharepoint developer

Thanks.

Return Max(Recent_Date) for each month

sixvegas09 — Tue, 02 Apr 2013 22:48:06 +0800

Hi All,

Basically, I want to achieve that for each months, like in this example, from January until March 2013, what is the Max(Most_Recent_Day) for each users.

Example, From January to March, every month in the Database, systems will capture the Most_Recent_Day for users.

Below are the expected results:

[attachmentid=3374649]

However, I want to have another DB column as well to be display . Below is the column.
[attachmentid=3374652]

I tried to use inner join, but the result are not what i expect. I got duplicated user name and duplicated recent day. Basically, I want only to display no duplicated record for the same user name.

[attachmentid=3374653]

CODE

SELECT t.[User],
t.Total_Hits,
t.Recent_Month,
t.Most_Recent_Day,
t.Most_Recent_Day_Hits FROM UserUsageMonthly t
INNER JOIN
(
select
[User]
, max(Most_Recent_Day) as Most_Recent_Day
from UserUsageMonthly (NoLock)
where Application_Name='Daily Production Review' and Site_Collection='wrm13'
and Most_Recent_Day between '1/1/2013' and '3/31/2013'
group by [User], datepart(month,Most_Recent_Day)
) table2
ON
t.[User]=table2.[User]
AND t.Most_Recent_Day = table2.Most_Recent_Day
order by t.[User]

Retrieve Latest Records From SQL DB

sixvegas09 — Fri, 22 Mar 2013 12:17:17 +0800

Hi All,

I have this table which contains of user information’s from January until this month, March. Hence, I would like to retrieve only latest information for each users and from different Application Name.

This table most of the time, contain duplicated value for each users.

So this can be check from the Most Recent Day If the value is same, then, it need to check from the Last_ Run_ Date.

I was thinking maybe need to use Join..but not very sure how to implement that.

Please advise on the right SQL Command to achieve this? Very limited experience on this. Thank you

The table info :

[attachmentid=3358741]

Error :

[attachmentid=3358742]

Any recommended USB Microphone for Conference Call

sixvegas09 — Thu, 11 Oct 2012 11:17:10 +0800

HI,

I'm looking for recommended USB Conference Call Microphone.

Do you know any product that available in Malaysia?

Many Thanks!

My car cermin kena pecah

sixvegas09 — Tue, 09 Oct 2012 19:53:17 +0800

Hi \k\

My car windscreen kena pecah in cyberjaya. Luckily, nothing lost.

Any recomendend shop in Kajang/Putrajaya/Sri Kembangan?

Populate CheckBox List Data From SQL

sixvegas09 — Fri, 24 Feb 2012 17:19:00 +0800

Hi All,

I have a problem here. in C# ..

I have data that populate from SQL into the CheckBox List. But the data is stored in value in a row.

For example :

ID Country
1 Malaysia, Singapore, Thailand,
2 Malaysia, Singapore
3 Malaysia Filipina

And I have a checkboxlist.

if I select ID no 1 : it will populate Malaysia, Singapore, and Thailand on the checkbx. After that I can update the Checkbox list, and I want to select Malaysia and Singapore only

So the DB will be update like this

ID Country
1 Malaysia, Singapore,

I know a little bit about the databind and datasource for checkbox list. But the problem is, to populate from DB on the selection.

SharePoint 2010 WCF

sixvegas09 — Tue, 19 Jul 2011 13:49:49 +0800

Hi,

I would like to ask, what is difference between WCF and Webservice? i had google it but I still don't understand, what is the purpose of WCF?

How it can helps user ?Because I would like to develop a webpart that using WCF.I mean SharePoint 2010 WebPart that can add user into specified group in SharePoint 2010?

Anyone here can explain to me in a simple term what mainly purpose of WCF?

Can cancel Easy-RHB ASB Loan

sixvegas09 — Mon, 11 Jul 2011 21:35:33 +0800

Hi All,

Please provided me some opinion.

Just now, I just apply EASY RHB ASB Loan.RM160K and got approved. Actually, it is not my intention to apply it but i just got interested with the plan and what can I get after 25years.

But monthly, I need to pay RM1000. Basically, every month, I can save RM1000. But, just now, when I'm thinking RM1000 for every months, is quite a lot since I just fresh graduates.

So, the rhb staff ask me to do ASB Book first tomorrow because I don't have any ASB account before.

My question is..can I cancel this loan? or..can I just reduce the loan from rm160k to something like RM100k or Rm50K only??

How to return false in javascript?

sixvegas09 — Thu, 14 Apr 2011 12:52:02 +0800

Hi Guys, I have problem..

I want to compare two date in javascript. Whenever the user click Submit button, the error should occur and the program should not allowed to save.

But, this code, even though it have display the error, but it still save the information.

How to solve this problem?

CODE

How to replace (/) with -

sixvegas09 — Wed, 13 Apr 2011 15:18:52 +0800

Hi All,

How to replace a slash (/) with a hypen (-) in javascript?

for example, i need to replace

18/4/2011

with

18-4-2011

CODE

var new = "-";
var s = '4/18/2011';
alert(s);
var s2 = s.replace(/\//g, new);
alert(s2);

when I doing like this, all the code above become uncomment.

Compare 2 Date in SharePoint List

sixvegas09 — Tue, 12 Apr 2011 09:20:17 +0800

Hi All,

Anyone here have experience on developing SharePoint 2007 list?

Ok.Here the question.

I have two different lists. That is List 1 and List 2.

List 1 - BlackOut Dates
List 2 - User Date

In List 1, the administrator will add dates that called are Blackout Dates.

In List 2, the user will select a date and if the date that he selected is in the Blackout Dates in List 1, the user should not be allowed to save the form and an error should pop-up say that “ This is blackout date. Please select another date”.

I have the sample source code using SPServices. But I don't know what to put in the loops.How to compare them and how to come out with alert.

CODE

$().SPServices({
operation: "GetListItems",
async: false,
listName: "List 1",
CAMLViewFields: "<ViewFields><FieldRef Name='Blackout_0020_Date' /></ViewFields>",
CAMLQuery: "<Eq><FieldRef Name='Blackout_x0020_Date' /><Value IncludeTimeValue='FALSE' Type='DateTime'>" + blackoutDateValue + "</Value></Eq>",
completefunc: function (xData, Status) {
$(xData.responseXML).find("[nodeName='z:row']").each(function() {
// Do something here if there are items returned
});
}
});
});

i'm new to Jquery and sharepoint.anyone here can helps?

SharePoint 2010

sixvegas09 — Tue, 25 Jan 2011 08:55:00 +0800

I would like to ask if anyone here ever use the SharePoint 2010 and customized it?

How about it?it is hard to learn?

If anyone here want to be freelance as a tutor for SharePoint 2010, maybe you can PM me.

How to master C# and ASP.Net?

sixvegas09 — Mon, 24 Jan 2011 09:06:51 +0800

Hi,

I wonder how you guys study C# and ASP.Net. A part of learning from book and the Internet, how long do you guys manage to master this language?

Closed

sixvegas09 — Wed, 10 Nov 2010 10:39:08 +0800

Closed

CLOSED

sixvegas09 — Thu, 28 Oct 2010 13:21:37 +0800

closed

Get Address From the Google Maps

sixvegas09 — Mon, 25 Oct 2010 13:08:51 +0800

Hello everybody,

I have study the Google Map Geocoder and I would like a program that Google Map can show the address based on the latitude and longitude in the database.

Something like here.

http://digitalinspiration.com/community/location.html

http://code.google.com/apis/maps/documenta...ng-reverse.html

Below are my coding.

CODE

CODE

var WINDOW_HTML = '<div style="width: 300px;height: 90px; padding-right: 5px"><b>Coordinates : </b> <?=$database['latitude'];?>, <?=$database['longitude'];?></div>';

CODE

<body onload="load(<?=$database['latitude'];?>, <?=$database['longitude'];?>)" onunload="GUnload()">

The function above will load based on the database in the mySQL. I wish to show address in the varWindow HTML.

Can share idea here how to do this?

Really need to finish my assignment.