This message is in MIME format. Since your mail reader does not understand

this format, some or all of this message may not be legible.



------_=_NextPart_001_01C0B2FC.26C200C8

Content-Type: text/plain;

	charset="utf-7"



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

---

You are currently subscribed to asp+AF8-databases as: mario+AEA-tonicdesign.co.uk


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