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!

Search results for query: *

  • Users: ethorn10
  • Content: Threads
  • Order by date
  1. ethorn10

    ForeignKeyConstraint issues

    Unfortunately, I don't have any code at hand to post (it's on the dev system) but I have a question for you experts. First things first, c# and a strongly-typed dataset to an Access database. Anyway, I'm getting the error: ForeignKeyConstraint <Name_of_constraint> requires the child key...
  2. ethorn10

    C# with Access database curiosity

    I have just inherited a web app written in c# with an Access database behind it. Prior to this, I was writing an app in ASP.NET using VB and SQL Server 2000 so maybe I'm biased but here goes: The database is relatively small (22 tables) and the app uses OO wonderfully. However, as I'm trying...
  3. ethorn10

    write html containg asp.net controls from database

    Based on my initial searches, I can't find anything that can help me out. For all I know, it might not even be possible but I'd love to think it is... I have html stored in my database for certain pieces of a page. I'd like to have a "main page" with certain constant pieces of the page and...
  4. ethorn10

    background-image

    Ok. I'm still new at this so be patient. I have a simple page at the moment. It has 7 divs: container header top inner topleft topright footer <body> <div id="container"> <div id="header" align="center"><img src="images/img1.gif" /></div> <div id="top"> <div id="inner"> <div...
  5. ethorn10

    site layout with css -- n00b

    ok guys, I'm extremely new to css and its magic but I'm curious how to go tableless with this type of layout: +------------wrapper----------------+ header -- full width top horizontal menu (left align) ------------------------------------- top half of site, 3 column...
  6. ethorn10

    select 2nd highest value per group

    Hello all... I have read up on ways to achieve part of my subject - 2nd highest values - select min(field) from table where id in (select top 2 id from table order by field desc) However, mine is only slightly different yet it's killing me. I need the 2nd highest value for each group that...
  7. ethorn10

    setting backcolor using itemdatabound

    Hello, I cannot figure this out for the life of me and it can't possibly be this difficult. I have a datagrid and I'm trying to set the backcolor of a specific cell based on the text of that cell (not that uncommon I presume). My code: Sub ItemDataBound(ByVal Sender As Object, ByVal E As...
  8. ethorn10

    CASE statement with SUM

    Hello all... Quite some time ago, I got a query straightened out here by some helpful MVPs. My situation has changed slightly. Previously, I had a query that was doing a SUM for each month. Now I'd like to add to that given a condition but I'm stuck in one mode of thinking. It isn't adding...
  9. ethorn10

    instead of triggers

    Hello all... I have a question about INSTEAD OF triggers. I am trying to use them so that I can successfully audit ntext columns. However, I'm struggling with the ability to accurately capture the ID field (autoincrement PK field). I can handle the rest, it's just keeping this ID field in...
  10. ethorn10

    Copy Database

    Hey guys... I'm looking for a little guidance here (i.e. a work-around). I am aliased as dbo on both databases at hand here but I am not the actual administrator to where I can just do this myself -- cause it would certainly be faster than my admin getting back to me. I'm trying to copy our...
  11. ethorn10

    duplicates issue

    Hello, I know this should not be this tough but I can't seem to wrap my head around it. I am trying to remove duplicates but it is more than just that... I have a result set of: ID Name SetDate ExpireDate AnotherDate Reason...
  12. ethorn10

    conditional summation

    Hey guys...this may seem trivial but I've been up way too long today and I just can't wrap my head around it. I need conditional summation performed based on a given value. For instance: SELECT SUM(CASE WHEN tbl_a.aID = 1 THEN SUM( crazy math goes here ) ELSE WHEN tbl_a.aID = 2 THEN SUM(...
  13. ethorn10

    Select max value for given value

    Ok, maybe the subject isn't the most descriptive in the world, but my issue is this: I have a table with several fields, but the only fields we care about are an autonumber primary key and an integer foreign key. I want to get the latest (maximum) primary key for any foreign key. Sample data...
  14. ethorn10

    Mapping IDs using a join?

    Hello, Hopefully I can explain this without typing too much or getting confused myself. What I need/want is a select statement that returns two columns, one of which has the IDs based on one set of criteria and the other is IDs based on another set of criteria. So for example, I want to use...
  15. ethorn10

    Operation Aborted, Catastrophic Failure, asp just quits

    Ok... Hopefully I won't type too much in trying to explain this, but I'm trying to find out why my site (which worked last year just fine) has recurring issues this year (with minimal changes to the code) that are awful both to business and my blood pressure... I get the errors mentioned in...
  16. ethorn10

    count dates, query help

    Ok, hopefully I'll make some sense of this so it won't take long to figure out. I'm just stumped... Have a field (date_applied) that is a timestamp. I format the date with date_format and %m/%e/%Y...I want to count all occurrences of any date. So let's say you have this: 3/12/2005 3/28/2005...
  17. ethorn10

    trigger is inconsistent in firing

    Hi all -- I'm pretty new to SQL Server but I was asked to look into why something is happening. The unfortunate part is that I do not have the specific trigger to give to you guys. What I was told is that it works on tables with 8 or fewer columns in it but more than 8 columns causes it not...
  18. ethorn10

    intriguing select statement issue

    ok, i've thought about this enough. i haven't gotten very far with it, so i'll spell it out for you guys and see how fast somebody can get a star. i want to grab totals for multiple months (april, may, june, july, august) using one select statement with two tables. so something like select...
  19. ethorn10

    regexp question

    I have a question mainly at an idea than how to solve something. I am aware that when dealing with Connection and Recordset objects they need to be closed and set to nothing as a housecleaning practice. Does the same hold true for the RegExp object? Will it cause the same types of issues that...
  20. ethorn10

    session variables not working

    quick question, hopefully quick solution. i have a client who appears to be using Win98 (from the log files) when hitting our site. for some reason, the session variables aren't working with this one user. haven't had this issue before and don't really know how to handle it. ordinarily...

Part and Inventory Search

Back
Top