Type Mismatch Error(numeric values) - ASP / Active Server Pages

Savas Ates

i have 3 columns in sql server ..

all of them are numeric value

when a user enter my site i take the value of userid (numeric one) i assign
it as session("userid ")

after a query i take 2 value (both numeric again) from my table and write
this code

if towhom=session("userid") then towhom=fromwhom

it gives an error .. how can i solve it

Type Mismatch Error

Jul 19 '05 #1

Subscribe Post Reply

2176

Ray Costanzo [MVP]

Have you tried casting your values to the same datatype?

If CInt(towhom) = CInt(Session("UserID"))...

Ray at work

"Savas Ates" <sa***@indexinteractive.com> wrote in message
news:ue*************@TK2MSFTNGP09.phx.gbl...

i have 3 columns in sql server ..

all of them are numeric value

when a user enter my site i take the value of userid (numeric one) i
assign
it as session("userid ")

after a query i take 2 value (both numeric again) from my table and write
this code

if towhom=session("userid") then towhom=fromwhom

it gives an error .. how can i solve it

Type Mismatch Error

Jul 19 '05 #2

Manohar Kamath

Ray,

Casting into String is the best option, since other cast functions give
errors if the input is not numeric (e.g. empty)

If CStr(towhom) = CStr(Session("UserID")) Then...

--
Manohar Kamath
Editor, .netWire
www.dotnetwire.com
"Ray Costanzo [MVP]" <my first name at lane 34 dot commercial> wrote in
message news:%2****************@TK2MSFTNGP14.phx.gbl...

Have you tried casting your values to the same datatype?

If CInt(towhom) = CInt(Session("UserID"))...

Ray at work

"Savas Ates" <sa***@indexinteractive.com> wrote in message
news:ue*************@TK2MSFTNGP09.phx.gbl...
i have 3 columns in sql server ..

all of them are numeric value

when a user enter my site i take the value of userid (numeric one) i
assign
it as session("userid ")

after a query i take 2 value (both numeric again) from my table and write this code

if towhom=session("userid") then towhom=fromwhom

it gives an error .. how can i solve it

Type Mismatch Error

Jul 19 '05 #3

Ray Costanzo [MVP]

Good point.

Ray at work

"Manohar Kamath" <mk*****@TAKETHISOUTkamath.com> wrote in message
news:e9*************@TK2MSFTNGP11.phx.gbl...

Ray,

Casting into String is the best option, since other cast functions give
errors if the input is not numeric (e.g. empty)

If CStr(towhom) = CStr(Session("UserID")) Then...

Jul 19 '05 #4

Similar topics

Error values returned in query...

by: noname | last post by:

How do I display a "0" instead of it returning "#ERROR" in a query where I have division. Also have negative numbers returned on some values, but want "0" displayed on them also.

Microsoft Access / VBA

Anyway of setting Request.Params type values from javascript?

by: foldface | last post by:

Hi Pardon the vague-ness, I mean the ?name=value stuff in the URL. Can you set this within javascript on a page such that when an asp.net button is clicked then these values are passed as params?...

ASP.NET

Casting return value to fit within constraints of error values (portability)

by: clayne | last post by:

I realize this may work for the majority of platforms. But I am concerned about the aspects of sign extension and portability. Is this portable: { unsigned long bw; if ((signed long)(bw...

C / C++

sqlEx = {"Error converting data type numeric to numeric."}

by: rajmgopal | last post by:

Hello Everyone I am getting the following error when i try to insert a record into Sql Server 2005 from my VB 2005 application. sqlEx = {"Error converting data type numeric to numeric."} I...

Visual Basic .NET

Writing a function that changes an unknown-type numeric variable

by: pozz | last post by:

In my software, there are some variables that represents some settings. They usually are numerical variables: unsigned char (0..255), signed char (-127..128), unsigned int (0..65535), signed int...

C / C++

Functions having same name return different type values in subclasses.

by: syang8 | last post by:

I want to declare a function F() in a class, which has two children A and B. I need A.func() return int and B.func() return double. How can I do that? The F() in parent can be empty or virtual, I...

C / C++

Arithmetic overflow error converting numeric to data type numeric.

by: darrel | last post by:

I'm getting this error: Arithmetic overflow error converting numeric to data type numeric. Triggered on this line of my code: objOleDbAdapter.Fill(DS, "rss") Everything works when this is...

ASP.NET

Arithmetic overflow error converting nvarchar to data type numeric.

by: sonata | last post by:

I am trying to compare two fields which are char data typr. BUT the comparision must be arithemetic in nature. so i tried to cast both the data base field and my parameter field to big int...

Microsoft SQL Server

hex type values

by: =?Utf-8?B?amlt?= | last post by:

If I assign an attribute using property name/value pairs such as where stringVal is a string C# generates the name\value pair using hex values 01 00 01 00 54 0E 09 73 74 72 69 6E 67 56 61 6C 03...

C# / C Sharp

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server