Recent content by klunde

Actually, what I ended up with is this: for i = 2 to 14 Response.write "<td bgcolor=""" & iif(weekday(dateadd("d",-i,date()),2)>5,bg1,bg2) & """>" & WeekDayName(weekday(dateadd("d",-i,date())),true) & " " & day(dateadd("d",-i,date())) & "/" & month(dateadd("d",-i,date())) & "</td>" next...

ah... got it. Thanks again for your excellent help! </Morten>

Thanks again! one final small question. In the first example you have ,substr(nvl(to_char(max(decode(nday,1,arts,null))),'-'),1,4) Day1 while in the last example you have ,substr(nvl(to_char(max(decode(nday,1,arts,null))),'-'),1,6) Day1 Why 4 on the first and 6 on the second? </Morten>

Hi I have a sql query that returns numbers from 0 to 14. When I'm showing the result on my asp page I would like to convert these numbers into 0 = "Today", 1 = "Yesterday", 2 = {the name of the day before yesterday (if ran today it would be "sunday"} and so on. Anyone know how I can...

Thank you both for very good help. I went for the second method since I'm writing up this page in an asp page and therefor didn't want to create new database objects. A small? follow-up question. Would it be possible to change the sql code to allow n-number of days? </Morten>

I have this sql code select source_name, round(sysdate-sup_date) as nday, count(article_id) as arts from articles_contents_xml where round(sysdate-sup_date) <=14 group by source_name, round(sysdate-sup_date)" order by source_name, nday which gives me this list: Source_name nday arts...

Additional info: On the server I'm running this program on I have the older compiled version of the program. This version works ok. There is no write to file errors or anything with that one, but if I start the one I have compiled I get this error. </Morten>

If only there where some docs.... Here is the code part where I get the error. I can't really understand why I get a "write to file" error when I'm actually trying to read data. try { ADBInterfaceDLL.ArticleDataBase ADB = (ADBInterfaceDLL.ArticleDataBase)obj; ADODB.Recordset RS = new...

No it wasn't. I finally found the component under COM+ applications on my server. I exported it and installed it into COM+ on my dev. machine. Then I removed the components (adbinterfacedll and adodb.dll) from my project and added them again from the COM page on the references in VS. Now my new...

Hi I have a C# program that I haven't written my self, but I have it running on a server here. Now I've opened the source on my computer (and upgraded the project without error to VS 2008). Then I've changed two small lines in the code and re-compiled it (again without error). But when I run...

Correction. The =INDIRECT("Sheet1!A"&ROW()) actually enables me to expand the formula. </Morten>

Thanks Glenn. The next thing would be to figure out how to apply an =INDIRECT() command on all my 597 existing formulas since you can't create an =indirect() and drag it to expand / increase the formulas. SkigVought and Combo: You didn't get the question. </Morten> </Morten>

Hi I have a spreadsheet with two sheets. On sheet two I have a list of formulas where the first 50 rows refers to one!a1..a50. Now the problem: I want my list on sheet two to ALWAYS refer to the cells a1 to a50, but if I on sheet one removes row 18, row 18 on sheet two ends up with a row...

Take a look at XTrans. From the website: A small free editor for building XSL templates and test their transformation with XML documents. http://www.simxtech.com/users/zc2/xtrans/ </Morten>

You'll find it here: ftp://ftp.ca.com/CAproducts/unicenter/AXWBAS/nt/GA/QO86307/ </Morten> </Morten>