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

  1. nwruiz

    SourceSafe Internet & Windows Integrated Authentication

    Hello, I was hoping that someone could help get me started with configuring my instance of SourceSafe to allow remote access via HTTPS. I went into the SourceSafe admin tool and created a user account and password (other than the admin) and also added the web services, etc. to my Default...
  2. nwruiz

    XSD defining element whose text matches a pattern and has attributes

    I am attempting to define an attribute within my XSD that can represent something like the following: <EnrollmentNumber alias="Account Number">0013423521</EnrollmentNumber> This almost does the trick: <xs:element name="EnrollmentNumber"> <xs:complexType> <xs:simpleContent>...
    • nwruiz
    • Thread
    • Replies: 1
    • Forum: XML
  3. nwruiz

    ADO.NET convert string to strongly typed XML class

    Imports PPL.PPLSolutions.Billing.BackingSheets Public Class XmlTest Public Sub Main(ByVal args() As String) Dim myInvoiceSummary As New Mailer.ROWSET() Dim myXml As String = "<?xml version=""1.0"" encoding=""utf-8""?>" & vbNewLine & _ " <ROWSET...
  4. nwruiz

    ADO.NET convert string to strongly typed XML class

    Hello, I am retrieving an XML document stored as a string from an Oracle stored procedure (XML was generated through a PL/SQL query): <ROWSET> <ROW> <KY_PND_SEQ_TRANS>100000</KY_PND_SEQ_TRANS> <KY_BA_LEAD_ZEROS>000000009</KY_BA_LEAD_ZEROS> <DT_PERIOD_START>28-Jun-2007</DT_PERIOD_START>...
  5. nwruiz

    Loading Oracle table schema information into DataTable.

    Hello, I would like to use System.Data.OracleClient to load a table's schema information into a DataTable object. I would essentially like to use the information from a "DESCRIBE TABLE" query to define the types within my DataTable. How would I go about doing this? Is OracleClient sufficient...
  6. nwruiz

    Get bin directory from an ASP.NET web service (GetExecutingAssembly)

    Hello, I would like to locate the bin directory of the executing assembly of an ASP.NET web service during runtime. Normally, with console and windows applications, I could simply use Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly.Location) However, when debugging my...
  7. nwruiz

    XSD validation - choose between an attributeGroup

    Ah, type inheritance...got it. Much like an interface in object-oriented language. Thanks to you, the XSD is now valid. Nick Ruiz
  8. nwruiz

    XSD validation - choose between an attributeGroup

    So, instead of being able to define the schema as this: <xs:element name="Column"> <xs:complexType> <xs:choice> <xs:group ref="Text" /> <xs:group ref="Number" /> <!-- <xs:attribute name="value" type="xs:date"/> --> </xs:choice> <xs:attribute name="name" type="xs:string"...
  9. nwruiz

    XSD validation - choose between an attributeGroup

    FYI...my schema header is defined as <?xml version="1.0" encoding="utf-8" ?> <xs:schema targetNamespace="http://tempuri.org/XMLSchema.xsd" elementFormDefault="qualified" xmlns="http://tempuri.org/XMLSchema.xsd" xmlns:mstns="http://tempuri.org/XMLSchema.xsd"...
  10. nwruiz

    XSD validation - choose between an attributeGroup

    Hello, I am relatively new to designing XSD's and have been fairly successful, aside from the problem listed below: <!-- Numeric tags --> <xs:attributeGroup name="Number"> <xs:attribute name="precision" use="optional"> <xs:simpleType> <!-- Precision must be 0-10 decimals -->...
    • nwruiz
    • Thread
    • Replies: 5
    • Forum: XML
  11. nwruiz

    Error reading Excel spreadsheet via OleDb

    Hello, I am trying to use OleDb to extract information from an Excel spreadsheet I am downloaded from the Internet. The OleDbCommand command text I am using is here: oleCmd.CommandText = "SELECT [MO], [DA], [YR], [S], [ ID], [T], [1/13], [2/14], [3/15], [4/16], " & _...
  12. nwruiz

    RegEx help!

    Looks good! Thank you for your help! Nick Ruiz
  13. nwruiz

    RegEx help!

    ...this page as if it were an XML document. Now, how would I modify that string to grab the tag that encompasses the </a>? I see that the <(?!a )[^>]*> would grab the <td> tag in this case. I was wondering if I could use a group definition to get the end </td> tag. Something like this: <((?!a...
  14. nwruiz

    RegEx help!

    I'm not actually using Perl, but I know that most RegExp pros use it regularly with Perl. RegExps go across programming languages, and unfortunately, Tek-tips does not have a forum dedicated to them. My actual solution is in .NET, but I feel that both I could get a better answer in this forum...
  15. nwruiz

    RegEx help!

    ...immediately follow the beginning of the <td> element. I need it to capture any <td> element where no <a> tag exists but a </a> exists. <(td)[^>]*> (?!<a[^>]*>) .*?</a>.*? </td> Whitespace has been included to make the RegEx easier to read. Nick Ruiz Associate Integrator PPLSolutions IT...
  16. nwruiz

    RegEx help!

    ...Since RegEx is coupled most closely with Perl, I decided to ask the question here. My first idea was to use the following expression: (<td[^>]*>[^<a.*?>]*?)(</a>) which almost did the trick, but it was a lucky stroke, since it would not work for tags of length greater than 1. I am...
    • nwruiz
    • Thread
    • Replies: 10
    • Forum: Perl
  17. nwruiz

    .NET regular expresions to repair malformed XHTML

    Perhaps I may be on my way to solving this problem. I managed to extract the integers I needed from the "Line 36," and "position 56." examples by making the following modification: ' This is just a code snippet. Please refer to the code in the previous post for the context. Dim line As Integer...
  18. nwruiz

    .NET regular expresions to repair malformed XHTML

    ...As Boolean Dim message As String = ex.Message Dim success As Boolean = False Const textInsideQuotes As String = "'([^']*)'" Const lineNumberSearch As String = "Line\s(\d*)," Const positionSearch As String = "position\s(\d*)." Const rexOptions...
  19. nwruiz

    Storeed procedures in MYSQL Administrator 1.1.9

    I have encountered the same problem - except that when I try to write a second stored procedure, it overwrites the first. Does anyone know of a solution to this problem? Nick Ruiz Associate Integrator PPLSolutions IT Billing and Transactions
  20. nwruiz

    newbie - email reader

    Hi Steve, I'm struggling with the same scenario. In my research, I have found that it is possible to do this if you have MS Outlook installed on the machine that would run your code. Basically, you would use COM to access your Outlook client, which would allow you to fetch emails. One article I...

Part and Inventory Search

Back
Top