p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

asp_databases thread: can't display the words after the space


Message #1 by "shinetime" <shinetime@2...> on Mon, 10 Dec 2001 22:28:32 +0800
This is a multi-part message in MIME format.



------=_NextPart_000_0007_01C181CA.003206E0

Content-Type: text/plain;

	charset="big5"

Content-Transfer-Encoding: quoted-printable



hi,  all, 

i have a problem about display data from access in the browse.

 i can't display all the words of the field,  only the front.  for 

example,

if a field have the words as "sport street", it only display "sport" in 

the browse.  that to say , the words "street" after the space can't 

display in the browse, it can only the front of the space.

i wonder that why it is ?

please help me.

Any advice will be welcome.

thanks !!!

Best Regards!

shine zhai








Message #2 by "Kim Iwan Hansen" <kimiwan@k...> on Mon, 10 Dec 2001 17:59:18 +0100
This is a multi-part message in MIME format.



------=_NextPart_000_0002_01C181A4.63340DE0

Content-Type: text/plain;

	charset="big5"

Content-Transfer-Encoding: 7bit



you gotta provide come code here :-)



-Kim

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

  From: shinetime [mailto:shinetime@2...]

  Sent: 10. december 2001 15:29

  To: ASP Databases

  Subject: [asp_databases] can't display the words after the space





  hi,  all,

  i have a problem about display data from access in the browse.

   i can't display all the words of the field,  only the front.  for

example,

  if a field have the words as "sport street", it only display "sport" in

the browse.  that to say , the words "street" after the space can't display

in the browse, it can only the front of the space.

  i wonder that why it is ?

  please help me.

  Any advice will be welcome.

  thanks !!!

  Best Regards!

  shine zhai






$subst('Email.Unsub').






Message #3 by "Drew, Ron" <RDrew@B...> on Thu, 13 Dec 2001 12:48:43 -0500
This is a multi-part message in MIME format.



------_=_NextPart_001_01C183FE.68445765

Content-Type: text/plain;

	charset="us-ascii"

Content-Transfer-Encoding: quoted-printable



You can use this just replace with your fields and table and if you want

change the <br> the html space

sqltemp=3D"select yourfieldwithspaces from yourtable "

set rstemp=3Dconntemp.execute(sqltemp)



form_appcode=3Drstemp("yourfieldwithspaces")

If form_appcode <> "" Then

 form_appcode=3DReplace(form_appcode, vbCRLF, "<BR>")

End If





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

From: shinetime [mailto:shinetime@2...]

Sent: Monday, December 10, 2001 9:29 AM

To: ASP Databases

Subject: [asp_databases] can't display the words after the space







hi,  all, 

i have a problem about display data from access in the browse.

 i can't display all the words of the field,  only the front.  for

example,

if a field have the words as "sport street", it only display "sport" in

the browse.  that to say , the words "street" after the space can't

display in the browse, it can only the front of the space.

i wonder that why it is ?

please help me.

Any advice will be welcome.

thanks !!!

Best Regards!

shine zhai






$subst('Email.Unsub').







  Return to Index