Search results for query: *

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

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

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

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.

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

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

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.

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.

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.

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

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

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

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

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

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