Lowyat.NET: Latest topics by greenCat

[WTS]Kelambu Moden / Mosquito Net

greenCat — Sat, 06 Sep 2014 11:43:30 +0800

Item(s): Mosquito Net/Kelambu Moden

» Click to show Spoiler - click again to hide... «

Product details

1. The product is supported by steel wire and thus has strong structure.
2. The mosquito net can be put on the bed or the mat lying on the floor.
3. The flex on the four corners of the mosquito net can be used to fix on the bed.
4. The product can prevent from mosquito and dust.It is safe with double side zip.
5. Easy installation and easily stored.
6. Suitable for confinement mother-recommended type B
7. For outdoor use or campaign.

Availability:
TYPE A

TYPE B

Dealing method:

Payment via Maybank /Cimb

Free post peninsular only / Sabah & Sarawak RM 5
COD at Kota Damansara / Subang Jaya / Sungai Buloh /Kelana Jaya

Contact method/details:

1. Direct contact with seller - 013-2360556(Wan) whatapps/sms/call
2. PM me
3. Post it here

Item(s) conditions:
New

Convert xml data to postgresql table

greenCat — Thu, 04 Sep 2014 17:19:48 +0800

Hello Master

Any solution or idea of how to convert XML data into pgsql table.

Details
One of the server (sql server) will send data .xml everyday via FTP and now my problem is still can't find solution how to insert into pgsql table.

XML format

» Click to show Spoiler - click again to hide... «

Convert to table.FYI,table already created in pgsql.

» Click to show Spoiler - click again to hide... «

Thank you

[WTS] Mosquito Net/Kelambu Moden

greenCat — Wed, 03 Sep 2014 22:18:33 +0800

Item(s): Mosquito Net/Kelambu Moden

» Click to show Spoiler - click again to hide... «

[WTS] : pregnancy and breastfeeding baju kurung

greenCat — Sat, 24 Aug 2013 11:25:22 +0800

Item(s): Nursing Baju Kurung for pregnancy and breastfeeding mom

Price:RM 159

Dealing method:FREE postage and COD at PJ / Damansara /Subang area ONLY (no further discount for COD)

Contact method/details:PM or reply directly to this post

Age of item:NEW

---

Item(s) conditions:NEW

Picture:

Baju 1
[attachmentid=3596559]

Baju 2
[attachmentid=3596560]

Baju 3
[attachmentid=3596561]

Baju 4
[attachmentid=3596562]

Baju 5
[attachmentid=3596563]

Baju 6
[attachmentid=3596573]

Baju 7
[attachmentid=3596576]

Baju 8
[attachmentid=3596579]

Baju 9
[attachmentid=3596580]

Descriptions
[attachmentid=3596571]

[attachmentid=3596572]

Reason for sale:Clearance Stock

Limited quantity and size(currently, all size still available).PM me for any inquiry.

Javascript

greenCat — Fri, 21 Oct 2011 10:19:30 +0800

hello

i'm newbie in programming and i got the problem currently.

question is how can i do from select list/menu

CODE

you can see a,b..
so from there when i select a button A will appear then when i select b button B will appear..

CODE

is like

CODE

if selected = 'a'
out='button A'
else
out='button B'

please help ya..done goggling

ASP Classic

greenCat — Sat, 26 Mar 2011 15:46:51 +0800

Dear All

I really2 need help..almost 2 days stuck at searching..
question anyone have multiple searching coding using asp..can share?

this is wat i want to do..

there are 3 option or searching..by name ,by location,by region

for the first display all data with paging..on top it has searching.
<textfield>name</textfield> <list/menu>location</list/menu> <list/menu>region</list/menu>

when search by region it will display all region are selected..then it allow to filter by name to get specific.

» Click to show Spoiler - click again to hide... «

thanks

MVC 3 ASP.NET

greenCat — Wed, 02 Mar 2011 09:32:27 +0800

Hello Pro

i newbie in MVC ASP.NET and try to play with it..i follow tutorial from this but now stack at access login..anyone can show me how to do..

here is my code for Controller

» Click to show Spoiler - click again to hide... «

AccountController is

» Click to show Spoiler - click again to hide... «

FYI,already set in security site and set ROLE= admin and user..When i enter username & password for admin is ok (go to insert) but for user nothing happen , it loaded in same page..or maybe in Account code i none to direct?

thanks & regards
-greenCat-

CIMB Interview

greenCat — Mon, 28 Feb 2011 16:05:28 +0800

