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!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. codecomm

    Autonumber ID to reset itself on month change

    We have a "To do" list that also has a "month" column. We'd like to have the todos in March to start with 1, and once we started entering in items for April, the first todo entered would start @ 1, then second todo would be 2, etc. Calculated field maybe?????? Any suggestions are welcome...
  2. codecomm

    Line chart series to start @ 0

    So, I got it to work with the help of a "Periods" look-up table that I created. My main table, which showed the 12 monthly periods, had one column which was a long date-time field. I took that and got the monthname(). With this new look-up child table, I defined an int column ("PKID") from...
  3. codecomm

    Line chart series to start @ 0

    Just to further explain: Let's say I look at three months time frame: January @ $10,000 February @ $15,000 March @ $12,000 The category fields (on the horizontal) are the months, and the data fields (what builds the vertical axis) are the costs. Right now, when I look at the start of my chart...
  4. codecomm

    Line chart series to start @ 0

    Thanks RiverGuy! That just did the same thing as the margin property. It just added a left margin more or less. The left to right flow is by month, and the vertical is dollar values.
  5. codecomm

    Line chart series to start @ 0

    I have a line chart series that is for accounting. A sample query would pull back 12 rows (1 row for each month, Jan - December), and the columns would show the dollar amounts for separate buckets of money allocations. What I'm trying to do is have the series chart line start @ 0 (we're trying...
  6. codecomm

    Trying to call SPROC w/ temp table from web application

    I've put the same user on both server and it's got dbo rights on each...same results.
  7. codecomm

    Trying to call SPROC w/ temp table from web application

    Sorry...I was just trying different records...same results w/ same ID. Do I need to do a print or something to get the SSMS "Execute Stored Procedure" to show up in the TextData column of the profiler? If I include the [Use DB] statement, I see that, but....that's all that gets written. It...
  8. codecomm

    Trying to call SPROC w/ temp table from web application

    So, in SQL Profileer, I to see this: EventClass -- RPC:Completed TextData -- exec usp_UpdateMilestoneDescription @UID=3796 ApplicationName -- .Net SqlClient Data Provider NTUserName -- no value shown...it's blank LoginName -- MyUser CPU -- 0 Reads -- 702 Writes -- 1 Duration -- 32...
  9. codecomm

    Trying to call SPROC w/ temp table from web application

    jmeckley, I've got the @ symbol in other DB calls, and it's working fine...no errors. The activeItem["UID"] is correct b/c I was writing it to the page to make sure it was the checked item's Primary Key.
  10. codecomm

    Trying to call SPROC w/ temp table from web application

    try { conn.Open(); SqlCommand MyCmd = new SqlCommand("usp_UpdateMilestoneDescription", conn); MyCmd.CommandType = CommandType.StoredProcedure; MyCmd.Parameters.Add("@UID", SqlDbType.Int)...
  11. codecomm

    Trying to call SPROC w/ temp table from web application

    I'm trying to call a linked server, SS2000 that has NText field and instert that data into an nvarchar(120) field on SS2008. If I execute the SPROC from SS Management Studio, it works fine. If I try to call the SPROC from my web application, I don't get any errors, but the data doesn't get...
  12. codecomm

    ipp_0001.asp page to group by Location

    All, I found this to get the column headers sortable: http://www.kryogenix.org/code/browser/sorttable/ I had to edit the ipp_0001.asp page as follows to get the table headers: Function GenTableHead () ...lines omitted for brevety strHTML = "<thead><tr>" For i = 0 to 5 strHTML = strHTML &...
  13. codecomm

    ipp_0001.asp page to group by Location

    I'm trying to get this printers page to have a grouping band by location: server/printers/ipp_0001.asp ...page found in the Windows/Web directory for Server 2008. So, when the page is run, there's a grouping band by location...and you can see by location where printers are associated. It's...
  14. codecomm

    Migration from ASP.NET 2.0 web app to SharePoint

    Hi! We're trying to migrate from an ASP.NET 2.0 web application to SharePoint. Luckily, our database is pretty simple for now. Questions we have are: 1. How do we pull in the data so users can view the same information just in the SharePoint UI? We're assuming Reporting Services will help...
  15. codecomm

    Datagrid Edit, Cancel, Paging calls SortCommand...not just limited to

    My issue is I'm trying to have a datagrid (ASP.NET 1.1) to allow editing, along with sorting ASC/DESC via column headers. When I click "Edit", my SQL query ASC goes to DESC, and vice versa. This happens on Cancel, Paging, Delete, etc...I'm trying to limit the "swap" in the order by criterion...
  16. codecomm

    Who's running reports in SSRS 2005

    hey all! Thanks for the threads...here's what I used: SELECT cat.Name AS ReportName, cat.Description AS ReportDescription, cat.CreationDate, cat.ModifiedDate, ex.UserName, ex.Format, ex.TimeStart, ex.Parameters FROM ExecutionLog AS ex RIGHT OUTER JOIN...
  17. codecomm

    Who's running reports in SSRS 2005

    We are trying to see if it's possible to see which users are running what reports. When users hit a report, they have to enter their WIN credentials. We do have the default switch is 3: <!-- 1 = error, 2 = warning, 3 = info, 4 = verbose --> <add name="DefaultTraceSwitch"...
  18. codecomm

    ASP.NET 1.1 move to either ASP.NET 3.5 or SharePoint/Infopath

    Hi all! We're in the process of going from ASP.NET 1.1 to either 3.5 or SharePoint/Infopath. Any suggestions/comments are welcomed! Thanks!
  19. codecomm

    Include files for root and subdirectories

    Thanks Vragabond! I knew it was something like that. I kept using tilda "~" then a forward slash.
  20. codecomm

    Include files for root and subdirectories

    I have a site which will have subdirectories. I'm creating a template having .js and .css file includes? How can I create a template that works in both the root and subdirectories w/o having to have two versions like the following where I have my .css file in a folder called css. First example...

Part and Inventory Search

Back
Top