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-03-24 : 11:18:42
|
| Ok everyone...this is driving me crazy. I have a web form that contains name, address, etc... Every once and a while, some extra characters get tagged at the end of the address field. Well, this isn't a problem for me, but the data is DTS to a text file that should contain one record per line. However, the extra characters at the end of the address field are making the line wrap and ends up hosing the Unix machine on the other site. Here is the deal...I looked in my DB and did this:select formemail, replace(formaddress,char(13),'<CR>')+replace(studentformaddress,char(10),'<LINE FEED>'), studentformcity And I see:123 epark rd. 4<CR> 123 epark rd. 4<LINE FEED> I also found that this ONLY happens for Mac OSX/Safari browser users. I tried to duplicated getting the CR/LF with OSX/Safari but I can't. Before writing to the DB, I do this in ASP:datafield(4)="addressline1"datawrite(4)=replace(request.form("addr1"),chr(13)+chr(10),"")But for some reason, I still seem to get the occasion CR/LF problemsAny suggestions/ideas on any of this? Maybe I should use Javascript on the form the strip codes?Thanks!! |
|
|
molebrain
Starting Member
18 Posts |
Posted - 2004-03-24 : 15:22:29
|
| Wait! I found out something...Safari lets you "Auto-Fill" your information from the Address Book application...which will stick in a CHR(10)+chr(13) combo at the end of the address field. What a stinking pain. Oh well. |
 |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2004-03-24 : 16:10:35
|
| Some HTML may be slightly off. Have you run your web page through an HTML validator? check out [url]http://validator.w3.org/[/url] |
|
|
|
|
|
|
|
|
Mac OSX and Safari control-m problems