edit.asp

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using the Database Interface Wizard to create a website. When I update
a text input field using edit.asp it adds a space to the end of my text and
inserts that space into my SQL database. This is causing problems for me
because the text is a website address and when it's displayed in
results_page.asp as a hyperlink it can't find the page because there is a
space at the end.

How do I fix that? Any help that you may have would be greatly appreciated.
 
Hi Vickie,
Assuming sql means sql server it sounds like your field is set to a char
datatype - this will always add spaces change the datatype to varchar.
 
Back
Top