Hello all

just now my gf got call from cimb invited her come for the interview this wednesday. She study in IT field and totally dont know what the questions will ask. During conversation my gf asked requirement and caller said is job description is about approve loan and salary offer 3k.

anyone hv experience on that..can share with us.

thanks

ASP && ms sql

greenCat — Thu, 24 Feb 2011 12:17:14 +0800

Dear all

anyone can teach me how to combine this two field in ms sql 2000..

problem

CODE

SELECT AssetStatus, DateCreated, Log_dateSntRegion, DATEDIFF(d, DateCreated, GETDATE()) AS datecreate, DATEDIFF(d, Log_dateSntRegion, GETDATE())
AS region
FROM dbo.tbl_Master
WHERE (AssetStatus = 'Sent to RO/Hospital') OR
(AssetStatus = 'MMDC in process')

output see attached

to learn

if LogdateSntRegion not is null select LogdateSntRegion but if LogdateSntRegion is null select dateCreate..then update in one field..hope can understand

tq

PHP Paging

greenCat — Wed, 05 Jan 2011 22:40:00 +0800

» Click to show Spoiler - click again to hide... «

sorry if my code look very crowded bcause i dont know which part i need to skip..

Actually this paging already function but still got problem.when i click to next page it goes to page no 3 so page no 2 skip..

to all pro..someone can teach me how to write paging code.. i really newbie in PHP.
i prefer page like LYN paging.see below..thanks

Car Loan

greenCat — Fri, 17 Dec 2010 14:36:26 +0800

Hello

I decide to buy new car this month.So now i got offer from ambank but quite confused because they offer me BLR plan..sound like interesting so i accepted it.

» Click to show Spoiler - click again to hide... «

file attached

let discuss about advantage and disadvantage..suggestion should i proceed or change plan?

thanks & regards
-greenCat-

ASP Searching

greenCat — Mon, 25 Oct 2010 10:54:21 +0800

CODE

[bad html removed]#include file="rcvPcb1.asp"-->

<html>
<head>
<%
ShowRecCount = "Yes" 'Yes or No (do you want to show the record count column on your page?) -Case Sensitive
RecsPerPage = 50 'number of records to show per page

SQL = "SELECT * FROM detail_report" 'actual SQL statement & yes you may include a where clause... the script can handle it.
ShowFieldNames ="DoNo///AssetNo///SerialNo///LRNo///AssetCategory///Model///Manufacturer" 'Seperate ACTUAL database fieldnames with ///

ShowSearch = "Yes" 'Yes or No (do you want to show the search option on your page?) -Case Sensitive
SearchChoices = "Jan///DoNo///LRNo///SerialNo" 'Seperate ACTUAL database fieldnames with ///
SearchChoicesShow = "Jan///DO No///LR No///Serial No" 'Seperate Show Names with /// MUST match order of SearchChoices above

ShowHeaders = "Yes" 'Yes or No (do you want to show the Headers on your page?) -Case Sensitive
ShowFieldHeaderNames = "DO NO///ASSET NO///SERIAL NO///LR NO///ASSET CATEGORY///MODEL///MANUFACTURER" 'Seperate Header Names with /// MUST match order of ShowFieldNames above

ShowMoreInfo = "Yes" 'Yes or No (do you want to show the More Info Link on your page?) -Case Sensitive
JumpPage = "cal4.asp" 'somepage.asp this is where you want the More Info Link to goto
JumpQuerystring = "ID" 'some varable for request.querystring
JumpKey = "ID" 'The database field ID name (must be a real database field)
MoreInfoText = "Update" 'What do you want the jumppage link text to say

response.write CreatePagination(ShowRecCount,RecsPerPage,SQL,ShowFieldNames,ShowSearch,SearchChoices,SearchChoicesShow,ShowHeaders,ShowFieldHeaderNames,ShowMoreInfo,JumpPage,JumpQuerystring,JumpKey,MoreInfoText)
%>
</body>
</html>

CODE

[bad html removed]#include file="conn.asp" -->
<script type="text/javascript">

function redirect(url) {
window.location = url;
}
function beginSessionTimer() {
// 30000ms = 30s
window.setTimeout(redirect, 6000000,
"../logout.asp");
}

</script>
<%
Session("name")

'Pick your database....
Dim rsFeedback 'Holds the recordset for the records in the database'
Dim strSQL 'Holds the SQL query to query the database'

Set rsFeedback = Server.CreateObject("ADODB.Recordset")

