Intresting Problem

Aug 7, 1998

Hello,

(sorry for my english)

I am using ADO.

I am having problem with AppendChunk and Image Field.

When ever I use AppendChunk to update an IMAGE field it stores double of the
size of value.

I mean when I use AppendChunk "ABC" on an image field it stores 6 (SIX )
bytes instead of 3 (THREE) bytes.

But when I use the same on TEXT field it work fine.


Please help me ... I want to store a .WAV file into image field



best regards

Iftikhar

View 1 Replies


ADVERTISEMENT

Intresting Question On Performance Monitor

Nov 2, 2000

Hi Everyone...

I cannot see the all the objects related in SQL SERVER Performance Monitor on one of our SQL SERVER..

The thing is before couple of days when i checked i was able to see all the object of sqlserver in performance monitor..

But for some reason I cant see it now..I am able to see only related to operation system..

Can anyone help me out.. to get back the sql server object in performance monitor..

Help is greatly appericated..

Thanks indeed
jessi..

View 2 Replies View Related

An Intresting Issue And Urgent Response Needed

Mar 15, 2008

I am writting a query to retrive some information about a person from the database, now intresting thing is that the query does'nt find the person who dont have a Last name in the database. i pass on the values which user have entered, the values are FirstName, LastName and EmployID, what ever information is given, its passed to the query and the person should be retrived if the person is logged in but problem is that the query works only if the person have a LastName in the database... this is my query.. please tell me what is wrong and what should i change.... its Urgent guys

SELECT distinct top 22 cfg_person.*,cfg_place.name,login_info.callablenumber,login_info_server.server
FROM cfg_person,cfg_login_info,cfg_agent_login,cfg_switch,login_info,cfg_place, login_info_server

where cfg_person.state='1'
and (cfg_switch.type = 5)
and cfg_person.is_agent=2

and cfg_person.first_name like 'Monique%'
and cfg_person.last_name like '%'
and cfg_person.employee_id like '%'


and cfg_person.dbid=cfg_login_info.person_dbid
and cfg_login_info.agent_login_dbid = cfg_agent_login.dbid
and cfg_agent_login.switch_dbid = cfg_switch.dbid
and login_info.person_dbid = cfg_person.dbid
and login_info.logged_voice=1
and cfg_place.dbid = login_info.place_dbid
and login_info.server_id = login_info_server.id

order by cfg_person.first_name

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved