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

Recent content by yeungsprite

  1. yeungsprite

    How to update merge and update 2 tables into a View

    Awesome - exactly what I was looking for; thanks Marc!
  2. yeungsprite

    How to update merge and update 2 tables into a View

    Hello! I am trying to determine the syntax to merge 2 tables together with different schema into a View. The 2 tables are identical except one of them has an additional column. Whenever the View is called, it will retrieve all data from each table with no conditions or restrictions. The...
  3. yeungsprite

    win32ole

    I found a simpler way using AutoItX3, which is a freeware automation tool that comes with a combined DLL/COM module called AutoItX with a separate HTML help file describing clearly the COM methods available. http://www.autoitscript.com/autoit3/downloads.php Here's the Ruby code now: require...
  4. yeungsprite

    win32ole

    Hello, I am new to Ruby and Windows programming and have a question regarding the WIN32OLE. The following sample code is used to launch MS Internet Explorer. require 'win32ole' ie = WIN32OLE.new('InternetExplorer.Application') ie.visible = true ie.gohome What I would like to do is launch MS...
  5. yeungsprite

    How to parse web page HTML source code

    The problem was that it should be content.document.body, not window.document.body. Thanks for the suggestions!!
  6. yeungsprite

    How to parse web page HTML source code

    Thanks for the test code kaht; it works correctly and confirms your reply. The problem for me is that the .js file holding the function is being called from a .xul file (I am making the call using a Firefox extension i am creating), not an html file. For some reason the document.body call is...
  7. yeungsprite

    How to parse web page HTML source code

    Thanks kaht and tsuji. I have tried both of your suggestions w/o success. kaht, you mentioned that the outerHTML call only works for IE? I think this is the same issue for innerHTML call, as I am getting the same error message: 'Error: document.body has no properties' I am using Firefox...
  8. yeungsprite

    How to parse web page HTML source code

    Thanks for the tip tsuji. I am still getting the following error message: 'Error: window.document.body has no properties' The HTMLsource variable is unable to store the HTML code and I am confused as to why. Any ideas? Thanks!
  9. yeungsprite

    How to parse web page HTML source code

    Hello, I am having trouble creating a javascript function to parse through the HTML source code of a webpage using the Firefox browser. I have the following code, which attempts to make use of the built in function calls 'window.document.body.innerHTML' and 'HTMLsource.indexOf('bug.gif'...
  10. yeungsprite

    Error in script

    Thanks for the help. I followed rzs0502's suggestion and things worked out. The _original code_ works on mySQL 4.0.14 and lower, but not 4.0.17.
  11. yeungsprite

    Error in script

    Hi, I am running a script which is outputting the following error: Invalid default value for 'changed' This corresponds to the following portion of code: CREATE TABLE realm ( name CHAR(16) NOT NULL, title CHAR(64) NOT NULL, changed TIMESTAMP(14) NOT NULL DEFAULT '', PRIMARY KEY(name)...
  12. yeungsprite

    Modification of Spell Check Dialog Box

    Thanks for the prompt reply. I am trying to follow your suggestion with the following simple code: Sub Macro1() Dim aRange As Range ' Column to run Spell Check on Dim word As Range ' value of current cell Dim convertedword As String Set aRange =...
  13. yeungsprite

    Open and Save Unicode Text file in Microsoft Excel

    ActiveWorkbook.SaveAs FileName:=filename, FileFormat _ :=xlUnicodeText, CreateBackup:=False
  14. yeungsprite

    Modification of Spell Check Dialog Box

    Hi Mike, Thanks for the reply and I'll try to clarify my problem. I am importing a unicode(to support multiple languages) text file into Excel. I would like to run the spell check function on the list of words. This list of words will be all 'misspelled' words, but the spell check dialog box...
  15. yeungsprite

    Modification of Spell Check Dialog Box

    Hi, I am wondering if anyone can direct me to some help regarding the use of the Spell Check Dialog Box. I would like to access Microsoft Excel's spell checking tool, but instead of clicking 'ok' to change words, I want to modify it so that a list of words can be separated into two lists of...

Part and Inventory Search

Back
Top