Search results for query: *

Hi all, I am trying to export from sql table to excel in SSIS there is an IMEI column in SQL containing data like 123456789123456. When I export to excel the data is displayed as 1.23E+14. If I format in excel the cell to number and 0 decimals I get the 123456789123456 back. My question is what...

Hi all, I am trying to produce an XML to a web service from the result of an sql query..I am very close with below but when I run the asp.net page I get a blank page. Can someone help me. Do I need to use a dataset? Query does return data in sql. I want the final result to produce...

Hiya , and thx for the reply. Just to confirm that you are using Symposium EXPRESS ? The only Option I have under system administration is "Backup". There may be a higher login required. So you are using EXPRESS ?

Hiya and thx for the reply.. Yes I had a fealing that this was the case.. You say you do not have the documentation to check. Can you tell me which documentation can confirm this.. I may have some angry managers that I need to prove this too.. I also noticed that the Sym Express documnetation...

Hi all, I am using Symposium Express Call Centre When I run the report Agent by Skillset Performace for last month I get no data returned. If I run this for last week I do get data returned. apparently "The number of days storage for different report types is defined under ....Historic...

Thx for the reply but I finally got an answer to this. I have Symposium Express installed... In the User guide for SE there is a Note: Call By Call reports are NOT availiable with Symposium Express Call Center.. So unless I have the Full Symposium I can not do this :( Ray..

Hi all, I an trying to get CLID of abandoned calls.. Apparently the tables in symposium that will give me the info are ecallbycallstat. However when I link to these tables through Crstal reports or SQL server the tables are EMPTY? Do I need to get this switch on somewhere ? Thx, Ray..

Hi all, I use sql server 2005 with a linked server to Pervasive. Using ODBC Pervasive version 10. My Problem is that there is a date field in Pervasive that can contain the value 00/00/0000. When I run and open query sql runs ok until it hots one of these dates.The I get the error "Conversion...

Hi all, I use sql server 2005 with a linked server to Btrieve. My Problem is that there is a date field in BTrieve that can contain the value 00/00/0000. When I run and open query sql runs ok until it hots one of these dates.The I get the error "Conversion failed because the data value...

Hi all, Just to let you know. I got it working. In SQL its WHERE MMITNO =@MMITNO IN db2 its WHERE MMITNO = ? Thx, Ray..

Hi all, Sorry if this is the wrong place to ask but I have tried a few places with no joy. In SQL when querying using a variable I can use @ symbol. ie: SELECT COUNT(*) FROM dbo.Persons WHERE SocialSecurityNumber = @SocialSecurityNumber Then in say visual web developer this would prompt me to...

Hi all, I am trying to do a mailmerge in office 2000 from an excel spread sheet that contains the list of addresses. Some addresses in the excel sheet are in say the russian language. eg: "?????????? ???????, ?.??????" Excel shows the address no probs but when I do a mailmerge in word the adress...

Hi all, I need to validate some CSV files.They exist in a local folder and can have any name. eg: eir102.csv, eir103.csv I want to check for any csv files in a folder and validate..IF Validation ok then save to good folder IF Fail then save to bad folder. Anyone know a good example of reading...

Hiya , the Date returned is 2007-11-15 00:00:00.000 how can I strip this down to just 2007-11-15 ? Thx, Ray..

Hi all, I am trying to do something that sounds easy but in fact is turning out to be very difficult. I am trying to return data in DB2 where a field MTTRDT is equal to the current date..I know in DB2 I can use WHERE DB2 = CURRENT DATE........However my problem is that my MTTRDT field is not in...

Hi all, Can someone please help. I am trying to upload a pdf 1MB to Sharepoint server 2001. The green progress bar stops half way and the the page cannot be displayed appears. What I have noticed is that this upload is ok if I use an old version of internet explorer?As soon as I click upload in...

Hi All , Just to let you know i sorted the problem by >1. enable netbios over tcp / ip (do this on the dial up connection >under networking / tcp ip / wins >2 enable client for Microsoft networks on the dial up connection.

Hi all, I can connect remotely using a dialup connection to our internal network using checkpoint secure remote. When logged in I can go to a windows 2003 server via start run \\server2003 and all the shares come up. However if I try the same with a windows NT server eg: \\servernt then I get...

Hi all, Win2003 is giving me terrible trouble with permissions accees to websites on the server. From reading up on this I need to Give permission on my sites to the group IIS_WPG which SHOULD contain the Network Service account.. However my IIS_WPG has NO members and when I try to add network...

Hiya, Thx for the reply, My curent setup is as follows. I have an SQL 2000 DB ( SQL setup as SQL Server and Windows ).. I have a user name and password setup in the connection string .. I am tryin to create a login page using Visual web But I still get this error..Without using a login page I...