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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Vince
  • Order by date
  1. Vince

    < 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=&quot;Column[@id < 'A']&quot;></xsl:value-of> Hope this...
  2. Vince

    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=&quot;Name&quot;></xsl:value-of> The rest of it seems OK B-)
  3. Vince

    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(&quot;//YEARS[. = '20']&quot;) I...
  4. Vince

    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=&quot;//elementName&quot;></xsl:value-of> this can be done for either a domdocument object using the selectSingleNode method...
  5. Vince

    XML/XSL Help Please!

    Hi, Yes you can do it <xsl:stylesheet version=&quot;1.0&quot; xmlns:xsl=&quot;http://www.w3.org/1999/XSL/Transform&quot;> <xsl:template match=&quot;/&quot;> testing <xsl:for-each select=&quot;Report/Heading/Columns/Column[@id = 'A']&quot;> <xsl:value-of select=&quot;@width&quot;/>...
  6. Vince

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

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

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

    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=&quot;Whatever()&quot; This will normally execute in javascript
  10. Vince

    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(&quot;Rootnode&quot;); //get xml to add var oNode2 = xmlDocSub.selectSingleNode(&quot;Header2&quot;); //Add them together...
  11. Vince

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

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

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

    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 (&quot;select count(party_id) as...
  15. Vince

    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 = &quot;the connection string for your database&quot...
  16. Vince

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

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

    Easy SQL/VB question

    you can set the field back to null if the field allows nulls by doing the following RS.fields(&quot;Field&quot;).value = vbnull I hope this helps
  19. Vince

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

    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>

Part and Inventory Search

Back
Top