By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,659 Members | 1,611 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,659 IT Pros & Developers. It's quick & easy.

Field only display half information.

kirubagari
100+
P: 158
Hi Experts,

Im having problem where if i add value MY TESTING.
It only display MY only.Please refer attachment.what need to be done so that system will show full character when load ?

Expand|Select|Wrap|Line Numbers
  1. set rsfb = server.CreateObject("ADODB.RECORDSET")
  2. sql = "select ID,title,value,updateby,updatedate from EMPLOYEE where title='lotowner'"
  3. set rsct = cn.execute(sql)
  4. maxid = clng(rsct("ID"))
  5. While Not rsct.Eof
  6.  
  7.  
  8.     'response.write "<tr><td align=center><img border=0 src=images/delete.gif alt=Delete onmouseover=this.style.cursor='hand' onmouseout=this.style.cursor='default' onclick=getcell('d','" & rsct("ID") & "','" & rsct("VALUE") & "');>"
  9.       'response.write "<tr><td align=center><lotowner_" & rsct("ID") & " value=" & rsct("VALUE") & " size=20 style=text-align:left>"
  10.       response.write "<tr><td align=center><input id=lotowner_" & rsct("ID") & " value=" & rsct("VALUE") & " size=20 style=text-align:left>"
  11.      'response.write "<td align=center><input id=lotowner_" & rsct("ID") & " " & rsct("VALUE") & ""
  12.       response.write "<td>" & rsct("UPDATEBY")
  13.       response.write "<td>" & rsct("UPDATEDATE")
  14.       response.write "<td align=center><img border=0 src=images/delete.gif alt=Delete onmouseover=this.style.cursor='hand' onmouseout=this.style.cursor='default' onclick=getcell('d','" & rsct("ID") & "','" & rsct("VALUE") & "');>"
  15.      if clng(rsct("ID")) > maxid then maxid = clng(rsct("ID"))
  16.      'response.write ">>" & maxid
  17.       rsct.MoveNext
  18. Wend
  19. rsct.Close
  20. Set rsct = Nothing
  21. end sub
  22.  
  23.  
Attached Images
File Type: jpg attachment.jpg (31.2 KB, 135 views)
Aug 15 '12 #1
Share this Question
Share on Google+
4 Replies


Rabbit
Expert Mod 10K+
P: 12,370
Put quotes around your value. In HTML form elements, if the value has spaces, it needs to be enclosed in quotes.
Aug 15 '12 #2

kirubagari
100+
P: 158
Hi,
Put quotes in between as below.Apperciate if you can show me

Expand|Select|Wrap|Line Numbers
  1.     response.write "<tr><td align=center><input id=lotowner_" & rsct("ID") & "&value&=" & rsct("VALUE") & " size=20 style=text-align:left>"
Aug 16 '12 #3

Rabbit
Expert Mod 10K+
P: 12,370
If I want an input box with a value with spaces, I would do this:
Expand|Select|Wrap|Line Numbers
  1. <input value="i want a space">
Notice the quotes around the value.
Aug 16 '12 #4

kirubagari
100+
P: 158
Hi,
Its works.Thanks.
Aug 16 '12 #5

Post your reply

Sign in to post your reply or Sign up for a free account.