Combobox problem...

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • rhepsi
    New Member
    • Apr 2007
    • 111

    #1

    Combobox problem...

    Hii All,

    i have a form, where when i select combobox(catego ry), project combobox, and click on insert,
    if already the same is present in the database then i should pop a message saying Already given select other category and project...

    For this when im trying to write in: IsValidForm()

    do i need to write the sql query that is select the category_id and the project id???
    or someother..

    plz some one help...its really urgent

    thnx in advance
    Last edited by rhepsi; Jul 3 '07, 07:13 AM. Reason: mistake
  • kenobewan
    Recognized Expert Specialist
    • Dec 2006
    • 4871

    #2
    Its faster to query the database with the primary id. HTH.

    Comment

    • rhepsi
      New Member
      • Apr 2007
      • 111

      #3
      Originally posted by kenobewan
      Its faster to query the database with the primary id. HTH.

      thnx....

      can u please show some example.. plz..

      for manager ,category_id=1

      tbl_staff_assig nments.sta_cate gory_id_fk = 1

      then pr_project_id_p k= ??? wat shd i give??

      i have abt 53 projects...

      Gimme Some sample code so tht i can write it...



      thnx n regards
      hepsi

      Comment

      Working...