JavaScript - Trying To Fetch The Date

Not sure if this is possible in javascript:

I'm looking for two different dates (bill date and due date) on an invoice that are captured by OCR. If one of them exists, but the other does not, I want the empty field to be 14 days before (or after) the other.

For example:
if the bill date is 7/27/2010 and the due date was not captured, I want to set the due date as 8/10/2010 (14 days after the bill date).

If the due date was captured as 8/10/2010, but the due date is blank, I want to assign the bill date as 7/27/2010 (14 days before the due date).

if both dates have values, do nothing.

Thanks.

I am creating a customized home page that can display regular links and login forms. I am adding Gmail login form into it. I can further customize it by putting multiple sign in buttons that can fill in username/password for different accounts before submitting.

Here's the preview:
http://imgur.com/s4Ert.jpg

Now the problem is, in Gmail login form a hidden variable called "dsh" is filled with a value that is matched with server as well as a cookie, this value changes in some hours. So this means that I cannot create a complete offline form, but is it possible to load the login page hidden, and catch the value from it?

I tried with an iframe with display:none and src="http://mail.google.com" but it opened in the top frame. Any other ideas?

In short, what we need is, every time a page is opened from my computer, an online page should be open invisible from the user, and a hidden form value is to be fetched from it.

im having issue with fetching answers from database by json file it says error once i click finish button, what do you think the error could be? here is the responses.php file code:

and here is the js code that pulls answers

Code:

$.ajax({
               url :'reponses.php',
               type : 'POST',
                data : 'fetchAnswers=' + answerCode + '&id_examens=' + examensId,
               dataType : 'json',
               success : function(data){
                   $(lastButton).html('Finish');
                    answers =data;// $.parseJSON(data);
                    $(dataDiv).data('answer', answers);
                    callback(answers);
               },

               error : function(resultat, statut, erreur){
                 $(lastButton).html('Finish');
                alert('There was a problem with your network connection. Please click "Finish" again to re-try. If the problem persists, you will have to wait until network connectivity has been restored.');
               },

               complete : function(resultat, statut){

               }

            });         





        }
        else {
            answers = $(dataDiv).data('answer');
            $(lastButton).html('Finish');
            callback(answers);                  
        }   
    }
}

when i click the finish button it shows the alert message instead of bring answer and proceed





Reply With Quote




01-17-2015, 06:18 PM #2
yamizer View Profile View Forum Posts

New to the CF scene Join Date Jan 2015 Posts 2 Thanks 0 Thanked 0 Times in 0 Posts

sorry i forgot to add responses.php file codee

Code:

<?php
include("config.php");
header('Content-Type: application/json');

$answers=array();

$sql_questions = 'SELECT * FROM question ';
$res_questions = mysql_query($sql_questions);

 while($data_questions=mysql_fetch_array($res_questions)){ 
    $id_question=$data_questions["id"];
    //$sql_answers = "SELECT * FROM reponse   WHERE id_question=".$id_question." AND rep_correcte='1'";
    $sql_answers = "SELECT * FROM reponse   WHERE id_question=".$id_question;//." AND rep_correcte='1'";
    $res_answers = mysql_query($sql_answers);

      $i=1;
      while($data_answers=mysql_fetch_array($res_answers)){
        if($data_answers["rep_correcte"]==1)
        {
                $answers[]=$i;//$data_answers['id']; 

        }
        //$answers[]=$data_answer["rep_correcte"];
        $i++;
      }
}//["1","6"]
// $answers=array(1,6);
echo json_encode($answers);

/* $answers=array(1,3,2,1,1,4,1);
echo json_encode($answers);  */
exit();
?>

Reply With Quote

01-19-2015, 05:44 AM #3
Old Pedant View Profile View Forum Posts

Supreme Master coder! Join Date Feb 2009 Posts 28,311 Thanks 82 Thanked 4,754 Times in 4,716 Posts

That is TERRIBLE TERRIBLE PHP coding! (Well, actually SQL coding!)

NEVER NEVER do a SELECT *inside* a PHP loop that results from a different SELECT!!

But the PHP code makes no sense in any case. You are invoking that page from the JSON code with parameters: Code:

'fetchAnswers=' + answerCode + '&id_examens=' + examensId

Yet NOWHERE in the PHP code are you USING those parameters!

That is, you should be doing PHP Code:
$answerCode = $_POST["answerCode"];
$id_examens = $_POST["id_examens"]; 


and then USING those values in your PHP code, probably to SELECT the correct records!

Hi,

I am new to javascript, Please help me with the issue below.
My javascript code below should actually fetch the data from html table on button click.

