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 |
|
molebrain
Starting Member
18 Posts |
 Posted - 2004-01-09 : 11:19:21
|
| Ok, Maybe someone can offer some ideas on this. I have a basic contact webform with name address, city, etc...all of whiche are TEXT fields (not Text areas) I have a SQL Server 2000 database for storage with a DTS process that sends a text file to a UNIX datbase. Just recently, I noticed that the UNIX side would bomb out on the import. I looked at the data on my end and found that the address field in some of the records , but ONLY SOME OF THEM, had line feeds tagged at the end of them, ultimately confusing the UNIX process. Ok, Yes, I know about the replace(), but can somebody offer me any ideas on how people are inserting chr(10)+chr(13) in just the address text field on the webform? This is very confusing to me. thanks |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-01-09 : 12:15:01
|
| [SHIFT]+[ENTER]?Brett8-) |
 |
|
|
molebrain
Starting Member
18 Posts |
Posted - 2004-01-09 : 12:28:02
|
| I tried that and it still didnt duplicate the problem. This is strange because why would so many people only hit SHIFT-ENTER in JUST the address field? I wonder if there are auto-fill programs out that that are inserting the codes. |
|
|
|
ehorn
Master Smack Fu Yak Hacker
1632 Posts |
Posted - 2004-01-09 : 12:42:56
|
| That is odd, I can only think of a copy and paste type function supplying a line feed into a text box element. If / when you determine the root cause can you post back though. |
|
|
|
|
|
|
line feeds in webforms