Lowyat.NET: Latest topics by kel_02

House For Sale (Shah Alam)

kel_02 — Mon, 27 Apr 2015 22:21:19 +0800

House located at Shah Alam Seksyen 25 for SALE!!!

Address: Taman Sri Muda, Seksyen 25
Property type: 2-Storey Terrace House
Tenure: Freehold
Unit type: Intermediate
Bedroom: 2
Bathroom: 3
Furnishing: Unfurnished
Built-up: 840 sq. ft

Facilities:
1. Covered parking
2. Playground

SCHOOLS NEARBY
~SK Taman Sri Muda
~SK Taman Sri Muda 2
~SMK Taman Sri Muda
~SJK (T) Ldg Emerald

TRANSPORTATION NEARBY
~Bus & Taxi Terminal Shah Alam

Selling price: RM 220K

For more information, kindly contact Bryan (012-6998998) or Kelly (012-2602086)

Rejecting offer

kel_02 — Sat, 26 Dec 2009 14:21:29 +0800

I'm a fresh graduate who is looking for a job. i've some experiences while i was having my degree study in a company. after 1 month of job seeking n attending interviews, i called back to my ex boss to ask if they still employing new staffs and the answer i got from them is yes. after that, i went for an interview and listen to the job scope. after listening to the job scope, my mind was blank and start to worry that i cant meet their expectation. interview that day itself i didn't reject their offer which they will start to process all the documentation so that i can start work asap. after thinking twice after the interview, i feel like i have to reject the offer but i don't how to reject it. this is my weakness in rejecting as well. anyone can give me some comment?

audio conversion

kel_02 — Thu, 27 Aug 2009 09:18:22 +0800

anyone here know why is there inaccuracy when converting .wav file to midi? i need explanation on tat as some one ask me this qs and i not manage to find the explanation online.

Checkbox variable from infopath form

kel_02 — Thu, 26 Mar 2009 17:16:59 +0800

anyone here know how to get the variable of a checkbox from an infopath form? i tried to google but most of the result that the display are web based solution. i need a form based solution as da infopath form that i made was in form based/template. i need the variable when i trying to do the event handler using visual studio tool for application. currently, i fail to get the checkbox variable.

hope someone here manage to help me out.

thx a lot.

get date without time in sql

kel_02 — Wed, 25 Mar 2009 10:22:07 +0800

hi all,

i'd like to ask how to get date without time in sql as i try google it and i found this:

CAST(FLOOR(CAST(GETDATE() AS float)) AS datetime)

i replace the GETDATE() with my column name (e.g: date)

since it cast it to datetime..so time will be displayed when i execute the sql command. if i remove the first cast and "AS datetime", it shows the number of days.

thus, how can i get only the date from date/time format.

hope to hear from you guys. thanks a lot.

retrieve image using php

kel_02 — Thu, 12 Feb 2009 13:38:42 +0800

i've successfully uploaded photos using php but i failed 2retrieve photos and name from mysql database.

below is my coding of uploading and retrieving photos:

i save the upload photo coding in login_process.php and to retrieve photo,i wish to retrieve the photo and echo it in home.php

//upload photo

$target_path = "images/";
$path= $target_path.$HTTP_POST_FILES['photo']['name'];

$db = new DBAction();
$db->openConnection();
$db->dbName();

if ($btnSubmit == "Submit")
{
copy($HTTP_POST_FILES['photo']['tmp_name'], $path);

$pic = $HTTP_POST_FILES['photo']['tmp_name'];

$query="INSERT INTO login_tbl (photo) values('".$pic."')";
$rs = $db->dbAccess($query);
}

//retrieve photo
$pic = $_POST['$pic'];

$query="SELECT * FROM login_tbl WHERE usrName = $usrName";
$rs = $db->dbAccess($query); echo $name; echo "<img scr='$pic'>"

the photo that appear is juz a small logo not a photo...

hard code username & password

kel_02 — Tue, 20 Jan 2009 17:34:47 +0800

Hi all,

i'm using C# to develop a project. i'm trying to connect sql server and a form that i've created. It's reading username from Active Directory automatically when i start to run the form. what i wish to do now is to hard code the username and password myself so that it cant read my hard coded username and password in order to connect to sql server. i try google the solution and hv tried a few methods but fail. what should i do in my webconfiq?

here is my sample of default coding in web confiq.

<appSettings>
<add key="ConnString" value="Data Source=sqlserver/database_name;Initial Catalog=BasicDataAccess;Integrated Security=True"/> </appSettings>

