multiple response query

Results 1 to 2 of 2

Thread: multiple response query

  1. #1
    Join Date
    Dec 1969

    Default multiple response query

    Select * FROM tmpOrderAttr Inner Join sfAttrib ON sfAttrib.attrdtID = tmpOrderAttr.odrattrtmpAttrID WHERE tmpOrderAttr.odrattrtmpID = Session("sessionID")<BR><BR>After the information has been pulled from the database I need to be able to complete the following statement:<BR>If sfAttrib.attrdtName = MP3 do not apply shipping but if there are more than one sfAttrib.attrdtName and one of them does not equal MP3 then apply the shipping to those.<BR><BR>Can anyone help me with how this might work. I am thinking a For each or do while loop. But beyond that I am not sure how to process the information to find out if there are more than one attributes to a particular order. <BR><BR>Erika

  2. #2
    Join Date
    Dec 1969

    Default if I comprehend properly....

    Do While Not rs.eof<BR>If rs("attrdtName") &#060;&#062; "MP3" then<BR> &#060;apply shipping&#062;<BR>End If<BR>rs.movenext<BR>Loop

Posting Permissions

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