SierraDNA and pgadmin software

Download  pgAdmin software, then fill in the following setup screen:

Server IP Address,  Port #: 1032,  Sierra User Name,  Password






under the SSL tab, make sure SSL is set to "Required"






If all is correct, this is what it looks like:




Click on the SQL button to run queries:





...

Using SierraDNA, SQL, and Innovative

Start by looking as these links for documentation, (CSdirect & Sierra)

•Sierra Documentation

•Sample SQL queries

•TechDocs (Table Specs)

•Sierra Listserv  

In Sierra Admin, create  User with permission to access "Sierra SQL Access" under applications: Sierra Administration Application

Goto PGadmin.org to download the software that is easiest to connect to SierraDNA

Startup folder in Windows 7

Place any shortcut of a program/webpage that you want to open on login to Windows 7:

C:\Users\<user-name>\AppData\Roaming\Microsoft\Windows\Start Menu\Programs\Startup

copy and paste scrubber: clipboardfusion

Here is Windows freeware to scrub HTML and formatting from copied items:

http://www.clipboardfusion.com/

Nice utility for copy and paste, clipboard.  Allows you to define macros and hotkeys.  Clipboard fusion

Using jQuery to dynamically control HTML

Have a web page with separate Windows and Apple instructions, want to only show Apple links on Apple laptop, etc.

First have link to jQuery:

<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js"> </script>

Then you can use jQuery hide & show functions, remember to put these functions AFTER the target class or id, otherwise it will not have any effect.

<script>
$(".1class_name").hide();
$("#1id_name").show();
</script>

 You could do all P tags  ("p"), one class  (".this-class") , or one id  ("#one_id")



From w3schools.com