Belows is the methods that i've tried out:
1.
<appSettings>
<add key="ConnString" value="Data Source=sqlserver/database_name;Initial Catalog=BasicDataAccess;User Id="username";Password="password"; />
</appSettings>

Note: it shows zigzag line at User Id="username";Password="password";

2.
<identity impersonate="true|false" userName="username" password="password"/>

Note: it shows zigzag line at "true|false"

FYP Project

kel_02 — Thu, 08 Jan 2009 10:52:49 +0800

I'm doing my FYP now. I planned to do online training system with multimedia elements. In the training system,i'll include multimedia training and questionaire. any suggestion on how to do it or anything to add? i oredi got the software to do screenshot for multimedia training.

Virtual ping

kel_02 — Mon, 22 Dec 2008 14:55:42 +0800

Who knows where can get the tutorial of virtual ping coding?i tried 2 search online but seems like can't find any. anyone can help me out here?

Microsoft Office Sharepoint Server & sql server

kel_02 — Thu, 11 Dec 2008 18:17:15 +0800

Hi all,

may i noe how can i make microsoft office sharepoint server (MOSS) and sql server talk to each other? As i noe, MOSS will talk to Active Directory(AD) automatically due to the configuration that had been set.

How to set bandwidth?

kel_02 — Wed, 27 Aug 2008 13:39:01 +0800

Hi,

I'd like to ask is there any software that can enable us to monitor the performance and to adjust the bandwidth of every ip that is using the same network? besides,is there any software that can enable us to block some application ip from accessing it? as far as i know, there is a software named "Netsense" but i can't find the installer for this software. Netsense can do the both functions that i've mentioned earlier.

Besides, I'd like to know, is there any software that can enable us to unblock an ip when someone try to block our ip from accessing internet?

will appreciate your help.

search function

kel_02 — Thu, 29 May 2008 11:46:24 +0800

Hi all,

i'm doing a search function using php and my sql. i need to search date but it's between date1 and date2, then display all the info that are in between of date1 and date2.

below is part of my coding

<?
$queryselection = "SELECT DISTINCT selection FROM tbl_a";
$sqlselection = $db->dbAccess($queryselection);
while ($row = mysql_fetch_array($sqlselection)) {
?>
<option value="<? echo $row['selection'];?>" <? if ($row['selection'] == $selection) echo "selected"; ?>><? echo $row['selection']?></option>
<? }
?>
</select>

<td><input type="text" name="date" class="fontsmall" size="29" value="<?if ($d!= NULL) {echo $date;}?>"/> <input type="image" name="cal" id="cal" src="images/calendar.gif" onclick='scwShow(document.formReport.date,event);return false;' />     to     <input type="text" name="date1" class="fontsmall" size="29" value="<?if ($date1 != NULL) {echo $date1;}?>"/> <input type="image" name="cal" id="cal" src="images/calendar.gif" onclick='scwShow(document.formReport.date1,event);return false;' /></td>

$selection = $_POST['selection'];
$date = $_POST['date'];
$date1 = $_POST['date1'];

$whr = "";

if ($selection <> "") {
if ($whr == "")
$whr = " and selection = '$selection' ";
}

if ($date <> ""){
if ($whr == "")
$whr = " and date = '$date'";
else
$whr = $whr . " and date = '$date'";
}

if ($date1 <> ""){
if ($whr == "")
$whr = " and date1 = '$date'1";
else
$whr = $whr . " and date1 = '$date1'";
}

<?
$query = "SELECT tbl_a.*, tbl_b.* FROM tbl_a JOIN tbl_b ON tbl_a.usrName = tbl_b.usrName";
$query = $query . $whr . " order by date ASC";
$sqlcount = $db->dbAccess($query);

if ($sqlcount) $cnt = mysql_num_rows($sqlcount);
$i = 0;
if ($cnt = 0)
{ ?>

</tr>
<tr align="center" valign="middle">
<td colspan="7"> <?echo "No Data";?></td>
</tr>
<? }

else {
while ($row = @mysql_fetch_array($sqlcount)) {
$selection =$row['selection'];
$Date = $row['Date'];
}
} ?>

<tr>
<td><? echo $selection ; ?></td>
<td><? echo $Date; ?></td>
</tr>

i know i need to write something in the highlighted part but i dunno what should i write there. Besides, i know i need to have a BETWEEN statement for the date part but i dunno where to write it. i tried to write it in the query statement but it doesn't work. i need to use LIKE %$date% for the date.

Will appreciate your help here.

Displaying problem

Thu, 01 Jan 1970 07:30:00 +0800

