LODESTAR ASP code snippets

Loading EIP on Win 7

2012-10-30T16:29:00.001-04:00

The IIS 7 LODESTAR virtual site was never created.

Here is what I had to check:

Withing the add components - IIS - app dev - check all boxes

New favorite place to hang out

2012-10-29T14:27:00.000-04:00

American Restaurant

Random value in a range

2012-05-23T18:21:00.003-04:00

Update a value in SQL Server 2008 with a random value in a range:

ABS(CHECKSUM(NEWID())) % 300 + 110 (that will add numbers between 110 and 409

Worket Custom Function

2012-05-21T10:22:00.000-04:00

Here is how to create a custom function to manipulate 2 or more cuts in a workset in LODESTAR 1.6
Files needed to change:
FuncProg2.asp
functions.xsd
dictionary.dic
Function.asp
FunctionCuts.xslt

To add scalar operators: add to:

To create the custom function, add this to the functions.xsd file.


                 
            Cut2 = CreateCopy();

cut 1 = current cut
cut 2 = cut that is created after math operation
cut 3 = second selected cut for operation
New Function in funcprog2.asp

CSS style for native framework date popups (date picker)

2011-03-29T11:26:00.002-04:00

.numeric { behavior: url(/lodestar/Classic/controls/numeric.htc); ls-digits: 2; ls-decimal: .; ls-lead: ; ls-validrange: "Valid range is";}
.date { behavior: url(/lodestar/Classic/controls/date.htc); ls-delimiter: /; ls-popupfolder: /lodestar/Classic; ls-posdate: 1; ls-posmonth: 0; ls-posyear: 2; ls-maskabbrev: dd,MM,yyyy,HH,mm,ss; ls-validrange: "Valid mask is"; ls-months: "January,February,March,April,May,June,July,August,September,October,November,December"; ls-days: "Sun,Mon,Tue,Wed,Thu,Fri,Sat"; ls-navtitle: "Previous Month,Next Month,Previous Year, Next Year, Click to select month, Click to select year"; ls-p_clear: Clear; ls-p_today: Today;}
.datetime { behavior: url(/lodestar/Classic/controls/datetime.htc); ls-sdate: /; ls-stime: :; ls-popupfolder: /lodestar/Classic; ls-posdate: 1; ls-posmonth: 0; ls-posyear: 2; ls-maskabbrev: dd,MM,yyyy,HH,mm,ss; ls-validrange: "Valid mask is"; ls-months: "January,February,March,April,May,June,July,August,September,October,November,December"; ls-days: "Sun,Mon,Tue,Wed,Thu,Fri,Sat"; ls-navtitle: "Previous Month,Next Month,Previous Year, Next Year, Click to select month, Click to select year"; ls-p_clear: Clear; ls-p_today: Today; ls-dayend: End of Day;}
.monthyear { behavior: url(/lodestar/Classic/controls/monthyear.htc); ls-delimiter: /; ls-maskabbrev: dd,MM,yyyy,HH,mm,ss; ls-validrange: "Valid mask is"; ls-months: "January,February,March,April,May,June,July,August,September,October,November,December"; ls-days: "Sun,Mon,Tue,Wed,Thu,Fri,Sat"; ls-navtitle: "Previous Month,Next Month,Previous Year, Next Year, Click to select month, Click to select year"; ls-p_clear: Clear; ls-p_today: Today;}

Custom Theme in 1.6.1

2010-12-06T14:05:00.002-05:00

Create folder under App_Themes, then modify or add Custom.ThemeTab, this file controls where the custom theme will appear.

Window.onLoad problems

2009-05-12T17:17:00.002-04:00

Not related to LODESTAR development but something that annoyed the hell out of me.
On one my pages the Body onLoad stop working, did not fire anymore.
So I used the script window.onload = function.
but first I used window.onload = function() and get a error message
not implemented' javascript error
BECAUSE I USED THE PARENTHESES ........WTF!!

correct syntax = window.onload = function

Add paging

2009-02-19T11:31:00.002-05:00

var PageParams1 = new PageParams(
["SessionId", String, ""],
["Command", String, ""],
["PAGENUMBER", String, "1"],
["ROWPERPAGE", String, "3"]

TableParams.ROWPERPAGE = PageParams1.ROWPERPAGE;
TableParams.PAGENUMBER = PageParams1.PAGENUMBER;

xmlTable = LsdbCommand("LSDB.stored_proc", TableParams);

in code:
<%=Paginator(TableParams["ROWPERPAGE"], TableParams["PAGENUMBER"])%>

Book Suggestion

2009-01-16T20:43:00.006-05:00

Once a while I will be including some books that I think are helpful on your way to become a better developer.
Here is the first suggestion.

Oracle PL/SQL Programming, 4th Edition

Product Description
For the past ten years, O'Reilly's "Oracle PL/SQL Programming" has been the bestselling book on PL/SQL, Oracle's powerful procedural language. Packed with examples and helpful recommendations, the book has helped everyone--from novices to experienced developers, and from Oracle Forms developers to database administrators--make the most of PL/SQL.

The fourth edition is a comprehensive update, adding significant new content and extending coverage to include the very latest Oracle version, Oracle Database 10"g" Release 2. It describes such new features as the PL/SQL optimizing compiler, conditional compilation, compile-time warnings, regular expressions, set operators for nested tables, nonsequential collections in FORALL, the programmer-defined quoting mechanism, the ability to backtrace an exception to a line number, a variety of new built-in packages, and support for IEEE 754 compliant floating-point numbers.

The new edition adds brand-new chapters on security (including encryption, row-level security, fine-grained auditing, and application contexts), file, email, and web I/O (including the built-in packages DBMS_OUTPUT, UTL_FILE, UTL_MAIL, UTL_SMTP, and UTL_HTTP) and globalization and localization.

Co-authored by the world's foremost PL/SQL authority, Steven Feuerstein, this classic reference provides language syntax, best practices, and extensive code, ranging from simple examples to complete applications--making it a must-have on your road to PL/SQL mastery. A companion web site contains many more examples and additional technical content for enhanced learning.

Check for unsaved data and display a confirmation message if so

2009-01-16T20:23:00.001-05:00

Below id the Link function and the necessary parameters that will make it work:

function ContractBasicsSave(){
    Form1.Command.value = "Save";
    isPostBack = true;
    Form1.submit();
}

Call the function from the Body OnUnload Event.
<body onunload="javascript:checkChanges('../zExelon/ContractBasics.asp', 'Save')">

Make sure you manage the isPostBack variable. Every time you do a Postback, you need to set it to true so the message does not fire off if you are doing a postback.

Error Messages

2009-01-16T20:02:00.001-05:00

} catch (e) { ReportError(e); }

– This displays an error message (with red font color and yellow background) wherever it is placed. You can also call this function right after the transaction hyperlinks by inserting the following code: <%if (saveError) ReportError(saveError)%>

Error message for required field: "Required field have missing values".
You can use the alert window to display this. Required fields have an asterisk (*) beside it (example: * Start Time).

Status Messages

2009-01-16T19:58:00.001-05:00

Call the function ReportStatus(s) – this is just a simple formatted Response.Write function.

function ReportStatus(s) {
Response.Write("<div class=StatusBox>" + s + "</div>");

}

Comparing dates in client-side script

2009-01-16T18:56:00.001-05:00

You need to convert them to a Date object. You might also need to convert it to IsoDate format.

var myCQAStart = new Date(Form1.tCQAStartDate.value);
    var myCQAStop = new Date(Form1.tCQAStopDate.value);
    var myCQAMin = new Date(IsoDate(Form1.minStartTime.value));
    var myCQAMax = new Date(IsoDate(Form1.maxStopTime.value));

if (myCQAStart < myCQAMin){

alert("Start Date comes before than the earliest Start Time.");
return false;

}

if (myCQAStop > myCQAMax){

alert("Stop Date comes after than the latest Stop Time.");
return false;

}

Comparing dates in the xsl file (in the SQL statement)

2009-01-16T18:55:00.001-05:00

Use the Oracle to_date function. If you are using an ISO date (if you called DateIso() from ccs/common.js), you must use the date format 'YYYY-MM-DD"T"HH24:MI:SS'

AND (CREATETIME = to_date('<xsl:value-of select="@CREATETIME"/>','YYYY-MM-DD"T"HH24:MI:SS'))

Getting the current date

2009-01-16T18:54:00.001-05:00

Use DateIso(). This is similar to Now() in ASP. Using DateIso() ensures that you are using the correct date format for Lodestar.

To split the date use:

var dt_array=DateIso().split("T");

var newDate = dt_array[0]+" "+dt_array[1];

Numeric text box

2009-01-16T18:52:00.000-05:00

Set the class = “numeric” in your input field.

Looping through an XML object generated by LsdbCommand

2009-01-16T18:21:00.001-05:00

The xml object created by the function LsdbCommand is actually an XMLDOM object so you can use the XMLDOM commands to manipulate the object. getElementsByTagName(element) instantiates your Element object from which you can extract the .length (how many times to loop) and also as a repository of your values. Loop through the XML using the .length value then use the Element object to extract your data. In the case below, .getAttribute(attributename) was used to pull the data.


xmlTable = LsdbCommand("LSDB.sp-get-contractitem",{"UIDCONTRACT":PageParams1.UIDCONTRACT});


xElement = xmlTable.getElementsByTagName("qrySel");

for (i = 0; i < xElement.length; i++){

Response.Write("<br>UIDCONTRACTITEM: " + xElement [i].getAttribute("UIDCONTRACTITEM"));

}

Selecting data from a single table without having to write a XSL stored procedure

2009-01-16T18:19:00.001-05:00

Use the MetaData function. Specify the table name, the parameter and set it to select a single node. You can use the getAttribute function to extract the value.

xmlTest = MetaData("LSCMCONTRACTITEM", {"UIDCONTRACTITEM":"124"}, {"LOOKUPS":"NO"}).selectSingleNode("//LSCMCONTRACTITEM");

Response.Write("<br>UIDCONTRACT: " + xmlTest.getAttribute("UIDCONTRACT"))

Getting data directly from the xml object

2009-01-16T18:18:00.001-05:00

You must select a single node to be able to do this.

var xmlItems = LsdbCommand("LSDB.sp-get-contractlistitem", {"UIDEXECONTRLISTITEM":PageParams1.Scenario[i]}).selectSingleNode("qrySel");

Then you can get the data using the getAttribute function by passing the column name.

xmlItems.getAttribute("UIDCONTRACT")

Using the Sort control:

2009-01-16T18:14:00.001-05:00

Attach <html xmlns:v="urn:schemas-microsoft-com:vml"> in the <html> tag.

Attach <script src="../controls/MultiSorting.js" language="jscript"></script> to the ASP code.

Attach <link rel="stylesheet" type="text/css" href="../controls/MultiSorting.css"> to the HTML code.

Attach the following controls:

Attach <%=ProcessXsl(XmlFreeFile('../cm/SortData.xml'), XmlFreeFile('../controls/MultiSorting.xslt'), void 0, {"urn:ls-proxy" : Proxy1})%> at the bottom of the page.

Using the dropdown date input control

2009-01-16T18:00:00.001-05:00

Set the input css to class=date
Attach ../controls/lsi18n.css to the HTML code
Attach <%= i18nStyles() %> to the HTML code

Get UserID

2009-01-16T17:59:00.001-05:00

var Proxy1 = new Proxy(PageParams1.SessionId);
var UserID = Proxy1.UserId();

Stored Procedures

2009-01-16T17:46:00.000-05:00

Cannot use < (less than) or > (greater than) in the SQL statement (for stored procedures) inside the XSL file(procedures.PROCS.xsl) .
Solution:

Use > and <