Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-10-04 : 08:04:10
|
| Alex writes "Windows Server 2003 Enterprise Version - SQL server 2000SQL Enterprise Mgr Version 8.0I am currently developing a backend SQL db for an ASP website. I am only learning, so quite new to it all & would appreciate some help with the following;I currently have a form that updates a recordset in my SQL db. This is working fine, except for the fact that when the form loads and the db tries to write the field value into my text box, e.g. Address: 20 Harbour Drive, the field value is truncated at the space and it writes the address as 20 in the text box.When I view the detail page, no problems, the recordset was updated, but when I go back to the update page, the record values are truncated again as though the ASP page thinks the space is some kind of delimiter?The size property of my textbox element is the same as the varchar datatype size in the SQL table.Can anyone help?Thanks in advance, this is driving me nuts.Alex" |
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
Posted - 2005-10-04 : 08:09:20
|
When you populate your textbox you must replace the space " " with "+" that will translate to a space in htmlDuane.  |
 |
|
|
|
|
|
text box in ASP page truncates field value when writing rst