Search results for query: *

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

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

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

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

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

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

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

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

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