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: *

  • Users: DH
  • Order by date
  1. DH

    SQL Split

    Hello, I have field which currently allows users to enter the ages of their children. Currently this information is entered in one field in the following format 2,12 which means 2 children of ages 2 and 12. The following sql statement returns the information in one row: SELECT...
  2. DH

    Parse URL Address

    ...Dim domainName As String = "mysite.com" Dim urlPath As String = "http://www.mysite.com/foo" Dim regexPattern As String = String.Format("^https?://(.*?)?\.?{0}/(.*?)?/?$", domainName.Replace(".", "\.")) Dim reMatch As Match = Regex.Match(URL, regexPattern) Response.write(reMatch.Groups(2))...
  3. DH

    Parse URL Address

    Hmmn. don't follow you. I will not know what the value is until I parse it from the URL, so a variable will not help in this case. I need to extract it from the URL at which time I will store it in a variable. DH
  4. DH

    Parse URL Address

    Requirement in this case is that the 'Foo' part is dynamic and will never been the same. DH
  5. DH

    Parse URL Address

    Hello, Any suggestions or examples on how to use a regular expression to parse a url address? For example, if the URL address is: http://www.mysite.com/foo -or- http://www.mysite.com/foo/anythingelse I am interested in grabbing the 'foo' part. DH
  6. DH

    Delete Rows from a DataTable

    I display the rows in a datagrid, each row of the datagrid has a checkbox which allows the user to select a row. I then loop through the datagrid rows to grab the ids for the selected rows.
  7. DH

    Delete Rows from a DataTable

    I'm having a little trouble finding the index of a row when I only know the value of a field. For example, I have a column named 'invoiceNumber' with a value '12345' DH
  8. DH

    Delete Rows from a DataTable

    Hello, I am using the following code to create a dataTable: Shared Function GetDataTable() As DataTable Dim da As SqlDataAdapter Dim ds As New DataSet Dim sConn As String = ConfigurationSettings.AppSettings("SqlConnection1.ConnectionString") Dim oConn As...
  9. DH

    Increment date using loop

    Awesome, works perfect! Thanks for your help 2night. DH
  10. DH

    Increment date using loop

    As an example, lets say I have the follwing exampleTable with 2 columns and data like so: userId expirationDate --------- -------------- 8 6/05/2006 24 6/15/2006 30 6/22/2006 I would like to use the following WHERE clause to grab certain rows of data: SELECT...
  11. DH

    Increment each record returned by 1

    Hello, I am writing a query to return results to use in a export file. One of the columns is I need to manually create is 'assetID' and per the specs, I need to: "Starting with the value of 1, increment 'assetID' for each record created. For simple example the following: USE Northwind...
  12. DH

    Show/Hide Panels Inline

    Thank you! DH
  13. DH

    Show/Hide Panels Inline

    Hello, I am using the folling code to hide or display a panel depending on which radio button has been selected. computer selected: display panel1 hide panel2 website selected: display panel2 hide panel1 Works fine except that when the 'website' radio button is selected 'panel2' displays but...
  14. DH

    SQL Stored Proc - Passing parameter for IN clause

    Thanks ESquared, I ended up using the link you provided above along with http://www.4guysfromrolla.com/webtech/031004-1.shtml to arrive at a solution. I created the following User Defined Function (UDF): CREATE FUNCTION dbo.Split ( @List nvarchar(2000), @SplitOn nvarchar(5) )...
  15. DH

    SQL Stored Proc - Passing parameter for IN clause

    Thanks ESquared, I will check out the fixed-length array link now! DH
  16. DH

    SQL Stored Proc - Passing parameter for IN clause

    Thank you everyone for your help so far. Here is what I have come up with so far: I build the SQL Select statement dynamically in asp.net/vb.net and pass it to the following stored proc: CREATE PROCEDURE [dbo].[Read_Address_List] @strSQL nvarchar(500) AS exec(@strSQL) GO This works fine...
  17. DH

    SQL Stored Proc - Passing parameter for IN clause

    Hello, Need help passing in the following string of fileID numbers to use in the stored procedure shown below. I would like the stored proc to return information for all users with the following fileID numbers (these fileID numbers are dynamically generated so I need to pass in on the fly)...
  18. DH

    Checkbox Select/Deselect All Problem

    ...id of 'DeleteThis'? I am not very familar with Javascript and any help will be very appreciated! Javascript: <script language=JavaScript> <!-- /*Using modified select_deselectAll script function of my original one, from Developerfusion.com forum members - ketcapli & thombo Forum Post -...
  19. DH

    String remove last ; semicolon

    tsuji thanks for the help! Can I ask you one more question... I create a variable for the value of a textbox like so: var emailString = document.Form1.txtEmail.value; I would like to test the variable to see if the variable ends with a semicolon and if not concatenate a semicolon to the...
  20. DH

    String remove last ; semicolon

    I am not to familar with JavaScript and would like to: 1.) test if a string ends with a semicolon ; 2.) if string ends in semicolon ; then remove the semicolon ; Original String: email1@domain.com; email2@domain.com; I would like to end up with the following string: email1@domain.com...

Part and Inventory Search

Back
Top