SPONSORS:






User Tag List

Thanks Thanks:  0
Likes Likes:  0
Dislikes Dislikes:  0
Results 1 to 4 of 4
  1. #1
    Member
    Join Date
    Dec 2001
    Location
    Baton Rouge, LA, USA
    Posts
    407
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Using DataTable and not having a vaule in the fiel

    If there is no value in the column for the datatable the script throws an error each time. Bellow is some code this line crashes each time it is ran if there is not a value in the "ReasonCoverageEnded" field in the datatable please help

    Browser("eEnrollment - Member Informati").Page("eEnrollment - Member Informati").WebList("ddlSH_CobraReason").Select DataTable("ReasonCoverageEnded", dtGlobalSheet)
    Robby
    Geaux LSU

  2. #2
    Senior Member
    Join Date
    Feb 2007
    Location
    Pittsburgh, USA
    Posts
    429
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Using DataTable and not having a vaule in the

    It could be you are trying to select null value from weblist.

    Null is not equal to blank value.
    -Reddy

  3. #3
    Member
    Join Date
    Dec 2001
    Location
    Baton Rouge, LA, USA
    Posts
    407
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Using DataTable and not having a vaule in the

    yea it is probably trying to select a null value but how can you avoid that if a dropdown has a value sometimes and not others how to you write that like of code?
    Robby
    Geaux LSU

  4. #4
    Senior Member
    Join Date
    Feb 2007
    Location
    Pittsburgh, USA
    Posts
    429
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Using DataTable and not having a vaule in the

    If Trim(DataTable("ReasonCoverageEnded", dtGlobalSheet))<> "" Then
    Browser("eEnrollment - Member Informati").Page("eEnrollment - Member Informati").WebList("ddlSH_CobraReason").Select DataTable("ReasonCoverageEnded", dtGlobalSheet)
    Else
    Browser("eEnrollment - Member Informati").Page("eEnrollment - Member Informati").WebList("ddlSH_CobraReason").Select ""
    End If
    -Reddy

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Search Engine Optimisation provided by DragonByte SEO v2.0.36 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Resources saved on this page: MySQL 11.54%
vBulletin Optimisation provided by vB Optimise v2.6.4 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.2.8 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
vBNominate (Lite) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Feedback Buttons provided by Advanced Post Thanks / Like (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Username Changing provided by Username Change (Free) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
BetaSoft Inc.
Digital Point modules: Sphinx-based search
All times are GMT -8. The time now is 03:41 AM.

Copyright BetaSoft Inc.