Forum Moderators: coopster
function getWrkHrsNew (tempDateLog2)
{
//some code here
//connection to database here
$recllWrkHrsNew_query=mysql_query(($SQLString),$datenewWrkHrsRec);
$recllWrkHrsNew2=mysql_num_rows($recllWrkHrsNew_query);if (<?$recllWrkHrsNew2?>!=0)
{
<? while($recllWrkHrsNew=mysql_fetch_array($recllWrkHrsNew_query))
{?>
if ("<? echo $recllWrkHrsNew["Transaction_Date"];?>" == tempDateLog2)
{
alert ("found something");
TotalRemainingTemp = TotalRemainingTemp + 7.5
foundValue = "found"
}
else
{
alert ("Can't find same date!");
}
<? }?>
}
<script language="javascript">
function getWrkHrsNew (tempDateLog2)
{
//some code here
//connection to database here
<? $recllWrkHrsNew_query=mysql_query(($SQLString),$da
tenewWrkHrsRec);
$recllWrkHrsNew2=mysql_num_rows($recllWrkHrsNew_qu
ery);?>if (<?$recllWrkHrsNew2?>!=0)
{
<? while($recllWrkHrsNew=mysql_fetch_array($recllWrkH
rsNew_query))
{?>
if ("<? echo $recllWrkHrsNew["Transaction_Date"];?>" == tempDateLog2)
{
alert ("found something");
TotalRemainingTemp = TotalRemainingTemp + 7.5
foundValue = "found"
}
else
{
alert ("Can't find same date!");
}
<? }?>
}
</script>
and here's the some part of the code which is working
<script language="vbscript">
Sub OkOutput()
tempDateLog = NewDataForm.LogYear.value &"-"& NewDataForm.LogMonth.value &"-"& NewDataForm.LogDay.value
NewDataForm.DateLog.value = tempDateLog
tempDateLog2 = tempDateLog
getWrkHrsNew(tempDateLog2)
End Sub
</script>
<body>
<form>
</form>
</body>
<? if ($WrkHrsNew2!= 0 )
{?>
alert ("ga san");
<? while( $WrkHrsNew=mysql_fetch_array($WrkHrsNew_query))
{
?>
alert ("san ga");
alert (<? echo $DateLogtemp?>);
alert (<? echo $WrkHrsNew['Date']?>);
<? if ( $WrkHrsNew['Date'] == $DateLogtemp )
{?>
alert ("Found!");
<? }
else
{?>
alert ("NONE");
<? }
}
}?>
Sub OkOutput()
tempDateLog = NewDataForm.LogYear.value &"-"& NewDataForm.LogMonth.value &"-"& NewDataForm.LogDay.value
NewDataForm.DateLog.value = tempDateLog
tempDateLog2 = tempDateLog
NewDataForm.DateLogtemp.value = tempDateLog2
getWrkHrsNew(tempDateLog2)
End Sub
<script language="js">
function getWrkHrsNew (tempDateLog2)
{
temp = tempDateLog2;
//some code here
//connection to database here
$WrkHrsNew2=mysql_num_rows($WrkHrsNew_query);?><? if ($WrkHrsNew2!= 0 )
{?>
alert ("ga san");
<? while( $WrkHrsNew=mysql_fetch_array($WrkHrsNew_query))
{
?>
alert ("<? echo $WrkHrsNew['Date']?>");
alert (temp);if ("<? echo $WrkHrsNew['Date']?>" == temp)
{
alert ("Found!");
foundValue = "found";
}
else
{
alert ("NONE");
}
<? }
}?>
}
</script>
<script language="vbscript">
//some other vb code
Sub OkOutput()
tempDateLog = NewDataForm.LogYear.value &"-"& NewDataForm.LogMonth.value &"-"& NewDataForm.LogDay.value
NewDataForm.DateLog.value = tempDateLog
tempDateLog2 = tempDateLog
getWrkHrsNew(tempDateLog2)
End Sub
</script>
but i've got a problem in comparing dates. in my database i have dates 2004-11-02, and 2004-11-22. in my select box if i have chosen the date november 23 2004 it is displayed in my textbox as 2004-11-23 and this date will be compared if there is a date in my database equal to my chosen date then it displays "Found". however, if i have chosen novermber 2 2004 it is displayed in my textbox as 2004-11-2 so when it is compared in my database it is displayed as "NONE". any idea what will i do now? thank you in advance. i will be looking forward for your reply.
is that right?
I need to be absolutely sure of the 2 formats if you want a good example.
