Recent content by dvannoy

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]