Search Results - VBForums

Search:

Type: Posts; User: aconybeare

Page 1 of 13 1 2 3 4

Search: Search took 0.02 seconds.

  1. Re: SQL Server 2008 R2: Check if IP address is in a range

    Hi,

    Think I've got it whipped thanks, converting the IP address into a number (BigInt) -

    I've not done any speed tests on these two methods -

    This one uses PARSENAME to access the octets
    ...
  2. SQL Server 2008 R2: Check if IP address is in a range

    Hi,

    I'm trying to write a SP to check if a passed in IP address is in a range e.g. equal to or between a start and an end address. e.g. -


    Is 10.10.10.5 equal to or between 10.10.10.1 and...
  3. Replies
    2
    Views
    561

    Re: SQL Server 2008 R2: Split function

    szlamany,

    Thanks very much for your pointers I've changed the function as follows although I'm not sure my changes to step along the @List variable are very efficient I'd appreciate it if you...
  4. Replies
    2
    Views
    561

    SQL Server 2008 R2: Split function

    Hi,

    I've been using a UDF split function courtesy of 4GuysFromRolla.com for a few years (2004) but I'm currently working on a project where I need to pass in quite a long list (65+) and I'm...
  5. Replies
    11
    Views
    12,497

    Re: new line in crystal report

    Hi,

    I realise that this is a very old thread but I've had a very similar problem and wanted to add my solution since one hasn't been provided yet -

    If you have "Text Interpretation" set to HTML...
  6. Re: VS2010: Service xml serialization [XmlAttributeAttribute()] is ignored

    Hi,

    I believe that I've fixed this by changing the default serializer. From .Net Framwork 3.0 microsoft changed the default serializer to the DataContract serializer, which is different from the...
  7. [RESOLVED] VS2010: Service xml serialization [XmlAttributeAttribute()] is ignored

    Hi,

    I have a WCF web service targeting .Net Framework 4 which utilizes a serialization class generated from a xsd schema using xsd.exe.

    When I request the xsd from the service...
  8. Re: VS2010: Service xml serialization - xsd schema output

    Hi,

    I've managed to fix this by regenerating my class (xsd.exe) using the f switch "/f[ields]" which generates fields instead of properties. By default, properties are generated.

    ...
  9. [RESOLVED] VS2010: Service xml serialization - xsd schema output

    Hi,

    I've created a WCF web service and generated the xml serialization class with xsd.exe. My problem is that when I request the xsd from the service...
  10. Re: HTML Code that Refers to CommonDialog ActiveX Control

    Hi,

    I realise that this a very old thread. I recently upgraded to windows 7 64bit and no longer have vb6 installed, I've just been on the forum and tried to use the highlight option on the vbforum...
  11. VS 2010 Re: Web service xsd parent element attribute being output as child element?

    Hi,

    Thanks for your reply

    My understanding is that the attribute tag defined within an element will make it an attribute of the parent element.

    http://www.w3schools.com/xsl/el_attribute.asp...
  12. VS 2010 Web service xsd parent element attribute being output as child element?

    Hi,

    I'm trying to write a service but there seems to be something not working with my set up. I've generated the .Net serialization classes from my xsd using xsd.exe, so far so good. When I query...
  13. VS 2010 Re: Development IDE show Start page on toolbar

    Hi,

    Eureka, I've figured it out.

    I changed my development environment from web developer to general and the missing options have magically appeared.


    Tools -> Import and Export...
  14. VS 2010 Re: Development IDE show Start page on toolbar

    Jmcilhinney,

    Hi and thanks for your reply.

    I'm using visual studio 2010 pro. when I do as you suggest the toolbox and start page options are not displayed under the standard toolbar. See the...
  15. VS 2010 [RESOLVED] Development IDE show Start page on toolbar

    Hi,

    I read somewhere that there is a toolbar that contains an item to access the "Start Page" instead of clicking View --> Start Page. I've hunted through the toolbars and can't find it. Does...
  16. Re: SQL2008 R2: String or binary data would be truncated - NVARCHAR(max) LIKE clause

    TechGnome,

    You might have cracked it; I've changed the "like" to "=" and the error has gone away. With SQL2005 or perhaps it was 2000, I was told to use "LIKE" instead of "=" when comparing large...
  17. Re: SQL2008 R2: String or binary data would be truncated - NVARCHAR(max) LIKE clause

    TechGnome,

    Thanks for your reply, I've quadripple checked it and it's a nvarchar(max)


    Body nvarchar(max),

    As a temporary workaround I'm ignoring the changed check if the...
  18. Re: SQL2008 R2: String or binary data would be truncated - NVARCHAR(max) LIKE clause

    Hi Si,

    Thanks for your reply I've tried your suggestion but no luck, I've done a little more testing and it seems that it's not IsNull, I've changed the line to -


    AND Body LIKE @Body

    the...
  19. [RESOLVED] SQL2008 R2: String or binary data would be truncated - NVARCHAR(max) LIKE clause

    Hi,

    I have a stored procedure that checks to see if the passed through data has changed before actually updating the table this works perfectly until the data exceeds 4000 characters despite the...
  20. Re: SQL2005: Simple query performance on column with nulls

    Si,

    Thanks your pointer helped, I changed my variable declaration from -


    DECLARE @Mtg_Id int
    To

    DECLARE @Mtg_Id numeric(18,0)
    it's performing much better now.
  21. Re: SQL2005: Simple query performance on column with nulls

    I've been doing some more testing on this and I've made the following discovery. When I hard code the value of @Mtg_Id the query returns super quick if I use the variable is takes ages?

    Very slow...
  22. SQL2005: Simple query performance on column with nulls

    Hi,

    I'm having performance problems with a query on a table with loads of nulls in a particular column. I've tried changing the nulls to 0 (Zero) and rebuilt the index on the column but it's not...
  23. Re: [RESOLVED] Where to post DOS or Command line question?

    Honeybee,

    Thanks, I've had a quick look I've not been able to find what I'm looking for please forgive me if it's there and I'm not seeing it.

    Here is a link to my post in General PC

    This...
  24. Re: Where to post DOS or Command line question?

    Dilettant; I'm going to have a hunt around for a technet forum to join for any future command line conundrums.

    HoneyBee; I searched on google first but didn't find what I was looking for, which is...
  25. Re: For Loop file filter in a .bat or .cmd file

    Hack,

    Snap you suggested pretty much what I've managed to figure out. I must have started typing out my reply just before you posted yours.

    Many thanks

    Cheers Al
  26. Re: For Loop file filter in a .bat or .cmd file

    As a workaround I've applied the following which works but I was hoping for a cleaner solution.



    SET counter=0
    FOR /r "e:\test\myfiles\" %%X IN (*.jpg) DO (set /a counter+=1)
    FOR /r...
  27. [RESOLVED] For Loop file filter in a .bat or .cmd file

    Hi,

    I'm not sure if this is the best place to post this question so please forgive me if it's not.

    I've got a for loop in a batch file that loops ".jpg" files and I'd like to change it to find...
  28. Re: Where to post DOS or Command line question?

    Hi,

    Thanks for all your replies.

    Yes I'm talking about batch files .bat or .cmd

    TheBigB: Thanks I'll try posting it there.

    Cheers Al
  29. [RESOLVED] Where to post DOS or Command line question?

    Hi,

    I have a question about using a For Loop in a cmd file can anyone advise me which forum would be best to post it in?

    Cheers Al
  30. Replies
    9
    Views
    14,614

    Re: Proper Case In VbScript

    BaileyPhil,

    You call it like this -

    Dim sMyLCName: sMyLCName="o'connor"
    Dim sMyPCName: sMyPCName=""

    ' ProperCase(sText)
    sMyPCName=ProperCase(sMyLCName)
  31. Replies
    6
    Views
    1,239

    VS 2005 Re: Execute bat/cmd with a different user

    Stanav,

    Thanks for the pointer.

    I've logged into the server and run it as you suggested but it's not executing. Password is okay because I deliberately put in an incorrect password and it...
  32. Replies
    6
    Views
    1,239

    VS 2005 Re: Execute bat/cmd with a different user

    Thanks for your replies

    Stanav; Nice idea, do you know how to access the RunAs command, I'm using a win 2003 server for this. The secondary logon service is running but when I right click or shift...
  33. Replies
    6
    Views
    1,239

    VS 2005 Execute bat/cmd with a different user

    Hi,

    I'm trying to execute a cmd file with a different user but what I have isn't working the log in returns true but the command doesn't run


    Dim iu As New ImpersonateUser
    ' Note: This user...
  34. Re: SQLCMD: call SP add param as contents of a file

    Think I've got it, however it's not going to work for me because newlines are replaced with slashes "/". I can't be sure that if I replace the slashes in my SP with newlines that I won't removing...
  35. SQLCMD: call SP add param as contents of a file

    Hi,

    I'd like to use SQLCMD to update my database. I've created a SP and am now trying to figure out how to supply one of the parameters as a variable/contents of a file, is this possible?

    I'm...
  36. Re: Regex: Find ampersands but ignore HTML entities

    Samba,

    Thanks for your reply, yes I guess that's an option but I was looking for something a little more bullet proof.

    An option might be to surround any fields that might contain non-standard...
  37. Regex: Find ampersands but ignore HTML entities

    Hi,

    I'm trying to write/find a regular expression for finding ampersands but not HTML entites

    I have this which finds entities but can't quite figure out how to ignore entities and return...
  38. Re: SQL Server 2005: Create view with unique numeric column

    Perfect thanks
  39. [RESOLVED] SQL Server 2005: Create view with unique numeric column

    Hi,

    I need to set up full text searching on a table with a non-numeric composite primary key. When I try to do this I get an error saying it requires a unique index, despite the fact that the...
  40. Re: SQL Server '05: Query Browser Usage stats

    KevChadders and NeedSomeAnswers,

    Thanks for your replies, both helped me come up with a solution: Use a derived table -


    SELECT b.Browser, b.Browser_Major_Ver, COUNT(*) AS Usage_Count
    FROM (...
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.