MP3切割工具,是一款不错的MP3进行分解的工具。在你听英语磁带,或者音乐的MP3文件太大,你需要分段听的时候,可以将其分成几段相同长度的音乐。分别保存为MP3文件。其帮助文件中有详细的使用说明。" "MP3切割工具,是一款不错的MP3进行分解的工具。在你听英语磁带,或者音乐的MP3文件太大,你需要分段听的时候,可以将其分成几段相同长度的音乐。分别保存为MP3文件。其帮助文件中有详细的使用说明。
MP3 Splitter & Joiner converts all features in the standard version and provides more powerful features
Multiple Audio Formats Support
MP3 Splitter Pro supports MP3, MPA, WAV audio files and MP3 Joiner Pro supports MP3, MPA, WAV, WMA/ASF, OGG, AIFF audio files.
Extreme Large Audio File Support
MP3 Splitter & Joiner Pro is able to join and split extreme large audio files over 2GB.*
MP3 Splitter Pro
Batch Split
Split multiple audio files in a single split session by just a simple click.
Split Group Support
You can quickly and easily set split parameters to all audio files in a split group, such as switch split mode, split special, save list, edit ID3 tag, etc.
Automatic Split Mode
MP3 Splitter & Joiner Pro will analysis the MP3 file you just loaded in 'Auto. Mode' and then automatically select the best split mode for you.
MP3 Joiner Pro
Automatic Merge Mode
MP3 Splitter & Joiner Pro will analysis the audio file you just loaded in 'Auto. Detect' Mode and then automatically select the best merge mode for you.
Build-in Audio Converter
MP3 Splitter & Joiner Pro is able to directly merge audio files in different audio formats or in different encoding parameters.
"
368 "使用SQL SERVER屏蔽垃圾留言的又一办法" "今天打开博客,又有许多垃圾广告留言,真是生气,决定升级一下反垃圾留言的功能。将原来的反垃圾触发器进行升级如下:" "今天打开博客,又有许多垃圾广告留言,真是生气,决定升级一下反垃圾留言的功能。将原来的反垃圾触发器进行升级如下:
ALTER TRIGGER [deleteguanggao] on [pub].[blog_Comment]
AFTER INSERT
AS
IF Exists (select * from Inserted where comm_AutoKEY=1 or comm_Author!='zhongguosou' )
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
rollback transaction
-- Insert statements for trigger here
END
在上面的Where条件中加入comm_content like '%www%'后发现,提示如下错误:
消息 311,级别 16,状态 1,过程 deleteguanggao,第 26 行
不能在 'inserted' 表和 'deleted' 表中使用 text、ntext 或 image 列。
这是因为L-Blog字段的原因。
只好在自己的首页的访问博客文章列表中加入删除留言功能:
Dim cmdselect As Data.SqlClient.SqlCommand
cmdselect = New Data.SqlClient.SqlCommand
cmdselect.Connection = conpubs
conpubs.Close()
conpubs.Open()
cmdselect.CommandType = System.Data.CommandType.StoredProcedure
cmdselect.CommandText = \"deletead\"
cmdselect.ExecuteNonQuery()
通过deletead存储过程删除留言中含有www或者http关键字的留言:
存储过程如下:
delete from blog_comment where comm_content like '%www%' or comm_content like ''%http%'"