This is a multi-part message in MIME format.



------=_NextPart_000_0013_01C0B2D1.6B53B1D0

Content-Type: text/plain;

	charset="utf-7"

Content-Transfer-Encoding: quoted-printable



RE: +AFs-asp+AF8-databases+AF0- RE: how?hey, it works :-)



Daniel



  -----Original Message-----

  From: Marios Adamantopoulos 

+AFs-mailto:mario+AEA-TonicDesign.co.uk+AF0-

  Sent: Thursday, March 22, 2001 1:16 PM

  To: ASP Databases

  Subject: +AFs-asp+AF8-databases+AF0- RE: +AFs-asp+AF8-databases+AF0- 

RE: how?





  Actually  I found the solution... this kind of stupid way



  The problem if that when I don't get any values from the database

  it gives me an error...



  How can I put a space character for example, if there is data returned 

from the database?



  Thanks in advance.



  New Code below

  --------------------------



  +ADw-table width+AD0AIg-100+ACUAIg- cellspacing+AD0AIg-0+ACI- 

cellpadding+AD0AIg-0+ACI- border+AD0AIg-0+ACIAPg-

  +ADw-tr valign+AD0-top+AD4-

      +ADw-td+AD4APA-img src+AD0AIg-img/px.gif+ACI- width+AD0AIg-15+ACI- 

height+AD0AIg-1+ACI- border+AD0AIg-0+ACI- alt+AD0AIgAiAD4APA-/td+AD4-

      +ADw-td class+AD0-copyResults width+AD0-25+ACUAPg-

  +ADwAJQ-

  dim mycount

  mycount +AD0- 1



  Do while not oRS.EOF

  if mycount +AD4- 0 and mycount +ADw-8 Then

          response.write +ACIAPA-a 

href+AD0-'portfolio+AF8-personal.asp?tonic-id+AD0AIg- +ACY- 

oRS(+ACI-artistid+ACI-) +ACY- +ACIAJg-tonic-topicid+AD0AIg- +ACY- 

oRS(+ACI-topicid+ACI-) +ACY- +ACI-'+AD4AIg- +ACY- 

oRS(+ACI-artistname+ACI-) +ACY- +ACIAPA-/a+AD4APA-br+AD4AIg-



  End if

  mycount +AD0-mycount +- 1

  oRS.movenext

  loop

  oRS.movefirst

  +ACUAPg-

          +ADw-/td+AD4-

      +ADw-td+AD4APA-img src+AD0AIg-img/px.gif+ACI- width+AD0AIg-15+ACI- 

height+AD0AIg-1+ACI- border+AD0AIg-0+ACI- alt+AD0AIgAiAD4APA-/td+AD4-

      +ADw-td class+AD0-copyResults width+AD0-25+ACUAPg-

          +ADwAJQ-

  mycount +AD0- 1



  Do while not oRS.EOF

  if mycount +AD4- 7 and mycount +ADw-15 Then

          response.write +ACIAPA-a 

href+AD0-'portfolio+AF8-personal.asp?tonic-id+AD0AIg- +ACY- 

oRS(+ACI-artistid+ACI-) +ACY- +ACIAJg-tonic-topicid+AD0AIg- +ACY- 

oRS(+ACI-topicid+ACI-) +ACY- +ACI-'+AD4AIg- +ACY- 

oRS(+ACI-artistname+ACI-) +ACY- +ACIAPA-/a+AD4APA-br+AD4AIg-



  End if

  mycount +AD0-mycount +- 1

  oRS.movenext

  loop

  oRS.movefirst

  +ACUAPg-

          +ADw-/td+AD4-

      +ADw-td+AD4APA-img src+AD0AIg-img/px.gif+ACI- width+AD0AIg-15+ACI- 

height+AD0AIg-1+ACI- border+AD0AIg-0+ACI- alt+AD0AIgAiAD4APA-/td+AD4-

          +ADw-td class+AD0-copyResults width+AD0-25+ACUAPg-

          +ADwAJQ-

  mycount +AD0- 1



  Do while not oRS.EOF

  if mycount +AD4- 14 and mycount +ADw-22 Then

          response.write +ACIAPA-a 

href+AD0-'portfolio+AF8-personal.asp?tonic-id+AD0AIg- +ACY- 

oRS(+ACI-artistid+ACI-) +ACY- +ACIAJg-tonic-topicid+AD0AIg- +ACY- 

oRS(+ACI-topicid+ACI-) +ACY- +ACI-'+AD4AIg- +ACY- 

oRS(+ACI-artistname+ACI-) +ACY- +ACIAPA-/a+AD4APA-br+AD4AIg-



  End if

  mycount +AD0-mycount +- 1

  oRS.movenext

  loop

  oRS.movefirst

  +ACUAPg-

          +ADw-/td+AD4-

      +ADw-td+AD4APA-img src+AD0AIg-img/px.gif+ACI- width+AD0AIg-15+ACI- 

