Jun 04
function GetLocalUserName : string;
var
Buffer : array[0..255] of char;
Count : DWord;
begin
Count := 256 + 1;
GetUserName(Buffer, Count);
Result := string(Buffer);
end;
Download example
Download source
May 29
#drop trigger
DROP TRIGGER `TRIGGER_NAME`
#auto DateTime, Date, Time
CREATE TRIGGER `TRIGGER_NAME` BEFORE INSERT ON `TABLE_NAME`
FOR EACH ROW SET NEW.DATEFIELD = NOW()
#insert something in another table
CREATE TRIGGER `TRIGGER_NAME` AFTER INSERT ON `TABLE_NAME`
FOR EACH ROW
INSERT INTO another_table SET some_field = NEW.fieldfromparenttable, text_field = 'sometext'
#if statement
CREATE TRIGGER `TRIGGER_NAME` AFTER INSERT ON `TABLE_NAME`
FOR EACH ROW BEGIN
IF NEW.Type = 0 THEN
INSERT INTO another_table SET ParentType = NEW.Type;
END IF;
END
May 28
<?
echo ($a == 0 ? "zero" : "not zero");
?>
http://php.net/ternary
May 28
<?php
$PK = "PrimaryID";
$$PK = "100034";
echo $PrimaryID; // 100034
echo $$PK; // 100034
?>
May 28
<?
define("VERSION", 2);
echo "Current version is " . VERSION;
?>
Recent Comments