Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2011
    Posts
    3

    Unanswered: CLOB datatype, i cant save doc file...

    HI,

    Anyway i dont really know if i am doing a right thing, thats why i am here to ask some help.

    Code:
    str = "insert into doc(docid,doctit,docdes,cntent)values('" & TextBox1.Text & "','" & TextBox2.Text & "','" & TextBox3.Text & "','" & FileUpload1.FileName & "')"
    My insert code
    Code:
    CREATE TABLE doc (docid varchar(6) NOT NULL PRIMARY 
    
    KEY, doctit varchar(50) NOT NULL,  docdes varchar(1000) 
    
    NOT NULL,cntent clob (1m) not null)
    my create table sql
    i cant save and it gives me "SQL0204N "ERANAANDO.DOC" is an undefined name. SQLSTATE=42704" this error which i really dont know how to fix it its my first time to use clob datatype, i need to upload .doc/pdf file upto 125 mb and minimum of 1 mb...
    im not sure what i talk about guys but please guide me and help me.

  2. #2
    Join Date
    Dec 2011
    Posts
    3

    Solved

    after 15 minutes of trying i got the solution which is very funny i forget the db name hahaha sorry...

Posting Permissions

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