function displaymessage()
{
alert ("button pressed");
var table_cells = new Array();
var table7 = document.getElementById('Auth');

for (i=0,n=table7.rows.length; i < n ; i++)
{
var Rowdata = table7.rows[i];
table_cells[i] = new Array();
for(j=0,cols = Rowdata.cells.length; j < cols; j++)
{
table_cells[i,j] = Rowdata.cells[j].innerHTML;
alert (table_cells[i,j]);
}
}
alert (table_cells[1,1]);
alert (table_cells[2,1]);
alert (table_cells[3,1]);
alert (table_cells[4,1]);
alert (table_cells[5,1]);
alert (table_cells[6,1]);
alert (table_cells[7,1]);
alert (table_cells[8,1]);

}

The problem with my code above is that the statement
"alert (table_cells[i,j]);" executes properly and shows the correct value.

But the other alert statements shows only the value of the last row of the table.
i.e., my table has 9 rows. and all the alert statements shows 9th row's 2nd column's value outside the for loop. But inside the for loop it executes fine.

I tried it in IE7.

I seem to miss something. Could someone please help me out with this?

Thanks in advance.

Hi All.

I have a dropdown list on a web form containing dates. My Question: How can I call data for that selected item(date) from a MySQL database and display it to the user? And more specifically, if that selected date has no data in the data base, I want to be able to display that as well.
I'm looking for a Javascript solution, and if possible a php solution.

Thank You!

I have a drop down menu where people can select a month, day and year. Based on their selection, I want to show them an image.

If their selection is >= July 26, 2010 but <= July 25, 2011, show the red image;
If their selection is >= July 26, 2011 but <= July 25, 2012, show the white image;
If their selection is >= July 26, 2012 but <= July 25, 2013, show the blue image;
If their selection is >= July 26, 2013 but <= July 25, 2014, show the yellow image;

I don't know how to compare a selected date to a range of dates like this.

Hi,
I need to add days to a date in javascript,
My requirement is as follows:
Date is coming from a textbox.
eg:- 26/07/2010

days from this statement

var day1=document.getElementById('<%=HiddenDate.ClientID %>').value;

an eg:- if the date is 28/01/2012 and days Needed to be added=5
the added date should be 02/02/2012.
Can anybody help me?

Thanks
Jamuna

Hi,

I've inherited a Form which calculates a future date based on a calculation and then inserts today's date and the future date into a database. The day part of the date is formatted as a number. This is fine, but up to 9 the numbers display in single figures with no leading zeros. I want them to display leading zeros (e.g. 01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11... 30, 31)

So;
1/12/2010 is NOT wanted
01/12/2010 IS wanted

