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 Wanet Telecoms Ltd 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: *

  1. mpopnoe

    Timing out - is this code to cumbersome?

    understandable. before I do though, here is a quick question that may solve my problem. My code is basically writing a couple thousand lines of javascript, using the DOM to create <option> for my 3 <select> on the page. I'm thinking this is a little out of hand - but maybe not. I don't do...
  2. mpopnoe

    Timing out - is this code to cumbersome?

    ...entire page here, if it is too much to look at let me know and I'll strip it down ... thanks in advance!! <? $link = mysql_connect('localhost', '******', '******') or die('Could not connect: ' . mysql_error()); mysql_select_db('******') or die('Could not select database'); if...
  3. mpopnoe

    Setting the selectedIndex of &lt;select&gt; in FireFox

    There are none coming up - that is why I'm having so much trouble figuring this out. I've found plenty of codce examples online showing the use of selectedIndex in FireFox - and they are accessing it in the same manner I am. Thanks alot for your input though - if you have any other ideas for...
  4. mpopnoe

    Setting the selectedIndex of &lt;select&gt; in FireFox

    Thanks but I mentioned in my orig. post that I tried both ways and it still is not working. I tried it again, here are results: function BodyLoad() { var oState = document.getElementById('myState'); oState.options[1] = new Option('Oregon'); oState.options[1].value = 1; oState.selectedIndex...
  5. mpopnoe

    Setting the selectedIndex of &lt;select&gt; in FireFox

    You got it: function BodyLoad() { var oState = document.getElementById('myState'); oState.options[1] = new Option('Oregon'); oState.options[1].value = '1'; oState.selectedIndex = 1; var oState = document.getElementById('myState'); oState.options[2] = new Option('Washington')...
  6. mpopnoe

    Setting the selectedIndex of &lt;select&gt; in FireFox

    ...not repopulating the javascript. HERE IS THE CODE: function BodyLoad() { <? if (isset($HTTP_POST_VARS["form_sent"])) { $query = 'SELECT * FROM state'; $Result = mysql_query($query) or die('Query failed: ' . mysql_error()); $ctr = 1; While( $Row =...
  7. mpopnoe

    Advanced &lt;img&gt; src change

    I'll take your advice, but I've been testing this site with Mozilla Firefox and IE 6 and onLoad and onError are firing away. Older browsers probably don't support it though so I'll look into doing it in FoxPro - I think I just need to use SOAP or some other component to make HTTP requests via a...
  8. mpopnoe

    Advanced &lt;img&gt; src change

    If they are supported why are they firing correctly? when the URL fails the onError fires and when it comes thourhg the onLoad fires. The problem at this stage is the 'stack overflow' errors - something to do with the image files but can't seem to pinpoint why. thanks again for your insight!
  9. mpopnoe

    Advanced &lt;img&gt; src change

    Thanks Jon, I'll look into it - I just thought javascript would be the best route. I almost got this working but I get a stack overflow error @ line 0 and it happens on the last image trying to be swaped and I can't figure out why - any ideas?
  10. mpopnoe

    Advanced &lt;img&gt; src change

    Sorry for not being more clear - just ignore the URLs, in the code they point to actual photo files but they are MLS listings and I am not authorized to display them outside the designated site.
  11. mpopnoe

    Advanced &lt;img&gt; src change

    I've found a lot of useful code but just can't seem to get this to work. Ok, the software shows images of real estate that a user searches for in a search results page. now, my databases image fields will always be populated since I auto-generate the photo filenames based on the MLS # of the...
  12. mpopnoe

    select unique records based on multiple columns

    Tiglet, Thanks! That worked great, except I did need to add this line to select the valid range of data otherwise &quot;all&quot; visible cells, all the way down to the maximum rows allowed in Excel (65k+) are copied into the clipboard and the virtual money is maxed. Range(Cells(1...
  13. mpopnoe

    select unique records based on multiple columns

    Thanks to both of you. Tony, The reason I move the columns around is because from my limited experience, the only way to create a compound unique key (of sorts) in Excel to filter on is to place them inline, then hide the columns that are not part of the unique key. Is this way off? I...
  14. mpopnoe

    select unique records based on multiple columns

    What I'm trying to do is find unique records based on a compound unique key, that being 5 columns for this example. In order to do the filter, I place the columns in columns 1-5, hide the remaining columns and filter. That part works fine, the only problem is when I try to select just the...
  15. mpopnoe

    Create an XML document from data in a CSV file

    Thanks for your quick response. Most of the data I ran into out there for converting data to XML was java and .net classes, so I'll either use the java classes or write something on my own....just wanted to make sure I wasn't missing the easy way of going about this...I have ended up doing...
  16. mpopnoe

    Create an XML document from data in a CSV file

    I read the first half of &quot;Beginning XML 2nd edition&quot; by wrox, and that was about 6 months ago....so I am not even to the status of newbie yet. Anyway, I believe I understand the concepts of creating xml documents based on dtds, and using DOM, etc. to access/manipulate the data within...
  17. mpopnoe

    Excel 2000 error: &quot;Compile Error, Automation Error, Unspecified error

    One user of the Excel macros I make is having tyrouble with 1 xls file only, getting the error message thrown by VB stating &quot;Compile Error, Automation Error, Unspecified Error&quot;. The code in this workbook is no different then the hundreds of other ones she runs. The VBE opens and has...
  18. mpopnoe

    References

    ...If InStr(objRef.Name, &quot;EDD_TEMPLATE&quot;) <> 0 Then 'objRef.Remove Application.VBE.VBProjects _(&quot;TEC_CLN.XLM&quot;).References.Remove (objRef) End If Next objRef ** I'm not sure how to pass the reference as Reference to the remove method.
  19. mpopnoe

    Retreiving values from other worksheet

    ...in the userform, placing data into a textbox) txtDataFromWorksheet.Text = ThisWorkBook.WorkSheets(&quot;YourWrkSheet&quot;).Cells(1, Range(&quot;First_Name&quot;).Column).Text **Note: This was the best I could do with the info you provided, please be more specific if this doesn't help. mike
  20. mpopnoe

    Sharing code between projects

    I referenced workbook &quot;B&quot; from workbook &quot;A&quot; so I could use the code (in standard modules) from &quot;B&quot; in &quot;A&quot;. However, I don't know how to call these subs/functions that reside in &quot;B&quot;. I also tried placing some code in &quot;B&quot; in a class...

Part and Inventory Search

Back
Top