Recent customer reviews (average rating 8.3/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
07/04/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:0771e819-946c-4981-b756-73f1b4409252
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='Canada' and City = 'Victoria BC' ORDER BY ReviewRating, [ReviewDate] desc ) as mm | END
Victoria BC car hire information
.
declare @latitude float, @longitude float, @distance float, @CountryCode varchar(50) select @distance = 1000 SET @latitude = (SELECT TOP 1 Lat FROM [cartrawler_v2].[dbo].[Location] where CartrawlerCode = 1067); SET @longitude = (SELECT TOP 1 Lng FROM [cartrawler_v2].[dbo].[Location] where CartrawlerCode = 1067); SET @CountryCode = (SELECT TOP 1 CountryCode FROM [cartrawler_v2].[dbo].[Location] where CartrawlerCode = 1067); ; with RestroomLocationsWithDistance as ( select Id, Lat, Lng, Name, address, CountryCode, ( 3959 * acos(cos(radians(@latitude)) * cos(radians( [Lat])) * cos(radians( [Lng]) - radians(@longitude) ) +sin(radians(@latitude)) * sin(radians( [Lat]) ) ) ) As Distance FROM [cartrawler_v2].[dbo].[Location] where CountryCode = @CountryCode and Lat<>@latitude and Lng<> @longitude) select TOP 10 Id,Lat,Lng, Name, Address,CountryCode,Distance,@latitude as citylat, @longitude as citylng from RestroomLocationsWithDistance WHERE Distance <= @distance and Name<> '' order by Distance SELECT TOP 1 Id,Lat,Lng, Name , Address,CountryCode,'0' as Distance, Lat as citylat, Lng as citylng FROM [cartrawler_v2].[dbo].[Location] where CartrawlerCode = 1067;
Laws and rules of the road when driving in Canada
-
R
Road Driving Side
-
50kph
Urban speed Limit
-
80kph
Rural Speed Limit
-
100kph
Motorway Speed Limit
-
CAD 1.42/Ltr
Current Petrol Price
-
50-80mg
Drink Drive Limit
-
CAD
Currency
-
YES
Tolls
-
-
Front and Rear
Seatbelts
-
Fixed and Mobile
Speed Cameras
-
Hands Free Only
Mobile Phones
select [type] from [customtable_price_data] where NodeID='7189' order by january;select [January],[Feburary],[March],[April],[May],[June],[July],[August],[September],[October],[November],[December] from [customtable_price_data] where NodeID='7189' order by january;
*average daily rates based on 7 day rental, search for todays best prices.