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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

drop down list box in edit.asp 7
DBRW include login.asa 2
Update database page help 1
Database Editor Returns No Results 10
Dynamic pulldown using DIW 3
Edit record gets error 2
Database Hyperlinks 19
Edit Database Issue 6

Back
Top