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 derfloh 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. LarrySteele

    Trying to Transpose Columns to Rows w/ Field Names

    Andy, As a matter of fact, I do know that. I'll blame it on OCD. [pc2]
  2. LarrySteele

    Trying to Transpose Columns to Rows w/ Field Names

    Here's the query I'm building, which gives me exactly what I need: select s01.seq, s01.cn, s01.cv from (select 1 as seq, 'ID' as cn, to_char(id) as cv, id from schema.apps union select 2 as seq, 'APP_NAME' as cn, to_char(app_name) as cv, id from schema.apps...
  3. LarrySteele

    Trying to Transpose Columns to Rows w/ Field Names

    I ended up going with Carp's suggestion. While I like Andy's idea of pulling the column names dynamically, SQL alone does not provision ability to use variables as for fieldnames. I could do this in a proc but just sticking to vanilla SQL for this. Thanks again for pointing me in the right...
  4. LarrySteele

    Searching multiple fields for any/all words from a search string.

    Andy, that's an interesting idea. I can see potential challenges but it gives me an approach, which is more than I had when I posted the question. If I can get this to work, I'll post the results. Thanks for the suggestion.
  5. LarrySteele

    Searching multiple fields for any/all words from a search string.

    We have an application that includes a people searcher. As people enter text, it searches four different fields (first name, last name, ID, email address) for the text entered. This works awesomely. If I enter "Lawrence", it will find me, along with anyone who has "Lawrence" in their first...
  6. LarrySteele

    Trying to Transpose Columns to Rows w/ Field Names

    Thanks for the responses. I'm glad I checked here because I didn't get my notifications. Skip - you are correct, I'm essentially trying to mimic Excel's transpose operation. Of course Excel doesn't have to contend with datatype conflicts the way an Oracle query would. Alas, Excel is not an...
  7. LarrySteele

    Trying to Transpose Columns to Rows w/ Field Names

    I'm trying to transpose a query resultset and I'm struggling finding what I'm looking for in Google. I'm developing an in-house application that inventories applications that our division supports. The inventory will include bringing in information from disparate data sources and pushing...
  8. LarrySteele

    SQLLDR adding a century to pre-1950 dates

    Looks like I found the root cause: it appears to have been the decode function. Again with Google, this time included "decode" in the criteria and I noticed a number of searches related to SQLLDR, incorrect dates, and Decode. So I modified my control file thusly: birthdate...
  9. LarrySteele

    SQLLDR adding a century to pre-1950 dates

    Thank you for your response John, You are correct that Oracle is acting as if it's only receiving RR rather than YYYY. That's what's baffling to me. The dates include the century (see examples from my original post plus the actual sample lines I was assembling as you were posting). I'm also...
  10. LarrySteele

    SQLLDR adding a century to pre-1950 dates

    Thanks for your response Bill. Here's a line of data from my CSV file with personally identifiable information replaced...
  11. LarrySteele

    SQLLDR adding a century to pre-1950 dates

    I've encountered an issue I've never seen before and I couldn't find a solution through Google. I'm using SQLLDR to bring data from some text files, nothing particularly special. The files are CSV with double-quotes where needed. The inbound data appears good. The problem is that dates prior...
  12. LarrySteele

    Hide Field contents based on an AD group of user

    My initial thought would be to have the AD role passed as an input parameter to the proc and use it to mask the data (return blanks, encrypted values, etc.) for the applicable fields. I haven't worked with SQL Server for a long time, but if memory serves, you could even use it as a conditional...
  13. LarrySteele

    LDAP slow to initialize

    Thanks. I too think it's caching, but I was thinking it was IIS that might be caching the connection.
  14. LarrySteele

    LDAP slow to initialize

    I have an intranet site that uses LDAP for authentication and authorization. I've done this for nearly a decade using ColdFusion and a couple of years with ASP.NET. There's one difference on this site - the initial call to LDAP takes a long time (27 seconds) to validate and complete page...
  15. LarrySteele

    Overriding CSS on GridView TemplateFields

    Got it! It turns out it was my CSS definitions after all. Sorry about posting a CSS issue in the ASP.NET forum. [blush] I'll post what I found in case someone else finds this useful. I finally found the right question to answer, which led me here...
  16. LarrySteele

    Overriding CSS on GridView TemplateFields

    I'm using CSS to set padding for TH and TD elements and it works as advertised. One of the attributes is padding (padding: 0 1em 0 .25em;). This adds a touch of whitespace before and after the text. I'm happy with pretty much all my tables, gridviews, etc. But there's one. Among other data...
  17. LarrySteele

    Troubleshooting bound cfselect

    I have a cfselect that's bound to a parent select. The first is a list of countries, the second is a list of schools in the selected country. This works great for most locations that use the page. However it doesn't appear to be working for a number of users in Japan. Thousands of people in...
  18. LarrySteele

    Form variable problems with Safari 5.1.5

    I'm having a problem with Safari (5.1.5) not receiving my POSTed form variables. IE 8, FF 19, Chrome 25 all have no problem sending/receiving form variables between these two pages. I searched here and Google, but wasn't able to conjure up the right phrase to find more than a couple of...
  19. LarrySteele

    Site slow to connect to database

    Thanks Mark. That's the pattern I'm using to connect to Oracle. I suspect this may have more to do with the infrastructure than anything else, which might explain why I haven't been able to find others with similar symptoms. I figured it was worth the shot seeing if anyone had experienced...
  20. LarrySteele

    Site slow to connect to database

    Mark - thanks for the response. Yes, all symptoms point to the DB connection as the bottleneck. Is there anything I can do to speed up connection initialization and/or extending time the connection stays alive? Then again, I'm defining the connection in web.config; should I have defined it in...

Part and Inventory Search

Back
Top