manifoldcf-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From <karl.wri...@nokia.com>
Subject RE: Database Connector JOB
Date Fri, 04 Jun 2010 12:01:59 GMT
Milliseconds since epoch implicitly includes the date as well as the time.  So I really don't
understand your question?
Karl

From: ext Rohan.GPatil@cognizant.com [mailto:Rohan.GPatil@cognizant.com]
Sent: Friday, June 04, 2010 8:00 AM
To: connectors-user@incubator.apache.org
Subject: RE: Database Connector JOB

Thanks figured it out.. Should we specify the startdate ?

Thanks & Regards,
Rohan G Patil
Cognizant  Programmer Analyst Trainee,Bangalore || Mob # +91 9535577001
Rohan.GPatil@cognizant.com<mailto:Rohan.GPatil@cognizant.com>

From: karl.wright@nokia.com [mailto:karl.wright@nokia.com]
Sent: Friday, June 04, 2010 5:18 PM
To: connectors-user@incubator.apache.org
Subject: RE: Database Connector JOB

$(IDCOLUMN) is the name of the column the connector wants to see in the resultset.  So your
query would be:

SELECT DID AS $(IDCOLUMN) FROM Revisions WHERE DINDATE > $(STARTTIME) AND DINDATE <=
$(ENDTIME)

Bear in mind that if your DINDATE column is not in milliseconds since epoch, you will need
to modify the above query to code for date conversion.

Thanks,
Karl

From: ext Rohan.GPatil@cognizant.com [mailto:Rohan.GPatil@cognizant.com]
Sent: Friday, June 04, 2010 1:57 AM
To: connectors-user@incubator.apache.org
Subject: Database Connector JOB

Hi,

I am setting up the Database connector Job. In the queries.

SELECT idfield AS $(IDCOLUMN) FROM documenttable WHERE modifydatefield > $(STARTTIME) AND
modifydatefield <= $(ENDTIME)

My document Id field is "DID"
Document Table is "Revisions"
Modifydatefeild is "DINDATE"

I am unable to figure out the substitutions. Should I substitute in idfield or $(IDCOLUMN)

Thanks & Regards,
Rohan G Patil
Cognizant  Programmer Analyst Trainee,Bangalore || Mob # +91 9535577001
Rohan.GPatil@cognizant.com<mailto:Rohan.GPatil@cognizant.com>

This e-mail and any files transmitted with it are for the sole use of
the intended recipient(s) and may contain confidential and privileged
information.
If you are not the intended recipient, please contact the sender by
reply e-mail and destroy all copies of the original message.
Any unauthorized review, use, disclosure, dissemination, forwarding,
printing or copying of this email or any action taken in reliance on this
e-mail is strictly prohibited and may be unlawful.


This e-mail and any files transmitted with it are for the sole use of
the intended recipient(s) and may contain confidential and privileged
information.
If you are not the intended recipient, please contact the sender by
reply e-mail and destroy all copies of the original message.
Any unauthorized review, use, disclosure, dissemination, forwarding,
printing or copying of this email or any action taken in reliance on this
e-mail is strictly prohibited and may be unlawful.




Mime
View raw message