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!

Register Log in
  • 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 JayF82

  1. JayF82

    Updating a RS in a COM

    Hi Sheco, Thanks for the answer, I'm pretty sure it allow text as it's not being queried directly from the db. It's in the SQL query and I have Select [...], '' network, [...] from [...] So its a text value in the RS...or I believe it is...
  2. JayF82

    Updating a RS in a COM

    Hi everyone, I've been hacking at this thing for the last couple of hours and I just can't seem to get it to work. I'm trying to update a RS before returning it to my ASP page. The RS is in a VB6 COM. Everything is working fine if I don't do any update but as soon as I add this...
  3. JayF82

    Recursive relationship

    Hi Ceh, Thanks for the reply, why would GROUP BY be used for simple table where no "group" statistics are needed? Not sure if I can think of an example where I would need summaries while preserving my Tree like view...
  4. JayF82

    Recursive relationship

    Okie! Browsed some more and found the statement I was looking for: ORDER SIBLINGS BY [Clause] Figured I would post it here so other poster who search for this topic can find it. Thanks a lot for your help johnherman.
  5. JayF82

    Recursive relationship

    Sweet! That worked...now I got the record in order. Now I could process them with some VB code and sort them alphabetically, but it sure would be nice if I could sort them directly in the query. I've played with ORDER BY but if I do it on Description I loose the logical tree order and my...
  6. JayF82

    Recursive relationship

    Hi everyone, I'm kind of in a bind right now, I have this Database table with a recursive relation in it pointing to a parentID. pkID Description ParentID 1 xxxxxxx null 2 xxxxxxx null 3 xxxxxxx 2 4...
  7. JayF82

    Array size in JS

    Hi tsdragon, Thanks for the reply, that would work and would be the way to go if I was to rewrite it not using multidimensional array. I couldn't use an associative array since I didn't know you could retrieve the index string until theniteowl's post.
  8. JayF82

    Array size in JS

    Eh, cool sometime its just there for us to see. That could prove useful but I've finished my calendar with a two dimensional array now. I might change it when I get more time though. Thanks.
  9. JayF82

    Array size in JS

    I initially started with two arrays, but then merged them in one to tidy up the code a little. I'll steer clear of 3 dimensional arrays for now :) Thanks for helping, I appreciate it.
  10. JayF82

    Array size in JS

    Hi niteowl, Thanks for the replies, I'm looping through my array to find the dates which are in the current year and month so that I can display only those. Its working ok with a two dimensional array as I loop through the array first colum [i][0] and if I get a match I can then use [i][1]...
  11. JayF82

    Array size in JS

    Well more or less, I want an associative array yes but need to search by date and perform some for loops on all elements. I was hoping that having the Date as the index would work as I saw a few example online that were using that method. After some testing I figured it really wasn't practical...
  12. JayF82

    Array size in JS

    Well after some testing with a fun for loop which crashed my browser I've decided it wasn't the way to go......
  13. JayF82

    Array size in JS

    Hi, I was looking at some code snippets online and sometime I saw stuff such as : var arrayName = new Array() arrayName[Date] = 'aasdfasdfsdf'; Its an easy way of indexing dates that are associated with a string (such as a calendar) or something but that create HUGE arrays. Does JS treat...
  14. JayF82

    Firefox executing a little too fast.......

    Here are screenshots : First from IE : You can see the popup happening BEFORE the calendar is displayed. If I click ok the calendar is displayed with the info from the text file. Click for SS: http://img266.imageshack.us/img266/815/ie4kg.jpg From Firefox : You can now see the calendar behind...
  15. JayF82

    Firefox executing a little too fast.......

    Hi everyone, I have just created a calendar which highlights days IF an event is planend for that day. I read the content of a text file using a XMLHttpRequest for Firefox and an ActiveXObject. Its working just fine as I can have the content of the file showing into a div element. Now when...
See more

Part and Inventory Search

Back
Top