formatting sql recordset

gleech · #1 (**permalink**) 05-06-03, 06:45

Dear All,

I have some SQL data which I want to format using VBScript on an ASP page. The SQL data is like this:

FieldName data1
FieldName data2
FieldName data3
FieldName data4

I want to format the front-end code so it reads like this:

FieldName data1
data2
data3
data4

Can anyone help?

Cheers

Gill

rhs98 · #2 (**permalink**) 05-06-03, 08:03

What is the problem your having?

Is it that you do not know where to start? If so, read the ASP guide on http://www.w3schools.com to save us having to explain it again. Or use Google.

It would be something like this

Code:

'create and open the rs
while not(rs.eof or rs.bof)
 for x=1 to 4
   if x=1 then
    response.write rs.fields(1).name & " "
  end if
  response.write rs.fields(x).value & "<br />"
 next
 rs.movenext
endw
'close rs and set to nothing

Internet Services

Web Development

Digital Marketing

Consumer Tech