hi,
I have taken a value from column which is of varchar type, and want to insert this value into another column which is of numeric type.
It is showing error.. how can i solve this..please help me out.
The code is :--
<%
Dim conn,productprice
Dim sql
Dim rs,rs1
transactionId=loginname+"01"
set conn = server.createobject("ADODB.Connection")
conn.open "Provider=SQLOLEDB;DATA SOURCE=RAJNEESHR;UID=sa;DATABASE=shop"
set rs1=Server.CreateObject("ADODB.Recordset")
set rs = Server.CreateObject("ADODB.Recordset")

sql="select Product_id,P_name,loginname,P_price from productInfo group by loginname,Product_id,P_name,P_price having loginname='"&loginname&"'"


rs.Open sql, conn

 DO WHILE NOT rs.EOF
productprice=rs("P_price")

' Here rs("P_price") is varchar

sqlInsert="insert into transactions(Transaction_Id,Transaction_Amout,Tran saction_Date,Product_Name,Status,Email) values ('"& transactionId &"', '& productprice &' ,'"&Date&"','"&rs("Product_id")&"','Shipped','"&lo ginname&"')"

conn.execute sqlInsert

rs.MoveNext
Loop
%>

Dhiraj

If data in the p_price field is non numeric for any one record and you try to insert this data in second table, you will get error.

Before inserting the data check whether it is numeric or not.

Example:

if isnumeric(productprice) then
    sqlInsert="insert into ..."
    conn.execute sqlInsert
end if

Om Prakash

the column of that table is varchar, but they have stored number in it. The field name is price and datatype is varchar. so how can i do.

Dhiraj

In this case above code should work

Om Prakash