Lowyat.NET: Latest topics by purplestar

Change Stainless Steel Sink

purplestar — Sat, 20 Jan 2018 22:46:40 +0800

I wish to change my existing sink in my wet kitchen. Where can i get it?
My existing sink overall : 79*46.5cm
The Sink Hole : 74*42cm
Budget : Less than RM 500.

Anyone know where can i get the sink (double sink in a set is more preferable)

selayang Hospital to terminal bus station

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

selayang Hospital to terminal bus station

purplestar — Sun, 28 Aug 2011 12:55:31 +0800

I need to travel from selayang hospital to tasik selatan bus station.
May i know how / which is the convenient way to reach there?

If i need to take taxi from Selayang hospital to tasik selatan bus station, may i know how much of the taxi price rate?

Is there any other public transport near Selayang hospital?

Appreciate and thanks for help.. please...

Macro (DB Connection to VBA) Issue - ORA 12154

purplestar — Mon, 23 May 2011 18:00:39 +0800

hi all,

I try to connect to the oracle db through excel Macro VBA, when i test it, i found the error message:

ORA 12154 TNS:could not resolve the connect identifier specified

I try to connect this servername with same username and password, it can be connected.

Anything going wrong?

'Create a reference to the OO4O dll
Set objSession = CreateObject("OracleInProcServer.XOraSession")
'Create a reference to my database
Set objDataBase = objSession.OpenDatabase(Sheet8.Cells(2, 4), Sheet8.Cells(3, 4) & "/" & Sheet8.Cells(4, 4), 0)

Help please...

[addedon]May 24, 2011, 5:11 pm[/addedon]I used another to define the connection String but hit the issue for
ORA-06413: Connection not open

strConnection = "UID=MIGRATION01;PWD=" & strPassword & ";driver=" _
& "{Microsoft ODBC for Oracle};SERVER=strServer;"

Set conn = CreateObject("ADODB.Connection")

conn.ConnectionString = strConnection

conn.Open

[addedon]May 25, 2011, 12:23 pm[/addedon]I found that it's not the connection script problem, the code that tested in another computer are works because it 's Window XP but my laptop is Window 7.

Is there any configuration need to setup in Window 7?

Anyone can help? Thanks...

CSS: Set border radius and shadow in UI for Web

purplestar — Wed, 06 Apr 2011 13:26:35 +0800

Hi all,

I face a problem for set the border radius and shadow.

I set
-moz-border-radius: 7px 7px 7px 7px;
-webkit-border-radius: 7px 7px 7px 7px;
border-radius: 7px 7px 7px 7px;
-moz-box-shadow: 2px 2px 4px 2px #CCCCCC;
-webkit-box-shadow: 2px 2px 4px 2px #CCCCCC;
box-shadow: 2px 2px 4px 2px #CCCCCC;

in my .css file. It can shows in Morzilla Firefox Web browser but it cant be shown in Internet Explorer Web Browser.

Anyone can help please? Thanks..

DB - Union two Cursors values return into 1 cursor

purplestar — Mon, 04 Apr 2011 12:22:30 +0800

Hi,

I have an idea to call two stored procedure and combine the values of the cursors that return from these two stored proc and union them in a new cursor.

Is that possible?

Please help ...thanks.

How to: Validate variable format in sql

purplestar — Mon, 14 Mar 2011 18:23:58 +0800

I need to do the checking for a variable in stored procedure.

eg:

v_string := 'ABC1234H'
v_string2 varchar(10);

check..
if v_string is started from two char and following by 4digits then
v_string2 :='Correct';
else if v_string is started from one char and following by 4digits then
v_string2 :='Slidely Different from format';
else v_string2 := 'Incorrect';

Anyone can help? Thanks...

How to access the key/value information from Hashm

purplestar — Thu, 03 Mar 2011 19:32:10 +0800

If I am using a Hashmap as the datasource for my <netui-data:repeater> tag,=
how can I get at the key/value pairs? I tried using {container.item.key} =
and {container.item.value}, but this did not work. Is this supported? Is =
there some special syntax that I need to use? I need to be able to extract=
out both the key and the value.

Any help is greatly appreciated.

How to: Grouping of Drop Down List

purplestar — Wed, 02 Mar 2011 20:05:09 +0800

Anyone can teach me how to do the drop down list by grouping those data source.

Eg is shown as the pic clip below..

[attachmentid=2070753]

How can i get the data source from db and put it in the grouping drop down list.

Can i use <netui:select> to do this?

[addedon]March 3, 2011, 10:02 am[/addedon]Anyone can help? or other way than <netui:select> such as <select> but how can i get the data from data source?

SQL QUERY for Funky Character (¿)

purplestar — Mon, 17 Jan 2011 11:57:55 +0800

I need to search the records which contain the funky character (¿).
I have used LIKE to search for that but it return nothing. Is there any special way to find out that?

The query i use as below:

SELECT * from account_table where address_city LIKE '%¿%'

Anyone have idea on this ?