Search Results - VBForums

Search:

Type: Posts; User: sapator

Page 1 of 13 1 2 3 4

Search: Search took 0.11 seconds.

  1. Replies
    11
    Views
    438

    Re: IE11 Incorrectly Rendering HTML5 Tags

    Yeah but the issue here is that we are going to start site maintenance doing browser specific stuff. I think we have talk about that in a specific thread.
    Of course doing one browser detect seems...
  2. Replies
    11
    Views
    438

    Re: IE11 Incorrectly Rendering HTML5 Tags

    Yeah with compatibility you win some and you loose some.
    I read that MS is going to create an entirely new IE .
    That is bad news and bad news.
    The bad news is that, probably, nothing will (again)...
  3. Replies
    9
    Views
    234

    Re: How to write and run ANY query in MySql?

    SQL Express Database engine and SQL express Management studio should be the minimum requirements.
  4. Re: Running a SPROC with recompile will ignore it?

    So after the maintenance plan addition the job runs in 54minutes instead of 1 hour and 14 minutes.
    That is good new.
  5. Re: Running a SPROC with recompile will ignore it?

    Hey.
    Manually running makes the difference but running from a job does not.
    I can't run this all the time as it's an 1 hour job that is impacting the data that is brought to a SAP system sub...
  6. Re: Running a SPROC with recompile will ignore it?

    It's not very easy to find the bottleneck. I believe this takes time because the db is huge, there is a lot of necessary left joins(this is support company specific so i cannot do much) and the job...
  7. Re: Running a SPROC with recompile will ignore it?

    Ok. When you come abroad then i will take you to the company and see the horror with your own eyes! :D
    Actually i don't want to use recompile, alegently, everything in the db's (i was told) does an...
  8. Running a SPROC with recompile will ignore it?

    Hi.
    I am running a SPROC like this exec mysproc WITH RECOMPILE;
    This will take 2 minutes.
    Without WITH RECOMPILE it takes 10 minutes.
    After that i put it on a job (the sprocs runs on the same...
  9. Re: Very strange time difference in 2 sprocs run through another sproc.

    Well the specific SPROC has been deprecated, I only use it for performance checks between different SQL Servers.
    I was hoping that the sp_updatestats will do the option recompile dirty job without...
  10. Re: Very strange time difference in 2 sprocs run through another sproc.

    I am bringing this up again.
    So for you not to have to read, a quick sum.
    I have a sproc, essentially-probably all sprocs that run faster in one server than the other (a lot faster, i mean 1second...
  11. Replies
    3
    Views
    127

    Re: Remove spaces from string.

    Hey,
    This will do nicely "theNewText = Regex.Replace(theOldText, "\r\n *\r\n", vbNewLine)"
    No i don't need to remove the other spaces, I'm fine as i put this on a datatable.
    Actually there is no...
  12. Replies
    3
    Views
    127

    Remove spaces from string.

    Hi.


    <?xml version="1.0" encoding="ISO-8859-7" ?><returnorder xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
    ...
  13. Replies
    5
    Views
    263

    Re: complete asp web database sql server

    Have a look here:
    https://code.msdn.microsoft.com/site/search?f[0].Type=Topic&f[0].Value=ASP.NET%20Code%20Sample%20Downloads
    Having posted that, i would suggest after you see the examples you give...
  14. Re: Calling Sql Server store procedure WITHOUT asp.net or any Server Scripting langua

    Am not sure if SQL supports a direct data retrieve, by hitting SQL port and specify some arguments.Maybe with BizTalk Server? But haven't touched that subject so i may be talking rubbish.Else the...
  15. Replies
    11
    Views
    593

    Re: [RESOLVED] Return Data As JSON

    Btw it is not simple old style. PHP is using this and PHP is A LOT LARGER in websites that ASP.NET.
    I am only using asp.net because i know how to write the database manips etc as a backbone in the...
  16. Replies
    11
    Views
    593

    Re: Return Data As JSON

    Be advised that also that a lot depend on the web service to call. What you are using (as i see it on your code) is a simple, lovable good ol' web service.
    you can also use WCF or WEB API. If i can...
  17. Replies
    11
    Views
    593

    Re: Return Data As JSON

    Yes.
  18. Re: Getting correct values from class but cannot check breakpoint

    I am using it in order to pass the connection to the entire application, Private sub was just forgotten and left there.
    I got the value yesterday when i open the PC. One time and then it was like...
  19. Replies
    11
    Views
    593

    Re: Return Data As JSON

    Haven't been doing Javascript for some time now due to a very tight job schedule but i am pretty sure you should correct this: dataType: "jsondata" with this: dataType: "json"
    Also use plain...
  20. Re: Getting correct values from class but cannot check breakpoint

    I call the class from another application that calls my main WCF classes but even before any sub init from my main classes i can get the value if i do ? GlobalConnections.strconVrExternal from...
  21. Getting correct values from class but cannot check breakpoint

    Hi. I have this class that default to a connection string.


    #Region "connectionstrings"
    Public NotInheritable Class GlobalConnections
    Private Sub New()
    End Sub
    Shared Sub...
  22. Re: private property of list of string will also display on calling object

    <DataMember()>
    Private m_seats As List(Of String)

    Solved. I've wrongly set it as datamember. Super blind mode on!
  23. Re: private property of list of string will also display on calling object

    I've set this as Protected Friend m_seats As List(Of String)
    but i still don't understand why it will show in the first place.
    Any opinions?

    EDIT! Nop it will still show!
  24. [RESOLVED] private property of list of string will also display on calling object

    Hi.


    <DataContract(), KnownType(GetType(List(Of String))), XmlSerializerFormat()>
    <Serializable()>
    Public Class setorder
    '.......
    <DataMember()>
    Public Property seats As...
  25. Replies
    17
    Views
    492

    Re: trying to get rid of in a query

    Actually using select will bring 4 null columns! Suppose something is wrong here.
    Guys, let it go. I have reduced the job latency of the query and i think this has taken more than it's worth looking...
  26. Replies
    17
    Views
    492

    Re: trying to get rid of in a query

    Yes it is a column name on table movie. I don't know, it works.
    The table is strange but here:


    USE [VT_External]
    GO

    /****** Object: Table [dbo].[MOVIE] Script Date: 16/2/2015 3:50:03 μμ...
  27. Replies
    17
    Views
    492

    Re: trying to get rid of in a query

    It will compare the id of prm_code and see if there are any same id's in Mov_director. But the run time is the same so, bleh!
    11200 lines in the table. It's not so big, if i remove the <> comparison...
  28. Replies
    17
    Views
    492

    Re: trying to get rid of in a query

    Hi.
    First this is not my query. So i am not responsible for alias but as i see it the alias are there until the author did not use them in the where. Maybe he was trying to get the initial results?...
  29. Replies
    17
    Views
    492

    Re: trying to get rid of in a query

    Well the initial question was if there is a way to do an not equal comparison without using the "<>".
    Apparently all the joins confused everyone. If there not an easy way i guess i will have to go...
  30. Replies
    17
    Views
    492

    Re: trying to get rid of in a query

    The right part anyhow, is because some codes are 12 chars and we need the first 6 and the trim is because of first and last name merger that (you've guessed it) join with the description table that...
  31. Replies
    17
    Views
    492

    Re: trying to get rid of in a query

    Unfortunately i cannot change anything on the design. I can only add parametric tables. The company is having a contract with an international firm and they can change the DB's and Applications in...
  32. Replies
    17
    Views
    492

    Re: trying to get rid of in a query

    Also trying like this


    select *
    FROM VEXTERNAL.dbo.MOVIE M
    RIGHT JOIN (SELECT Film_strCode,MAX(Person_strCode) as Person_strCode FROM VISTAHO.dbo.tblFilmPerson WHERE FPerson_strType='D' GROUP...
  33. Replies
    17
    Views
    492

    Re: trying to get rid of in a query

    Trying this but i get no results.

    WHERE (NOT EXISTS(select prm_code from movie inner join parametric on movie.mov_director = parametric.prm_code)
  34. Replies
    2
    Views
    195

    Re: greek character issue in xml

    Yep that did it.
    Thanks!
  35. Replies
    2
    Views
    195

    [RESOLVED] greek character issue in xml

    using this:


    <?xml version="1.0" encoding="utf-8" ?>
    <returnorder xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
    ...
  36. Replies
    17
    Views
    492

    trying to get rid of in a query

    select *
    FROM VTEXTERNAL.dbo.MOVIE M
    RIGHT JOIN (SELECT Film_strCode,MAX(Person_strCode) as Person_strCode FROM VISTAHO.dbo.tblFilmPerson WHERE FPerson_strType='D' GROUP BY Film_strCode) FP
    ON...
  37. Replies
    2
    Views
    146

    Re: create xml and xml schema

    Alright.
    Thanks.
  38. Replies
    2
    Views
    146

    [RESOLVED] create xml and xml schema

    Hi i am goggling around and all i can find is either create xml and either schema.
    Is it possible to do both and merge to an xml document?
    I suppose i can do it manually (yuck!) but i was looking...
  39. Re: How to pass value between classes.

    Well as i couldn't figure something out, i changed the transport security to use Certificate and not Username Password. That way i don't need the extra class as the Cert will take over and i could...
  40. Re: Unable to cast object of type 'System.Collections.Generic.List`1[System.String]'

    Actually, this does the trick as shown in the OP :


    <DataContract(), KnownType(GetType(List(Of String))), XmlSerializerFormat()>

    After that everything seems to fall into place and i don't...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.