Wish list
If you like this blog and want to say thanks in some way, here is my wish-list on Amazon. It'll be very cool to get a gift from my subscribers. Just don't forget to put your name on it -)Tags
Author Archives: admin
Buttons on forms?
Long time ago we needed to have a button on HRNET screen. If you work with HRNET, you know, there are no buttons available on the screens. Today almost no need for buttons, but I’ll tell you how the buttons … Continue reading
Function in computed field in temp table
It is not easy to set up function on computed field in temp table. I spent the whole day trying to resolve this… and here is the answer: use hrnetdev declare @functions nvarchar(4000) set @functions = ‘ use [tempdb] IF … Continue reading
Parse Hrnet Date
Simple snippet for Custom Scripts: convert form HRNET date string into JavaScript format /** * Parce from string representind date in format “dd/mm/yyyy” into JavaScript Date format */ function parseDate(strDate){ var array = strDate.split(“/”); return new Date(array[2], array[1]-1, array[0], 0,0,0); … Continue reading
Screen Validation
Many times I need to validate entries on the screen via JavaScript (or Custom Script, in terms of HR.Net). For about a year I struggled with validation via overloading function “Page_ClientValidate“. But when you overload this function, you can’t run … Continue reading
Posted in Uncategorized
Tagged code, custom script, javascript, Screen, snippet, validation
3 Comments
Drupal and HRNET
Would anybody be interested in module for Drupal that interacts with HRNET? Currently I’m working on one of the subsystems and building a module for Drupal to read/write data from HRNET, and I can see how this can be developed … Continue reading
Posted in Uncategorized
Leave a comment
Table definitions
For those of you wanting to know where HRNET stores meta information about tables and table-fields: look into oc_fileddefs for field definitions – type of data, validation, etc. For field captions and descriptions go to oc_filedlanguages.
PHP Error: unable to get Memo fields from HRNET
When I was doing select statement from HRNET database, one of the problems was that I got error looking like this: warning: mssql_query() [function.mssql-query]: message: Unicode data in a Unicode-only collation or ntext data cannot be sent to clients using … Continue reading
Regexp to validate MS SQL uniqueidentifier
I’m working on PHP project that interacts with HRNET and at some point I need to validate if given string is valid mssql guid. For this I use php regular expression: ^[0-9a-zA-Z]{8}-[0-9a-zA-Z]{4}-[0-9a-zA-Z]{4}-[0-9a-zA-Z]{4}-[0-9a-zA-Z]{12}$
More JavaScript snippets
To open help screen: ShowHelp(); Returns true or false depending if the form validates or not. IsPageValid(); To switch screen into attached documents, print this setTimeout(“ShowAttachedDocs()”,0); if you print only ShowAttachedDocs() – this will give you an error when you … Continue reading
Find End of a Day for Given Date
Determines the last second for the day for the given date CREATE FUNCTION [dbo].[EndOfDay] ( @DATE DATETIME ) RETURNS DATETIME AS BEGIN RETURN DATEADD(s,-1,DATEADD(d, DATEDIFF(d,0,@DATE)+1,0)) END