Out of curiosity ... You said in an earlier message the Database Input Length was 4 on the form for that column. What happens when you change it to 5 (or 15)?
Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Bill Bookers Sent: Friday, November 21, 2008 9:24 AM To: [email protected] Subject: Re: Update/Resend Re: Problem with view forms For anyone still playing at home, the reinstall of AR Server did not help (on the positive side, it did not make anything worse). On Thu, Nov 20, 2008 at 10:45 AM, Bill Bookers <[EMAIL PROTECTED]> wrote: I had replied to both Fred and Joe, but I never saw my messages go through. My aplogies if this ends up being a duplicate. (FWIW it seems to work when I send email to the listserv, but not when I try to post from the list's web interface) I ran an arsql.log and searched against one of the view forms. I found that "ARGetEntry" is searching thusly: ... WHERE C1 = N'1025' instead of: WHERE C1 = 10257 According to our DBA, the 'N' serves as a sort of wild-card to allow for various data types. We are still leaning toward doing a reinstall of the current ARS version, using the upgrade option, in hopes that the problem is with "ARGetEntry" and that a re-install will replace it (and anything else that's broken). _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
