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 Chriss Miller 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: *

  • Users: woogoo
  • Content: Threads
  • Order by date
  1. woogoo

    Using ISO Schematron in a Java Application

    Hello. Can anyone tell me how to validate an XML file using an ISO Schematron (.sch) file from within a Java application? I want to be able to validate an XML file (provided by the User) against my .sch file. But to be honest I don't really know where to start, so I would really appreciate your...
    • woogoo
    • Thread
    • Replies: 3
    • Forum: Java
  2. woogoo

    Check Constraint

    Hi, I want to add a check constraint that will allow a column to contain either A, A3, A4 or A5. At present I've written it as Col = 'A' OR Col='A3' ... but I was hoping to use something like Col='A|A[3-5]' but this doesn't appear to work. Any suggestions? woogoo
  3. woogoo

    CASE Statement

    Hi All, I want to create this Trigger: CREATE TRIGGER [dbo].[TR_Info_Insertion] ON [dbo].[Information] FOR INSERT AS BEGIN CASE Inserted.VarType WHEN 'EB' THEN Inserted.EB = Inserted.Price WHEN 'ES' THEN Inserted.ES = Inserted.Price END END ; But when parsed I get an error: Msg 156...
  4. woogoo

    Return value from dynamic SQL

    Given this: CREATE FUNCTION [dbo].[GetCSVExpectedF] ( @Table nvarchar(32), @Type char(1) ) RETURNS datetime AS BEGIN DECLARE @ID bigint ; DECLARE @Ref nvarchar(32) ; DECLARE @Result datetime ; DECLARE @Query nvarchar(1024) ; SELECT @ref = Reference FROM CSV_LookUp WHERE ((FileName =...
  5. woogoo

    TraceEventType Icons

    Hi All, I have a log file that contains various TraceEvents and I would like to include the appropriate Icon when displayed in the log file viewer (a ListView with a smallImageList). I'm looking for icons such as Stop, Start, Critical, Information etc. But I need to get these icons in the first...
  6. woogoo

    Finding the CHARINDEX of last occurrance.

    Hi All, I need to find the charindex() of the last occurrance of a character within string, but this is proving awkward to solve can anyone help here? -- woogoo
  7. woogoo

    XPath Question

    Hi All, I have been given a file in the following format: <ItemInformation xmlns="http://tempuri.org/ItemInfo.xsd"> <ItemDetails> <Title>This is the item title</Title> <State>This is the item state</State> <ItemCost ... /> <ItemCost ... /> <ReOrder>...
    • woogoo
    • Thread
    • Replies: 1
    • Forum: XML
  8. woogoo

    Parallel Transaction Woes

    Hi All, Is it (really) possible to implement true parallel transacions using VB.NET (v3.5 and 2008) and SQL Server 2005? I've tried various attempts at this but nothing seems to work. In my code I start up 10 instances of a SQLConnection using this connection string: ... m_Connections.Add(New...
  9. woogoo

    Parallel Transaction

    A simple question does SQL Server 2005 support true parallel transactions via a third party application? If it does are there any settings that need to be done in order to implement this, and if so what are they? Thanks. woogoo
  10. woogoo

    Using INFORMATION_SCHEMA Views

    Hi, I've created a (SQL Auth) Login and User details for an application I am writing, this application needs access to the INFORMATION_SCHEMA views. But whenever I try to grant SELECT permissions I get told: Cannot find the user 'DSSelector', because it does not exist or you do not have...
  11. woogoo

    Disposing of Objects from a Generic.List(Of ...)

    Hi, I have an Generic.List(Of MyObjects) these Objects implement IDisposable and as a result I want to clean up on exit. Regardless of how I attack this I get an error when trying this (or similar): Protected Overrides Sub OnStop() ' Service is stopping so clean up. Dim...
  12. woogoo

    Trigger Question

    Hi, I want to write a trigger that will ensure that values entered or updated into a series of columns are monotonic. But I can't seem to access the current column values! Under SQL Server 2005 I thought the syntax was Inserted., Deleted. etc., but no. Can someone tell me what it is as there...
  13. woogoo

    Ranking 10 Columns down to 2.

    Mmmm, maybe not the best title for the problem but here is what I've got : SELECT Item, I1, V1, I2, V2, I3, V3, I4, V4, I5, V5 FROM MyTable ; Simple, however I now want to return only One set of Items (I) and one set of Prices (P) from the above result set ordered on P ASC. ROW 1 Item A, 0...
  14. woogoo

    Disk Fragmentation

    Hi, is it possible using VB / .NET 3.5 to check a disk's level of fragmentation? If so, can someone point me in the right direction. Thanks. woogoo
  15. woogoo

    Parallel SQL Transactions

    Hi, Using a single SQLConnection object, 4 SQLCommand objects and 4 BackgroundWorkers I'm trying to execute 4 Parallel Transactions on a SQL Server database. Regardless of how I set the MultipleActiveResultSets property on the Connection object's connection string I always get an error saying...
  16. woogoo

    Declare Function Question

    Hi All, In one of my applications I use a 3rd Party DLL that uses the 'Declare Function' statement for importing the DLLs functions, but my problem lies in the fact that I need to support two versions of the DLL. At present with the exception of the DLL's name the Declare statements are...
  17. woogoo

    FileStream gaining bytes.

    Hi, This is what I'm doing: Opening a file and reading it into a byte array. GZipping the byte array to a RW FileStream. Reading the GZipped Stream into a new byte array and 3DES encoding it. Writing this new byte array back to the RW Stream. Having written the file, if you then...
  18. woogoo

    Docking a Form in a Panel

    Hi, is it possible to dock a borderless form within a panel, I've had various attempts at this but with no success. Any help would be appreciated. -- woogoo
  19. woogoo

    Icon required.

    Hi all, this is a bit off topic but I'm looking for an Icon (.ico) of a PFX (Personal Information Exchange) file. I could extract it from a DLL but I don't know where to find it, can anyone help me out please. -- woogoo
  20. woogoo

    (Simple!) XPath Text Comparison

    Hi, I'm scratching my head over this (I assume trivial) task. I want to skip outputing a table within my HTML transformation, when a given elements value is "no" (well ideally ignoring case). I've tried several variations from <xsl:if test="ELF = 'Yes'"> to using fn:match(..., ...) but some...
    • woogoo
    • Thread
    • Replies: 2
    • Forum: XML

Part and Inventory Search

Back
Top