'Initialise the strSQL variable with an SQL statement to query the database'
strSQL = "SELECT * FROM tbl_assets2010;"

'Open the recordset with the SQL query'
rsFeedback.Open strSQL, oConn

Function CreatePagination(ShowRecCount,RecsPerPage,SQL,ShowFieldNames,ShowSearch,SearchChoices,SearchChoicesShow,ShowHeaders,ShowFieldHeaderNames,ShowMoreInfo,JumpPage,JumpQuerystring,JumpKey,MoreInfoText)
' records per page'
recordsonpage = RecsPerPage

' count all records'
allrecords = 0
If ShowSearch = "Yes" Then
'write necessary javascript commands'
%>
<script LANGUAGE=Javascript>
function mSubmit(){
//document.form.submit();
//alert(document.form.xwith.value);
document.location.href='?xwhat='+document.form.xwhat.value+'&xwith='+document.form.xwith.value+'';
}
</SCRIPT>
<style type="text/css">
[bad html removed]
@import url("images/links.css");
@import url("links.css");
@import url("../images/link.css");
body,td,th {
font-family: Arial, Helvetica, sans-serif;
font-size: 8pt;
}
#apDiv1 {
position:absolute;
width:189px;
height:67px;
z-index:1;
left: 1004px;
top: 112px;
}
body {
margin-top: 0px;
}
.style3 {font-size: 12px}
.style1 {color: #FFFFFF}
-->
</style>
<script type="text/javascript">
[bad html removed]
function MM_preloadImages() { //v3.0
var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
//-->
</script>
<title>PayDoc System - Finance</title>
<link href="../link.css" rel="stylesheet" type="text/css">
<style type="text/css">
[bad html removed]
.style7 {
font-size: 14px;
font-weight: bold;
}
.style9 {font-weight: bold}
-->
</style>
<body onFocus="form.xwith.focus();" onload='beginSessionTimer();'>
<table width="1000" height="51" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="379" height="32"><img src="../images/logo.png" width="276" height="32" /></td>
<td width="524"> </td>
</tr>
<tr bgcolor="#c32033">
<td><span class="style1"><img src="../images/spacer.gif" width="10" height="1" />Welcome
<%Response.Write(Session("username"))%>
,
<%Response.Write(Session("designation"))%>
</span></td>
<td><div align="right"><a href="../logout.asp"><strong>LOG OUT</strong></a><strong></strong></div></td>
</tr>
<tr bgcolor="#c32033">
<td colspan="2" bgcolor="#FFFFFF"><span class="style3 style9"><a href="CalSearch.asp">Receive From Logistic</a> | Receive From PCB LAB |<a href="CalSearchCert.asp"> Asset Certificate</a> |<a href="pending.asp"> Pending Docs</a> | <a href="complete.asp">Complete Docs</a> | <span class="style3 style8"><a href="new.asp">New Asset</a> |</span> <a href="Search.asp">Search</a></span></td>
</tr>
<tr bgcolor="#c32033">
<td colspan="2" bgcolor="#FFFFFF"><img src="../images/line.jpg" width="1000" height="2"></td>
</tr>
</table>
<p><span class="style7"><u>Receive From PCB LAB</u></span>
<%
'split the SearchChoices & SearchChoicesShow
ListSearchChoices = Split(SearchChoices,"///")
ListSearchChoicesShow = Split(SearchChoicesShow,"///")
'create drop down
For i = 0 to Ubound(ListSearchChoices)
If request.querystring("xwhat") = ListSearchChoices(i) Then
addselect = " selected"
Else
addselect = ""
End if
daDropDown = daDropDown & "<option value='"& ListSearchChoices(i) &"' "& addselect &">"& ListSearchChoicesShow(i) &"</option>"
next
'add to sql WHERE statement
if request.querystring("xwhat") <> "" then
SearchWhat = request.querystring("xwhat")
SearchWith = request.querystring("xwith")
else
SearchWhat = ListSearchChoices(0)
SearchWith = "%"
end If
If InstrRev(LCase(SQL), "where") <> 0 Then
xwhere = " and "
Else
xwhere = " where "
End if
SQL = SQL &" "& xwhere &" "& SearchWhat &" like '"& SearchWith &"%'"
if SearchWith = "%" then
SearchWith = ""
end if
End if
set rs = oConn.Execute(SQL)
do until rs.EOF
allrecords = allrecords + 1
rs.movenext
loop

' if offset is zero then the first page will be loaded
offset = request.querystring("offset")
if offset = 0 OR offset = "" then
requestrecords = 0
else
requestrecords = requestrecords + offset
end if

' opens database'
set rs = oConn.Execute(SQL)

' reads first records (offset) without showing them (can't find another solution!)
hiddenrecords = requestrecords
do until hiddenrecords = 0 OR rs.EOF
hiddenrecords = hiddenrecords - 1
rs.movenext
if rs.EOF then
lastrecord = 1
end if
Loop
%>
<% If ShowSearch = "Yes" then%>
</p>
<form action="?" method="post" Name="form" >
<strong>Search:</strong>
<input id="xwith" name="xwith" type="Text" size="" onChange="mSubmit();" value="<%=SearchWith%>" onFocus="if (this.createTextRange) {var r = this.createTextRange(); r.moveStart('character', this.value.length); r.select();}">
   
<select name="xwhat" onChange="mSubmit();">
<%=daDropDown%>
</select>
<label>
<input type="button" name="button2" id="button2" value="Search">
</label>
</form>
<% End If %>
<table cellspacing="0" cellpadding="3" border="0" bordercolor="#c32033" width="1000" bgcolor="#ffffff">
<%

ListShowFieldHeaderNames = Split(ShowFieldHeaderNames,"///")

If ShowHeaders = "Yes" then %>
<tr>
<% If ShowRecCount = "Yes" Then %>
<td bgcolor="#c32033"><B><FONT COLOR="#ffffff">Bil.</FONT></B></td>
<% End If %>

<% For i = 0 to Ubound(ListShowFieldHeaderNames) %>
<td bgcolor="#c32033"><B><FONT COLOR="#ffffff"><%=ListShowFieldHeaderNames(i)%></FONT></B></td>
<% Next %>

<% If ShowMoreInfo = "Yes" Then %>
<td bgcolor="#c32033"><B><FONT COLOR="#ffffff">Action</FONT></B></td>
<% End If %>
</tr>
<% End If %>

<%
' prints records in the table'
showrecords = recordsonpage
recordcounter = requestrecords
do until showrecords = 0 OR rs.EOF
recordcounter = recordcounter + 1

ListShowFieldNames = Split(ShowFieldNames,"///")

%>

<tr onMouseOver="this.style.background='#f8db97';" onMouseOut="this.style.background='#ffffff';">

<% If ShowRecCount = "Yes" Then %>
<td width="5"><% = recordcounter %>)</td>
<% End If %>

