Query Failed. Contact portal administrator. System.Exception: Select [rm1_fn]AS First_Name ,
[rm1_ln]AS Last_name,
[rm1_email] AS Email_Address, +SPACE (4) +
[rm2_fn]AS First_Name ,
[rm2_ln]AS Last_name,
[rm2_email] AS Email_Address
FROM [dbo].[csu_housing_roommate_info]
Where roommate_2 = 'guest' OR roommate_1 = 'guest' ---> System.Data.Odbc.OdbcException: ERROR [22018] [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting the varchar value 'guest' to data type int.
at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)
at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)
at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader)
at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
at CUS.OdbcConnectionClass3.OdbcConnectionClass3.OdbcConn(String sqlStatement, Exception& exReturn, Int32 timeout, List`1 parameters)
--- End of inner exception stack trace ---
at CUS.ICS.SimpleQuery.SimpleQueryExecution.GetData(Guid portletId)
at CUS.ICS.SimpleQuery.Default_View.RenderOutput()
This portlet is only available to users of certain roles logged into the system.