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 strongm 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. AndyInNC

    How can I increase a column size for a large, often-used, SQL table and minimize downtime?

    In MS SQL Server 2014 SP 2, I have a Communication table that is used by many areas of our website to store user notes, comments, and certain email text. The Comments column is defined as nvarchar(4000) and I need to change it to nvarchar(max). The table has over 250k rows with numerous...
  2. AndyInNC

    How do I end the OutputStream during a file download?

    Oh yes, I have. And different events (Page_PreRenderCompleted, Page_PreRender, etc.) And Response.OutputStream.End()
  3. AndyInNC

    How do I end the OutputStream during a file download?

    I'm downloading an Excel file in ASP.Net that works in Firefox and IE, but not Chrome. A link on a calling page opens this page in a new window which generates a spreadsheet, downloads it, then closes the window. protected void Page_Load(object sender, EventArgs e) {...
  4. AndyInNC

    ASP.Net with SSRS vs Crystal Reports

    I am beginning a new project and, against my better judgement, we are using SSRS rather than Crystal Reports. I have never been impressed with SSRS but I have use it in a couple of situations where it was just easier to install and let users run reports from the server. But now I am developing...
  5. AndyInNC

    Is it acceptable to store HTML in a database?

    Thanks for the thoughts. What is the relevance to PHP? Well, I guess it's only a small tie-in. <story type='long, boring'> I have a PHP subroutine that you can pass some data and a css class and it will build an HTML table from that. I've had it for years and it works pretty well. Usually...
  6. AndyInNC

    Is it acceptable to store HTML in a database?

    I have always tried to keep a separation in my coding (N-tiered development it used to be called; now in .Net it is MVC) but it has recently come up that it can be "better" to store some code inside database tables. This seems REALLY hard to troubleshoot and / or maintain. Does anybody...
  7. AndyInNC

    Single dataset, multiple layouts, same report

    I have a stored procedure that returns the Store, Product Category, Units Sold, & Sales Dollars, but each is reported in different charts. StoreID ProductCategory FYQuarter Units Sold Sales Dollars 1198 Gloves 2013 - Q1 1 176 1198 Hats 2012 - Q4 18 4410 1198 Shoes 2013 - Q1 8 2460...
  8. AndyInNC

    jQuery How do I load a URL with parameters and script block

    Here is the code; it's pretty simple: var sURL = "Edit/?iAction=2&sGroup=" + sGroupName; $('#sGroupNameIsValid').load(sURL + ' #div_Results', function(){}); It works just fine... ...until I add a space in the sGroupName variable. The user enters some text for a new data item. All I want...
  9. AndyInNC

    Using PRINT in a stored procedure, but not for errors

    We have a really long, complicated stored procedure and, for tracking its progress, we have added PRINT statements showing the current location of the execution. Like this: -- Do long SELECT into temp table PRINT 'Location 1' -- Update temp table via loop PRINT 'Location 2' -- Sequentially...
  10. AndyInNC

    Reducing the transaction log in SQL Server

    SQLBill, your link to the book made me LOL that there would be an entire book dedicated to Transaction Logs. Nevertheless, you are very much on the right track with the database Recovery Mode, which I had not considered. In SQL 2008 R2, there are Simple, Full, and Bulk-Insert options...
  11. AndyInNC

    Reducing the transaction log in SQL Server

    We are revising our data structure from 15 tables with 255 columns each to 1 (or possibly 5) tables with 6 columns each. Pivoting all this data -- or actually, UNpivoting -- is creating a lot of rows and therefore a lot of transactions. On a couple of occasions we filled up the transaction log...
  12. AndyInNC

    What is the syntax for ImageURL from another in-house server?

    Thanks jbenson001. What you said makes perfect sense, but I couldn't make it happen. It turns out what I thought was just a file server for the images does more than that so they won't let me touch IIS there. Here's the approach I took. Hopefully someone can use it. As you said, it has to be a...
  13. AndyInNC

    What is the syntax for ImageURL from another in-house server?

    This does not seem like it should be that hard, but for some reason I'm stuck. We have a file server that houses images from several applications and our web server needs to display them. When I add this code, I get a broken image icon. <asp:Image ID="imgPhoto" runat="server" Width="140px"...
  14. AndyInNC

    Alphabetic Counter

    Perfect! Thanks!
  15. AndyInNC

    Alphabetic Counter

    I'm trying to write a counter that uses the alphabet as the count like this: A B ... Y Z AA AB ... AZ BA BB .... ZY ZZ AAA AAB Here's my current (incomplete) code. It's a recursive function where you pass in a counter value and it's converted to a letter via Chr(). It's close, but at the...
  16. AndyInNC

    nullif error when no value is specified

    Sorry, I misunderstood. I didn't take the "SET @value1 =" literally. Yes, there has to be something after the equals. Otherwise it's an incomplete statement. If you want it to be NULL, that works. "SET @value1 = NULL", but that is like it was never set in the first place.
  17. AndyInNC

    nullif error when no value is specified

    Try IsNull instead. SELECT IsNull(@value1, 0) And under certain circumstances, SQL will bark at you when confusing data types like your example. @value1 was declared as int, but you returned a string. You may need to Convert() it. (Just a caution.)
  18. AndyInNC

    How do stopwords function in SQL 2008?

    We are implementing a full-text search in our database and the goal is to be as search engine-like as possible for the user. Unfortunately, it has been difficult finding clearly written information about some of these things involved in the full-text search. Right now, I am trying to understand...
  19. AndyInNC

    Create user wizard - but we decide if they can join

    I'm new to the Create User Wizard so I've done some searching and haven't found the answer to this. I am happy with the way the wizard works and the info it collects, but we want to be in control of who is allowed to log into our site. Ideally, if the user entered his own data and we were...
  20. AndyInNC

    Why is my collection empty in page_load?

    You're right. There's nobody here to look over my shoulder. The problem was that the grid is inside a loginView. I realized it as soon as you said that about the grid (which, indeed, is barebones at this point). Thanks for the help!

Part and Inventory Search

Back
Top