Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. davejam

    WIN8 Phone OWA to exchange 2007 - cert issue

    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...
  2. davejam

    WIN8 Phone OWA to exchange 2007 - cert issue

    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...
  3. davejam

    ASA 5505 - windows client access to VPN

    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...
  4. davejam

    Insert Statement not working

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

    INSERT and UPDATE same record to new database

    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...
  6. davejam

    sp_executeSQL - Avoid Injection risk?

    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!!!
  7. davejam

    where clause from split string search

    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...
  8. davejam

    where clause from split string search

    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!!!
  9. davejam

    Fill in with $0 balance when period has no records

    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...
  10. davejam

    where clause from split string search

    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...
  11. davejam

    Converting Text in a Database to Date/Time fromat

    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...
  12. davejam

    get image from excel

    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...
  13. davejam

    get image from excel

    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...
  14. davejam

    get image from excel

    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...
  15. davejam

    get image from excel

    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...
  16. davejam

    get image from excel

    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...
  17. davejam

    Converting Text in a Database to Date/Time fromat

    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...
  18. davejam

    get image from excel

    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...
  19. davejam

    Convert Week number and year to date

    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...
  20. davejam

    get image from excel

    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...

Part and Inventory Search

Back
Top