tag:blogger.com,1999:blog-3850181493643097742024-10-07T10:39:47.502+05:30Lotus Notes/Domino BlogFlex Integration, Flex Dashboards, Flex Reporting, Flex Charts, Flex Tips, Flex Development, Lotus Domino Web Development, , Flex integration with Lotus Domino, jQyery, Ajax, XPages, Java/J2EERaghuhttp://www.blogger.com/profile/11490582601331789990noreply@blogger.comBlogger33125tag:blogger.com,1999:blog-385018149364309774.post-44051465962221554262010-11-30T23:52:00.000+05:302010-11-30T23:52:15.365+05:30jQuery Mobile has launched API for Mobile Applications DevelopmentHmmm.... jQuery launched Mobile API called jQueryMobile. <a href="http://jquerymobile.com/">http://jquerymobile.com/</a><br />
<br />
I have tried to use this for a blackberry mobile application. But it was not working as it should work :(<br />
<br />
<b>jQuery Mobile issues for BlackBerry device:</b><br />
<br />
The following are the 2 main reasons that i have come across while using jQuery Mobile.<br />
<br />
1. If i use jQuery mobile API, the content loading is very slow, & even a small ajax request is making the browser to hang.<br />
<br />
2. Lists hyperlinks are not working. <br />
<br />
Hope, they will fix all the issues in next release :)Raghuhttp://www.blogger.com/profile/11490582601331789990noreply@blogger.com0tag:blogger.com,1999:blog-385018149364309774.post-89779018713084130222010-10-01T14:57:00.000+05:302010-10-01T14:57:07.047+05:30Unique Variant in LotusscriptGet unique values in a variant by calling the below function in lotusscript.<br />
<br />
Pass the variant to Unique function.<br />
<br />
<code><br />
Function Unique(vSourceArray As Variant)<br />
Dim iFound As Integer<br />
Dim sTargetArray() As Variant<br />
<br />
Redim sTargetArray(0) As Variant<br />
sTargetArray(0) = ""<br />
<br />
Forall sText In vSourceArray<br />
iFound = False<br />
Forall sNewText In sTargetArray<br />
If sText = sNewText Then<br />
iFound = True<br />
Exit Forall<br />
End If<br />
End Forall<br />
If Not iFound Then<br />
If sTargetArray(0) ="" Then ' First time<br />
sTargetArray(0) = sText<br />
Else<br />
Redim Preserve sTargetArray(Ubound(sTargetArray)+1)<br />
sTargetArray(Ubound(sTargetArray)) = sText<br />
End If<br />
End If<br />
End Forall<br />
<br />
Unique = sTargetArray<br />
End Function<br />
</code>Raghuhttp://www.blogger.com/profile/11490582601331789990noreply@blogger.com0tag:blogger.com,1999:blog-385018149364309774.post-64642580492622310132010-07-02T12:32:00.000+05:302010-07-02T12:32:41.053+05:30Hide/Show the flex elements by id in action script 3Hide/Show any flex element by ID in action script. Toggle any element in flex.<br />
<br />
The below example gives the toggle of HBox on click of the label.<br />
<br />
Here is the code to achieve the toggle functionality of any flex element in actionscript 3.<br />
<br />
Have added the comments in the code to explain use of each element.<br />
<code><br />
<?xml version="1.0" encoding="utf-8"?><br />
<mx:Application xmlns:mx="http://www.adobe.com/2006/mxml" layout="absolute" creationComplete="init()"><br />
<mx:Script><br />
<![CDATA[<br />
//Add event listner to any element in flex to call the below function to hide/show the HBox by id<br />
<br />
//Say on click of the lable call the handlerFunction.<br />
public function handlerFunction(event:Event):void {<br />
//get the id of the element by getting the data of the calling element event<br />
var id:String = event.currentTarget.data.toString(); <br />
//get the handle of parent element. i.e. VBox in the below code <br />
var parentVBox:VBox = event.currentTarget.parent as VBox;<br />
//get the handle to the element by id<br />
var hBoxtoShow:HBox = parentVBox.getChildByName(id) as HBox; <br />
//code to toggle the HBox (hide/show) <br />
if (hBoxtoShow.includeInLayout) {<br />
hBoxtoShow.includeInLayout = false;<br />
hBoxtoShow.visible = false;<br />
} else {<br />
hBoxtoShow.includeInLayout = true;<br />
hBoxtoShow.visible = true;<br />
} <br />
}<br />
<br />
public function init():void {<br />
//add HBox id to the lable data. This is used for dynamic hide/show of multiple elements<br />
labelID.data = "hideHBox";<br />
labelID.addEventListener(MouseEvent.CLICK , handlerFunction);<br />
}<br />
]]><br />
</mx:Script><br />
<mx:VBox id="mainVBox"><br />
<br />
<mx:Label text="Click me" id="labelID"/><br />
<mx:HBox id="hideHBox"><br />
<mx:Text text="Sample HBox filed to hide this on click of the label"/><br />
</mx:HBox><br />
<br />
</mx:VBox><br />
</mx:Application><br />
</code>Raghuhttp://www.blogger.com/profile/11490582601331789990noreply@blogger.com0tag:blogger.com,1999:blog-385018149364309774.post-26017064067416172242010-06-06T19:14:00.003+05:302010-06-06T19:23:52.537+05:30Google Motion Chart using XML datasource<a href="http://code.google.com/apis/visualization/documentation/gallery/motionchart.html"><b>Gooogle Motion Chart using XML as data source</b></a><br />
<br />
<div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiNto0tqg4fjYOfJP0DuQXo5nxkJkxMI1llbzrzesDd2BP0B2LeISHCuIDPK7HL1dUeicN93aN6EWCPO8qh4muZ8pEgRHtaNRVAZsnNXderWMKLmOZTwJvHLrMaG_-s6-M7paCWyjvSTm6F/s1600/Google+Motion+Chart.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="336" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiNto0tqg4fjYOfJP0DuQXo5nxkJkxMI1llbzrzesDd2BP0B2LeISHCuIDPK7HL1dUeicN93aN6EWCPO8qh4muZ8pEgRHtaNRVAZsnNXderWMKLmOZTwJvHLrMaG_-s6-M7paCWyjvSTm6F/s640/Google+Motion+Chart.PNG" width="640" /></a></div>A dynamic chart to explore several indicators over time. The chart is rendered within the browser using Flash.<br />
<br />
XML is used as datasource for motion chart instead of google spreadsheet.<br />
<code><br />
<html> <br />
<head><br />
<script type="text/javascript" src="http://www.google.com/jsapi"></script><br />
<script type="text/javascript"><br />
google.load('visualization', '1', {'packages':['motionchart']});<br />
google.setOnLoadCallback(getXMLData);<br />
<br />
function getXMLData() {<br />
url = "XML data url here"<br />
if (window.XMLHttpRequest) { // Non-IE browsers<br />
req = new XMLHttpRequest();<br />
req.onreadystatechange = drawChartData;<br />
try {<br />
req.open("GET", url, true);<br />
} catch (e) {<br />
alert("Problem : " + e);<br />
}<br />
req.send();<br />
} else if (window.ActiveXObject) { // IE<br />
req = new ActiveXObject("Microsoft.XMLHTTP");<br />
if (req) {<br />
req.onreadystatechange = drawChartData;<br />
req.open("GET", url, true);<br />
req.send();<br />
}<br />
}<br />
}<br />
<br />
function drawChartData() {<br />
if (req.readyState == 4) { // Complete<br />
if (req.status == 200) { // OK response<br />
var reqResponse = req.responseXML;<br />
var xmlItems = reqResponse.getElementsByTagName("item")<br />
//alert(xmlItems[i].getElementsByTagName("item1")[0].childNodes[0].nodeValue);<br />
var data = new google.visualization.DataTable();<br />
data.addColumn("string", "Country");<br />
data.addColumn('date', 'Year');<br />
data.addColumn('number', 'Projects');<br />
data .addRows(xmlItems.length);<br />
<br />
for (var i = 0; i < xmlItems.length; i++) {<br />
//alert(xmlItems[i].getElementsByTagName("year")[0].childNodes[0].nodeValue);<br />
data .setCell(i, 0, xmlItems[i].getElementsByTagName("country")[0].childNodes[0].nodeValue);<br />
data .setCell(i, 1, new Date(xmlItems[i].getElementsByTagName("year")[0].childNodes[0].nodeValue));<br />
data .setCell(i, 2, Number(new Number(xmlItems[i].getElementsByTagName("projects")[0].childNodes[0].nodeValue)));<br />
}<br />
//alert(data.getValue(0,0));<br />
var chart = new google.visualization.MotionChart(document.getElementById('chart_div'));<br />
chart.draw(data, {width: (screen.availWidth-50), height:(screen.availHeight-250)});<br />
}<br />
<br />
} else {<br />
//alert("Problem: " + req.statusText);<br />
}<br />
}<br />
</script><br />
</head><br />
<br />
<body><br />
<br />
<div id="chart_div" width="100%" height="90%"><br />
<table width="100%" height="100%"><tr><td height="80%" width="100%" align="center" valign="center"><br />
<img src="Loading Image URL"></img><br />
</td></tr></table><br />
</div><br />
</body><br />
</html><br />
<br />
******************<br />
<br />
XML format shoule be as shown below<br />
<br />
<items><br />
<item><br />
<country>India</country><br />
<year>12/24/2009</year><br />
<projects>2000<projects/><br />
</item><br />
<item><br />
<country>USA</country><br />
<year>12/24/2009</year><br />
<projects>4000<projects/><br />
</item><br />
</items><br />
</code>Raghuhttp://www.blogger.com/profile/11490582601331789990noreply@blogger.com0tag:blogger.com,1999:blog-385018149364309774.post-4774279428664477852010-05-19T20:47:00.001+05:302010-05-19T21:24:43.067+05:30Flex progress bar while loading the xml data using URLLoaderShow progress bar in flex while loading the xml data using URLLoader class.<br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiZxURV5ot4hmZUehn0lS-p1gCAZwNW0ZwyIBl8plOH76YeyDvvdaLzbspMeO2G9fRb0vG4lxUuMYUuoG8J4j1YY1IphnSNMtWbWvVjLs02dF7marSqDLino7_HwiYIEJC-LFqbvTee586b/s1600/Loading+Progress.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiZxURV5ot4hmZUehn0lS-p1gCAZwNW0ZwyIBl8plOH76YeyDvvdaLzbspMeO2G9fRb0vG4lxUuMYUuoG8J4j1YY1IphnSNMtWbWvVjLs02dF7marSqDLino7_HwiYIEJC-LFqbvTee586b/s320/Loading+Progress.JPG" /></a></div><br />
For progress bar display, have a separate MXML component called LoadingBar<br />
<br />
MXML Main Code<br />
<code><br />
<?xml version="1.0" encoding="utf-8"?><br />
<mx:Application xmlns:mx="<a href="http://www.adobe.com/2006/mxml" target="_blank">http://www.adobe.com/2006/mxml</a>" <br />
xmlns:net="flash.net.*" layout="absolute" creationComplete="init()"><br />
<mx:Script><br />
<![CDATA[<br />
<br />
import mx.managers.PopUpManager;<br />
import mx.containers.TitleWindow;<br />
import flash.geom.Point;<br />
import mx.containers.HBox;<br />
import mx.controls.Spacer;<br />
import mx.containers.*;<br />
import mx.controls.*;<br />
public var loadingBar:LoadingBar;<br />
<br />
public function init():void{ <br />
loadingBar=LoadingBar(PopUpManager.createPopUp( this, LoadingBar , true));<br />
loadingBar.progressBar.source = urlLoader;<br />
PopUpManager.centerPopUp(loadingBar); <br />
urlLoader.addEventListener(Event.COMPLETE, xmlLoaded); <br />
<br />
urlLoader.load(new URLRequest("<a href="http://localhostdatasource" target="_blank">http://localhostdatasource</a>"));<br />
}<br />
<br />
private function xmlLoaded(event:Event):void { <br />
<br />
PopUpManager.removePopUp(loadingBar);<br />
<br />
}<br />
]]><br />
</mx:Script> <br />
<br />
<net:URLLoader id="urlLoader" /><br />
<br />
</mx:Application><br />
</code><br />
MXML Loading Bar component code<br />
<code><br />
<?xml version="1.0" encoding="utf-8"?><br />
<br />
<mx:TitleWindow xmlns:mx="<a href="http://www.adobe.com/2006/mxml" target="_blank">http://www.adobe.com/2006/mxml</a>" title="Progress" <br />
width="300" height="100" borderThicknessLeft="1" styleName="loadingStyle"<br />
borderThicknessRight="1" borderThicknessBottom="1" borderThicknessTop="1" ><br />
<br />
<mx:VBox width="100%" height="100%" verticalAlign="middle" horizontalAlign="center"><br />
<mx:ProgressBar id="progressBar" label="Loading Data..." mode="event" labelPlacement="center" /> <br />
</mx:VBox> <br />
<br />
</mx:TitleWindow> <br />
</code><br />
The Flex Project looks like below image.<br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhiypAMFSxf_-nkf8k7zDQbVOR7x1yyRpmOY-SIEur5F7ACaHFixgvInhrrTilgSRcnZYFb196SaoraBMQEmPZEIu8pvFLaa9JPFAFa89yScR0KJChP8nV5E7eoxfvhG57kZ7CJe0ZeAqv1/s1600/FlexURLLoader.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhiypAMFSxf_-nkf8k7zDQbVOR7x1yyRpmOY-SIEur5F7ACaHFixgvInhrrTilgSRcnZYFb196SaoraBMQEmPZEIu8pvFLaa9JPFAFa89yScR0KJChP8nV5E7eoxfvhG57kZ7CJe0ZeAqv1/s320/FlexURLLoader.JPG" /></a></div>Raghuhttp://www.blogger.com/profile/11490582601331789990noreply@blogger.com0tag:blogger.com,1999:blog-385018149364309774.post-14545897559255948292010-05-18T23:39:00.000+05:302010-05-18T23:39:59.185+05:30Flex & ActionScript 3 tips useful for code optimization & performanceThere are many useful tips to optimize the flex & actionscript code.<br />
<br />
The below site gives some of the tips to optimize flex code while developing.<br />
<br />
<a href="http://www.insideria.com/2009/04/51-actionscript-30-and-flex-op.html">ActionScript 3.0 and Flex optimization techniques and practices</a>Raghuhttp://www.blogger.com/profile/11490582601331789990noreply@blogger.com0tag:blogger.com,1999:blog-385018149364309774.post-65373595344166416042010-04-28T22:43:00.002+05:302010-04-28T22:44:58.456+05:30Develop Mobile Applications in Flex<b>Slider: Flex Mobile Framework</b><br />
<br />
Adobe is currently developing a mobile-optimized version of the Flex framework that will make it easy for developers to build Flex applications that run across mobile devices. Using Slider, developers can leverage their existing skills to build intuitive applications that can be easily customized and rapidly adapted across platforms.<br />
<br />
More info at <a href="http://labs.adobe.com/technologies/flex/mobile/" target="_blank">http://labs.adobe.com/technologies/flex/mobile/</a><br clear="all">Raghuhttp://www.blogger.com/profile/11490582601331789990noreply@blogger.com0tag:blogger.com,1999:blog-385018149364309774.post-49247259652414720432010-03-24T23:37:00.002+05:302010-03-24T23:42:39.804+05:30Excel active rows check in vb, lotusscriptExcel import active rows check in lotus script<br />
<br />
Its not the best way to check the blank value in a mandatory row and stop the process while importing data from excel file.<br />
<br />
You can get the active rows in an excel file by using SpecialCell function.<br />
<br />
The syntax for the SpecialCells Method is;<br />
expression.SpecialCells(Type, Value)<br />
<br />
Where "expression" must be a Range Object. For example Range("A1:C100"), ActiveSheet.UsedRange etc.<br />
<br />
Type=XlCellType and can be one of these XlCellType constants.<br />
xlCellTypeAllFormatConditions. Cells of any format<br />
xlCellTypeAllValidation. Cells having validation criteria<br />
xlCellTypeBlanks. Empty cells<br />
xlCellTypeComments. Cells containing notes<br />
xlCellTypeConstants. Cells containing constants<br />
xlCellTypeFormulas. Cells containing formulas<br />
xlCellTypeLastCell. The last cell in the used range. Note this XlCellType will include empty cells that have had any of cells default format changed.<br />
xlCellTypeSameFormatConditions. Cells having the same format<br />
xlCellTypeSameValidation. Cells having the same validation criteria<br />
xlCellTypeVisible. All visible cells<br />
<br />
These arguments cannot be added together to return more than one XlCellType.<br />
<br />
Value=XlSpecialCellsValue and can be one of these XlSpecialCellsValue constants.<br />
xlErrors<br />
xlLogical<br />
xlNumbers<br />
xlTextValues<br />
<br />
These arguments can be added together to return more than one XlSpecialCellsValue.<br />
<br />
The lotus script code to get the active rows count.<br />
<code><br />
Set varExcel = CreateObject( "Excel.Application" )<br />
<br />
varExcel.Visible = False ' Making the selected Excel invisible<br />
<br />
varExcel.Workbooks.Open xlFilePath '// Open the Excel file<br />
<br />
Set xlWorkbook = varExcel.ActiveWorkbook<br />
<br />
Set xlSheet = xlWorkbook.ActiveSheet<br />
<br />
xlSheet.Cells.SpecialCells(11).Activate<br />
<br />
xlsRows = varExcel.ActiveWindow.ActiveCell.Row<br />
</code><br />
xlsRows variable gives the count of the active rows in an excel file.Raghuhttp://www.blogger.com/profile/11490582601331789990noreply@blogger.com0tag:blogger.com,1999:blog-385018149364309774.post-63150011753293622742010-03-24T23:30:00.001+05:302010-03-24T23:45:34.875+05:30Facebox is not loading in FireFoxIf you use removeAttribute function in your page, and if you try to load facebox, then facebox will not load properly in firefox.<br />
<br />
removeAttribute function is used to make the font as clear type in IE.<br />
<br />
This function solves the issue of clear type text in IE with jQuery.<br />
<br />
You should use removeAttribute function only for IE.<br />
<code><br />
if ((verOffset=navigator.userAgent.indexOf("MSIE"))!=-1) {<br />
this.style.removeAttribute('filter');<br />
}<br />
</code>Raghuhttp://www.blogger.com/profile/11490582601331789990noreply@blogger.com0tag:blogger.com,1999:blog-385018149364309774.post-14688287978463080392010-03-03T22:03:00.000+05:302010-03-03T22:03:32.933+05:30Gauge in flex open source code by brightpointincI need to develop a dashboard application with the column/bar charts and Gauges.<br />
<br />
I searched in google for Gauge chart, i could find Gauge charts by IBM Ilog Elixir which is licensed version.<br />
<br />
I continued my searching for a free Gauge chart and at last i found Gauge chart by Brightpointinc which is an open source.<br />
<br />
Its very easy to use and easily customizable.<br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj7qxC5L7PggYL6piASzlcEuT6e-fLFtnvtqMOYw0e35W6cLvUGaKglhGccJ90lWAIaWYvO5qEVsBUgor4U_frP-Pcg8r5QhuqwU3ExDk-Oz7Czih64yRVuszQ8ts1KuTUH5CU9DmFseLrl/s1600-h/gauge.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj7qxC5L7PggYL6piASzlcEuT6e-fLFtnvtqMOYw0e35W6cLvUGaKglhGccJ90lWAIaWYvO5qEVsBUgor4U_frP-Pcg8r5QhuqwU3ExDk-Oz7Czih64yRVuszQ8ts1KuTUH5CU9DmFseLrl/s320/gauge.png" /></a></div><br />
You can find the sample and source code here -- <a href="http://www.brightpointinc.com/flexdemos/gauge_v04/gauge_v04.html">http://www.brightpointinc.com/flexdemos/gauge_v04/gauge_v04.html</a>Raghuhttp://www.blogger.com/profile/11490582601331789990noreply@blogger.com6tag:blogger.com,1999:blog-385018149364309774.post-47905338286131211902010-03-03T21:51:00.000+05:302010-03-03T21:51:48.341+05:30Wedge Stack Graph in Flex by AXIIS Open Sourcehttp://www.axiis.org/<br />
<br />
<a href="http://www.axiis.org/examples/WedgeStackChartExample.html" target="_blank">Wedge Stack Graph</a> is a fantastic chart that can be easily customizable and its free.<br />
<br />
<div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhhnVEtg8iDUv4xAQdNJ5e1j9eev6VK1AWum7fdfXhmK2eSfc6QAzsknuuy3OYFMlmUKXDmwpF0lpFZJlQBMM90zws6wHoRQOgR243GpJ06-aJG5L_yme-AcBI3JrYGqv4nlutPR13fgRw_/s1600-h/Axis+Chart.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhhnVEtg8iDUv4xAQdNJ5e1j9eev6VK1AWum7fdfXhmK2eSfc6QAzsknuuy3OYFMlmUKXDmwpF0lpFZJlQBMM90zws6wHoRQOgR243GpJ06-aJG5L_yme-AcBI3JrYGqv4nlutPR13fgRw_/s320/Axis+Chart.JPG" /></a></div><br />
Link to download the source code -- <a href="http://www.axiis.org/examples/WedgeStackChartExample.html" target="_blank">http://www.axiis.org/examples/WedgeStackChartExample.html</a>Raghuhttp://www.blogger.com/profile/11490582601331789990noreply@blogger.com0tag:blogger.com,1999:blog-385018149364309774.post-71603921356961343852010-02-19T08:08:00.001+05:302010-02-19T08:09:03.213+05:30getElementById is not working in fire foxFor hidden fields the following code will not work in firefox<br />
<code>document.getElementById("AttachName").value = fname;</code><br />
it should be <br />
<code>document._frmUpload.AttachName.value = fname;</code><br />
Here _frmUpload is the form name.<br />
AttachName is field ID.<br />
So better use the second one if you know the form name.Raghuhttp://www.blogger.com/profile/11490582601331789990noreply@blogger.com0tag:blogger.com,1999:blog-385018149364309774.post-2723503986910839082010-02-12T21:04:00.001+05:302010-02-12T22:01:36.385+05:30Flex Pie Chart using XML as data source<span style="font-weight: bold;">Pie Chart in flex using XML as dataprovider for piechart</span><br />
<br />
The XML format should be as shown below.<br />
<code><br />
<?xml version="1.0" encoding="utf-8" ?><br />
<items><br />
<item name="option1" number="2000" /><br />
<item name="option2" number="9000" /><br />
<item name="option3" number="5000" /><br />
<item name="option4" number="7000" /><br />
</items><br />
</code><br />
The Flex application code is shown below.<code><br />
<?xml version="1.0" encoding="utf-8"?><br />
<mx:Application xmlns:mx="http://www.adobe.com/2006/mxml" layout="absolute"><br />
<mx:HTTPService id="dataRequest" url="" showBusyCursor="true" fault="dataRequestFaultHandler(event);" /> <br />
<mx:Script><br />
<![CDATA[<br />
import mx.rpc.events.ResultEvent;<br />
import mx.rpc.events.FaultEvent;<br />
import mx.controls.Alert;<br />
import mx.collections.ArrayCollection; <br />
public function initApp():void {<br />
var timeStampForNocache:Date = new Date() ; <br />
var urlAgent:String = "Your XML returing URL PATH & tim=" + timeStampForNocache.toString(); <br />
dataRequest.url = urlAgent;<br />
dataRequest.send();<br />
}<br />
[Bindable]<br />
private var stats:ArrayCollection;<br />
<br />
private function dataRequestFaultHandler(event:FaultEvent):void {<br />
Alert.show(event.fault.message);<br />
}<br />
]]> </mx:Script> <br />
<mx:PieChart width="100%" height="100%" showDataTips="true" dataProvider="{dataRequest.lastResult.items.item}" id="myChart"><br />
<mx:series><br />
<mx:PieSeries width="100%" height="100%" field="number" nameField="name" /><br />
</mx:series><br />
</mx:PieChart><br />
<mx:Legend direction="horizontal" dataProvider="{myChart}"/><br />
</mx:Application><br />
</code><br />
The result would be like the below image.<br />
<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjVZfMEJWubWzvXhf9FecpooxCirxTnXGkfBdA2Y7iJqdqthewbbX52Ff-ZUul98jhrN3X2qfJuIwCs8KW6bvVFnwzJHU_aDKpmoPkPRMK7kPgPWrzvtxevvBn9FmIZdfu8ZZCsMuSCZe_s/s1600-h/PieCCC.JPG" onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}"><img alt="" border="0" id="BLOGGER_PHOTO_ID_5437381413245893474" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjVZfMEJWubWzvXhf9FecpooxCirxTnXGkfBdA2Y7iJqdqthewbbX52Ff-ZUul98jhrN3X2qfJuIwCs8KW6bvVFnwzJHU_aDKpmoPkPRMK7kPgPWrzvtxevvBn9FmIZdfu8ZZCsMuSCZe_s/s400/PieCCC.JPG" style="cursor: pointer; display: block; height: 372px; margin: 0px auto 10px; text-align: center; width: 276px;" /></a>Raghuhttp://www.blogger.com/profile/11490582601331789990noreply@blogger.com0tag:blogger.com,1999:blog-385018149364309774.post-21801900622217749202010-02-11T22:13:00.002+05:302010-02-12T22:02:46.922+05:30Flex Column Chart using XML as source<span style="font-weight: bold;">Column Chart in flex using XML as dataprovider for column chart</span><br />
<br />
The XML format should be as shown below.<code><br />
<items><br />
<item><br />
<name> Test1 </name><br />
<number> 1000 </number><br />
</item><br />
<item><br />
<name> Test1 </name><br />
<number> 1000 </number><br />
</item><br />
<item><br />
<name> Test1 </name><br />
<number> 1000 </number><br />
</item><br />
<item><br />
<name> Test1 </name><br />
<number> 1000 </number><br />
</item><br />
</items></code><br />
The Flex application code is shown below.<br />
<code> <?xml version="1.0" encoding="utf-8"?><br />
<mx:Application xmlns:mx="http://www.adobe.com/2006/mxml" layout="absolute" creationComplete="initApp()"><br />
<mx:HTTPService id="dataRequest" url="" showBusyCursor="true" result="dataRequestResultHandler(event);" fault="dataRequestFaultHandler(event);" /> <br />
<mx:Script><br />
<![CDATA[<br />
import mx.rpc.events.ResultEvent;<br />
import mx.rpc.events.FaultEvent;<br />
import mx.controls.Alert;<br />
import mx.collections.ArrayCollection; <br />
public function initApp():void {<br />
var timeStampForNocache:Date = new Date() ; <br />
var urlAgent:String = "Your XML returing URL PATH & tim=" + timeStampForNocache.toString(); <br />
dataRequest.url = urlAgent;<br />
dataRequest.send();<br />
}<br />
[Bindable]<br />
private var stats:ArrayCollection;<br />
private function dataRequestResultHandler(event:ResultEvent):void {<br />
stats = event.result.items.item;<br />
}<br />
private function dataRequestFaultHandler(event:FaultEvent):void {<br />
Alert.show(event.fault.message);<br />
}<br />
]]> </mx:Script> <br />
<mx:ColumnChart id="xmlChartBar" dataProvider="{stats}" showDataTips="true" width="500"><br />
<mx:horizontalAxis><br />
<mx:CategoryAxis dataProvider="{stats}" categoryField="option"/><br />
</mx:horizontalAxis><br />
<mx:series><br />
<mx:ColumnSeries showDataEffect="fadeIn" xField="name" yField="number" displayName="Hits" /><br />
</mx:series><br />
</mx:ColumnChart> <br />
</mx:Application></code><br />
The result would be like the below image.<br />
<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiYHpdM4x5QFaapaUkOD7h21Zae4THtejANzMRjwyMA4-Vpf3h8PRQ7NUrbIbq92MjCCQke3yju8u2n9GoHVXFF2932Et6pw1i2sGMOSkgne6iNLHh2wKn0mbGCfgzUltWf_OKh4amft900/s1600-h/Bar+CCCC.JPG" onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}"><img alt="" border="0" id="BLOGGER_PHOTO_ID_5437379191998622386" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiYHpdM4x5QFaapaUkOD7h21Zae4THtejANzMRjwyMA4-Vpf3h8PRQ7NUrbIbq92MjCCQke3yju8u2n9GoHVXFF2932Et6pw1i2sGMOSkgne6iNLHh2wKn0mbGCfgzUltWf_OKh4amft900/s400/Bar+CCCC.JPG" style="cursor: pointer; display: block; height: 148px; margin: 0px auto 10px; text-align: center; width: 400px;" /></a>Raghuhttp://www.blogger.com/profile/11490582601331789990noreply@blogger.com0tag:blogger.com,1999:blog-385018149364309774.post-20153532516208207812010-02-08T21:34:00.000+05:302010-02-08T21:48:38.447+05:30Quiz result page - Quiz application in flexAs i have mentioned in the <b><a href="http://lotusdominoweb.blogspot.com/2010/01/quiz-application-in-flex-integrating.html">previous post</a></b>, developed quiz application result page.<br /><br />Here is the sreen shot. As it is not fully completed, i am not posting the source code.<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjgiT0x5GTNGTQ_KAOmF-oV1aNTF7LJKhPaY-ErK9tad_AkTzf81V1M1Up8dbgzB_6_dxeKW4KBY_6CfTsrMl5QSuYNZOsSs_p8pCwKcSd0N70ZQJfQYd3dNuWKAfLUA-eeMMAGI2HT_Ovr/s1600-h/QUIZ_RESULT.JPG"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 297px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjgiT0x5GTNGTQ_KAOmF-oV1aNTF7LJKhPaY-ErK9tad_AkTzf81V1M1Up8dbgzB_6_dxeKW4KBY_6CfTsrMl5QSuYNZOsSs_p8pCwKcSd0N70ZQJfQYd3dNuWKAfLUA-eeMMAGI2HT_Ovr/s400/QUIZ_RESULT.JPG" alt="" id="BLOGGER_PHOTO_ID_5435906461940768514" border="0" /></a><br />Navigation to all the quiz questions is shown below.<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiUtUAVaFzAyP8TYm-IASkXayHMF_71I4j53qHcamCtrcVibgZC90WTmmCM-CR9qCmQ4gMYvCC1C7W1XzJCnkKNwJtDAptrul273f2KLQstlj2It5sWc4Rns3apE74jENobS-gYyqYDOHId/s1600-h/qUIZ+NAVI.JPG"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 287px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiUtUAVaFzAyP8TYm-IASkXayHMF_71I4j53qHcamCtrcVibgZC90WTmmCM-CR9qCmQ4gMYvCC1C7W1XzJCnkKNwJtDAptrul273f2KLQstlj2It5sWc4Rns3apE74jENobS-gYyqYDOHId/s400/qUIZ+NAVI.JPG" alt="" id="BLOGGER_PHOTO_ID_5435906764177336050" border="0" /></a><br />Once it is completed, then i will post the code to download.<br /><br />MEANWHILE IF YOU WANT THE CURRENT VERSION AS IT IS, PLEASE LEAVE YOUR MAIL ID IN COMMENTS SECTION, TO MAIL THE SOURCE CODE.Raghuhttp://www.blogger.com/profile/11490582601331789990noreply@blogger.com4tag:blogger.com,1999:blog-385018149364309774.post-31201480418322765442010-02-06T11:56:00.000+05:302010-02-06T12:03:16.549+05:30IE is losing ClearType if you use jQuery hide or fadeInIE is losing ClearType if you use jQuery hide/show or fadeIn/fadeOut or even when you open a remote page.<br /><br /><code>$('#myDiv').hide();<br /><br />$("#myDiv").fadeIn('slow');<br /><br /></code><br />The problem seems to be that the CSS "filter" attribute is not automatically removed. The most simple solution to this problem would be removing it manually :)<br /><br /><code><br />$('#myDiv').fadeIn('slow', function() {<br /> this.style.removeAttribute('filter');<br />});<br /></code><br />But the above solution looks odd because for each hide you need to remove manually.<br /><br />A simple, more elegant solution would be to wrap the .fadeIn() and .fadeOut() functions with a custom function via the plugin interface of jQuery. The code would be exactly the same, but instead of directly calling the fade functions, we call the wrapper.<br /><code><br />$('#node').customFadeOut('slow', function() {<br /> //no more fiddling with attributes here<br />});<br /></code><br />So, how do you get this working? Just include the following code after you include the jQuery library for the added functionality.<br /><code><br />(function($) {<br /> $.fn.customFadeIn = function(speed, callback) {<br /> $(this).fadeIn(speed, function() {<br /> if(jQuery.browser.msie)<br /> $(this).get(0).style.removeAttribute('filter');<br /> if(callback != undefined)<br /> callback();<br /> });<br /> };<br /> $.fn.customFadeOut = function(speed, callback) {<br /> $(this).fadeOut(speed, function() {<br /> if(jQuery.browser.msie)<br /> $(this).get(0).style.removeAttribute('filter');<br /> if(callback != undefined)<br /> callback();<br /> });<br /> };<br />})(jQuery);<br /></code>Raghuhttp://www.blogger.com/profile/11490582601331789990noreply@blogger.com0tag:blogger.com,1999:blog-385018149364309774.post-30456825197381154462010-02-06T11:51:00.000+05:302010-02-06T11:55:49.131+05:30Bug in Lotus 8.5.1 ? jQuery script is giving error while saving in Lotus 8.5.1 script library as javascript codejQuery script is giving error while saving in Lotus 8.5.1 script library as javascript code.<br /><br />Error screen shot:<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiF_Mc__8EPSA198TgnvJDCIZ69l10MUioGsqXg0Jy3muUPCMQjujIPjyuy6amVpI-mhMbMj4RWU3qmDrUWR1vPoS1_NJ0PIIBTxp_MKx3Jtvophrc78KrFkjXUb7ui8xvGznntNJSRJivS/s1600-h/jQuery+Error.JPG"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 225px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiF_Mc__8EPSA198TgnvJDCIZ69l10MUioGsqXg0Jy3muUPCMQjujIPjyuy6amVpI-mhMbMj4RWU3qmDrUWR1vPoS1_NJ0PIIBTxp_MKx3Jtvophrc78KrFkjXUb7ui8xvGznntNJSRJivS/s400/jQuery+Error.JPG" alt="" id="BLOGGER_PHOTO_ID_5435012243237814866" border="0" /></a><br />Is that problem with jQuery (i dont think). This could be a problem with Lotus 8.5.1 javascript script library.<br /><br />What do you think?Raghuhttp://www.blogger.com/profile/11490582601331789990noreply@blogger.com2tag:blogger.com,1999:blog-385018149364309774.post-74948472634522828262010-02-05T21:30:00.000+05:302010-02-06T12:03:49.269+05:30Have you used jQuery facebox in your application?Facebox is a fantastic tool to display small information in pop up style.<br /><br />The code is very simple. This is effectively working in Lotus Domino.<br /><br />The below image shows how the facebox looks.<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh0E6_cFEAmvLXhr_RDq90bR8hkf8NS8DXQPNKitVsOnynm0S7SxD3Tl7qxH4pLhbGtOxJWi4M1xp4seu7qdLHUke4fVniYDp1iPoGacenC5EX_lOXS2NqoWFUNleujvlKChDagzns2OL6D/s1600-h/facebox-jquery.JPG"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 263px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh0E6_cFEAmvLXhr_RDq90bR8hkf8NS8DXQPNKitVsOnynm0S7SxD3Tl7qxH4pLhbGtOxJWi4M1xp4seu7qdLHUke4fVniYDp1iPoGacenC5EX_lOXS2NqoWFUNleujvlKChDagzns2OL6D/s400/facebox-jquery.JPG" alt="" id="BLOGGER_PHOTO_ID_5434799090050865138" border="0" /></a><br /><a href="http://famspam.com/facebox">Click Here to see more information on this.</a>Raghuhttp://www.blogger.com/profile/11490582601331789990noreply@blogger.com0tag:blogger.com,1999:blog-385018149364309774.post-32437930930884806072010-02-04T23:59:00.000+05:302010-02-05T00:11:07.132+05:30Do you want to copy css of a particular element in any site.. Its easy..Do you want to copy css of a particular element in any site.. Its easy now with Mozilla Firefox.<br /><br />All you need to do is<br /><br />1. Download firefox (if you do not have).<br /><br />2. Install WebDeveloper add on as shown in below image.<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj2HJ9kLMt_dozqsz8mzIdxVIet43nh8RNPYJPSr7JqgJ4tyPVyYgnstRCtd-vxPSFH5MChXKpqYYljSXXUEVYjL5iHG0ErwUdcG6vCghYS5UNK7Nse8_y16ABHWTRkw4MmQf0zeaP1eoaY/s1600-h/Addons+in+Firefox.JPG"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 219px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj2HJ9kLMt_dozqsz8mzIdxVIet43nh8RNPYJPSr7JqgJ4tyPVyYgnstRCtd-vxPSFH5MChXKpqYYljSXXUEVYjL5iHG0ErwUdcG6vCghYS5UNK7Nse8_y16ABHWTRkw4MmQf0zeaP1eoaY/s400/Addons+in+Firefox.JPG" alt="" id="BLOGGER_PHOTO_ID_5434459775326726482" border="0" /></a><br /><br />3. Goto CSS tab in web developer toolbar and select View CSS Information as shown below.<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh4UwXz4A-8nm7_xzp4mTeJGmhXd0WjE_cooiXbZqoFQN4HR9O9D2PCJX1-5Q5CjmU_rT0jC8GqVnQW3g3UXf3FtpZCmmauufblOAD0xYf3Vnk1JO5Ow6jhoe2F-2tyAblxC7XkiC0ddWGJ/s1600-h/view+C+SS.JPG"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 182px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh4UwXz4A-8nm7_xzp4mTeJGmhXd0WjE_cooiXbZqoFQN4HR9O9D2PCJX1-5Q5CjmU_rT0jC8GqVnQW3g3UXf3FtpZCmmauufblOAD0xYf3Vnk1JO5Ow6jhoe2F-2tyAblxC7XkiC0ddWGJ/s400/view+C+SS.JPG" alt="" id="BLOGGER_PHOTO_ID_5434459784556302706" border="0" /></a><br />The below figure shows the CSS for Signup button in twitter. CSS displayed in the Right side bar.<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgfXYqclFYI-Lt2NlbFQljlBOL7o0eiq7ccqIGY-zCw_JbqaFhB2H-zWz7nyn1z8WGP2SXPWkxQrLotQ3fpzdLMXlAP4C1KLycpHHBhxsNAreKBG9_rLATUmid0vdOrMqoquMKE08m-rjas/s1600-h/Twitter+CSS.JPG"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 225px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgfXYqclFYI-Lt2NlbFQljlBOL7o0eiq7ccqIGY-zCw_JbqaFhB2H-zWz7nyn1z8WGP2SXPWkxQrLotQ3fpzdLMXlAP4C1KLycpHHBhxsNAreKBG9_rLATUmid0vdOrMqoquMKE08m-rjas/s400/Twitter+CSS.JPG" alt="" id="BLOGGER_PHOTO_ID_5434459779049644370" border="0" /></a><br />It is so simple right?Raghuhttp://www.blogger.com/profile/11490582601331789990noreply@blogger.com0tag:blogger.com,1999:blog-385018149364309774.post-76494092658274940122010-01-19T22:43:00.000+05:302010-01-19T23:08:39.910+05:30Quiz application in Flex integrating with Lotus Domino<div style="text-align: center;">Quiz application in flex<br /><br /><div style="text-align: left;">Here is the main screen shot of quiz application. its like a gadget and you can have it in side bar.<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhWzjMIRLleQwDi2Dv8TRPPc2KTbT5zUU5rH1TNQyDf_BGja12QkFC-GXv_zhFGaHeVExlrhwN7pySMMNpRr0dvz9ALXdjlD9FvcTbTohsCN-tzVRB7LVTrDoqeRWc68o93J5I72dq_H9eW/s1600-h/MainPage_Quiz.JPG"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 243px; height: 307px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhWzjMIRLleQwDi2Dv8TRPPc2KTbT5zUU5rH1TNQyDf_BGja12QkFC-GXv_zhFGaHeVExlrhwN7pySMMNpRr0dvz9ALXdjlD9FvcTbTohsCN-tzVRB7LVTrDoqeRWc68o93J5I72dq_H9eW/s400/MainPage_Quiz.JPG" alt="" id="BLOGGER_PHOTO_ID_5428501601771992530" border="0" /></a><br />On click of any choice it opens a new page which shows the result and flex chart to show the overall result.<br /><br />How did i achieve it?<br /><br />Well, here is the procedure:<br /><br />Create a lotus notes db and a form to post the questions with answer, options and some other info.<br /><br />Have a view which returns the value in XML format.<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgvvzbQBuXI3Vl89u-ZVkRm4u1kMzat6EPevdfjKRtqc1qREkJRzhzNCbKgMIE44MGJy6WZXgyrrEBSulfQF0AEe2Mm_Pn_qrsdRm8rqkGj3ZIn8r-0FdAuYMbvNj5cAg0ks48reQF9A7ze/s1600-h/QuizXMLView.JPG"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 225px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgvvzbQBuXI3Vl89u-ZVkRm4u1kMzat6EPevdfjKRtqc1qREkJRzhzNCbKgMIE44MGJy6WZXgyrrEBSulfQF0AEe2Mm_Pn_qrsdRm8rqkGj3ZIn8r-0FdAuYMbvNj5cAg0ks48reQF9A7ze/s400/QuizXMLView.JPG" alt="" id="BLOGGER_PHOTO_ID_5428504902815031890" border="0" /></a>Getting the question and choices in the flex application by using URLLoader.<br /><code><br />var urlLoader:URLLoader = new URLLoader();<br />urlLoader.addEventListener(Event.COMPLETE, xmlLoaded);<br />urlLoader.load(new URLRequest(DBPath+"/QuizView?OpenView"));<br /></code><br />As of now i am attaching the screen shot of flex code.<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjWlBo29OIGQg2eGKxO_QzxLcKBW4WfiEl7TtVtgcEtM69irjvHMIlGEh9-2_ZdEqBUtYrOhRl4IOe6pzcT4empp0OQYrMAVU82oyOUp7sKNEittbX7T1CJQcTS9R818_qM3mSJB22cJls1/s1600-h/FlexCodeView.JPG"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 225px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjWlBo29OIGQg2eGKxO_QzxLcKBW4WfiEl7TtVtgcEtM69irjvHMIlGEh9-2_ZdEqBUtYrOhRl4IOe6pzcT4empp0OQYrMAVU82oyOUp7sKNEittbX7T1CJQcTS9R818_qM3mSJB22cJls1/s400/FlexCodeView.JPG" alt="" id="BLOGGER_PHOTO_ID_5428505204938273154" border="0" /></a><br />Main screen part completed. Working on Quiz Rresult page.<br /><br />Once everything is completed without any loopholes, i will post the entire flex code and lotus notes db used.<br /><br />If you have any queries please feel free to post in comments box.<br /></div></div>Raghuhttp://www.blogger.com/profile/11490582601331789990noreply@blogger.com1tag:blogger.com,1999:blog-385018149364309774.post-31549872959872954692009-10-20T22:53:00.000+05:302009-10-20T22:53:44.332+05:30IBM Released 8.5.1 lotus designer for freeIBM Released 8.5.1 lotus designer for free.<br />
<br />
Its really wonderful...<br />
<br />
They have added 3 new field types.<br />
1. Formula<br />
2. Timezone<br />
3. Color<br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgfpgTJIjdMYL5izRY6oEikDQCsFWP3YVt9OhrTMWvRu20AVAB1Su3NL95cfnbzbRDjaDFekqvyTsjMaQEo5_Te8gtIjSKLdGUwmNak8YlDbEEUDuhyphenhyphen5q-jbozWARSz9pgThrFpPAp9WMk/s1600-h/NEW+fIELDS.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgfpgTJIjdMYL5izRY6oEikDQCsFWP3YVt9OhrTMWvRu20AVAB1Su3NL95cfnbzbRDjaDFekqvyTsjMaQEo5_Te8gtIjSKLdGUwmNak8YlDbEEUDuhyphenhyphen5q-jbozWARSz9pgThrFpPAp9WMk/s640/NEW+fIELDS.JPG" /></a><br />
</div><br />
One more feature while writing the code in lotusscript, it shows the errors without saving. Its almost similar to writing code in flex.<br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhqUCezs7eb1gjhZTHKzKyoBjiLf2O-3UT8UJGt0DujJ9CLy8CMo6jUbhyswbYlFGxaHjVyyLnonRNa-tnyZ9ErOAIIE525Y882I6DFz7BXywi0xlT3zfnF0UuFQQB7TAH-6mbcWrpQWsQ/s1600-h/AgentErro.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhqUCezs7eb1gjhZTHKzKyoBjiLf2O-3UT8UJGt0DujJ9CLy8CMo6jUbhyswbYlFGxaHjVyyLnonRNa-tnyZ9ErOAIIE525Y882I6DFz7BXywi0xlT3zfnF0UuFQQB7TAH-6mbcWrpQWsQ/s640/AgentErro.JPG" /></a><br />
</div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-385018149364309774.post-38036261738261732782009-10-20T22:44:00.000+05:302009-10-20T22:44:06.462+05:30Connect ODBC/Oracle Using LC coneector classes<b>Lotusscript code to connect ODBC/Oracle Using LC coneector classes </b><br />
<b><br />
</b><br />
<code><br />
Sub Initialize <br />
On Error Goto ErrorHandler<br />
<br />
Dim session As New NotesSession <br />
Dim LC_S As New LCSession<br />
LC_S.clearstatus<br />
Set LC_Conn = New LCConnection ("odbc2") <br />
<br />
' Make a connection...<br />
LC_Conn.Server = "lotussystem" ‘System DSN on server…<br />
LC_Conn.UserID = "crystal" ‘SQL Server user id…<br />
LC_Conn.Password = "crystal" ‘SQL Server password…<br />
LC_Conn.Metadata = "employee" ‘SQL Server table name…<br />
LC_Conn.Connect<br />
<br />
Dim count As Integer<br />
Dim lsQuery As String <br />
Dim fldLst As New LCFieldList<br />
<br />
' Execute the Query...<br />
lsQuery = "Select * from employee"<br />
count = LC_Conn. Execute (lsQuery, fldLst)<br />
<br />
Dim fldLC As LCField<br />
<br />
Dim fldFName As LCField<br />
Set fldFName = fldLst.Lookup ("fname") <br />
Dim fldLName As LCField<br />
Set fldLName = fldLst.Lookup ("lname")<br />
<br />
' Get the AppInfo view...<br />
Dim loDb As NotesDatabase<br />
Dim loVw As NotesView<br />
Dim loAppInfoDoc As NotesDocument<br />
Set loDb = session.CurrentDatabase<br />
Set loVw = loDb.GetView("vwAppInfo")<br />
Set loAppInfoDoc = loVw.GetFirstDocument<br />
<br />
Call LC_Conn.Fetch (fldLst, 1, 1)<br />
'Msgbox fldFName.Text(0)<br />
<br />
loAppInfoDoc.count = "1"<br />
loAppInfoDoc.EmpName = fldFName.Text(0) + " " + fldLName.Text(0)<br />
<br />
Set fldLC = fldLst.Lookup ("emp_Id") <br />
loAppInfoDoc.EmpID = fldLC.Text(0)<br />
<br />
Set fldLC = fldLst.Lookup ("job_Id")<br />
loAppInfoDoc.Job = Cstr(fldLC.Text(0))<br />
<br />
Set fldLC = fldLst.Lookup ("hire_date")<br />
loAppInfoDoc.Hire_Date = Cstr(fldLC.Text(0))<br />
<br />
Call loAppInfoDoc.save(False, False)<br />
<br />
' Disconnect the connection...<br />
LC_Conn.Disconnect<br />
<br />
CleanUp:<br />
Exit Sub<br />
<br />
ErrorHandler:<br />
'Msgbox result.GetExtendedErrorMessage,, result.GetErrorMessage<br />
Msgbox "An error has occurred in button at line no. " & Erl() & " and the error is " & Str$(Err) & " " & Error$ <br />
Resume CleanUp<br />
<br />
End Sub<br />
</code>Unknownnoreply@blogger.com1tag:blogger.com,1999:blog-385018149364309774.post-82854116909012105582009-09-20T12:49:00.000+05:302009-09-20T12:53:11.935+05:30Showing alternate coloured rows on WebThere has been quite a few solutions to produce alternate row colors for a Web view. They all involve writing cluttered HTML in the column headings, treating view contents as HTML, or using agents, etc. But the following solution is purely a javascript function and has nothing to do with Domino view design. Part of this idea was derived from a posting in the notes.net site. <br />
<br />
<br />
<br />
Step 1.) Create a view with few columns(Let it be uncategorized initially). <br />
<br />
Step 2.) Embed the view in a form(Display as HTML). <br />
<br />
Step 3.) Put the following code in the Onload event of the form.(Or have it as a function in the JS Header and call it in the OnLoad event).<br />
<br />
<br />
<code>var tableElements = document.body.all.tags("table");<br />
var table = tableElements[tableElements.length-1];<br />
var headlength=rowlength="";<br />
heads = table.getElementsByTagName("th") ;<br />
headlength=heads.length;<br />
<br />
// If the view is categorized , use this line, else comment it<br />
//headlength=headlength-1;<br />
<br />
for( i = 0; i <headlength; i++)<br />
heads[i].bgColor = '#D2D2D2';<br />
<br />
rows = table.getElementsByTagName("tr") ;<br />
for( i = 0; i < rows.length; i++)<br />
{<br />
if(i % 2)<br />
{<br />
// If the view is not categorized , use this line <br />
celllength=rows[i].cells.length; <br />
// If the view is categorized , use this line <br />
//celllength=rows[i].cells.length-1;<br />
<br />
for (var c = 0; c < celllength; c++)<br />
rows[i].cells[c].bgColor = '#F4F4F4';<br />
} <br />
else<br />
rows[i].bgColor='';<br />
}<br />
<br />
(The code is self explanatory. It gets the table element, changes the background color of the cells. The above code works fine for an uncategorized view.) <br />
<br />
Step 4: For a categorized (single or many), uncomment the following lines, <br />
<br />
//headlength=headlength-1;<br />
//celllength=rows[i].cells.length-1;<br />
<br />
and comment the following line.<br />
//celllength=rows[i].cells.length;<br />
<br />
This should work well for a categorized view. <br />
<br />
Step 5 : To provide alternate column color effect, modify the for loop given below, <br />
<br />
for (var c = 0; c < celllength; c++)<br />
rows[i].cells[c].bgColor = '#F4F4F4';<br />
<br />
to,<br />
<br />
for (var c = 0; c < celllength; c++)<br />
if (c % 2)<br />
rows[i].cells[c].bgColor = '#F4F4F4';<br />
<br />
</code><br />
<br />
The above javascript function is fully customizable like,<br />
table.cellspacing='2'<br />
table.cellpadding='2'<br />
and the bgcolor values etc.Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-385018149364309774.post-53125767678983326572009-09-20T12:38:00.000+05:302009-09-20T12:38:31.878+05:30Creating Notes Documents from Excel Sheet in lotusscript<code><br />
Sub Initialize<br />
Dim lspath,lsextn As String<br />
Dim gosession As New NotesSession<br />
Set godb=gosession.CurrentDatabase<br />
Set godoc=New notesDocument(godb)<br />
<br />
'Enter the Path and the XL file that has to be Imported into th<br />
database..like the one is shown below<br />
<br />
lspath=Inputbox$("Enter the Excel file path for importing into<br />
the Notes Database")<br />
<br />
lsxlFilename=lspath<br />
<br />
'Create an Excel sheet object<br />
<br />
Set gvExcel=CreateObject("Excel.Application")<br />
gvExcel.visible=False<br />
<br />
Messagebox ("Opening Excel sheet File eneterd in Input box<br />
previously ...")<br />
gvExcel.Workbooks.Open lsxlFilename<br />
Set gvxlWorkbook=gvExcel.ActiveWorkbook<br />
Set gvxlsheet=gvxlWorkbook.Activesheet<br />
<br />
'Start to move through the Excel file and start pulling data<br />
from there<br />
lsrow=0<br />
lswritten=0<br />
<br />
'Start Importing into the Notes Database<br />
Print "Start impoting from Excel sheet"<br />
<br />
Do While True<br />
<br />
With gvxlsheet <br />
lsrow=lsrow+1<br />
<br />
'Create a new Notes document<br />
<br />
Set godoc=godb.CreateDocument<br />
godoc.Form="TestForm"<br />
godoc.Name=.Cells(lsrow,1).Value<br />
godoc.Division=.Cells(lsrow,2).Value<br />
godoc.Manager=.Cells(lsrow,3).Value<br />
<br />
'Save the Notes document <br />
Call godoc.Save(True,True) <br />
<br />
lswritten=lswritten+1<br />
If godoc.Name(0)="" Then<br />
End<br />
End If<br />
End With<br />
<br />
Loop<br />
Set godoc=Nothing<br />
gvExcel.quit <br />
<br />
Goto CleanUp <br />
<br />
CleanUp:<br />
Exit Sub<br />
<br />
ErrorHandler:<br />
Msgbox "An error has occurred in the agImport at line no. " &<br />
Erl() & " and the error is " & Str$(Err) & " " & Error$ <br />
Resume CleanUp<br />
<br />
End Sub<br />
</code>Unknownnoreply@blogger.com1tag:blogger.com,1999:blog-385018149364309774.post-5419219840390828932009-09-20T12:27:00.000+05:302009-09-20T12:31:57.156+05:30Return to previous page after submit in javascriptPlace in a $$Return field on a form.<br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg9fWPiXnTHiannLCxSLXv2T8-meZj5nMmQx7waONLvZN6Uma04ClKdDErlkLHGdCWvFHGmkc_4LrCgNiq6hV6WUsXgnspuzWAsk5zL8EG6J9WYarKfTIkqPqI1CTidlMGgNGQ0wnruXlY/s1600-h/pajj.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" iq="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg9fWPiXnTHiannLCxSLXv2T8-meZj5nMmQx7waONLvZN6Uma04ClKdDErlkLHGdCWvFHGmkc_4LrCgNiq6hV6WUsXgnspuzWAsk5zL8EG6J9WYarKfTIkqPqI1CTidlMGgNGQ0wnruXlY/s400/pajj.JPG" /></a><br />
</div><div class="separator" style="clear: both; text-align: center;"><br />
</div><div class="separator" style="clear: both; text-align: left;">More clear picture<br />
</div><div class="separator" style="clear: both; text-align: left;"><br />
</div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi-rObqfUX1jcdKZxs3y9mL6YBGJ8ag0U291GQIY_dje7LB4l7cnATwBONWaDp0-CcvgxdAxh3PWiaJKlWcVd3ety168ox535RO5YKcXkPuMOyS3wGlcXRFNWIujbHeHL47rfQcgLvRU6A/s1600-h/morec.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" iq="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi-rObqfUX1jcdKZxs3y9mL6YBGJ8ag0U291GQIY_dje7LB4l7cnATwBONWaDp0-CcvgxdAxh3PWiaJKlWcVd3ety168ox535RO5YKcXkPuMOyS3wGlcXRFNWIujbHeHL47rfQcgLvRU6A/s400/morec.JPG" /></a><br />
</div>Unknownnoreply@blogger.com0