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

Borislav , There is one more thing. I can run the SQL for the trigger in QA and get results fine, but when the actual trigger fires nothing happens, no email. After more testing I discovered that when a value is updated in our application two new records are inserted into this same table, one...

Thank you Boris. Of course, I should have seen that with the INSERTED table. Thank you very much.

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

Thank you RiverGuy. Much obliged.

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 " & _...

Thank you huggyboy. I think it is being truncated, although I didn't see why at first. Thanks for your replay and feedback. I really appreciate you taking the time. Best Regards, Alejandro