The inherited code originally set the Month names as "Jan", "Feb" etc, and it was easy to kludge these to 01, 02... 12, but I suspect there's a more elgant solution to this as well, this bit of the code works so it's not as vital to neaten this but my database needs dd/mm/yyyy format (it's a third party email program).

Code:

 </script>

<script type="text/javascript">
var todaysDate = new Date();

function updateExpiryDate(){

	var weeklyMileage = document.getElementById('AvWeeklyMileage').value;
	var expiryDate;
	var weeks = 0;
	var expiryDateString = '';

	if (!isNaN(parseInt(weeklyMileage))){
		weeks = 700/weeklyMileage;
		expiryDate = new Date(todaysDate.getTime() + (1000 * 3600 * 24 * 7 * weeks));

		var expiryDateString = expiryDate.getDate() + '/' + getMonthString(expiryDate.getMonth()+1) + '/' + expiryDate.getFullYear();

		document.getElementById('expiryDate').innerHTML = expiryDateString;
		document.getElementById('ShoeExpiryDate').value = expiryDateString;
	} else {
		document.getElementById('ShoeExpiryDate').value = '';
		document.getElementById('expiryDate').innerHTML = 'Please enter a valid weekly average mileage'
	}

}

function getMonthString(monthNumber){
	var monthString = "";
	switch(monthNumber){
		case 1:
			monthString = "01";
			break;
		case 2:
			monthString = "02";
			break;
		case 3:
			monthString = "03";
			break;
		case 4:
			monthString = "04";
			break;
		case 5:
			monthString = "05";
			break;
		case 6:
			monthString = "06";
			break;
		case 7:
			monthString = "07";
			break;
		case 8:
			monthString = "08";
			break;
		case 9:
			monthString = "09";
			break;
		case 10:
			monthString = "10";
			break;
		case 11:
			monthString = "11";
			break;
		case 12:
			monthString = "12";
			break;
		default:
			// do nothing;
	}
	return monthString;
}

function setTodaysDate(){
	var todaysDateString = todaysDate.getDate() + '/' + getMonthString(todaysDate.getMonth()+1) + '/' + todaysDate.getFullYear();
	document.getElementById('todaysDate').innerHTML =todaysDateString;
	document.getElementById('DateOfPurchase').value = todaysDateString;

}

Can someone point me in the right direction please?

Using Adobe Form Javascript validation, how would I do this code for Visual Basic in Javascript (non web)

Code:

If PurchaseDate.Value > Date Then
MsgBox ("PurchaseDate cannot be greater than Today's Date!")
Cancel = True
End If

Something along these lines but this isnt working:

Code:

If (PurchaseDate.Value > Date) Then 
{
app.alert ("Purchase Date cannot be greater than Today's Date!");
}

Thanks

Hello,

I really need your help with one.

How can I use the following code below to save the date from my popup window datepicker back into a var and relay it back onto its parent page?

I can't seem to figure this out:

Code:

<html>



<head>

<script>
	
	function open_cal() {
	

  var str_html	= 	""
  				+	"<!DOCTYPE html>\n"
				+	"<html lang=\"en\">\n"
				+	"<head>\n"
				+	"<meta charset=\"utf-8\">\n"
				+	"<title>CALENDAR</title>\n"
				+	"<link href=\"jq/jquery-ui.css\" rel=\"stylesheet\" type=\"text/css\">\n"
				+	"<script src=\"jq/jquery.min.js\" type=\"text/javascript\"></" + "script>\n" 
				+	"<script src=\"jq/jquery-ui.min.js\" type=\"text/javascript\"></" + "script>\n"
				+	"<script src=\"jq/datepicker.js\" type=\"text/javascript\"></" + "script>\n"
				+	"</head>\n"
				+	"<body>\n"
				+	"<div id=\"text\" style=\"font: bold 10pt Tahoma\">Enter Approval Date:</div>\n"
  				+	"<div id=\"datepicker\"></div>\n"
  				+	"</body>\n"
  				+	"</html>"
  				
var j = window.open("","CALENDAR","width=200,height=250,status=no,resizable=yes,top=200,left=200")
	j.opener = self;
	j.document.write(str_html);
}


</script>	
	

		
</head>

<body>

<input onclick="open_cal()" type="button" value="Open" name="B1">


</body>

</html>

Datepicker.js:
Code:

$(function() {
	
		$( "#datepicker" ).datepicker({ 
		
		dateFormat: 'dd/mm/yy',
		
		onSelect: function(dateText, inst) { 
		alert(dateText)
		window.close()
		
		} 
		
		})
		
		
		
		
});

Any help with this is greatly and mostly appreciated.

Thanks in advance,

Cheers,

J

I am trying for a javascript code that would ask for the excel file location when run, fetch data from two columns till eof in an excel file (MS Excel 2010), append it to an existing text file and upload the plain text file to an ftp location.

The ftp username, password and location needs to be hard coded in the script.

Is this possible?

hello there
this is in vb script. but i dont where to post it. can any one hlep me out plzz
I need to check if the date entered by user is within 5th date from current date.

I am trying to do it this way
entered date has month and date value
Code:

sResvDate = 01/24
Set sMaxDays to getdate(5)

but get date will give year too. and how do i compare if it less than 5th day or not.

Hi folks,
i am trying to generate a dynamic datefield with date mask "mm/dd/yyyy" and trying to insert it into Oracle db ...i still got the error ORA invalid month ehich means the date filed is not recognized as date:

below is what i am doing :

newStartDate = document.createElement( 'INPUT' ); newStartDate.setAttribute('type','Date'); newStartDate.setAttribute('id1','id'+ elementid+elementrow); newStartDate.setAttribute('name','StartDateName'+ elementid+elementrow); newStartDate.size=8; newStartDate.style.backgroundColor= bgc;

any help thanks ??

Also i want to add a datepicke to this textbox..how it is posible / other option is to use Jquery datepicker but could not know how to impement it

thanks again

I am delving into the coding world and while I understand the basic principle of cookies, conditional statements, arrays, etc... I am still learning how to properly implement them. Any asistance with the following situation would be greatly appreciated and help with my learning as I try to reverse engineer the logic. I have looked around the web and this forum with little success. If the situation below is too complicated, I would really appreciate even a shove in the right direction regarding the logic.

-----------------
How could I show a preset counter which counts up from a preset, beginning number toward a preset, end number? I imagine the increment and speed is set be the difference between the two numbers and a timeframe.

Assumptions:
I would rather not set the increment but edit the end number to show a steady increase. As I update that number, the increment adapts dynamically.

I would want the number/script to be useful, so it should not refresh to the beginning number on each page load (i.e. num=0). When a visitor comes to the page, it must seem like the counter has been steadily been increasing in their absence.

Coke or Pesi did something similar one time regarding cans sold to date (doubt it was plugged into a DB somewhere but rather based on a steady sales figure) and it was pretty cool.

All the best!

Hi guys,

I hope to seek your help about the date function. I had the date store in my database under the type of timestamp.

Now i wish to retrieve out the date store on my database and match it with today date however, I am facing problem with it. I know that I had to create a variable for it, however, after trying for many time, it still show me error.

Would appreciate your kind help