Hello.
It is the first time that Im using IMAGE field type..
I created a stored procedure that should return an IMAGE field back to a
c-sharp program .
(@.OutImg IMAGE declared as an output parameter of the procedure.)
(Select @.OutImg = ImgFld from table)
Well,I can compile it , but when execute i get this error :
Msg 2739, Level 16, State 1, Line 14
The text, ntext, and image data types are invalid for local variable.
Is there something I can do ,OR should I use any cast/convert func to solve it ..?
Many thanks.:ofrom 2005 BOL:
text, ntext, and image parameters cannot be used as OUTPUT parameters, unless the procedure is a CLR procedure.
So you'll have to return this in a record set, not in an OUT param.
Showing posts with label image. Show all posts
Showing posts with label image. Show all posts
Monday, March 26, 2012
Sunday, February 26, 2012
error comming at insert stmt
assume connection is established and photo cloumn as data type as image in sql table.
str_insert ="INSERT INTO SIS_TeachingStaff VALUES('TSMT2','V.RAJANIKANTH','LECTURER','TEACHING STAFF','Msc(Maths)','" & Emp_pic.Image &"' "
cmd =New SqlCommand(str_insert, conn)
cmd.Connection = conn
cmd.ExecuteNonQuery()
Error at insert stmt: Operator '&' is not defined for types 'string' and 'system.drawing.image'
Hi
")" is missed at the end .Try this:
str_insert ="INSERT INTO SIS_TeachingStaff VALUES('TSMT2','V.RAJANIKANTH','LECTURER','TEACHING STAFF','Msc(Maths)','" & Emp_pic.Image &"') "
Labels:
assume,
cloumn,
comming,
connection,
database,
error,
established,
image,
insert,
microsoft,
mysql,
oracle,
photo,
server,
sis_teachingstaff,
sql,
stmt,
str_insert,
table,
type
Subscribe to:
Posts (Atom)