08-19-2006, 08:50 PM
OK, you guys answered my SQL query question so quickly it was obviously too simple for you; maybe you can advise me on this issue?
I was using (from prior version of QM) the following to extract data from a web page that lists routing info I place into a database. (I originally created this with the handy QM wizard on the add-in bar that QM comes with).
MSHTML.IHTMLElement el=HtmlFind3("TABLE" "" "[]<TABLE cellSpacing=0 cellPadding=0 width=''100%'' bgColor=#e1e1e1 border=1><TBODY>[]<TR>[]<TD vAlign=top>[]<TABLE cellSpacing=0 cellPadding=2 width=''100%'' border=0>[]<TBODY>[]<TR>[]<TD vAlign=top>[]<TABLE cellSpacing=2 cellPadding=2 border=0>[]<TBODY>[]<TR>[]<TD align=right><FONT face=Arial,Helvetic" win("Nexxon Services - Maxthon Browser") 0 4 0x28)
str thetext=el.innerText
str s = el.innerText
However, the IHTMLElement has been deprecated in favor of the HTM function. But when I try to duplicate the process with HTM(), I can't get a match (although if I add copies of the system functions that apply to the old IHTMLElement to the new version of QM, I can again match using IHTMLElement-but this is obviously not ideal.)
HTM() function as I am using it now:
Htm el=htm("TD" "Part / service #DescriptionSent airbillReturn airbillRMA #Notes[]3DFORCEFX-5200 VIDEO CARD 97493765784 A45422707621 0000725634 " "" win("Nexxon Services - Maxthon Browser" "IEFrame") 0 64 0x21)
str partstext=el.Text
Can anyone advise of any obvious goofs or suggest QM method for identifying this area of HTML so the data can be extracted as IHTMLElement accomplished?
Again, I appreciate your help.
I was using (from prior version of QM) the following to extract data from a web page that lists routing info I place into a database. (I originally created this with the handy QM wizard on the add-in bar that QM comes with).
MSHTML.IHTMLElement el=HtmlFind3("TABLE" "" "[]<TABLE cellSpacing=0 cellPadding=0 width=''100%'' bgColor=#e1e1e1 border=1><TBODY>[]<TR>[]<TD vAlign=top>[]<TABLE cellSpacing=0 cellPadding=2 width=''100%'' border=0>[]<TBODY>[]<TR>[]<TD vAlign=top>[]<TABLE cellSpacing=2 cellPadding=2 border=0>[]<TBODY>[]<TR>[]<TD align=right><FONT face=Arial,Helvetic" win("Nexxon Services - Maxthon Browser") 0 4 0x28)
str thetext=el.innerText
str s = el.innerText
However, the IHTMLElement has been deprecated in favor of the HTM function. But when I try to duplicate the process with HTM(), I can't get a match (although if I add copies of the system functions that apply to the old IHTMLElement to the new version of QM, I can again match using IHTMLElement-but this is obviously not ideal.)
HTM() function as I am using it now:
Htm el=htm("TD" "Part / service #DescriptionSent airbillReturn airbillRMA #Notes[]3DFORCEFX-5200 VIDEO CARD 97493765784 A45422707621 0000725634 " "" win("Nexxon Services - Maxthon Browser" "IEFrame") 0 64 0x21)
str partstext=el.Text
Can anyone advise of any obvious goofs or suggest QM method for identifying this area of HTML so the data can be extracted as IHTMLElement accomplished?
Again, I appreciate your help.