Recent content by scuttleButt

I did not design the workbook, I just inherited it. This was made years ago and I can't change it. I can only work with what I have. Really nice forum. A person comes here looking for help and all I get is some folks sitting on their high-horse. Never mind

Hi, I have 8 worksheets with people entering times on various projects. Each person has 4 - 10 projects on their worksheet. On the project summary I want to search the 8 worksheets and find out who is on each project (via project ID) and total their time. So if 2 of the 8 people are on a...

Thank you both for the tips, I will work both issues to see if either works. I have not tried the mappath I will try that. I think the Intranet machine has privileges to access other machines, it accesses my SQL server fine and it is a different physical machine. I work at a military...

I am working in asp pages with vbscript on Windows 2000 and I am trying to work with the code: DIM objFSO, objFolder SET objFSO = Server.CreateObject("Scripting.FileSystemObject") SET objFolder = objFSO.GetFolder("\\servername\public\News\dep\depnews\") It is working if server name is on the...

Could someone see what I am doing wrong? This SHOULD be soooo simple... but I am not strong in javascript. I am trying to fill an array with numbers based on a string filled with 1's and 0's (selVal). If the first char is a "1" then the array needs to get a "1" added to...

Thank you... BOTH posts were very helpful

May be a stupid question but I am trying to create a stored procedure which I pass 2 parameters, 1 for the column name and 1 for the column value. I am working in SQL Server 2000 using vbscript on asp pages. If I create a stored procedure in SQL like this: CREATE PROCEDURE crFiltered AS...

Thank you, worked great!

I am working in vbscript, ASP pages, SQL 2000 backend. I have 2 multi-select list boxes working together. One list is selUnused for unused codes and the other list is, selSelected for the codes selected. The user can move the codes between the two lists while they are deciding which codes...

I figured out what I did wrong and yes, it was simple. When I changed over to Windows and SQL authentication, I left the SQL server (in the enterprise manager in SQL) set at windows authentication. WHen I changed that to SQL authentication and gave it the sa user name and password I was able...

When I say connect for SQL tools, I mean that I registered a new server in my client-side enterprise manager and I have to "connect" when I get into the query analyzer. I was working fine while I was setting things up. My wwwroot was also connecting through the Intranet when I was...

I am confused. I am using SQL Server 2000. Initially I set up SQL as Windows only authentication. The problem was that my Intranet server could not connect; it is running Windows 2000. For some stupid security reasons the administrator disabled all IUSR_ accounts. So it was having problems...

p.s. and with the addition of incrementing @idx -- donnamaxey [santa2]

Thank you Sunil, you were very helpful. It worked with the addition of brackets, it didn't like having just a number for a column name. Declare @idx int, @eom int Declare @SQL varchar(1000) Set @idx = 1 set @eom = (select...

I am using sql server 2000. I am creating a table in a dts with one column for each day. I have declared my variables and found the last day of the month. I am trying to set up the columns in a "while" loop: Declare @idx int, @eom int Set @idx = 1 set @eom = (select...