Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-11-21 : 07:54:05
|
| selva writes "hello well i have a problem , i have a table with (empid int) and the value being passed is within codes , it is something like this sql="insert into indstaff values("& empid &",'"&name&"','"& shermail con.execute(sql)this particular statement is working fine in my system , but when it goes to the server , it gives out an error Microsoft OLE DB Provider for ODBC Drivers error '80040e07' [Microsoft][ODBC SQL Server Driver][SQL Server]Disallowed implicit conversion from datatype 'varchar' to datatype 'int' Table: 'sherston.dbo.indstaff', Column: 'empid' Use the CONVERT function to run this query. /staff/staff/editmem.asp, line 190 please could you please help me in finding a solution to this .thanking you selva" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-11-21 : 08:19:06
|
| I guess your other server is 6.5 or the database is in 6.5 emulation mode.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
sql convertions