Inserting records into a database

Results 1 to 2 of 2

Thread: Inserting records into a database

  1. #1
    Chase Pilkington Guest

    Default Inserting records into a database

    I have devolped an ASP application that will insert, delete, modify, and search records within a database. All of this is done from a web based form. The problem that I am having is that when I insert a record into the database, it truncates the "Title" to 49 characters. I tried this add feature two different ways, once using a *.htx and *.idc file and the other using a *.asp file but both of them behave in the same manner.

  2. #2
    David Errington Guest

    Default RE: Inserting records into a database

    Is the length of the field in your db long enough for the "title" field/column?<BR><BR>In SQL, when creating the table, you say<BR><BR>title varchar(100)<BR><BR>This allows up to 100 characters in the title field/column.<BR><BR>Also, in ASP, be careful of single and double quotes when assembling strings. SQL strings need to be in single quotes, VBScript strings are manipulated with double quotes. You may have missed a quote when assembling your sql target string, resulting in truncation.<BR>

Posting Permissions

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