The query string is

strsql = "SELECT EmployeeName,ReferenceNo,ProjectName,Task, " & _
         "TaskStatus,CurDate,StartTime,EndTime,Duration, " & _
         "Customer,Deliverables,Notes " & _
         "FROM TIMELOG " & _
         "WHERE EmpID=" + request("EmpID")  & _
         "AND TimeLogID=" + request("ColTimeID")

Columns CurDate, StartTime and Notes have length of 50-255 chra in
MS-Access.

When displayed on HTML like
<TD><INPUT TYPE="TEXT" name="CurDate" value=<%= rs("CurDate")%>
size="300"></TD>

i get onlt the first chrs with no spaces.
Ex Tue 20 June 2000 CDT .. is displayed as "Tue"..

Thanx

>From: Lee Elenbaas <[EMAIL PROTECTED]>
>Reply-To: A mailing list about Java Server Pages specification and
>     reference <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: Re: Display problems on HTML if fields have spaces !!!
>Date: Tue, 20 Jun 2000 19:07:22 +0300
>
>Simply wrappes them with "
>lee
>
>PS: how did you got to this list?
>
>Lee Elenbaas
>ViryaNet
>[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
>http://www.viryanet.com/
>
>
>-----Original Message-----
>From: A mailing list about Java Server Pages specification and reference
>[mailto:[EMAIL PROTECTED]]On Behalf Of Mohammed Sharif
>Sent: Tuesday, June 20, 2000 6:33 PM
>To: [EMAIL PROTECTED]
>Subject: Display problems on HTML if fields have spaces !!!
>
>
>Hi
>
>I am using ASP to display data from a database. If the values in the
>database have spaces in them, the text after space is not displayed. How do
>i avoid that.
>
>Thanx
>________________________________________________________________________
>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
>===========================================================================
>To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
>JSP-INTEREST".
>Some relevant FAQs on JSP/Servlets can be found at:
>
>  http://java.sun.com/products/jsp/faq.html
>  http://www.esperanto.org.nz/jsp/jspfaq.html
>  http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
>  http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
>
>===========================================================================
>To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
>JSP-INTEREST".
>Some relevant FAQs on JSP/Servlets can be found at:
>
>  http://java.sun.com/products/jsp/faq.html
>  http://www.esperanto.org.nz/jsp/jspfaq.html
>  http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
>  http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets

________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:

 http://java.sun.com/products/jsp/faq.html
 http://www.esperanto.org.nz/jsp/jspfaq.html
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets

Reply via email to