Text Box Question

Results 1 to 2 of 2

Thread: Text Box Question

  1. #1
    Join Date
    Dec 1969

    Default Text Box Question

    I have created an edit page that fills a text box with pre-existing data from an access database. The user can then edit the data and save it back to the db. <BR><BR>Code looks like this:<BR>&#060;%<BR><BR>string=string & "&#060;input type=&#039;text&#039; value = &#039;" & rs.fields(i) & "&#039;&#062;"<BR>response.write string<BR>%&#062;<BR><BR>I am using asp to create the text box because I use this same code in a number of places to dynamically create an edit page.<BR><BR>Everything works well except when the data includes an apostrophe:<BR><BR>rs.Fields(i)="Bob&#039;s"<BR><B R>In this case the text field will truncate the field beginning with the apostrophe and will display only "Bob"<BR><BR>I have tried changing the single apostrophe to a double apostrophe but that doesn&#039;t work here.<BR><BR>Any ideas?<BR>Thanks<BR>Kevin

  2. #2
    Join Date
    Dec 1969

    Default RE: Text Box Question, would this help

    Replace apostrophe(&#039;) with tilda(`).<BR><BR>Cheers,<BR>Sandy.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts