Recent content by HotBob

This method doesn't work for some reason!

Hi there I have a link button in my datagrid and the link button opens up another page such as Private Sub dgStaff_ItemCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles dgStaff.ItemCommand Dim sb As New...

This dowsn't work Response.Write("<Script Language=JScript> 'window.open('PC.aspx?ID=' + document.getElementById('ddlPC1').value,'mywindow','width=360,height=180');</Script>") any ideas? Can i pass in a query string

Hi there, I have a button and when I click on it I want to be directed to another page, but I want this page to open in a new window and be of a certain height and width, any ideas? I need something like this Response.Redirect("PC.aspx?ID=" & ddlPC2.SelectedValue & "&w=300&h=300") but I need...

What is the html tag for a text box with multiple lines e.g a want a text box with 300 px width and 200 px height where multiline is present. Cheers.

Hi there, I am saving a page with a few items back to a database. However, when I overwrite my old values and press save the values in my text box go back to the previous value. Then if i press F5 the page refreshes and the new values appear. However, I want to see the new values straight...

What is the best way to deal with hyphens. I am passing in a search name into a sql query but if the name has a hyphen such as strName = o'connor Then I need to pass in the strName = o''connor Other wise it errors Any ideas?

Hi there I wanted to insert a record into a database using javascript, such as function InsertSP() { var strConn = 'Driver={SQL Server};Server=**;Database=**;Uid=**;Pwd=*;'; var oConn = Server.CreateObject("ADODB.Connection"); oConn.Open(strConn); var oRS =...

Hi there why doesn't this work <% Dim xlApp xlApp.Application.Visible = true Response.Write "Finish" Response.End %> How come I can't do this in dreamweaver?

sorted, for example... DECLARE @Ref Varchar(20) SET @Ref = 'S501734' DECLARE @String Varchar(8000) SET @String = '( creditor.account_no in (''' + @Ref + ''',''S510385'') ) ' print @String INSERT INTO #Output exec Tramps_Trial.tramps.spt_rep_payable_status @String, NULL, NULL, 'ZLV', ''...

It is very long. However, if I place the code INSERT INTO #Output exec spt_rep_payable_status '( creditor.account_no in (''S501734'',''S510385'') ) ', NULL, NULL, 'ZLV', '', '', '', '', 0, 0, 'Jul 20 2006', 'N', ',Approved,Paid,Part Paid,', ',Normal,', 'c', 'Y' It works fine. But the...

Hi there I am wanting to execute this stored procedure DECLARE @String Varchar(8000) SET @String = '''S501734'',''S510385''' INSERT INTO #Output exec spt_rep_payable_status '( creditor.account_no in (' + @String + ') ) ', NULL, NULL, 'ZLV', '', '', '', '', 0, 0, 'Jul 20 2006', 'N'...

Hi there, I have a form with a html button and I need to reference this in my sever side code. Say the button is named btmHTML.

Yes I did. It recognises the fact that there is a control. But when I use search1.source = "../MyPage.aspx" The property doesn't hold the value So the return is always nothing. Any ideas?

Hi there I have a control called Search and in that control I have a property such as: Dim _Source As String Public Property Source() As String Get Return _Source End Get Set(ByVal Value As String) _Source = Value End Set End...