Recent content by Torp23

I figured it out. I had to set the variable to a value before the code above ran. It must default to a null or something and that froze up the report. When I moved the function that instantiated the variable to the header, the code ran fine. Thank you for your time on considering this...

Thank you for your response. Eventually I will want to report the PlanTotalArray in another section, but at the moment I am not doing anything wtih the array outside of this function. Even though making it global should be irrelevant in this case, I changed it anyway and it still did not work...

Simplest thing and can't get it to work. This doesn't work: WhilePrintingRecords; numbervar PlanCounter; Global numbervar array PlanTotalArray; Redim PlanTotalArray[PlanCounter]; This DOES work (but of course the project won't work this way): WhilePrintingRecords...

After working on this all morning I learned that (after cleaning up some statements) writing a SQL statement (SQL 2000) against a view that joins multiple tables will return records with null values in the queried field when the queried field is from the 'child' table. If the query references...

I have a view that contains nulls in a column when there is no data. I am calling the view from an ASP page with a select statement and a where clause that specifies the selection of records that match a text string. The query returns all the records that match the string, but also all nulls...

I don't know what your level of programming knowledge is, but I have found that if you go to web sites that have lots of examples on a topic you want to learn and play with them, you can learn alot of information quickly. One site that might help you is www.xmlpitstop.com. They have a nice...

I have an XSL file that filters a recordset to send back to the calling code. The page works fine, but I can't get it to do a 'LIKE' search or 'wildcard' search. Here is the active line that I am trying to change: <xsl:for-each select=&quot;root/pd_peopleview[@fname=($fname)]&quot;> I am...

I GOT IT!!!! :) Here is the final script that worked... I used part of your suggestion and filled in the 'blanks': <script language=&quot;VBscript&quot;> function fillMgrCombo() Dim xmldoc, nodes, N, s, stateCode, anID, aName, aList, i set xmldom = document.all(&quot;xmlDSO&quot;) set...

I am trying to fill a combo (drop-down) box based on a XML 'data island' in my ASP page. All the examples that I find use an XML format where all the fields of the record are seperate elements in the data island, but I am pulling this recordset from SQL2000 with the &quot;...FOR XML&quot...

Thanks for the idea Bryan, I wasn't aware of that command, but when I tried it I get the same effect. Like I said, I think it sees that file, but it is either returning no records or it isn't reading what is being returned. If I load an XML file into a DOM object (the one that is not being...

I have been an ASP/VB programmer for years, but am very new to XML myself, but had some thoughts I hope might be helpful to you: I know that if you save a Word file as html and look at the source code for it, you always get a 'ton' of xml stuff but I'm not sure how it is used. I always delete...

I have decided to give up on using XSD for this and reposted this with a different question regarding the new methodology. Please read my new posting &quot;DOM and SQL2000&quot;. If I can't get that method to work I am going to look into stripping out the unwanted text of what SQL2000 returns...

My goal is to read an XML file that is created from SQL2000 into a DOM I am reading the XML and XSL files into seperate DOM objects as follows: Set source = Server.CreateObject(&quot;MSXML2.DOMDocument&quot;) source.async = false source.load(xmlurl) Once the DOM objects are defined they...

Why can't I substitute an XML file being produced from SQL2000 for one that is hard-coded? I used the 'EXPLICIT' function to make sure all the items are elements and I ran it in a browser by itself so that I am sure the format matches the hard-coded file exactly. But when I run the ASP page to...

The example that I am working through is in the new MS press book called &quot;XML&quot; and it says that it recommends it as a way to transform the data as an alternative to using EXPLICIT mode. All I am trying to do is return data from SQL2000 as XML so that all the attributes are elements...