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 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: dvannoy
  • Content: Threads
  • Order by date
  1. dvannoy

    Enable ASP button

    I have an asp button on a page that is disabled by default. I want to create a function that OnKeyPress event of a text box the button will get enabled. I've tried a few different options but nothing works. document.getElementById('Button1').disabled = ''...
  2. dvannoy

    closing connection

    question.... is con.close() enough to close the connection ? or should I also add con.dispose() ? I have been getting a message stating "Timeout expired. the timeout period elapsed prior to a connection from the pool. This may have occurred because all pooled connections were in use and...
  3. dvannoy

    Two Select Statments

    I have a simple innerjoin as shown below SELECT MyTable1.Field1 MyTable2.Field1 FROM MyTable1 INNER JOIN MyTable2 ON MyTable1.ID = MyTable2.ID What I'm trying to do check a third table to see if a record was created that relates to any of the innerjoin records. The results...
  4. dvannoy

    Simple Layout

    I'm trying to create a simple layout to be used on an asp.net master page. I would like the header and menu to stay in position while the content scrolls up or down. Also the footer to stay at the bottom of the page at all times Example of what I'm looking to do...
  5. dvannoy

    apostrophe in var

    I'm getting a value from a label on a webform and passing it to another form using the code below. var value = '<%= l10.Text %>'; the problem is when there is an apostrophe within the text. since i never will know what text the label will have, how can I ignore the apostrophe within the...
  6. dvannoy

    Counting with 3 tables

    I have the below query with an inner join that works like I want. But, I now need to join a third table and get a count of a specific field. SELECT TABLE1.FIELD1 ,TABLE2.FIELD1 ,TABLE2.FIELD2 ,TABLE1.FIELD2 ,COUNT(TABLE1.FIELD3) AS QTY FROM TABLE2 INNER JOIN TABLE1 ON...
  7. dvannoy

    Using GETDATE

    I have a field called DUE_DATE I'm trying to show records that have a DUE_DATE of today and anything 10 days out in between. The below shows 10 days out but does not show today's records. DUE_DATE BETWEEN GETDATE() AND GETDATE() + 10 any help would be appreciated thanks
  8. dvannoy

    Subtraction Issue

    I have a query that has an inner join. everything works fine except I'm trying to subtract two fields to get a remaining balance. both fields are int. SUM(MY_TABLE.TRANSFERED) AS TRANSFERED ,SUM(MY_TABLE.RECEIVED - MY_TABLE.TRANSFERED) AS REMAINING what is happening is the value will not...
  9. dvannoy

    Session Timeout Question

    I need some info on how to handle session time outs on web forms. So, I have the following code on each one of my pages form load event; If Not IsPostBack Then If Session("User") IsNot Nothing AndAlso Session("Group") IsNot Nothing Then ' let them access the page...
  10. dvannoy

    Show Table Structure with Description

    I'm trying to get the table structure including the field descriptions. There are several examples of how to do this but how do I get the field description included in the information schema ? SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'MyTable' ORDER BY ORDINAL_POSITION Any...
  11. dvannoy

    Update a Field Based on DATEDIFF

    I have a field called STATUS. I'm trying to run a procedure that will update the field STATUS if the below code results are > 8 days SELECT DATEDIFF(DAY, DATE_FIELD, GETDATE()) AS DAYS_IN_QUE FROM TABLE any help would be appreciated thanks
  12. dvannoy

    Full Screen Mode

    I would like to set my web application into full screen mode (F11). I'm looking at what might be the best way to handle this or if this is even possible or recommended. Would like some feedback or ideas if possible. Thanks in advance.
  13. dvannoy

    windows 10 tablet - default keyboard layout

    is it possible on a windows 10 tablet to make the tablet keyboard default to the numeric keypad? If so, how ? I've been searching and can't find anything on this. we have an app that users will mostly type numeric values and changing back and forth from text to numeric gets old real fast...
  14. dvannoy

    Count Several fields in same row

    I'm trying to count records that are past due. table has 5 dates and a field called type e.g. date_1, date_2, date_3, date_4, date_5, type I'm trying to count the above dates based on <getdate() and group them by type. so the results would show something like this type date_1 date_2...
  15. dvannoy

    Validate

    I need to display a message if a textbox is not empty but a combox box is. all examples I have found check if a single textbox is empty. so if txt1 has txt but cbo1 does not, I would like a message displayed. I'm trying to do this using java script because my room on my asp.net form is...
  16. dvannoy

    html sql email and body formatting

    I'm using the below code to send out an html email using sql server 2012. I'm trying to include the @count inside the html message but can't get it to work. I've tried (' + @count +') as well. Declare @count int = 0 DECLARE @Body NVARCHAR(2000) SELECT @count = COUNT(1) FROM MY_TABLE WHERE...
  17. dvannoy

    Using two css files within a master page

    I'm trying to use two different css styles in my master page. both files are exactly the same except one expands the form wider. In my master page I have the following; <head runat="server"> <meta http-equiv="content-type" content="text/html; charset=utf-8" /> <title></title>...
  18. dvannoy

    Center a div within an asp.net content placeholder

    I'm trying to set a div to to 100% hieght and to the center of the content placeholder in my asp.net masterpage. I can't seem to get it to work. my css is below any help woudl be appreciated .maindiv { position:fixed center !important; display:inline-block; background-color...
  19. dvannoy

    Custom Errors Not Working

    I'm trying to setup a custom error section in my web.config file. I've been researching how to do this and have tried several examples but can't seem to make this work. I'm trying to get rid of the yellow application error screens that could show. This is my latest web.config entry...
  20. dvannoy

    How not to show duplicate rows on a join query

    I have two tables Table 1 and Table 2 Now, in Table 1 the data could look like this all on 1 row Number Result 1 Result 2 Result 3 100 7.1 7.8 6.4 Table 2 has multiple rows Number Test Percent 100 abc 1.3 100 cde 12.9 100...

Part and Inventory Search

Back
Top