Thank you Kaiser.
Manjari R. Shrestha Junior Programmer Analyst -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96 CS/SCCE Sent: Thursday, October 04, 2007 8:39 AM To: [email protected] Subject: Re: Syntax error converting the varchar value to a column of data type int. Your Knowledge field looks like it's a radio button or a dropdown field. A radio button or dropdown's value is stored as an integer in the underlying DB. Your query should be something like this: SELECT count(*) from HIC_Survey_Results where (Create_Date >= 1188619200 AND Create_Date <= 1191211200 AND Knowledge = 1) -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Shrestha, Manjari R. Sent: Thursday, October 04, 2007 6:54 AM To: [email protected] Subject: Syntax error converting the varchar value to a column of data type int. ** Hello List, I am trying to create a report where it will count the number of results with the following SQL command and am getting error. I am trying to set the value returned by this command in a integer variable through an active link. SELECT count(*) from HIC_Survey_Results where (Create_Date >= $ztmpStartDate$ AND Create_Date <= $ztmpEndDate$ AND Knowledge = 'Excellent') Below is the error I am getting on the SQL log: <SQL > <TID: 007688> <RPC ID: 0000037627> <Queue: Admin > <Client-RPC: 390600 > <USER: ranjanm > /* Thu Oct 04 2007 07:47:42.5260 */ SQL Trace Log -- ON <SQL > <TID: 008140> <RPC ID: 0000037644> <Queue: List > <Client-RPC: 390620 > <USER: ranjanm > /* Thu Oct 04 2007 07:47:46.9950 */ SELECT actlinkId from actlink where name = 'HIC:SurveyStats-CalculateKnowledge - SetKnowledgeCounts' <SQL > <TID: 008140> <RPC ID: 0000037644> <Queue: List > <Client-RPC: 390620 > <USER: ranjanm > /* Thu Oct 04 2007 07:47:46.9950 */ SELECT assignShort,assignLong FROM actlink_set WHERE actlinkId = 3011 AND actionIndex = 0 <SQL > <TID: 008140> <RPC ID: 0000037644> <Queue: List > <Client-RPC: 390620 > <USER: ranjanm > /* Thu Oct 04 2007 07:47:46.9950 */ BEGIN TRANSACTION <SQL > <TID: 008140> <RPC ID: 0000037644> <Queue: List > <Client-RPC: 390620 > <USER: ranjanm > /* Thu Oct 04 2007 07:47:46.9950 */ SELECT count(*) from HIC_Survey_Results where (Create_Date >= 1188619200 AND Create_Date <= 1191211200 AND Knowledge = 'Excellent') <SQL > <TID: 008140> <RPC ID: 0000037644> <Queue: List > <Client-RPC: 390620 > <USER: ranjanm > /* Thu Oct 04 2007 07:47:46.9950 */ *** ERROR *** Syntax error converting the varchar value 'Excellent' to a column of data type int. (SQL Server 245) <SQL > <TID: 008140> <RPC ID: 0000037644> <Queue: List > <Client-RPC: 390620 > <USER: ranjanm > /* Thu Oct 04 2007 07:47:46.9950 */ ROLLBACK TRANSACTION <SQL > <TID: 008140> <RPC ID: 0000037644> <Queue: List > <Client-RPC: 390620 > <USER: ranjanm > /* Thu Oct 04 2007 07:47:46.9950 */ *** ERROR *** The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION. (SQL Server 3903) <SQL > <TID: 007380> <RPC ID: 0000037645> <Queue: List > <Client-RPC: 390620 > <USER: Remedy Application Service > /* Thu Oct 04 2007 07:48:05.7280 */ SELECT TOP 101 T310.C1,C18092,C18090,C18099,C18083 FROM T310 WHERE (((T310.C18093 = 'ID001279D4E3149QWVRgQK4BAAMQAA') AND (T310.C18099 = 1)) AND (T310.C18092 = 1)) ORDER BY 1 ASC Thanks in advance. Manjari R. Shrestha Junior Programmer Analyst ________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Pickering, Christopher Sent: Wednesday, August 15, 2007 12:20 PM To: [email protected] Subject: Re: Deleting Users Katherine, Try running the Remedy Configuration Manager first. Once open go to the Support Specifics Tab, select step 1 and select the group, go to the show people in group tab, the individual still showing should appear. If so, delete, if not then you need the find the SHR:Assignment form, which is a back end form. Search there for the individuals login or last name, then delete. C ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Katherine Hoffner Sent: Wednesday, August 15, 2007 12:07 PM To: [email protected] Subject: Re: Deleting Users ** DUH, Sorry I am using AR 6.3 across the board. On 8/15/07, Pickering, Christopher <[EMAIL PROTECTED]> wrote: Katherine, What ARS version, what ITSM version? C ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Katherine Hoffner Sent: Wednesday, August 15, 2007 11:57 AM To: [email protected] Subject: Re: Deleting Users ** I checked the Support Staff Skills and nothing. I am looking for the SHR:Assignment form and I cant find that form. On 8/15/07, Ostwinkle, Mary - ITSD < [EMAIL PROTECTED]> wrote: ** Check Individual Support Staff Skills in Configuration Manager. Mary ________________________________ From: Action Request System discussion list(ARSList) [mailto: ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" -- Katherine __20060125_______________________This posting was submitted with HTML in it___ __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 ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