height+AD0AIg-1+ACI- border+AD0AIg-0+ACI- alt+AD0AIgAiAD4APA-/td+AD4-

          +ADw-td class+AD0-copyResults width+AD0-25+ACUAPg-

          +ADwAJQ-

  mycount +AD0- 1



  Do while not oRS.EOF

  if mycount +AD4- 21 and mycount +ADw-28 Then

          response.write +ACIAPA-a 

href+AD0-'portfolio+AF8-personal.asp?tonic-id+AD0AIg- +ACY- 

oRS(+ACI-artistid+ACI-) +ACY- +ACIAJg-tonic-topicid+AD0AIg- +ACY- 

oRS(+ACI-topicid+ACI-) +ACY- +ACI-'+AD4AIg- +ACY- 

oRS(+ACI-artistname+ACI-) +ACY- +ACIAPA-/a+AD4APA-br+AD4AIg-



  End if

  mycount +AD0-mycount +- 1

  oRS.movenext

  loop

  oRS.movefirst

  +ACUAPg-

          +ADw-/td+AD4-

      +ADw-td+AD4APA-img src+AD0AIg-img/px.gif+ACI- width+AD0AIg-15+ACI- 

height+AD0AIg-1+ACI- border+AD0AIg-0+ACI- alt+AD0AIgAiAD4APA-/td+AD4-

  +ADw-/tr+AD4-

  +ADw-/table+AD4-



  +AF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBf-

  Marios Adamantopoulos

  Web Developer



  Tonic Design Limited

  Studio 2, Church Studios

  Camden Park Road

  London NW1 9AY



  Tel +-44 (0)20 7691 2227

  Fax +-44 (0)20 7691 2228

  Mob +-44(0)7904 221 663



  www.tonicdesign.co.uk

  

.........................................................................

.......................................

  Opinions, conclusions and other information in this message

  that do not relate to the official business of Tonic Design Ltd

  shall be understood as neither given nor endorsed by them.

  

.........................................................................

.......................................







  -----Original Message-----

  From: Marios Adamantopoulos 

