chris-vanvranken

1. Create a free account with github
2. Email chris with your account name. Chris will add your account to the issues repository
3. login to github, use the dropdown on the left side of the frontpage, just underneath the github logo to change your account context to urmc-pathology.
4. click the repository link that appears on the right side.
5. click the issues tab to view issues.
6. click watch and select "watching" to receive emails when issues are updated.

chris-vanvranken

SQL Developer Manual

Problems unique to querying Oracle from Access

Syntax Error in FROM clause, invalid use of vertical bars in query expression

Oracle queries can fail for no good reason when running in Access.

When using || to concatenate, or at other times.

chris-vanvranken

create a subquery using the WITH keyword

http://msdn.microsoft.com/en-us/library/ms175972.aspx

WITH Sales_CTE (SalesPersonID, NumberOfOrders)
AS
(
    SELECT SalesPersonID, COUNT(*)
    FROM Sales.SalesOrderHeader
    WHERE SalesPersonID IS NOT NULL
 GROUP BY SalesPersonID

chris-vanvranken

How to Manipulate the DataTables

protected override Option<DataTable> _ConstructDataTable(GetSoftOracle soft)
{
   return Option.Some(soft.
     FilledTable(Query.get("softquery",orderControl.OrderRangeFrom,orderControl.OrderRangeTo))
   );
}

chris-vanvranken

#Description The FileSystemFaxing Service sends out an Email to faxNumber@eFaxsend.com when a new file is created under a subdirectory of C:\FileSystemFaxing. The created file is attached to the email so that eFaxsend.com will send the attachment as a fax to the given faxNumber. eFaxsend.com sends a notification to a shared mailbox, lis-rr@URMC.rochester.edu, when faxes are successfully (or unsuccessfully) sent out. Currently installed on the CLSS Automation PC.

##Features

• Supports faxing any of these eFaxSend file types including PDF and HTML
• Ignores files created with names starting with "!" or ending with ".ini"
• Ignores files in Directories named "Faxed"
• Reads parameters from fax.ini

##fax.ini