$(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 [email protected] [mailto:[email protected]] Sent: Friday, June 04, 2010 1:57 AM To: [email protected] 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 [email protected]<mailto:[email protected]> 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.
