众果搜的博客

脚踏大地,仰望星空,致力于财经投资网站导航与在线网络工具的开发与普及

Search(博客搜索)

热文排行

最近发表

最新评论及回复

« 注册表扫描对比软件-RegShot 易中天如何教育女儿-收藏,以提醒自己 »

MP3切割工具

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%'"
  • 相关文章:

发表评论:

◎欢迎参与讨论,请在这里发表您的看法、交流您的观点。

Powered By Z-Blog 1.8 Spirit Build 80722 Code detection by Codefense

Copyright www.zhongguosou.com. Some Rights Reserved.微信号:MiZhiHeiGeTaXiaoMi