Drop Down List - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

Drop Down List

Last post 11-16-2007 04:16 AM by adamrharding. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 11-08-2007 08:57 AM

    Drop Down List

    I have a form that I use to collet billing information.  I have 3 drop down lists in the form that is filled using a secondary data source.  I created the data connection with the following information:

    1. https://MyServer/qdabrawebservice/databaseenumerationservice.asmx?WSDL

    2. GetColumnsForRows

    3. (ns1:database = PIMS) and ( ns1:table = Infov_Therapist)

    TheInfov_Therapist is a list of Therapist along with their UserID (Primary Key). The view sorts correctly when the columns are in the following order:

     SELECT     TOP (2147483647) UserName, UserName + ' ( ' + Title + ')' AS TherapistUserName, UserID, EmailAddress, Title, First + ' ' + Last AS FullName
    FROM         dbo.Users
    WHERE     (Title LIKE '%PT%') OR
                          (Title LIKE '%OT%') OR
                          (Title LIKE '%MT%')
    ORDER BY UserName

    The view sorts Incorrectly when the columns are in the following order:

    SELECT     TOP (2147483647) UserID, UserName, UserName + ' ( ' + Title + ')' AS TherapistUserName, EmailAddress, Title, First + ' ' + Last AS FullName
    FROM         dbo.Users
    WHERE     (Title LIKE '%PT%') OR
                          (Title LIKE '%OT%') OR
                          (Title LIKE '%MT%')
    ORDER BY UserName

     

  • 11-16-2007 04:16 AM In reply to

    Hi

    I think this is becuase it sorts by the first record in the field list so put the username before the userID and that shoudl work fine if my understanding is correct.

    cheers

    Adam Harding
    Wales
    UK
Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.