Tutorial Php Project Using Wamp Server And Netbeans IDE

Honestly I just read and follow this 1 blog and I manage to use my netbeans with wamp server.

Credit to : https://hassoon3.wordpress.com/2011/12/18/developing-php-with-netbeans-7-0-1-and-wamp2-2-server/

Fatal error: Call to undefined function mb_detect_encoding() in C:\wamp\apps\phpmyadmin4.0.4\libraries\php-gettext\gettext.inc on line 177

I did follow too many post about this problem.. Finally I follow the following link :  http://stackoverflow.com/a/18694767  and able to open my phpmyadmin .. :)

How to fix the “api-ms-win-crt-runtime-l1-1.0.dll is missing” error when installing Apache Wen Server

Having this little problem when trying to install Apache on my new office PC.
What i do is, getting help from Mr. Google.

Credit to : http://blog.spreendigital.de/2015/09/01/how-to-fix-the-api-ms-win-crt-runtime-l1-1-0-dll-is-missing-error-for-delphi-10-seattle/  by Dennis D.Spreen

What i need to do is installing Visual C++ Redistributable for Visual Studio 2015 (32-bit)
 for Windows  32-bit

IIF Statement With Wildcard Condition In Access

Criteria :  All records where unit price is 0.99 or 1.99 or 2.99 or 3.99

Besides using the = operator in the expression for exact matches, we can also use other operators.
For example, for partial matches of text strings/numbers, we can use LIKE "*".

Credit to : http://www.access-programmers.co.uk/forums/showthread.php?p=471291#post471291


Example : Total2: IIf([Total] Like "*.99", True, False)


Criteria  : Multiple IIF in Access

Example : SWITCH (Criteria, TrueResult, Criteria2, TrueResult2, Criteria3, TrueResult3, Criteria4, TrueResult4)

 or by using Nested IIF

Example  : IIF( Criteria, TrueResult, IIF(Criteria, TrueResult, IIF(Criteria,
TrueResult, FalseResult)))
Credit to  : http://www.pcreview.co.uk/threads/multiple-if-else-in-ms-access.2789488/ 

Specifying Textual Criteria That Comes from a Field on a Form:

=DLookUp("[EMAIL]","penyelia","[NAMA PEGAWAI] = '" & [Forms]![borang]![NAMA PENYELIA] & "'")

Email – specific field

Penyelia – table

Nama penyelia – field yg berkaitan

Forms – berdasarkn borang

Borang – form name

Nama penyelia – field ygdiisi

=[nmPenyelia] & IIf(Nz([penyelia.EMAIL])<>""," [" & [penyelia.EMAIL] & "]")

TIMEDIFFERENCE IN ACCESS

Start time 01:10:53
Stop time 01:20:05
Duration IJAM, 40MINIT

USING DATEDIFF

EXAMPLE : Minutes: DateDiff("n",[STARTTIME],[STOPTIME])

DURATION: [Minutes]\60 & Format([Minutes] Mod 60,"""JAM,  ""00""MINIT""")

Total 2 column When 1 Column Has A Null Value

Problem  : I have 2 column that contain numeric fields but then one column sometimes does not have any value, means that it has null value.

Solution :  Use NZ function to convert the values to zeroes.

Example : NZ ([columnName1, 0 ]) +  NZ([columnName2, 0])

Running Number On Report MS Access

Problem :  Running number for each records for report  MS Access / Numbered Query

Solution : First add unbound text box. Then click properties, control source is = 1 and set Running Sum
               to all over.

                                       

Credit To : http://rogersaccessblog.blogspot.com/2010/12/domain-function-examples-numbered-query.html

Relationship Indeterminate

Problem : I want to create One-To-Many relationship between 2 tables, but it show indeterminate.

Solution : Specific fields must be primary and make sure dekat properties tu choose no duplicate.

Include All Records On Query

Right now I'm working on access project..

Problem : Pegawai yang tidak berkursus tidak akan di display dalam result query

Solution : Click edit the relationship line in the query and select the 2nd radio button to include all records from the first table termasuk pegawai yang belum pernah berkursus.

Credit to : http://stackoverflow.com/users/13302/marc-s

Uztaz Azhar Idrus

Today : 11.11.2011

Its been a while since I write something on my blog.
Malas nak tulis apa2 la...xdak idea.hehe..
Saja nak wat entri sbb date hri ne mcm best jak...=)
see u next time ..

Cronjob + Ruby Script

######### To Run Ruby Script Manual#########
/home/path/of/ruby/script ruby script.rb

########## To Run Ruby Script With Cronjob ##########
crontab -e

-------------------

RAILS_ENV=production

*/5 * * * * /bin/bash -l -c 'cd /home/path/of/ruby/script && ruby script.rb'


*p/s make sure script.rb file executeable without any permission denied.can use chmod +x..