Hi,
I need some correction in a javascript for date validation. The error I'm getting is, when ever i run the report , for any selected value , it's popping out the alert.
here is the script:
<script>
var cntlName;
function right(str, n){
if (n <= 0)
return "";
else if (n > String(str).length)
return str;
else {
var iLen = String(str).length;
return String(str).substring(iLen, iLen - n);
}
}
function customCheckPage(){
var par1;
var par2;
for( var i=0; i<preProcessControlArray.length; i++){
cntlName = eval(preProcessControlArray
);
if ( cntlName.m_oSubmit.name.toLowerCase() == 'Par_FromDate' ){
eval('pickerControl' + cntlName.m_sRef + '.lostFocus()');
par1 = cntlName.m_oForm.value;
}
if ( cntlName.m_oSubmit.name.toLowerCase() == 'Par_ToDate' ){
eval('pickerControl' + cntlName.m_sRef + '.lostFocus()');
par2 = cntlName.m_oForm.value;
}
}
if (par1<=par2)
promptButtonFinish();
else
alert('FROM DATE parameter must be smaller than or equal to TO DATE parameter!');
}
for( var i=0; i<pageNavigationObserverArray.length; i++){
cntlName = eval( pageNavigationObserverArray );
if(cntlName.m_oParent.onclick.toString().indexOf('promptButtonFinish()')>0 ){
cntlName.m_oParent.onclick = customCheckPage;
}
}
for( var i=0; i<preProcessControlArray.length; i++){
cntlName = eval(preProcessControlArray);
dt = new Date();
df = new Date( dt - 30*86400000);
if (cntlName.m_oSubmit.name.toLowerCase() == 'Par_FromDate' ){
cntlName.m_oEditBox.value = df.getFullYear()
+ '-' + right('0'+(1+df.getMonth()),2)
+ '-' + right('0'+df.getDate(),2);
eval('pickerControl' + cntlName.m_sRef + '.lostFocus()');
}
if (cntlName.m_oSubmit.name.toLowerCase() == 'Par_ToDate' ){
cntlName.m_oEditBox.value = dt.getFullYear()
+ '-' + right('0'+(1+dt.getMonth()),2)
+ '-' + right('0'+dt.getDate(),2);
eval('pickerControl' + cntlName.m_sRef + '.lostFocus()');
}
}
</script>
Thanks in Advance
First of all ....... STOP CALLING IT YOUR SCRIPT ! ... >:( I've wrote it about a year ago for Hewitt in Lincolnshire, IL ...
Second, which alert box are you getting?
That might be ur script. I also worked for Hewitt in charlotte , and i got it from there. I think it's not copyrighted ;) ....okay...
The problem now is I'm testing it in cognos 8.2 with two date prompts "from date" and "to date ". so, when the from date is may 1 2007 and to date is may 31 2007 it shouldn't show any alert for me . But it's showing me an alert like " From date should be smaller than the to date" ...
Your script is awesome. Can you suggest me some good site where i can learn javascripting ? :)
Thanks in Advance
Is that okay now Cognoise Administrator ?
Good work Dude :)
A good website for anything HTML related is w3schools.
as for your, pardon mine, script, the problem is:
cntlName.m_oSubmit.name.toLowerCase() == 'Par_FromDate'
it should be
cntlName.m_oSubmit.name.toLowerCase() == 'par_fromdate'
Every time you you toLowerCase() the string you compare it to should be using only lower case characters.
Hi,
I tried using lowercase. But the problem is still there .....
if (par1<=par2)
//alert ('CORRECT');
promptButtonFinish();
else
alert('FROM DATE parameter must be smaller than or equal to TO DATE parameter!');
i think the problem is at this part of the code . When i use the first alert, it's going into the report irrespective of date. I mean second alert is not working (even if par1>par2).
if i comment the first alert, then it's popping the alert even when (par1<par2)...
Thanks in Advance....
This is a different problem.
It should be:
if (par1<=par2) {
//alert ('CORRECT');
promptButtonFinish();
} else {
alert('FROM DATE parameter must be smaller than or equal to TO DATE parameter!');
}
This is also not working .... I tried changing my script with that ..... It's not showing the alert at all .
this is the latest script .....
<script>
var cntlName;
function right(str, n){
if (n <= 0)
return "";
else if (n > String(str).length)
return str;
else {
var iLen = String(str).length;
return String(str).substring(iLen, iLen - n);
}
}
function customCheckPage(){
var par1;
var par2;
for( var i=0; i<preProcessControlArray.length; i++){
cntlName = eval(preProcessControlArray
);
if ( cntlName.m_oSubmit.name.toLowerCase() == 'par_fromdate' ){
eval('pickerControl' + cntlName.m_sRef + '.lostFocus()');
par1 = cntlName.m_oForm.value;
}
if ( cntlName.m_oSubmit.name.toLowerCase() == 'par_todate' ){
eval('pickerControl' + cntlName.m_sRef + '.lostFocus()');
par2 = cntlName.m_oForm.value;
}
}
if (par1<=par2) {
//alert ('CORRECT');
promptButtonFinish();
} else {
alert('FROM DATE parameter must be smaller than or equal to TO DATE parameter!');
}
for( var i=0; i<pageNavigationObserverArray.length; i++){
cntlName = eval( pageNavigationObserverArray );
if(cntlName.m_oParent.onclick.toString().indexOf('promptButtonFinish()')>0 ){
cntlName.m_oParent.onclick = customCheckPage;
}
}
for( var i=0; i<preProcessControlArray.length; i++){
cntlName = eval(preProcessControlArray);
dt = new Date();
df = new Date( dt - 30*86400000);
if (cntlName.m_oSubmit.name.toLowerCase() == 'par_fromdate' ){
cntlName.m_oEditBox.value = df.getFullYear()
+ '-' + right('0'+(1+df.getMonth()),2)
+ '-' + right('0'+df.getDate(),2);
eval('pickerControl' + cntlName.m_sRef + '.lostFocus()');
}
if (cntlName.m_oSubmit.name.toLowerCase() == 'par_todate' ){
cntlName.m_oEditBox.value = dt.getFullYear()
+ '-' + right('0'+(1+dt.getMonth()),2)
+ '-' + right('0'+dt.getDate(),2);
eval('pickerControl' + cntlName.m_sRef + '.lostFocus()');
}
}
</script>
Thanks in Advance
The version of Cognos I'm using is 8.2. will that be a problem ????
What are your parameter names?
par_fromdate ,par_todate
You should be comparing parameter names to 'p_' concateneted with parameter name, so every reverence of par_fromdate should be p_par_fromdate (same for to date).
Thanks Dude .... It's working now :)