right records please

Results 1 to 2 of 2

Thread: right records please

  1. #1
    Join Date
    Dec 1969

    Default right records please

    I have 3 calendar images, 3 mugs, and 2 bags in the recordset. They have different project_id but their var_id are similar(such as all calendars has a var_id=1; all mugs have var_id=2). Now from the recordset, I only need one image of each type to display such as 1 calendar, 1 mug, and 1 bag. Can you please help me?

  2. #2
    Join Date
    Dec 1969

    Default RE: right records please

    You can prepare a seperate Recordset Object, where u can get each image for each criteria i.e calendar, mugs and so on.<BR><BR>To do this,<BR><BR>Set con = Server.CreateObject("ADODB.Connection")<BR>Set rs = Server.CreateObject("ADODB.RecordSet")<BR>con.open m_connstring<BR>rs.Open "Select distinct var_id from tbl_name", con, 2,3<BR><BR>Have you seen www11.ewebcity.com/aspindia<BR><BR><BR><BR>

Posting Permissions

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