Displaying problem

kel_02 — Wed, 21 May 2008 11:44:24 +0800

Hi,

I'd like to ask how to display another drop down menu appear when the first drop down menu select some particular option?

e.g.

in the first drop down menu,

<tr align="left">
<td>Number</td>
<td><select name = "Number">

option value="1">One</option>
option value="2">Two</option>
option value="3">Three</option>

</select></td>
</tr>

when i click on value 2, the second drop down list appears which mean when value 1 & 3 are selected, the second drop down menu won't appears.

should i do sth like if($Number == '2') {

then only start the new <tr> in da new drop down menu?

anyone can help me on this?

Will appreciate your help..
Thanks.

SQL doubt

kel_02 — Thu, 15 May 2008 17:25:42 +0800

Hi,

i'm having some problem here. i'd like to ask sth like this.

normally in sql, we type SELECT column1, count(column2) FROM tbl group by column1 order by column1

the problem is, if i wanna display another column from another table i.e. tbl1 and it must display in the previous interface's table. How to do it?

can u guys understand my question?

passing value

kel_02 — Mon, 25 Jun 2007 17:46:18 +0800

hi all,

may i noe how to show the value that i'd like to pass from login.php to another file. i successfully pass the value once i clicked login n it did pass the value to the particular page, but my problem here is when i'd like to click some buttons like search, clear, etc, it cant show the value that had been passed just nw n showed error of "PHP Notice: Undefined index: fullname in xxx on line yy". is that mean that the value stored in fullname is no longer store there?

i use the following command to pass the value to the particular page.

login.php
window.open('main.php?email=<?php echo $email; ?> &&fullname=<?php echo $fullname; ?>', '_parent');

main.php
<frame src="test.php?email=<?php echo $email; ?> &&fullname=<?php echo $fullname; ?>" name="first">

test.php
<?php
$fullname= $_REQUEST['fullname'];
?>
<input type="text" size="15" readonly size="5" maxlength="5" name="name" style="border:white; background-color:#FFFFCC;" value= "<?php if(isset($_POST['searching']) || isset($_POST['searchnext'])) {echo @$name;} else if (@$_POST['clearing']) {echo $fullname;} else {echo $fullname;} ?>" />

when i clicked search, search next and clear, it shows the error msg above.

anyone here can help me on that? thx in advance.

Authentication

kel_02 — Thu, 07 Jun 2007 14:43:09 +0800

i've a question here. i saw a topic which is regarding the authentication where the coding was written in php and mysql...i wonder can i write the coding in php and microsoft sql....i'm confuse with microsoft sql and mysql.what are the differences between microsoft sql and mysql.
Besides,i'm quite confuse where how odbc connect with microsoft sql..anyone here can make me understand more on that?thx in advance.

find future date

kel_02 — Fri, 01 Jun 2007 14:50:36 +0800

may i noe how to find future date if i've information of the duration in days and current date

i use this coding to find the current date
<?php
$today = date("j F Y"); print $today;
?>

for example,today is 1st june 2007,duration is 31days
den i should get 2nd July 2007.

coding prob

kel_02 — Fri, 25 May 2007 09:29:29 +0800

i got prob in coding..i did a drop down list which after i selected one of the item,it'll either show NA or juz blank in another text box..now,i'd like to send the selected option to sql;besides,i also want it to read from the sql and become a selected option after i click a button.can anyone here giv me some idea on it??thx in advance.
here is my code example:

CODE

<select name="opt" onchange="optionBrowser()" >
<?php
$choices = array('OTHERS', 'CABINET A', 'CABINET B', 'CABINET C', 'CABINET D');
foreach($choices as $temp)
{
if( $temp == $opt )
{
printf("<option selected>%s</option>\n", $temp);
}
else
{
printf("<option>%s</option>\n", $temp);
}
}
?>
</select>

<script type="text/javascript">
function optionBrowser()
{
var opt=document.getElementById("opt")
if ((opt.options[opt.selectedIndex].text=="CABINET A") || (opt.options[opt.selectedIndex].text=="CABINET C"))
{
document.getElementById("name").value="NA";
}
else
{
document.getElementById("name").value="";
}
}

problem in coding

kel_02 — Thu, 17 May 2007 09:21:32 +0800

i'm facing some prob in my coding.i'd lik 2 noe how 2 show NA in a column of a table if the user didn't key in anything in a text area after the user click summit button?besides,how to update the database so that all the columns in a table which is blank currently to become NA? i'm using microsoft sql server,php and javascript in my coding currently.