I think he mentioned that the SERVER has been limited to 1000. On Dec 14, 2007 11:03 AM, Evans.Randy <[EMAIL PROTECTED]> wrote:
> ** Change your preferences to unlimited while you run the macro. > You probably don't want to go against the database itself. Remedy has a > tendency to store dates as long integers based on the number of seconds > since 1/1/1970. > > ------------------------------ > *From:* Action Request System discussion list(ARSList) [mailto: > [EMAIL PROTECTED] *On Behalf Of *Martinez, Raul (ISD, IT) > *Sent:* Friday, December 14, 2007 9:47 AM > *To:* arslist@ARSLIST.ORG > *Subject:* Remedy SQL query assistance... Please Help. > > ** > > Can anyone assist me in either in connecting an ODBC connection to Remedy > through Access or with creating a SQL search query for $DATE$ function? I am > needing to grab all submitted tickets for current day based on certain > submitters. I already have a remedy macro created but it would be easier > with a SQL query. I had to split the macro up several times due to the > server being limited to only 1000 line return. > > > ************************************************************************* > This communication, including attachments, is > for the exclusive use of addressee and may contain proprietary, > confidential and/or privileged information. If you are not the intended > recipient, any use, copying, disclosure, dissemination or distribution is > strictly prohibited. If you are not the intended recipient, please notify > the sender immediately by return e-mail, delete this communication and > destroy all copies. > ************************************************************************* > __20060125_______________________This posting was submitted with HTML in > it___ > __20060125_______________________This posting was submitted with HTML in > it___ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"