Compare datas

[Rizvan Asgarov]

Dear friends,
How can i compare repeating datas when connecting to database (Oracle) from my java application?
or taking any data for to compare with others?
Can you please give an example using "javascripts"...


Every reply will be appreciated,
Thanks in advance
Rizvan

[Eric Pascarello]

I do not think you want JavaScript to compare Oracle dates.

Where do you want to do the comparison on the clientside or on the serverside? How are the dates entered? What makes the comparison occur.

Eric

[Rizvan Asgarov]

Eric, thanks for your reply,

Eric, it is connected with Oracle datas... not dates. Maybe you have not noticed! (it is a normal)

I use for this purpose in TestComplete. So any data is a problem when repeating. So I want to continue it by comparing ...
Here my existing code as the following:

  Consts
cUserName = "username";
cPassword = "password"

var vParameters;

 //  Export of Results  //
function ExportResults()
{
  var vFileName, vMailBody;
  if(Log.ErrCount > 0)
  {
    vFileName = Project.ConfigPath + "Log\\MyResults.mht";   
    if(aqFile.Exists(vFileName)) 
    {
      aqFile.Delete(vFileName); 
    }
    Log.SaveResultsAs(vFileName, 2);
    vMailBody = "There are " + IntToStr(Log.ErrCount) + " error(s)!";
    if(SendMail("[e-mail]", "mail.fhn.gov.az", "Rizvan Asgarov", "[e-mail]", "Notification", 
      vMailBody, vFileName))
    {
      Log.Message("Mail was sent"); 
    }     
    else
      Log.Warning("Mail was not sent");
  }       
}
 
function Main()
{
  var  vPage, vFileName, vConfigFileName, vSection, vIni;
  var aquery;
  var vUrlPath = null;
  
  vConfigFileName = Project.ConfigPath + "Config.ini";
  ShowMessage(Project.ConfigPath);
  if(aqFile.Exists(vConfigFileName))
  {
    vIni = Storages.INI(vConfigFileName);
  
    vParameters = Sys.OleObject("Scripting.Dictionary");
    vSection = vIni.GetSubSection("Test1");
    ShowMessage(vSection.Name);
    vParameters.add("username", vSection.GetOption(cUserName, ""));
    vParameters.add("password", vSection.GetOption(cPassword, ""));     
    TestedApps.IEXPLORE.Run(1, false);
    Sys.Process("iexplore").Find("Name", "Window(Edit, '',1)", 50).Keys("http://192.168.8.4/fhnng/dc/[Enter]");   
  }
  else
  {
    ShowMessage("Configuration file does not exists!");
  }
  try 
  { 
    vPage = Sys.Process("iexplore").Page("http://192.168.8.4/fhnng/dc/");
    vPage.INPUT.Item("username").value = vParameters.Item("username");
    vPage.INPUT.Item("password").Keys(vParameters.Item("password") + "[Enter]");
    aquery=ADO.CreateADOConnection();
    aquery.LoginPrompt="false";
    aquery.ConnectionString="Provider=MSDAORA.1;Password=" + vParameters.Item("password") + ";User ID=" + vParameters.Item("username") + ";Data Source=192.168.8.4/fhndbtst;Persist Security Info=True";
    aquery.Connected = "True";
    Log.Message("Successful!");
    vPage.SPAN.SPAN_4.Click(57, 8);  
  }
  catch(exception)
  {
    Log.Picture(vPage.Picture());
    Log.Error("Unsuccessful! Check your username or password!"); 
  }
  finally
  {
    //aquery.Close();        
    ExportResults(); // Export of Results          
  }
}    
  

Thanks in advance,
Rizvan

[Eric Pascarello]

That does not look like any JavaScript that I know of.

Eric

[Rizvan Asgarov]

Eric Pascarello wrote:

That does not look like any JavaScript that I know of.

Yeah Eric, these codes does not resemble to the javascript wholly...
This is a jscript... Sorry, I have not used javascript much.Therefore I have meant the jscript like javascript.
Thanks again,
Rizvan