<% For i = 0 to Ubound(ListShowFieldNames) %>
<td><% = rs(ListShowFieldNames(i)) %></td>
<% Next %>

<% If ShowMoreInfo = "Yes" Then %>
<td><a href='<%=JumpPage%>?<%=JumpQuerystring%>=<%If JumpKey <> "" Then response.write rs(JumpKey) End if%>'><%=MoreInfoText%></a></td>
<% End If %>

</tr>
<%
showrecords = showrecords - 1
rs.movenext
if rs.EOF then
lastrecord = 1
end if
loop
%>
</tr><tr>
<% 'manage table spacing correctly
xtrafieldcount = 1
If ShowRecCount = "Yes" Then
xtrafieldcount = xtrafieldcount + 1
End If
If ShowMoreInfo = "Yes" Then
xtrafieldcount = xtrafieldcount + 1
End If
ListShowFieldNames = Split(ShowFieldNames,"///")

%>
<td colspan="<%= Ubound(ListShowFieldNames) + xtrafieldcount %>">
<table cellspacing="5" cellpadding="5" border="0" width="100%">
<tr>
<td align="center"><span class="style3">
<% if requestrecords <> 0 then %>
<a href="?offset=<% = requestrecords - recordsonpage %>&xwhat=<%=request.querystring("xwhat")%>&xwith=<%=request.querystring("xwith")%>"><img src="previous.gif" border="0" alt="Previous Page"></a>
<% else %>
<img src="blank.gif" border="0">
<% end if %>
   
<%
pagelist = 0
pagelistcounter = 0
do until pagelist > allrecords
pagelistcounter = pagelistcounter + 1

If CDbl(request.querystring("offset")) = CDbl(pagelist) Then %>

<% = pagelistcounter %>

<% Else %>
<a href="?offset=<% = pagelist %>&xwhat=<%=request.querystring("xwhat")%>&xwith=<%=request.querystring("xwith")%>">
<% = pagelistcounter %>
</a>
<% End if
pagelist = pagelist + recordsonpage
loop
%>
   
