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!

  • Congratulations strongm 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: xcaliber2222
  • Order by date
  1. xcaliber2222

    Logging Origin Table in Audit Trail Trigger

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

    Change Tab View based on Combo Box Value

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

    Filtering Records Based on Linked Child and Master Fields

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

    Performance Issue with Inner Join

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

    Creating a New Intranet Site, Proof of Concept

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

    HTTP POST of XML/SOAP Request to ASP.NET 2.0 web service method

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

    Required Field Validator and Drop Down list

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

    Sending Email Attachment with ASP.NET 2.0

    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 "...
  9. xcaliber2222

    HTTP POST of XML to Web Service

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

    App_Web dlls

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

    Need Help Using a Generic List with a Webservice Class

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

    Consuming a web service with non-primitive type parameter

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

    HttpPost to WebService

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

    Insert Trigger Firing Before Commit?

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

    Insert Trigger Firing Before Commit?

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

    Insert Trigger Firing Before Commit?

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

    Parameterized Query Problem

    Thank you RiverGuy. Much obliged.
  18. xcaliber2222

    Parameterized Query Problem

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

    Passing Multiple ListBox Values to WHERE clause

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

    Output for DateTime string format

    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

Part and Inventory Search

Back
Top