Database Query question

Results 1 to 2 of 2

Thread: Database Query question

  1. #1
    Vadim Guest

    Default Database Query question

    Hi, I wasn&#039t sure whether to post here or in the DB QA section.<BR><BR>Here goes: <BR><BR>I have a list of ID&#039s which I have parsed into a Session Array. <BR><BR>I wish to display (from the Database) all of those who are in the array and who have a certain flag set to ON. I will then create a link based on each record&#039s information. <BR><BR>The ID must have a flag set to ON, or else, it should not have a link created. <BR><BR>Following this, how do I create this dynamic DB call since this array can vary in size? Do I place a loop attaching SQL statments or something (as follows)?<BR><BR>SELECT * FROM table WHERE flag=ON &#062;&#062;AND/OR id = X1...Insert a loop here .. AND/OR id=Xn&#060;&#060; ??<BR><BR>Thanks for your time,<BR><BR>Vadim

  2. #2
    Vadim Guest

    Default RE: Database Query question

    This post has now been solved in the DB Q&A board by Bill... thanks again!<BR><BR>-Vadim

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts