Thanks so much.... I found out that it is a permission issue. This does not work as well in the WUT when I log on as "Guest"
Lisa -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96 CS/SCCE Sent: Tuesday, June 26, 2007 4:56 PM To: [email protected] Subject: Re: Mid Tier and SQL Commands So is the field not getting set or is it throwing an error? Setting a field via SQL should work. I'd suggest you turn SQL logging on at the server, perform the action that should fire the active link in the browser, then check the logs to see what gets passed to the DB backend. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa Sent: Tuesday, June 26, 2007 3:53 PM To: [email protected] Subject: Mid Tier and SQL Commands If I have an Active Link that is setting a field via a SQL command, shouldn't this work in the Mid Tier? Works fine with WUT. I'm trying to get a COUNT of something: SELECT count(Rint1) from TEIS_SURVEY_FINAL Where Submitter_Upper = '$Administrator ID$' and TEIS_SURVEY_TYPE = '$Survey Type$' AND TEIS_SURVEY_NUMBER = '$Survey Number$' We have Mid Tier 7.0.1 Patch 1 on a Windows 2003 server. Our ARServer is 6.3. Lisa ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
