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 Rhinorhino 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 ragepro

  1. ragepro

    How do I create PK's off another tables data?

    I switched the link fields to DetailID and it now works like it should. Can't believe it was that simple!! Thanks! -- яДGЄРЯΦ --
  2. ragepro

    How do I create PK's off another tables data?

    i should add that I'm using MS ACCESS in OFFICE XP thanks again Adam
  3. ragepro

    How do I create PK's off another tables data?

    I have two tables. My forms are set up so I have one form embedded into another each form using a table. tables: SYSTEM - contains general system data DETAIL - contains individual discrepancies by date forms: SYSTEMF - contains SYSTEM table with DETAILF form embedded DETAILF - contains DETAIL...
  4. ragepro

    SQL Syntax in ASP

    Jason, more than one LIKE seemed to confuse it and it would return nothing. One LIKE worked of course. Thanks for the idea though! clarkin, your's worked GREAT! Thanks a lot man!! I had actually thought doing it that way and didn't think it would work... I should have tried it anyway, huh...
  5. ragepro

    SQL Syntax in ASP

    I am having some trouble applying extended queries in an ASP environment. I'd like to use the following: SELECT Name, alphaOrder = CASE WHEN (LEFT(Name,2) LIKE '[a-d]') THEN 1 WHEN (LEFT(Name,2) LIKE '[b-c]') THEN 2 ELSE 0 END FROM table ORDER BY AlphaOrder, Name I've tried...
  6. ragepro

    SQL output problem

    VERY COOL! I now just have to go through the trouble of incorporating it into my ASP script. BAAAA Thanks a lot man!
  7. ragepro

    SQL output problem

    I should add that I'm using MS SQL. Thanks.
  8. ragepro

    SQL output problem

    Hello, I'm trying to output my database by column 'CompanyName' in alphabetical order. Too simple. Now, here's the kicker, I want to start not from A, but from a predetermined letter, say L and have it loop back around to K. Is this possible with just an SQL query? Or do I have to write a...
See more

Part and Inventory Search

Back
Top