Search results for query: *

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

I have an XML file that is generated from SQL2000 that works just fine, but I need the output of that file to show each item as an element instead of as an attribute of the main element which is the default. I have been trying to apply an XSD schema that I have developed (based off a text book...

I am developing a new intranet page in XML for our company and as I walk around to the other workstations in the IT Dept to test some of it, I am finding that 2 of the 6 computers I have tried it doesn't come up. One computer gave me a &quot;you are not authorized to view...&quot; error and the...

We have a computer running a Caché database on the VMS operating system and need to access this database from another machine with SQL Server 2000 running on it. Does anyone know of a driver to allow this access into Caché? Scott Schuman Medical Associates Menomonee Falls, WI

I have an ASP page that calls an ODBC DSN (to a MS Access 2000 database) to create a connection object to use in the code. On the development machine, this code always works, but on my production server it does not always work. Sometimes it will run the code without error and other times it...

I have an ASP page that calls an ODBC DSN (to a MS Access 2000 database) to create a connection object to use in the code. On the development machine, this code always works, but on my production server it does not always work. Sometimes it will run the code without error and other times it...