Server Error in '/' Application.

42883: operator does not exist: numeric = character varying

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: Npgsql.PostgresException: 42883: operator does not exist: numeric = character varying

Source Error:


Line 12:             dbconn.Open()
Line 13:             Dim cmd As New NpgsqlCommand(" SELECT LN, PTYP FROM Listings WHERE LN =(SELECT LN FROM FeaturedHome WHERE website='skagitwhatcomrealestate.com') ", dbconn)
Line 14:             Dim reader As NpgsqlDataReader = cmd.ExecuteReader()
Line 15:             While reader.Read()
Line 16:                 LN = reader(0).ToString

Source File: C:\inetpub\wwwroot\v4.04.idxmap.com\rentals.aspx.vb    Line: 14

Stack Trace:


[PostgresException (0x80004005): 42883: operator does not exist: numeric = character varying]
   Npgsql.<<DoReadMessage>g__ReadMessageLong|0>d.MoveNext() +1025
   System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() +32
   Npgsql.<<DoReadMessage>g__ReadMessageLong|0>d.MoveNext() +2755
   System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() +32
   Npgsql.<NextResult>d__44.MoveNext() +8860
   System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() +32
   System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) +62
   Npgsql.NpgsqlDataReader.NextResult() +311
   Npgsql.<ExecuteReaderAsync>d__102.MoveNext() +1901
   System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() +32
   System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) +62
   Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior) +198
   _listings.Page_Load(Object sender, EventArgs e) in C:\inetpub\wwwroot\v4.04.idxmap.com\rentals.aspx.vb:14
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +154
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4082


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.4042.0