Recent customer reviews (average rating 9.0/10)
Have your say
What would you score us?
?/10
Let us know
Share your experience with us and save up to 10% of your next rental
04/06/2020
2
Catch 2 random based on country + Advert - Error: System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'ReviewNameCounbtry'.
Invalid column name 'ReviewNameCountry'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
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 CMSWebParts_MyWebParts_Review.populateReviews(String pvLocationType, String pvLocationName, String pvCountryName, String pvBookingEngineID, String pvDocumentID, String pvAirportCode, String pvIsAirport, String pvAdvert_Title, String pvAdvert_Text) in c:\Default\rhinocarhire.com\htdocs\CMS\CMSWebParts\MyWebParts\Review.ascx.cs:line 303
ClientConnectionId:89294b04-4024-48d7-b171-c95e2d6a6217
Error Number:207,State:1,Class:16
text
Review SQL: START | SELECT ROW_NUMBER() OVER( ORDER BY mm.ReviewRating desc ) row_num, mm.ItemID, mm.ReviewRating as ReviewRating_1,CAST(mm.ReviewRating AS float) * 2 as ReviewRating,[ReviewComment],[ReviewName],[ReviewNameCountry],[ReviewDate],Supplier_Logo,Supplier_Name,City,Country FROM (SELECT top 3 ItemID, [ReviewRating], [ReviewComment], [ReviewName],[ReviewNameCountry], [ReviewDate], Supplier_Logo, Supplier_Name,City,Country FROM [dbo].[customtable_reviews] WHERE Country='Malaysia' and City = 'Kota Kinabalu' ORDER BY ReviewRating, [ReviewDate] desc ) as mm | END
Kota Kinabalu car hire information
*average daily rates based on 7 day rental, search for today's best prices.