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...
...in a view, you have to use the field in the 'people' table in the WHERE clause, not a field in the 'dept' table. If I write the query:
select * from view_statement where deptName = 'Maintenance'
It will return all the records that have 'Maintenance' in the child field and also any that had...
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 GOT IT!!!! :)
Here is the final script that worked... I used part of your suggestion and filled in the 'blanks':
<script language="VBscript">
function fillMgrCombo()
Dim xmldoc, nodes, N, s, stateCode, anID, aName, aList, i
set xmldom = document.all("xmlDSO")
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 "...FOR XML"...
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 "DOM and SQL2000". 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("MSXML2.DOMDocument")
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 "XML" 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 "you are not authorized to view..." 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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.