my data is stored in mssql server. <br>the data type, varchar, only allow me to input 255 characters so i use <cffile action="write"> to write input into text file. <br>Then store the pathname in database. <br>To retrieve the file contents, i use <cffile action="read"> but i cannot output the contents of the file, instead got its pathname... <br>so how can i save my input as??? <br>pls help, thank you
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
cffile action="read"
- Thread starter Rachel80
- Start date
If you're using CFFILE ACTION="write" like this:<br><FONT FACE=monospace><CFFILE ACTION="Write" FILE="c:\myfiles\thefile.txt" OUTPUT="#form.content#"></font><br><br>You should be able to read it with:<br><br><FONT FACE=monospace><CFFILE ACTION="Read" FILE="c:\myfiles\thefile.txt" VARIABLE="Message"><br><CFOUTPUT>#Message#</CFOUTPUT></font><br><br>Make sure you are using the full path name in both the write and read actions, and the correct file name, and you should be able to read it....<br><br>Let me know if this helps...<br><br>DM<br><br>
- Thread starter
- #3
sorry i guess u got the wrong idea...<br>the problem with my program is: the pathname of text file is stored in database, so i guess there's no use storing the contents in a variable. Next time when i retrieve data from the database, i want to retreive the contents and read the text file. Instead, only pathname is displayed.
- Thread starter
- #4
hm... i got it!<br>bcoz i thought that the variable for cfile action="write" must be the same as the one in action="read", which is not very possible... so i thought i can't use this method. but it works already, thanx alot!<br>
- Status