Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
ReDim an Array
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...- Torp23
- Post #4
- Forum: Business Objects: Crystal Reports 1 Formulas
-
ReDim an Array
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...- Torp23
- Post #3
- Forum: Business Objects: Crystal Reports 1 Formulas
-
ReDim an Array
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...- Torp23
- Thread
- Replies: 3
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Getting rid of nulls in a view result statement
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...- Torp23
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Getting rid of nulls in a view result statement
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...- Torp23
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
-
new to xml-XML to URL
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... -
'LIKE' search in XSL
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="root/pd_peopleview[@fname=($fname)]"> I am... -
Filling options in a drop-down box
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... -
Filling options in a drop-down box
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"... -
DOM and SQL2000
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... -
XML for websites: Filling XML databases
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... -
Applying XSD to an XML file
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... -
DOM and SQL2000
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... -
loading an XML file from SQL2000
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... -
Applying XSD to an XML file
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... -
Applying XSD to an XML file
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... -
Doesn't work on some machines
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... -
Caché ODBC driver
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 -
Inconsistant ODBC connection
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...- Torp23
- Thread
- Replies: 2
- Forum: Microsoft: Access Other topics
-
Inconsistant ODBC connection
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...- Torp23
- Thread
- Replies: 1
- Forum: Microsoft: ASP (Active Server Pages)
