Recent content by nwruiz

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

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

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

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

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

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

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

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

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

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

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], " & _...

Looks good! Thank you for your help! Nick Ruiz

Thanks for your help! Now, allow me to explain why I want to fix these problems. I am actually pulling this HTML source from a website and would like to store it in an XML-structured object. However, in .NET, I can't do this, since it's not proper XML (or for my purposes, XHTML). Scraping from...

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

This RegEx meets my immediate needs for cleaning this fragment, but it would not satisfy the general condition I am trying to fix. It captures any <td> cell where an <a> tag does not immediately follow the beginning of the <td> element. I need it to capture any <td> element where no <a> tag...