Hello,



I am using an SQL server 7 dbase to store a comma seperated value in one 

of the tables. When I do this via an ASP page the value is stored as an 

integer. E.g. I want to store the value 5.1, SQL server stores it as 51.



The same problem occurs when I do this directly in SQL server (so without 

ASP code).



Any ideas?



Kind regards

Stefan

> I am using an SQL server 7 dbase to store a comma seperated value in one

> of the tables. When I do this via an ASP page the value is stored as an

> integer. E.g. I want to store the value 5.1, SQL server stores it as 51.

>

> The same problem occurs when I do this directly in SQL server (so without

> ASP code).

>

> Any ideas?



Hello Stefan,



adding a non-nummeric char in the value should solve the problem. the

question is if it isn't too much work to delete this char by an ASP program.

It seems very strange for me, because this error occures directly by SQL

server, too. I could have understood if ASP doesn't interprete the value

very well, but SQL server should.

Try once to separate it otherwise.



Sorry, I can't help you more.



Philipp.

Put it in quotes.

Make sure that the datatype of the column is varchar(),nvarchar(),etc.





----- Original Message -----

From: "Stefan Rijkaart van Cappellen" <stefanrvc@h...>

To: "ASP Databases" <asp_databases@p...>

Sent: Saturday, August 25, 2001 8:17 PM

Subject: [asp_databases] Problem inserting a comma seperated value in SQL

server with ASP





> Hello,

>

> I am using an SQL server 7 dbase to store a comma seperated value in one

> of the tables. When I do this via an ASP page the value is stored as an

> integer. E.g. I want to store the value 5.1, SQL server stores it as 51.

>

> The same problem occurs when I do this directly in SQL server (so without

> ASP code).

>

> Any ideas?

>

> Kind regards

> Stefan

>