Search results for query: *

thanks for responding juxvp, We are currently running a CA cert, its never really caused us an issue apart from this. I am not 100% on the dynamics of exchange but I have looked into the cert and I have added IIS through the power shell. If i list my certs under my live cert i have services...

Hi All, I have been trying to setup windows phone 7.5 (now 7.8) on our exchange for ages but with no success, the guy who originally setup the exchange server / firewall got it working for iphone but neglected to put the time into getting it working for WP. For a couple of years i have just...

Hi all, Bit of a long story but here goes. I took on my current position (2+ years ago) and at the time we had a contracted network guru (possibly) and were in the process of moving over to fibre. Along with many other network upgrades we needed to implement and move over to the ASA 5505...

Do you have permission or have you set permission to INSERT into the linked server table? daveJam easy come, easy go!!!

is the customerID going to be the same internally and externally... if not, this is the problem. When creating the customer records to the external source you need some kind of link back to the original data... such as passing the ID to a field such as intRef... this way you can have a link to...

You could just pass null values for the criteria that you don't want ie. select field from table where field1 = isnull(@Var1,field1) so if it does not have criteria passed it just says where it is the same as itself!! daveJam easy come, easy go!!!

Cheers, cracked it... I was having to find items that have the search terms in any part of the description which made it all a little harder so did it in a few steps -- 1. get the search items into a table variable DECLARE @GetSearch TABLE ( srcWord nvarchar(50) ) INSERT INTO @GETSEARCH...

that looks interesting makros... i will look into this, i think i may have had an issue with table variables in select statements but i think that may have been from an exec build which is obviously what i am trying to avoid... i will let you know how i get on!! daveJam easy come, easy go!!!

Depends on how you want to display the data, you could always use case to bring the details as columns FOR EXAMPLE select ACCOUNT, sum(case WHEN trxDate >= convert(datetime,'01/07/2011',103) AND trxDate < convert(datetime,'01/08/2011',103) then trxAmount end )as Period01, sum(case WHEN trxDate...

Hi all, I am writing a webpage that has a search that simply builds the search with entered words. I have compiled this so pipe symbols are between the search words. I then want to submit this to a sproc to then bring back the data. Is there a way to write an inline query for each of these...

thinking about it, i don't think mid works with sql, think you have to use substring. dim sql as date sql = "select ...." would bring up an error. I would test the query directly against sql with the sql server management studio until you get what you need, then move it into your vb.net...

if i step the code and paste into paint after every sp.copy it pastes the expected image, so its not how it is picking up the images, yet it is not picking it up from the clipboard.containsimageif in the process i copy some text to clipboard (ctrl+C) and test with If clipboard.containstext...

if i step the code and paste into paint after every sp.copy it pastes the expected image, yet it is not picking it up from the clipboard.containsimage if in the process i copy some text to clipboard (ctrl+C) and test with If clipboard.containstext then it picks this up. if, whilst stepping in...

if i step the code and paste into paint after every sp.copy it pastes the expected image, yet it is not picking it up from the clipboard.containsimage if in the process i copy some text to clipboard (ctrl+C) and test with If clipboard.containstext then it picks this up. if, whilst stepping in...

cheers, changed to xlApp = New excel.Application but nothing is changed when it scrolls through MsgBox(sp.Name) it displays the name of each imnage in this test case being Image11 through 16! so this would suggest its finding everything properly but its when its playing with the clipboard...

thats great but not sure if i'm missing something, when it gets to If Clipboard.ContainsImage Then it picks up nothing! i've got code as follows Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim xlApp As Excel.Application...

you could try a convert on that Select Date, Time, convert(datetime,(mid([Date],5,2) & "/" & Mid([Date],7,2) & "/" & Left([Date],4)) & " " & (Left([Time],2) & ":" & Mid([Time],3,2)),131) AS DateTime From Table convert code 131 formats to dd/mm/yy hh:mi:ss:mmmAM so hopefully should not give a...

Thats a great help, thats the error checking on the number of images sorted for me. My problem is i don't know what to do with the item once i have reference to it, simply trying to put it in an image variable doesn't want to work. How do i work with the sp.copy once i have it as none of the...

i guess a starting point would be to find out the date of the first friday of the year... to do that i guess you could work out which day the first of jan was in that year and add the differing days then to find the date for the week and year you want you simply do a dateadd for the number of...

Hi all, one of my colleagues has built hundreds of product specs including images in spreadsheets. Unfortunately this is seperate to our system and of no use to what we are trying to do!!! I have managed to programatically open the file and get the data out of the cells (luckilly the files...