Search results for query: *

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

I guess the best way to put it that initially the value is unkown. A visitor to the site supplies the value as part of the URL so it will be unkown initially. I have been working with the following code that is working nicely but needs a little fine tuning: Dim domainName As String =...

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

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

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

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.

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

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

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

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

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

Thank you! DH

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

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

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

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

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

I am using the following Javascript shown below to check or uncheck all checkboxes with the id 'DeleteThis' in a asp.net datagrid. This functionality allows the user to select various records to be deleted for example. The problem is that I also have a radio button list named 'searchby' on the...

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

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