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

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

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

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

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

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

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

Hello, For some reason I cannot set the write permission to a directory in my web application running on localhost. The operating system is XP Pro. I am receiving the following error: Error in Creating file. Error is System.UnauthorizedAccessException: Access to the path...

Hello, I am receiving the following error when trying to return the identity of the record just insterted... Error: String or binary data would be truncated. The statement has been terminated. The 'Insert_New_File' procedure attempted to return a status of NULL, which is not allowed. A status...

I am new to Encrypting and Decrypting text and would like to learn more. I am working with the following code from ASP.NET Unleased. The code encrypts text and saves the text to a file. I can then decrypt the file when needed. To learn more I would like to: 1.) Display the encrypted text on...

Users of my Access 2K application seem to have the following isolated instance from time to time: Within my application I have a form where users can click a locate button and then browse their machine and pull the path of an image file such as .gif, .bmp, .jpg, .jpeg, etc... into the form...

When opening a form tied to a query some users receive the "Query Too Complex" error, while other users do not and the form opens okay. Any reasons why some users may receive the error and other don't? I cannot re-create the error on my machine. Thanks, DH

In Access I can create a query with multiple tables and update multiple tables within the query. In learning SQL Server I have read that in SQL Server you can only update one base table within a view. I am new to SQL Server and wondering how to update multiple tables? Can someone explain or...

I have 2 input text boxes for users to enter a start date and end date to query the SQL database. Here is the code.... Else Dim searchdatestart Dim searchdateend searchdatestart = Session("searchdatestartquote") searchdateend = Session("searchdateendquote") cmdSelect = New...

I have built a site using Visual Studio.net and have published successfully. I would like to create a new Visual Studio.net project/solution and use all the same files of the original site again. This way I can re-use the majority of the aspx files, code-behind files, etc of the orignal...

I am trying to delete a record in a datagrid by clicking a delete link/button in the datagrid. I am receiving the following error when running the code below. Error: Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index Code...

Here is my scenario: Prior to form submission, If a user partially fills out a form and decides to visit another link they will loose the data they entered into the form. I would like to warn a user via a popup/alert that if they leave the current form they will loose the information they have...

What changes would need to be made to the following code snipped to make it late binding so that I do not need to reference the msoutl9.olb in the VBA references? Here is the code: Dim oOutlook As Outlook.Application Dim oAppt As Outlook.AppointmentItem Set oOutlook = New...