SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Zealot
    Join Date
    Jun 2000
    Location
    Canada
    Posts
    161
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    problem using 2 cffile: String data right truncation

    Greetings,

    I am trying to use 2 cffile for my news/articles system and it gives an SQL error: String data right truncation.

    The first cffile is for uploading an image, if it's all alone it works but as soon as I add the secon cffile to upload a text file it gives the error. Both fields have a big enough length to accept the file size, the image is about 4k and same for the text file and I even tried to set the length of the filefield to 4000 and it still gave me the error.

    Here is what I do in this particular page:

    -cffile for the image
    -cfupdate image
    -cffile for the text file
    -cfupdate file

    -cfoutput image
    -cfoutput file

    If I leave only th eimage cffile it works great and once I add the cffile file it bugs the whole thing and I tried also with only the cffile file and it definately shows that it's hwere the problem is.

    Let me know how it can be solved.

    Cheers!
    CG Focus

    Focusing On CG Graphics.

  2. #2
    SitePoint Zealot
    Join Date
    Jun 2000
    Location
    Canada
    Posts
    161
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Disregard hehe I figured it out

    Cheers!
    CG Focus

    Focusing On CG Graphics.


Bookmarks

Posting Permissions

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