What do you mean, Dave? Refer to whom where?

Imar

Imar you wrote...
>>And how do you think your application knows where to look for the data? How do you think it finds your Access database or SQL Server database??

My mistake. I messed up the Access connection string on previous page. I assume you were referring to that. I should have also called
variable" an object. This day has been too long man...

Ha, don't worry.... ;)

I was referring to this: This code just assigns an arbitrarily chosen variable name to the ActiveConnection, without actually passing in a valid connection string. Only later I realised the mix between the Recordset and the Command object in the code....

Cheers,

Imar

Good morning Guys :-) (Well it's morning here, lol)

Okay I have a question for you referring to this line here

        ' Now display the Placing stuff
        Response.Write(.Fields("BoatName").Value & "(" & _
               .Fields("SailNum").Value & ")<br />")

It is displayed like this boatName(SailNum) with the bracets. How can get it to display without them. Also My original idead was to have column headings for the Html Table, Like this.

(Headings) BOAT NAME SAIL #
(Recordset) BoatName SailNum

Is there any way I can pull this off?

Thanks



-----------------------------------------------------------
"Don't follow someone who's not going anywhere" John Mason

        Response.write "<table>"
        Response.write "<tr><td><b>BoatName</b><td>"
        Response.write "<td><b>Sail #</b><td></tr>"
   Do While Not .EOF
        If .Fields("Event").Value <> OldEventName Then
          OldEventName = .Fields("Event").Value
          Response.Write("<h2>" & .Fields("Event").Value & "</h2>")
        End If
        ' Now display the Placing stuff
        Response.write "<tr><td>"
        Response.Write(.Fields("BoatName").Value & "</td><td>" & _
               .Fields("SailNum").Value & "</td></tr>")
        .MoveNext()
   Loop
Response.write "</table>"

Hope this is what you were looking for.
Cheers!

_________________________
-Vijay G
Strive for Perfection

Okay I think I got it I just moved the Do While Not.Eof line, to before the table, like this

   Do While Not .EOF
        Response.write "<table>"
        Response.write "<tr><td><b>BoatName</b><td>"
        Response.write "<td><b>Sail #</b><td></tr>"

        If .Fields("Event").Value <> OldEventName Then
          OldEventName = .Fields("Event").Value
          Response.Write("<h2>" & .Fields("Event").Value & "</h2>")
        End If
        ' Now display the Placing stuff
        Response.write "<tr><td>"
        Response.Write(.Fields("BoatName").Value & "</td><td>" & _
               .Fields("SailNum").Value & "</td></tr>")
        .MoveNext()
   Loop
Response.write "</table>"


-----------------------------------------------------------
"Don't follow someone who's not going anywhere" John Mason

        Response.write "<table>"
   Do While Not .EOF
        If .Fields("Event").Value <> OldEventName Then
          OldEventName = .Fields("Event").Value
Response.Write("<h2>" & .Fields("Event").Value & "</h2>")
          Response.write "<tr><td><b>BoatName</b><td>"
          Response.write "<td><b>Sail #</b><td></tr>"
        End If
        ' Now display the Placing stuff
        Response.write "<tr><td>"
        Response.Write(.Fields("BoatName").Value & "</td><td>" & _
               .Fields("SailNum").Value & "</td></tr>")
        .MoveNext()
   Loop
Response.write "</table>"

Is this what you wanted? Hope I have understood;) that. lol
Cheers!

_________________________
-Vijay G
Strive for Perfection

Thanks happygv :):):):):):):)

That seems to work great, I just have to add more records and see if they display right.


-----------------------------------------------------------
"Don't follow someone who's not going anywhere" John Mason

Okay I know I am a pain but I have another question

When I have more than one record under this line
    ' Now display the Placing stuff
It makes it's own table and it dosen't look right
But if I move the Do while not.eof under the Response.write "<table border=1>" It dosen't work the way I want it too.

So the headings and first record make one table
Then any more records after that make there own table and don't line up under the headings.

  Do While Not .EOF
 Response.write "<table border=1>"

 If .Fields("Event").Value <> OldEventName Then
  OldEventName = .Fields("Event").Value

 Response.Write("<h2>" & .Fields("Event").Value & "</h2>")

 Response.write "<tr><td><b>BoatName</b></td>"
 Response.write "<td><b>Sail #</b></td>"
 Response.write "<td><b>Type</b></td>"
 Response.write "<td><b>Date</b></td>"
 Response.write "<td><b>Position</b></td>"
 Response.write "<td><b>Time</b></td></tr>"

End If

' Now display the Placing stuff

Response.write "<tr><td>"

Response.Write(.Fields("BoatName").Value & "</td><td>" & _
.Fields("SailNum").Value & "</td><td>" & _
.Fields("Type").Value & "</td><td>" & _
.Fields("RaceDate").Value & "</td><td>" & _
.Fields("Position").Value & "</td><td>" & _
 .Fields("RaceTime").Value & "</td><td></tr>")
.MoveNext()
   Loop

Response.write "</table>"

I think I need to loop seperatley through the bottom half under the
' Now display the Placing stuff
so it stays in the same table, instead of going back up to the top and looping through everything again

Thanks


-----------------------------------------------------------
"Don't follow someone who's not going anywhere" John Mason

There was one <TD> extra in your code between the RED code down there, I removed it and rearranged the code. Please see below. New code lines are bolded out.

Does this work the way you wanted?
Cheers!

_________________________
-Vijay G
Strive for Perfection