Search results for query: *

Hi all, I am pulling my hair out here! I am trying to select all the children records from the following data (i.e. I need to return all of the data you see below.) The only 'where clause' data is have is WHERE ID = 37 [ID] [ParentID] [Title] 37 1 BIG GIG 38 37...

Hi guys, I would appreciate any helpon this one as I am pulling out my hair trying to get it to work. What I have got so far is a recordset with all the correct distict data. The query is below. What I am after is to also return the count of each distinct record. SQL Query: SELECT...

Hi all, I am getting close to solving my problem, however some extra help would be great as I am now stumped! I have a table that contains 'Sections'. There is a root section and many children, which can have more children etc. As you can see from my tree result below, the output is looking...

Hi all, was wondering if someone could help me strip this string : Dim strURL strURL = /products.asp?L1=3&L2=0&PARENT_PAGEID=0&TBL_PAGEID=4&offset=50 If the string contains "&offset=" then i would like the string stripped so that it looks like : strURL =...

SELECT E.Name, E.GroupClass, E.NIIN FROM Equipment E WHERE (E.Assessor LIKE 'te%') AND (E.ArchivedBy IS NULL OR WHERE (E.Assessor LIKE 'te%') AND (E.ArchivedBy IS NULL OR E.ArchivedBy = '') AND (E.ArchivedByID IS NULL OR E.ArchivedByID = 0) AND (E.ArchivedByPosID IS NULL OR...

Hi all, I am trying to write my first hierarchical query in oracle 8i. The data I have is as follows : WID Name ParentID 1 Telecomunications NULL 2 Mobiles 1 3 Handheld Phones 8 4 Foxtel 1 5 Wholesale NULL 6...

Hi all, In VBSCRIPT, how do you print a &quot;<BR>&quot; after every 15 characters of a string? eg strTempString = &quot;abcdefghijklmnopqrstuvwxyz123456789098gfjkgdfgkd&quot; and output would be : abcdefghijklmno <br> pqrstuvwxyz1234 <br> 56789098gfjkgdf <br> gkd Thanks kloner

Hi all, I am trying to come up with a way to ignore numbers and symbols in my query for a particular field. If i have a word like &quot;4-Acetamidophenylboronic&quot; I want to ignore all numbers and symbols. For example I want my query to display the word...

Hi all, I'm going crazy! I need to format a formula. I have a string that looks like this &quot;a56c5t78h10K7&quot;. What I need to do is somehow loop through the string and append the html tag  around the integers. eg final string returned should look like ...

HI all, I was wondwring if it was possible to created a share on a specified folder in VB 6.0. I have looked everywhere for some help but to no sucess. EG. Directory is C:\MY_DEMO And I want to share it under the name &quot;MY_DEMO&quot;, and let only authenticated people have full control...

HI all, I was wondwring if it was possible to created a share on a specified folder in VB 6.0. I have looked everywhere for some help but to no sucess. EG. Directory is C:\MY_DEMO And I want to share it under the name &quot;MY_DEMO&quot;, and let only authenticated people have full control...

Hi all, I'm trying to create a IIS 5 application with virtual directories etc using Visual Basic. Can someone please tell me what reference library I should be using. I am using VB 6.0. thanks so much kloner

Hi all, I'm trying to create a IIS 5 application with virtual directories etc using Visual Basic. Can someone please tell me what reference library I should be using. I am using VB 6.0. thanks so much kloner

Hi all, I have a couple of hundred ASP pages and I would like to get a count of the total number of lines written. I am probably writing this in the wrong forum. I have found an app that counts lines for a VB app, but am after the number of lines written on other asp files. Does anyone have an...

Hi all, I guess this is a simple thing to do, but I am having trouble. I want to do the following in a SQL statement in Oracle. 1. Select * from tbl_blah where AUDIT_TIMESTAMP < (sysdate - x days) 2. Select * from tbl_blah where AUDIT_TIMESTAMP < (sysdate - x months) 3...

hi all. I'll try my best at explaining this problem. I have 5 seperate queries (which will not be merged for specific reasons). Each list returns a list of ID's (if any are available). A min of 1 list and up to 5 lists can be returned. list1 = &quot;1,2,3,4,5,6,7,8,19&quot; list2 =...

hi all. I'll try my best at explaining this problem. I have 5 seperate queries (which will not be merged for specific reasons). Each list returns a list of ID's (if any are available). A min of 1 list and up to 5 lists can be returned. list1 = &quot;1,2,3,4,5,6,7,8,19&quot; list2 =...

Hi guys, I have 3 windows open .... 1. Main (MAIN) 2. click link from main and it pops up a window (SUB_A) 3. click link on SUB_A and it opens another window (SUB_B) Now when i hit OK button on SUB_B i refresh the SUB_A window by doing the following. window.opener.refreshSelf(); Now I am...

HI all, Quick question. I am having trouble trying to run a file on a webserver (IIS 5) - WebServerA. I am calling the file via the MS Win Winhttp Object on a similar webserver (WebServerB). The problem is that we have NT Security and you have to pass your username / password / domain, to run...

Hi all, I have 2 x Webservers (A + B). A - Hosts one file which reads a directory and returns a temp file name I need. B - The main webserver that hosts the application. Problem : I am using winhttp object to call a page on 'B' from 'A'. Because we have 2000/NT security, the page on 'A' the...