Search results for query: *

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 = ''...

okay, thanks I thought of the whole purpose of "using" was that the connection was closed automatically and you don't need to do a con.close() ? I guess it wouldn't hurt

okay, I understand. is the below code fine or did I miss something. since I'm using "try" do I need to dispose or con ? Using con As SqlConnection = New SqlConnection(My_Con) Dim cmd As New SqlCommand cmd.Connection = con...

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

Thank you...

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

Thank you sorry for not posting the markup, it's basically just a blank page I'm starting with. Should I wrap all the div's into another div as a wrapper ?

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

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

Olaf, that worked. thank you so much. appreciate it

so, here is what I have so far SELECT document_number, qty = (SELECT COUNT(O.document_number) FROM TABLE1 O WHERE O.document_number= C.document_number) FROM TABLE2 C This gets me the counts I'm looking for but I now need to be able to select more fields from TABLE1. I've...

Thanks, when I do that it's counting all the records within those joins

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

This worked for what I need to do... due_date<GETDATE()+10 thanks for that. I don't know why I was stuck on the between factor. you guys gave me a lot of info and I appreciate it. I will use this info for the future as well. Thanks again guys

thanks for the info Olaf.... I'm not an expert like you so that's why I asked the question in the first place. I appreciate your time and help. BTW, I'm searching for those sesame street episodes right now, great stuff. [2thumbsup]

so if due_date = 08/11/2017 and it's now 08/12/2017 then GETDATE() would not show any records that are < then GETDATE() what I now need to do is show the records that the due_date is < "Today" and also due 10 days from "Today" so if the due_date has passed I still need to show it.

thanks everyone for your info and examples, I appreciate it. I ended up using DUE_DATE BETWEEN GETDATE() - 1 AND GETDATE() + 10 Now, I have another question how would you use BETWEEN < GETDATE() AND GETDATE() + 10 ??? I get a syntax error on the <

Thanks for the info Sorry, here is more detail... DUE_DATE field is datetime and the data looks like this; 2016-12-31 00:00:00.000

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

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