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!

Register Log in
  • Congratulations derfloh 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. HotBob

    link button

    This method doesn't work for some reason!
  2. HotBob

    link button

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

    setting new page properties

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

    setting new page properties

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

    Text Box

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

    Refresh Page

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

    Hyphens(') problem

    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?
  8. HotBob

    Server Undefined

    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 =...
  9. HotBob

    Excel in Dreamweaver

    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?
  10. HotBob

    Running a stored proceduere with a variable

    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', ''...
  11. HotBob

    Running a stored proceduere with a variable

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

    Running a stored proceduere with a variable

    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'...
  13. HotBob

    html Buttons

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

    Property in control

    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?
  15. HotBob

    Property in control

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

    Excel

    I installed excel onto the server and now nothing happens even if I place this code in a blank asp page. Any ideas? <HTML> <HEAD> </HEAD> <body bottomMargin="0" leftMargin="0" topMargin="0" rightMargin="0" marginwidth="0" marginheight="0"> </body> </HTML> <% Dim xls Set xls =...
  17. HotBob

    Excel

    excel isn't installed on the server. Any ideas?
  18. HotBob

    Excel

    Hi there, hopefully not another Excel question but I have the folllowing code <form ACTION="<%=Request.Servervariables("URL")%>" METHOD="Post" name="search" id="search" > <% Dim xls Set xls = CreateObject("Excel.Application") with xls .Application.Visible = TRUE...
  19. HotBob

    sub call from Image

    I want to call VBScript not Javascript
  20. HotBob

    sub call from Image

    Hi, I have a image on my form and on the click event I want to call a sub. Has anyone got an example. Thanks

Part and Inventory Search

Back
Top