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!
-
< character
Hi, I the < is within the Javascript itself why not place the javascript within Cdata tags <![CDATA[ <script language=Javascript>.....</script>]]> or if its within the xsl itself then use the string literal <xsl:value-of select="Column[@id < 'A']"></xsl:value-of> Hope this... -
XSL, getting values from XML elements
Hi, Your path to the name elemt eof your document is not correct it should read <xsl:value-of select="Name"></xsl:value-of> The rest of it seems OK B-) -
XML FILTERING(very urgent)
Hi, You can search the collection of nodes for a specific value using the selectSingleNode or selectNodes methods from the DomDocument object To find a specific value anywhere in the document use the following syntax set oNode = DomDocument.selectSingleNode("//YEARS[. = '20']") I... -
search in xml file for a tag value
Hi, I f I understand what you are trying to do is to locate a specific tag within an XML document if wit exists. You could use xsl to do this <xsl:value-of select="//elementName"></xsl:value-of> this can be done for either a domdocument object using the selectSingleNode method... -
XML/XSL Help Please!
Hi, Yes you can do it <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:template match="/"> testing <xsl:for-each select="Report/Heading/Columns/Column[@id = 'A']"> <xsl:value-of select="@width"/>... -
Open SQL database using VB
Hi, You could try using the catalog object withing the VB project references select Microsoft ADO Ext. 2.5 For DDL and Security within your project Create a module wide declaration dim cn as adodb.connection create a function called connect Private function Connect() as boolean...- Vince
- Post #2
- Forum: Visual Basic (Classic)
-
Converting database to xml
Hi, I don't think that you can save a recordset striagt into an xml dom document. The way that we initially got around this was to save the xml into an ado stream dim s as new adodb.stream rs.save s,adopersistxml then load the data into the DOM document xmlDoc.loadXML(s) However we... -
newbie XML/DOM question
Hi, I dont really know what you are trying to do. I will asume that you are trying to export the results of access queries into xml files. If so you will need to use VB6 this is a quick walkthrough of how you could do it in the VB exe regerence the ADO libraries create an instance of the... -
XML - ASP Interaction
Hi, I'm none to sure if this is what you are asking for but have you tried just removing the alert and replacing it with the function call onSave="Whatever()" This will normally execute in javascript -
Add a node to a document???
Load each of the fragraments into DOM documents //use the selectSingleNode method to goto the correct position var oNode = xmlDocMain.selectSingleNode("Rootnode"); //get xml to add var oNode2 = xmlDocSub.selectSingleNode("Header2"); //Add them together... -
Start Stop Tag problems
Hi, Why don't you use a good xml editor (xml spy for example) This will sort out all of the tag problems that you are having and will allow you to validate against the DTD -
Parser Question
Hi, a DOM parser loads the entire document into the standard tree on the load event and will therefore fall over if the xml document is not well formed. The SAX parser (I think as I don't use this that often) only loads the sections of the document as it needs them. therefore I would think that... -
Newbie with questions
Hi, Yes you can do what you want to. There are many examples of this on the internet e.g www.xml101.com. As for software requirements there are several ways to go to transform (work with xml using xsl) on the server your isp will have to have either a SAX pharser or a DOM parser installed... -
Help in Assigning SQL Values
It would make it easier for you if you did the following Change your code to read dim vCount as variant dim oRs as adodb.recordset 'Create an alias that can be referenced in the recordset object returned from the execute statement set oRs = cn.Execute ("select count(party_id) as...- Vince
- Post #2
- Forum: Visual Basic (Classic)
-
Displaying SQL
All you need is the following option explicit Dim oConnection as adodb.connection Private function GetConnection as Boolean dim bconnected as boolean set oConnection = new adodb.connection with oconnection .connectionstring = "the connection string for your database"...- Vince
- Post #2
- Forum: Visual Basic (Classic)
-
Using Modules in ActiveX DLLs
As a general rule I only ever store constants in a Bas file within a multiuser object. The reason for this is that I developed a system for 5500 users it had one bas file with some generic functionality and it kept falling over until I removed the bas file hope this helps- Vince
- Post #2
- Forum: Visual Basic (Classic)
-
Comand Dialog Box Preventing Errors
It can be done on the CancelError property of the commondialog control if Commondialog1.CancelError = false Then'The User Clicked OK Prompt for confirmation end if hope this helps- Vince
- Post #2
- Forum: Visual Basic (Classic)
-
Easy SQL/VB question
you can set the field back to null if the field allows nulls by doing the following RS.fields("Field").value = vbnull I hope this helps- Vince
- Post #2
- Forum: Visual Basic (Classic)
-
Random Error (Transaction Not enlisted) using MTS ASP and IIS5
I have written several components to talk to an SQL server 7 DB which run on Transaction server. These components are called via ASP. This was tested on accross our local network and worked fine, but as soon as it was moved onto the ISP system it does not create the connection waith the DB...- Vince
- Thread
- Replies: 0
- Forum: Microsoft: Microsoft Transaction Server (MTS)
-
Programmatically creating a Class Module
Sorry it appears that you have to do this from within an addin project as you require a reference to the VBIDE object from which you can get the activeproject or create a new one. So the solution might be to create this as an addin <br><br>hope that this helps<br><br>- Vince
- Post #6
- Forum: Visual Basic (Classic)
