Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Location
    Singapore
    Posts
    31

    Unanswered: Help in database !

    i have to join 2 table together and retrieve value from 2 table
    i have a car and rental table

    <%
    set oRS = server.createobject("ADODB.recordset")
    SQL = "SELECT * FROM Rental R,Car C where R.Model = C.Model"
    'oRS.Open SQL , oC, adOpenDynamic, adLockOptimistic, adCmdText
    %>

    response.write(oRS("Daily Rate"))

    ADODB.Recordset error '800a0cc1'

    Item cannot be found in the collection corresponding to the requested name or ordinal.

    but this error occurs.
    daily rate is from car table.
    how?

  2. #2
    Join Date
    Oct 2003
    Location
    Canada
    Posts
    574
    Your Daily Rate column has a space.
    Try response.write(oRS("[Daily Rate]"))
    or get rid of the space in the name and try again.

Posting Permissions

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