Chilkat
HOME
Android™
ASP
Visual Basic
VB.NET
C#
iOS (IPhone)
Objective-C
C++
C
MFC
Delphi
FoxPro
Java
Perl
PHP Extension
PHP ActiveX
Python
PowerShell
Ruby
SQL Server
VBScript
|
CRLF ModeThe CrlfMode property applies when downloading files in ASCII mode. If CrlfMode is set to 0 (the default), then the ASCII transfer happens normally without alteration. A value of 1 converts all line endings to CR+ LF. A value of 2 converts all line endings to LF-only. A value of 3 converts all line endings to CR-only.
CREATE PROCEDURE ChilkatSample AS BEGIN DECLARE @hr int DECLARE @sTmp0 nvarchar(4000) DECLARE @ftp int EXEC @hr = sp_OACreate 'Chilkat.Ftp2', @ftp OUT IF @hr <> 0 BEGIN PRINT 'Failed to create ActiveX component' RETURN END DECLARE @success int -- Any string unlocks the component for the 1st 30-days. EXEC sp_OAMethod @ftp, 'UnlockComponent', @success OUT, 'Anything for 30-day trial' IF @success <> 1 BEGIN EXEC sp_OAGetProperty @ftp, 'LastErrorText', @sTmp0 OUT PRINT @sTmp0 RETURN END EXEC sp_OASetProperty @ftp, 'Hostname', 'ftp.chilkatsoft.com' EXEC sp_OASetProperty @ftp, 'Username', 'MyLogin' EXEC sp_OASetProperty @ftp, 'Password', 'MyPassword' -- Connect and login to the FTP server. EXEC sp_OAMethod @ftp, 'Connect', @success OUT IF @success <> 1 BEGIN EXEC sp_OAGetProperty @ftp, 'LastErrorText', @sTmp0 OUT PRINT @sTmp0 RETURN END -- Set the transfer mode to ASCII EXEC sp_OAMethod @ftp, 'SetTypeAscii', @success OUT IF @success <> 1 BEGIN EXEC sp_OAGetProperty @ftp, 'LastErrorText', @sTmp0 OUT PRINT @sTmp0 RETURN END -- Set the CrlfMode to ensure that line endings are CR+LF: EXEC sp_OASetProperty @ftp, 'CrlfMode', 1 -- CrlfMode line ending settings: -- 0 = do ASCII transfer without alteration. -- 1 = CR+LF -- 2 = LF-only -- 3 = CR-only -- Change to the remote directory where the file will be uploaded. EXEC sp_OAMethod @ftp, 'ChangeRemoteDir', @success OUT, 'junk' IF @success <> 1 BEGIN EXEC sp_OAGetProperty @ftp, 'LastErrorText', @sTmp0 OUT PRINT @sTmp0 RETURN END DECLARE @localFilename nvarchar(4000) SELECT @localFilename = 'hamlet.xml' DECLARE @remoteFilename nvarchar(4000) SELECT @remoteFilename = 'hamlet.xml' -- Turn on session logging for the upload: EXEC sp_OASetProperty @ftp, 'KeepSessionLog', 1 -- Download a file. EXEC sp_OAMethod @ftp, 'GetFile', @success OUT, @remoteFilename, @localFilename IF @success <> 1 BEGIN EXEC sp_OAGetProperty @ftp, 'LastErrorText', @sTmp0 OUT PRINT @sTmp0 RETURN END -- View the session log. You can verify visually that -- the transfer was in ascii mode. EXEC sp_OAGetProperty @ftp, 'SessionLog', @sTmp0 OUT PRINT @sTmp0 EXEC sp_OAMethod @ftp, 'Disconnect', NULL PRINT 'File Downloaded!' END GO |
© 2000-2010 Chilkat Software, Inc. All Rights Reserved.