Question
Need Help With File Upload
Hi Guys,
I am new to Cold Fusion. Please help me out.
I have written a code to upload a .doc file into SQL Server 2000. SQL Server 2000 has only Text data type for files.
The code uploads the file fine.
When it is trying to insert the fie to the database it is throwing an error.
Throws an error for data mismatch.
---------------------------
Invalid data {TIMECREATED={ts '2008-08-19 16:09:55'}, FILEWASAPPENDED=false, FILEWASRENAMED=true, FILEWASOVERWRITTEN=false, CLIENTDIRECTORY=Admin.txt, OLDFILESIZE=85, CONTENTTYPE=text, CONTENTSUBTYPE=plain, ATTEMPTEDSERVERFILE=Admin.txt, CLIENTFILEEXT=txt, DATELASTACCESSED={d '2008-08-19'}, FILEWASSAVED=true, FILEEXISTED=true, CLIENTFILENAME=Admin, SERVERFILE=Admin5.txt, CLIENTFILE=Admin.txt, FILESIZE=85, SERVERDIRECTORY=C:\, SERVERFILENAME=Admin5, SERVERFILEEXT=txt, TIMELASTMODIFIED={ts '2008-08-19 16:09:55'}} for CFSQLTYPE CF_SQL_CHAR.
The error occurred in \\l-ny-shegde\web\workspace\ETS\application\ets\includes\FAW\getSetBlob.cfm: line 52
50 : (<cfqueryparam
51 : value="#file#"
52 : cfsqltype="cf_sql_text">)
53 :
54 : <!--- insert into file_data (filedata)
---------------------------
I am new to Cold Fusion. Please help me out.
I have written a code to upload a .doc file into SQL Server 2000. SQL Server 2000 has only Text data type for files.
The code uploads the file fine.
When it is trying to insert the fie to the database it is throwing an error.
Throws an error for data mismatch.
---------------------------
Invalid data {TIMECREATED={ts '2008-08-19 16:09:55'}, FILEWASAPPENDED=false, FILEWASRENAMED=true, FILEWASOVERWRITTEN=false, CLIENTDIRECTORY=Admin.txt, OLDFILESIZE=85, CONTENTTYPE=text, CONTENTSUBTYPE=plain, ATTEMPTEDSERVERFILE=Admin.txt, CLIENTFILEEXT=txt, DATELASTACCESSED={d '2008-08-19'}, FILEWASSAVED=true, FILEEXISTED=true, CLIENTFILENAME=Admin, SERVERFILE=Admin5.txt, CLIENTFILE=Admin.txt, FILESIZE=85, SERVERDIRECTORY=C:\, SERVERFILENAME=Admin5, SERVERFILEEXT=txt, TIMELASTMODIFIED={ts '2008-08-19 16:09:55'}} for CFSQLTYPE CF_SQL_CHAR.
The error occurred in \\l-ny-shegde\web\workspace\ETS\application\ets\includes\FAW\getSetBlob.cfm: line 52
50 : (<cfqueryparam
51 : value="#file#"
52 : cfsqltype="cf_sql_text">)
53 :
54 : <!--- insert into file_data (filedata)
---------------------------