Lowyat.NET: Latest topics by honda88

[WTS] Prada Bag B1336M New

honda88 — Fri, 02 May 2014 19:39:02 +0800

Item(s): Prada Bag B1336M Black

Package includes: 100% New Prada Bag B1336M Black Color with Card

Price: MYR 6000

Dealing method: COD

Location of seller: KL / Seremban

Contact method/details: Whatsapp -> 0192008187

Item(s) conditions: 100 Brand new

Picture: As attachements

Which job better?

honda88 — Sun, 18 Dec 2011 10:45:57 +0800

I would like to ask for u guys opinion which job is better?
1. SAP Consultant in SD @ Ecenta
2. SAP Consultant in BW @ DHL

Thank you.

vb script do while loop help

honda88 — Thu, 14 Apr 2011 23:29:58 +0800

I have the vb script as below:

sql = "SELECT d.Description, COUNT (v.StockID) AS Unit FROM tbStock d, tbAsset v WHERE v.StockID=d.ID AND v.Location LIKE 'A%'Group By d.Description Order By d.Description"
set RS4 = con.Execute(sql)

Do While Not RS4.EOF

id=RS4("Description")
name1=RS4("Unit")
collect =collect & id&" "
collects =collects & name1&" "

RS4.MoveNext
Loop

s_id="&s_id="& collect
s_name="&s_name="& collects
Response.Write (s_id &" " &s_name)
RS4.Close

Results return are:

&s_id=COMPUTER DESKTOP COMPUTER NOTEBOOK Digital Camera Hard Disk Drive PRINTER &s_name=3 1 2 1 1

How to make it to return the results as below:

&s_id=COMPUTER DESKTOP &s_name=3
&s_id=COMPUTER NOTEBOOK &s_name=1
&s_id=Digital Camera &s_name=2
&s_id=Hard Disk Drive &s_name=2
&s_id=PRINTER &s_name=1

Will appreciate if anyone can help me..
Thank you.

Convert PHP to vb script

honda88 — Tue, 12 Apr 2011 00:12:56 +0800

Anyone know how to convert below php code into asp vb svript?

<?php

$username = $_POST['username'];

// create connection
$connection = mysql_connect("localhost", "db_user", "db_password") or die ("Couldn't connect to the server.");

// select database
$db = mysql_select_db("db_name", $connection) or die ("Couldn't select database.");

// create SQL
$sql = "SELECT domain FROM db_table where username = '$username'";

// execute SQL query and get result
$sql_result = mysql_query($sql, $connection) or die ("Couldn't execute query.");

// get number of rows in $result.
$num = mysql_numrows($sql_result);

$domain_list = "";
$hosting_list = "";

$counter = 0;

while ($row = mysql_fetch_array($sql_result)) {

$domain = $row["domain"];
$hosting = $row["hosting"];

if ($counter == 0) {
$domain_list .= $domain;
$hosting_list .= $hosting;
} else {
$domain_list .= "|" . $domain;
$hosting_list .= "|" . $hosting;
}

$counter++;
}
echo "domainList=" . $domain_list . "&hostingList=" . $hosting_list . "&totalItem=" . $num;

// free resources and close connection
mysql_free_result($sql_result);
mysql_close($connection);

?>

HELP! vb code and action script code

honda88 — Sun, 10 Apr 2011 22:50:07 +0800

Can anyone tel me what is the error on below vb code and action script code?[SIZE=7]

<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<%
servername = "localhost"
username = "sa"
password = "sa"
database = "AimsSQL"

con_string = "Driver={SQL Server};Server=localhost;UID=sa;PWD=sa;Database=AimsSQL"

set con = server.CreateObject("ADODB.Connection")
con.open(con_string)

set all = server.CreateObject("ADODB.RecordSet")
Response.Write("Kelvinnnnn David")

dim id
dim name1
dim pw
dim addr

str1 ="SELECT ID, IndexNumber,Model,Location FROM tbAsset WHERE ID = '2052'"
set RS2 = con.execute(str1)

if not RS2.eof then
id = RS2("ID")
name1 = RS2("IndexNumber")
pw = RS2("Model")
addr = RS2("Location")

response.Write("&s_id="&id&"")
response.Write("&s_name="&name1&"")
response.Write("&s_password="&pw&"")
response.Write("&s_address="&addr&"")
response.Write("&Value=success")
else
response.Write("&Value=fail")
end if

%>

Below is the action script in Flash:

btnSearch.onRelease = function() {
pass_value = new LoadVars();
pass_value.userid = id_box.text;
pass_value.sendAndLoad("Search.asp", pass_value,"POST");

pass_value.onLoad = function(){
if (this.Value == "success"){
id_box.text = this.s_id;
name_box.text = this.s_name;
pw_box.text = this.s_password;
add_box.text = this.s_address;

msg_box.text = "Data is found";
}
else{
msg_box.text = "No record found";
}
}
}

Flash Problem

honda88 — Wed, 06 Apr 2011 14:51:51 +0800

Hi, anyone know how to display sql select statement result in Flash?

If anyone have the knowledge, I would like to outsource it.

Thank you.