+AFs-mailto:mario+AEA-TonicDesign.co.uk+AF0-

  Sent: 22 March 2001 18:01

  To: ASP Databases

  Subject: +AFs-asp+AF8-databases+AF0- RE: how?







  Thanks all, for your responses,

  the thing is that I don't want to scan horizontally...



  In the first column I have the following(just for testing though+ADs-

  I don't want all the results on the first table.



  --------------

  +ADwAJQ-

  Do while not oRS.EOF

          response.write +ACIAPA-a 

href+AD0-'portfolio+AF8-personal.asp?tonic-id+AD0AIg- +ACY-

  oRS(+ACI-artistid+ACI-) +ACY- +ACIAJg-tonic-topicid+AD0AIg- +ACY- 

oRS(+ACI-topicid+ACI-) +ACY- +ACI-'+AD4AIg- +ACY-

  oRS(+ACI-artistname+ACI-) +ACY- +ACIAPA-/a+AD4APA-br+AD4AIg-

  oRS.movenext

  loop

  +ACUAPg-

  --------------

  Here is the table I'm trying to create

  --------------



  +ADw-table+AD4-

   +ADw-tr+AD4-

      +ADw-td class+AD0-copyResults width+AD0-25+ACUAPg-

                  +ADw-a 

href+AD0AIg-portfolio+AF8-personal.html+ACIAPg-adrian 

green+ADw-/a+AD4APA-br+AD4-

                  +ADw-a 

href+AD0AIg-portfolio+AF8-personal.html+ACIAPg-adrian 

myers+ADw-/a+AD4APA-br+AD4-

                  +ADw-a 

href+AD0AIg-portfolio+AF8-personal.html+ACIAPg-allison 

fennel+ADw-/a+AD4APA-br+AD4-

                  +ADw-a 

href+AD0AIg-portfolio+AF8-personal.html+ACIAPg-caroline 

harding+ADw-/a+AD4APA-br+AD4-

                  +ADw-a 

href+AD0AIg-portfolio+AF8-personal.html+ACIAPg-allison 

fennel+ADw-/a+AD4APA-br+AD4-

                  +ADw-a 

href+AD0AIg-portfolio+AF8-personal.html+ACIAPg-caroline 

harding+ADw-/a+AD4APA-br+AD4-

          +ADw-/td+AD4-

      +ADw-td+AD4APA-img src+AD0AIg-img/px.gif+ACI- width+AD0AIg-15+ACI- 

height+AD0AIg-1+ACI- border+AD0AIg-0+ACI- alt+AD0AIgAiAD4APA-/td+AD4-

      +ADw-td class+AD0-copyResults width+AD0-25+ACUAPg-

                  +ADw-a 

href+AD0AIg-portfolio+AF8-personal.html+ACIAPg-adrian 

green+ADw-/a+AD4APA-br+AD4-

                  +ADw-a 

href+AD0AIg-portfolio+AF8-personal.html+ACIAPg-adrian 

myers+ADw-/a+AD4APA-br+AD4-

                  +ADw-a 

href+AD0AIg-portfolio+AF8-personal.html+ACIAPg-allison 

fennel+ADw-/a+AD4APA-br+AD4-

                  +ADw-a 

href+AD0AIg-portfolio+AF8-personal.html+ACIAPg-caroline 

harding+ADw-/a+AD4APA-br+AD4-

                  +ADw-a 

href+AD0AIg-portfolio+AF8-personal.html+ACIAPg-allison 

fennel+ADw-/a+AD4APA-br+AD4-

                  +ADw-a 

href+AD0AIg-portfolio+AF8-personal.html+ACIAPg-caroline 

harding+ADw-/a+AD4APA-br+AD4-

          +ADw-/td+AD4-

      +ADw-td+AD4APA-img src+AD0AIg-img/px.gif+ACI- width+AD0AIg-15+ACI- 

height+AD0AIg-1+ACI- border+AD0AIg-0+ACI- alt+AD0AIgAiAD4APA-/td+AD4-

          +ADw-td class+AD0-copyResults width+AD0-25+ACUAPg-

                  +ADw-a 

href+AD0AIg-portfolio+AF8-personal.html+ACIAPg-emma 

leon+ADw-/a+AD4APA-br+AD4-

                  +ADw-a 

href+AD0AIg-portfolio+AF8-personal.html+ACIAPg-glyn 

roberts+ADw-/a+AD4APA-br+AD4-

                  +ADw-a 

href+AD0AIg-portfolio+AF8-personal.html+ACIAPg-allison 

fennel+ADw-/a+AD4APA-br+AD4-

                  +ADw-a 

href+AD0AIg-portfolio+AF8-personal.html+ACIAPg-caroline 

harding+ADw-/a+AD4APA-br+AD4-

          +ADw-/td+AD4-

      +ADw-td+AD4APA-img src+AD0AIg-img/px.gif+ACI- width+AD0AIg-15+ACI- 

height+AD0AIg-1+ACI- border+AD0AIg-0+ACI- alt+AD0AIgAiAD4APA-/td+AD4-

          +ADw-td class+AD0-copyResults width+AD0-25+ACUAPg-

                  +ADw-a 

href+AD0AIg-portfolio+AF8-personal.html+ACIAPg-adrian 

green+ADw-/a+AD4APA-br+AD4-

                  +ADw-a 

href+AD0AIg-portfolio+AF8-personal.html+ACIAPg-adrian 

myers+ADw-/a+AD4APA-br+AD4-

                  +ADw-a 

href+AD0AIg-portfolio+AF8-personal.html+ACIAPg-allison 

fennel+ADw-/a+AD4APA-br+AD4-

                  +ADw-a 

href+AD0AIg-portfolio+AF8-personal.html+ACIAPg-caroline 

harding+ADw-/a+AD4APA-br+AD4-

          +ADw-/td+AD4-

      +ADw-td+AD4APA-img src+AD0AIg-img/px.gif+ACI- width+AD0AIg-15+ACI- 

height+AD0AIg-1+ACI- border+AD0AIg-0+ACI- alt+AD0AIgAiAD4APA-/td+AD4-

  +ADw-/tr+AD4-

  +ADw-/table+AD4-



  --------------



  +AF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBf-

  Marios Adamantopoulos

  Web Developer



  Tonic Design Limited

  Studio 2, Church Studios

  Camden Park Road

  London NW1 9AY



  Tel  (0)20 7691 2227

  Fax  (0)20 7691 2228

  Mob (0)7904 221 663



  www.tonicdesign.co.uk



  ---

  SoftArtisans helps developers build robust, scalable Web 

applications+ACE-

  Excel Web reports, charts: 

http://www.softartisans.com/excelwriter.html

  File uploads: http://www.softartisans.com/saf.html

  Transactional file management: http://www.softartisans.com/saf1.html

  Scalability: http://www.softartisans.com/saxsession.html

  ASPstudio value pack: http://www.softartisans.com/aspstudiosuite.html



mario+AEA-tonicdesign.co.uk


leave-asp+AF8-databases-477561D+AEA-p2p.wrox.com



  --- SoftArtisans helps developers build robust, scalable Web 

applications+ACE- Excel Web reports, charts: 

http://www.softartisans.com/excelwriter.html File uploads: 

http://www.softartisans.com/saf.html Transactional file management: 

http://www.softartisans.com/saf1.html Scalability: 

http://www.softartisans.com/saxsession.html ASPstudio value pack: 

http://www.softartisans.com/aspstudiosuite.html --- You are currently 

subscribed to asp+AF8-databases as: dodorisio+AEA-home.com To 

unsubscribe send a blank email to 

leave-asp+AF8-databases-482936V+AEA-p2p.wrox.com