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 klunde

  1. klunde

    Convert numbers to day names

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

    Concatenate?

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

    Concatenate?

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

    Convert numbers to day names

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

    Concatenate?

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

    Concatenate?

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

    System.InvalidCastException problem

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

    System.InvalidCastException problem

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

    System.InvalidCastException problem

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

    System.InvalidCastException problem

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

    Excel Remove row without breaking formula

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

    Excel Remove row without breaking formula

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

    Excel Remove row without breaking formula

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

    XML editor suggestions (XML newbie)

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

    Where can I get SP3 for BrightStor 11.5

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

Part and Inventory Search

Back
Top