<% if lastrecord <> 1 then %>
<a href="?offset=<% = requestrecords + recordsonpage %>&xwhat=<%=request.querystring("xwhat")%>&xwith=<%=request.querystring("xwith")%>"><img src="next.gif" border="0" alt="Next Page"></a>
<% else %>
<img src="blank.gif" border="0">
<% end if %>
</span></td>
</tr>
<tr><td bgcolor="#BFE4FA">

</tr>
</table>

<%
' Closes connection
rs.close
oConn.close
%>

<%
End Function
%>

Hello gud morning
Above there are 2code related with each others..original code only have 1 textfield and list/menu(selected) then sumbit button..
Now on this code i want to remove textfield then insert another list/menu..so i will hv 2 list/menu..so on the both list i want search by month and year.

example
when user select month then select year so report will generate..e.g select Jan(1st list) and 2010(2nd list) -->sumbit

------------------report generate----------------

any ideas?

thank and regard

Locked Out Automatic problem

greenCat — Fri, 22 Oct 2010 11:42:26 +0800

[attachmentid=1846866]

I got this problem since last 2 month.every 30minit user complaint they cannot print..when i checked it is coz of account locked out.so to enable i need to setup in Active Directory user and comp..then click on checkbox.

Question
How to disable automatic user lock out for all window.

plz help.thank

ASP

greenCat — Mon, 23 Aug 2010 11:48:02 +0800

Hello everyone..
i really need ur help.anyone know how to set datetime format for sql server..at form i set dd/mm/yyyy but when sumbit in database it will appear mm/dd/yyyy..

CODE

[bad html removed]#include file="conn.asp" -->
<%
'Declare variable.'
Dim dtmVar

'Assign the variable a value.'
dtmVar = #08 / 27 / 97 5:11:42pm#

'Set the variable to the web server date and time.'
dtmVar = Now()
i=1
'Dimension variables
'Dim adoCon 'Holds the Database Connection Object
Dim rsUpdateEntry 'Holds the recordset for the record to be updated
Dim strSQL, DO_id 'Holds the SQL query to query the database
'Dim lngRecordNo 'Holds the record number to be updated'
Dim ChequeReleaseDate,rs1

'Read in the record number to be updated'
'lngRecordNo = CLng(Request.Form("ID_no"))'
'DO_id = CLng(Request.Form("Code_id"))'

'TEST'
set rs1 = server.CreateObject ("ADODB.Recordset")
'rs1.Open "SELECT * FROM login where id=" & Session("userID"), oConn, 3, 3 '
'rs1.Open "SELECT * FROM tbl_Assets2010 where Code_id=" & DO_id, oConn, 3, 3 '
'Receiving values from Form, assign the values entered to variables'

ChequeReleaseDate=Request.Form("ChequeReleaseDate")

'Create an ADO recordset object'
Set rsUpdateEntry = Server.CreateObject("ADODB.Connection")

'Initialise the strSQL variable with an SQL statement to query the database'
strSQL = "Insert into tbl_test(testDate)values ('ChequeReleaseDate &')"

'Open the recordset with the SQL query'
rsUpdateEntry.Open (oConn)
rsUpdateEntry.execute (strSQL)

'Reset server objects'
rsUpdateEntry.Close
Set rsUpdateEntry = Nothing
Set oConn = Nothing
'Return to the update select page in case another record needs deleting'
Response.Redirect "acknowledge.asp"
%>

tq
ps: google done

SMIL

greenCat — Sun, 21 Mar 2010 01:07:21 +0800

hello
SMIL stand for Synchronized Multimedia Integration Language.
anyone here heard language above..I need to make presentation slide using SMIL so i lazy lol to study and type that coding.
so who know how to make it faster such as use SMIL creator ke.hehe help ya

blogspot

greenCat — Wed, 17 Mar 2010 21:13:59 +0800

hello
i super newbie as a blogger but know i already hv i portfolio blog..
question

how to upload flash .swf to blogspot and where free database should i go to get url.
thank you

a.script+xml

greenCat — Tue, 16 Mar 2010 15:05:58 +0800

hello everyone..I'm newbie here and beginner in flash..now i develop 1 project using flash(a.script)+database(xml)..
question
1.How to load xml in flash?
2.anyone here already developed dictionary,using what?

what i want to develop same below
http://www.flash-db.com/remoting/mmhelp/

hope u all can help me