http://forums.method.me/cs/forums/15.aspxAsk questions specific to the MethodAPI from the Method Team and other Method users.enCommunityServer 2007.1 SP2 (Build: 31113.47)http://forums.method.me/cs/forums/thread/14732.aspxTue, 27 Nov 2012 20:57:58 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:14732Matt0http://forums.method.me/cs/forums/thread/14732.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=15&PostID=14732<p><span id="mce_0_start" style="overflow:hidden;">Thank You Dave!</span></p>http://forums.method.me/cs/forums/thread/14647.aspxWed, 21 Nov 2012 15:17:23 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:14647Method_David0http://forums.method.me/cs/forums/thread/14647.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=15&PostID=14647<p><br /><span style="overflow:hidden;" id="mce_1_start"><span style="overflow:hidden;" id="mce_2_start"><span style="overflow:hidden;" id="mce_3_start"><span style="overflow:hidden;" id="mce_4_start"><span style="overflow:hidden;" id="mce_5_start"><span style="overflow:hidden;" id="mce_6_start"></span></span></span></span></span></span><span style="overflow:hidden;" id="mce_0_start">Hi Matt,<span style="overflow:hidden;" id="mce_6_end"></span></span></p> <p><span style="overflow:hidden;">For any file field....two columns get added to&nbsp;the table. The first column <span style="overflow:hidden;" id="mce_8_start"><span style="overflow:hidden;" id="mce_9_start"></span></span><span style="overflow:hidden;" id="mce_7_start"></span><span style="overflow:hidden;" id="mce_8_end"><span style="overflow:hidden;" id="mce_9_end"></span></span>is the name of the field. Internally we store the data as&nbsp;varbinary<span style="overflow:hidden;" id="mce_11_start"><span style="overflow:hidden;" id="mce_12_start"><span style="overflow:hidden;" id="mce_13_start"><span style="overflow:hidden;" id="mce_14_start"><span style="overflow:hidden;" id="mce_15_start"><span style="overflow:hidden;" id="mce_16_start"><span style="overflow:hidden;" id="mce_17_start"><span style="overflow:hidden;" id="mce_18_start"><span style="overflow:hidden;" id="mce_19_start"><span style="overflow:hidden;" id="mce_20_start"><span style="overflow:hidden;" id="mce_21_start"><span style="overflow:hidden;" id="mce_22_start"><span style="overflow:hidden;" id="mce_23_start"><span style="overflow:hidden;" id="mce_24_start"><span style="overflow:hidden;" id="mce_25_start"></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span><span style="overflow:hidden;" id="mce_10_start"></span><span style="overflow:hidden;" id="mce_11_end"><span style="overflow:hidden;" id="mce_12_end"><span style="overflow:hidden;" id="mce_13_end"><span style="overflow:hidden;" id="mce_14_end"><span style="overflow:hidden;" id="mce_15_end"><span style="overflow:hidden;" id="mce_16_end"><span style="overflow:hidden;" id="mce_17_end"><span style="overflow:hidden;" id="mce_18_end"><span style="overflow:hidden;" id="mce_19_end"><span style="overflow:hidden;" id="mce_20_end"><span style="overflow:hidden;" id="mce_21_end"><span style="overflow:hidden;" id="mce_22_end"><span style="overflow:hidden;" id="mce_23_end"><span style="overflow:hidden;" id="mce_24_end"><span style="overflow:hidden;" id="mce_25_end"></span></span></span></span></span>. The second column is fieldnameFileName, which is the name of the file.</span></span></span></span></span></span></span></span></span></span></span></p> <p><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;">When you retrieve the data, it is a bytearray.<span style="overflow:hidden;" id="mce_57_start"></span></span></span></span></span></span></span></span></span></span></span></span></p> <p><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;">So a simple example would be as follows:</span></span></span></span></span></span></span></span></span></span></span></span></p> <p><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;">When you retrieve the file name, you need to append the filename to the location where you are saving&nbsp;the file (assuming you want a local copy)</span></span></span></span></span></span></span></span></span></span></span></p> <p><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;">Then &nbsp;<span style="overflow:hidden;" id="mce_43_start"><span style="overflow:hidden;" id="mce_44_start"><span style="overflow:hidden;" id="mce_45_start"><span style="overflow:hidden;" id="mce_46_start"><span style="overflow:hidden;" id="mce_47_start"><span style="overflow:hidden;" id="mce_48_start"><span style="overflow:hidden;" id="mce_49_start"><span style="overflow:hidden;" id="mce_50_start"><span style="overflow:hidden;" id="mce_51_start"><span style="overflow:hidden;" id="mce_52_start"></span></span></span></span></span></span></span></span></span></span><span style="overflow:hidden;" id="mce_42_start"></span><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;">you can use the<span style="overflow:hidden;" id="mce_53_start"> .Net</span>&nbsp;File.WriteAllBytes</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;" id="mce_41_start"></span><span style="overflow:hidden;" id="mce_40_start"></span><span style="overflow:hidden;" id="mce_41_end"></span><span style="overflow:hidden;" id="mce_27_start"><span style="overflow:hidden;" id="mce_28_start"><span style="overflow:hidden;" id="mce_29_start"><span style="overflow:hidden;" id="mce_30_start"><span style="overflow:hidden;" id="mce_31_start"><span style="overflow:hidden;" id="mce_32_start"><span style="overflow:hidden;" id="mce_33_start"><span style="overflow:hidden;" id="mce_34_start">(path, bytearray)<span style="overflow:hidden;" id="mce_67_start"> function</span>....using the location +&nbsp;filename mentioned above, and the bytearray of data as parameter<span style="overflow:hidden;" id="mce_68_start"></span>s<span style="overflow:hidden;" id="mce_69_start"> to write the file locally</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></p> <p><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;">Dave</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></p>http://forums.method.me/cs/forums/thread/14599.aspxMon, 19 Nov 2012 22:23:57 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:14599Matt0http://forums.method.me/cs/forums/thread/14599.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=15&PostID=14599<p><span id="mce_0_start" style="overflow:hidden;">How do you download a document file using the API?</span></p>