Search results for query: *

Hello, I have two tables, each with an audit trail trigger. It is copying two field values I need to the destination (audit) trail table. What I'm not sure how to do is grab the value of the table that the values are actually coming from. If someone could please show me how to do this or point...

Hello, I have an Access 2003 app that has a tab control with a 3-table join query (QBE) as the data source. So, as you go through the 4 tabs you obviously see the same data. I have a combo box with two values (data source is a local lookup table). I would like to be able to switch to a...

Hello, I have a parent and child subform which are linked by two values [TID2] and [BankDate]: Link Child Fields: [TID2];BankDate Link Master Fields: [TID2];BankDate My understanding is that these two values form a unique composite key. However, it seems that records with a duplicate TID2 are...

Hello, here is the join in my stored proc: dbo.TEST AS o INNER JOIN dbo.TEST2 AS i ON LTRIM(RTRIM(o.ICD9_PC1)) = LTRIM(RTRIM(REPLACE(i.ICD9, '.', ''))) OR LTRIM(RTRIM(o.ICD9_PC2)) = LTRIM(RTRIM(REPLACE(i.ICD9, '.', ''))) OR...

Hello, I am about to create a new Intranet site. I have done a lot of SP development on existing sites, but only a couple of smaller test sites from scratch. This one is going to go into production. My understanding is that the best approach is to use the Publishing Portal Template to start...

Hello, I am trying to post xml to a webservice method that requires a complex data type. Otherwise, I could use the test harness for primitive types as is always supplied by default. I can consume the webservice method with another method, pass in parms, etc. But, I am having a problem with...

Hello, I know how to implement a RFV for a DDL, but I have 11 drop down lists and 1 TextBox. One of these 12 controls must have a value before submit. Is there any way to insure that the user will have to select one of the 11 drop downs or TextBox? I've tried client side validation using a...

Hello, I have the following code which I can step through in debug mode fine, and I receive the email, but without the attachment. I had a security/permission issue I've resolved, so if someone could take a peek and maybe see what I'm missing I'd sure appreciate it: Region " Send Email "...

Hello, No matter what I try my local web service works fine. I've been able to consume the web service locally with a test application that passes in parms to my web method. I've tried to send the xml sent as a separate attachment to the web service via http post and cannot get past a security...

Hello, I've inherited an ASP.NET, 3.5, C# application with what appear to be several precompiled assemblies in the bin folder: App_Code.compiled App_Code.dll App_Web_0-twcwe2.dll App_Web_2kqew1a-.dll App_Web_6zcdwfhm.dll App_Web_blw6-sk7.dll App_Web_uahiyv8u.dll I am trying to get under the...

Hello, I am importing a generic list into a class to test a webservice: Here is my TESTList class: Imports System.Collections.Generic <Serializable()> _ Public Class TESTList Inherits List(Of TEST) End Class Here is my class for the Getters and Setters: <Serializable()> _ Public Class...

Hello, I have a WebMethod that is using a non-primitive tyupe parm (actually a generict list). So, I cannot use the standard UI test harness to enter parms for testing. Can someone please show me how I could write a little test app to consume the web service. I saw this post which talks about...

Hello, I am testing a ASP.NET 2.0 webservice and I can't figure out why when I hit the url and use the test harness it tests fine, but passing the xml to it causes an error. Here is the xml error: System.InvalidOperationException: There is an error in XML document (16, 34). ---&gt...

Hello, I'm firing this insert trigger but no data is being returned to the email, I think because it is firing before the commit: set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER TRIGGER [dbo].[trTestNotifyShipperIns] ON [dbo].[flight] FOR INSERT AS BEGIN Declare @flight_id as...

Hello, I have a query which I am adding a service_id parameter to like so: If Me.strServiceLevel <> "0" Then cmd.Parameters.Add(New SqlParameter("@strServiceID", SqlDbType.NVarChar)) cmd.Parameters("@strServiceID").Value = Me.strServiceLevel End If I am passing...

Hello, I have list box values than I'm going to multi select like so: Dim cmdServiceLevel As New SqlCommand Dim dtrServiceLevel As SqlDataReader strSQL = "SELECT distinct s.service_id, '(' + s.service_id + ') ' + s.name as name " & _ "FROM service_class s " & _...

Hello, Sorry for the repost, but I had no reply from the asp.net group, and the language for my project is VB.NET so I thought I would try here. I am trying to get the output for: DateTime.Now.ToString("yyMMddHHmmssffff") The problem is all I get back as display is: 090701133 From what I'm...

Hello, I am trying to get the output for: DateTime.Now.ToString("yyMMddHHmmssffff") The problem is all I get back as display is: 090701133 Can someone please tell me what I need to do? From what I'm seeing on MSDN this "should" work, but it seems I'm only getting back the yyMMdd part(090701)...

Hello all, Could someone please show me how I could parse out the numeric value from an option selected value? Once I have this value then I can perform a calculation and return the value beside the control: <option value="">Choose One</option> <option selected="selected" value="Dell...

Hello, I'm using RequiredFieldValidators which are working fine, but need to open a popup window with the validation summary list as well? Can someone please show me an example of how this would be done? I've searched but can't seem to find an example of this. Also, my page is moving to the...