FCKeditor ¸üÐÂÊý¾Ý¿â£¨mssql£©µÄÎÊÌâ
ÓÃÁËFCKeditorµÄ±à¼Æ÷£¬´æÈëÆÕͨÎÄÕº󣬿ÉÒÔ¸üС£µ±´æÈëwordµÄÄÇÖÖ±í¸ñ¸ñʽµÄÎÄÕÂʱºò£¬¾Í³öÏÖÎÞ·¨¸üеÄÎÊÌâ¡£ <httpRuntime maxRequestLength="2097151" executionTimeout="43200"/> Õâ¸öÉèÖÃÁË£¬Êý¾Ý¿âµÄ×î´ó³¬Ê±Ê±¼äÒ²ÉèÖÃÁË¡£
Êý¾Ý¿âÓõÄÊÇtext×ֶΣ¬ntextÒ²ÊÔ¹ý£¬Ò³ÃæÏÔʾ´íÎ󣺳¬Ê±Ê±¼äÒѵ½¡£ÔÚ²Ù×÷Íê³É֮ǰ³¬Ê±Ê±¼äÒѹý»ò·þÎñÆ÷δÏìÓ¦
Èç¹ûÊDZí¸ñ¸ñʽµÄÎÊÌ⣬ÈçºÎ½â¾ö£¿
sf....................
ÄǾʹæhtml
ÊÔÊÔ:
(1)ÓÃSQL²ÎÊý´«µÝ
(2)Êý¾Ý¿âÀàÐ͸ijÉImage,°´¶þ½øÖƱ£´æ
²»Ðа¡£¬ºǫ́ÐèÒª½«wordÎĵµ´æÈëÊý¾Ý¿âµÄ
Íü¼Ç˵ÁËÎÒÓõÄÊÇ ´æ´¢¹ý³Ì ²»¿ÉÒÔ£¿
´æ´¢¹ý³ÌÒ²¿ÉÒԵİ¡£¡Ö»ÒªÖ¸¶¨Á˲ÎÊý¾ÍÐÐÁË
ºÇºÇ û¿´ÇåÎÊÌâ°É
´æ´¢¹ý³Ì¿ÉÒÔ£¬Ìù³öÏà¹Ø´úÂë
FCKeditor1.ValueÒ»°ãʹÓÃntext±£´æÃ»ÎÊÌâ
wordÄÚÈݸºÔðµ½FCKeditor,»òÉÏ´«Îļþµ½·þÎñÆ÷£¬±£´æÂ·¾¶µ½Êý¾Ý¿â
±£´æÊÇûÓÐÎÊÌ⣬µÚÒ»´Î±£´æ wordÎĵµÊÇ¿ÉÒÔ±£´æµÄ£¬µ«ÊÇÄã±£´æÁËÒÔºó¼ÓÔØÉÏÀ´ ¾Í²»ÄÜÐÞ¸ÄÁË Òì³£ÔÒòÈçÉÏ
Ïà¹ØÎÊ´ð£º
ÏÖÔÚÁ¬µÄÒ»Ô¶³Ìmssql£¬Ã¿´Î²éѯ±È½ÏÂý£¬ÏÖÔÚÏëһϰÑËùÓмǼ²éѯ³öÀ´ÓÃÊý¾Ý¼¯±£´æÆðÀ´£¬È»ºóÕë¶ÔÊý¾Ý¼¯Ôٴβéѯɸѡ¡£
ÏÖÔÚÎÊÏÂÄǸöÊý¾Ý¼¯ÈçºÎ±£´æ²éѯ¼Ç¼£¬¶øÔٴβéѯ£¬¶àлÁË¡£
¿ÉÒÔ°ÑÊý¾Ý¼¯ÖеÄÊý¾Ý·Åµ½ÄÚ´ ......
ÔÚvbscriptÖв»ÓÃon error resume nextÈçºÎÅжÏmssqlÓï·¨´íÎó£¡
TRY CATCH?
»òÕßʹÓÃÁ÷³Ì¿ØÖÆÓï¾ä
if
else
²»ÓÃon error ÓÃÄǸöÎҾͲ»ÐèÒªÔÚÕâÀïѰÕÒ´ð°¸
ÒýÓÃ
²»ÓÃon error ÓÃÄǸöÎҾͲ»Ðè ......
accessʱ²éѯËÙ¶È»¹Âù¿ìµÄ£¬ÏÖÔÚת³ÉmssqlÁË£¬Êý¾ÝÁ¿²¢²»´ó£¬Í¨³£Êý¾ÝÁ¿¶àЩµÄ¾ÍÊǼ¸Ç§Ìõ£¬µ±È«²¿ÁгöÊý¾ÝʱËÙ¶ÈÒ²²»Âý£¬¾ÍÊǰ´Ìõ¼þËÑË÷ʱ¾ÍÂýÁË£¬ÇëÎÊÊDz»ÊǸúlikeÓйذ¡£¬µ«ÒÔǰÓÃaccessÂù¿ìµÄ°¡£¬Ò²½¨Á¢ÁËË÷ÒýÁË ......
Êý¾Ý¿âÄÚÓÐ500WÌõÊý¾Ý£¬²éѯµÄʱºòÈçºÎÓÅ»¯
Õâ¶Îʱ¼äÒ²ÔÚ¿´SQL.ÎÒ¾õµÃÕâÁ½±¾Êé²»´í!SQLÒÕÊõ,SQL2008¼¼ÊõÄÚÄ» T-SQL»ù´¡.
ȷʵдһÌõ¸ßЧµÄSQL²»ÊÇÈÝÒ×µÄÊÂ!ÎҼǵÃ×îÇå³þµÄÒ»ÌõÊÇ:×î½ü¹ýÂ˵ô²»·ûºÏÌõ¼þµÄ¼Ç¼ ......
¸Õ¿ªÊ¼Ñ§Ï°´æ´¢¹ý³Ì£¬Ð´Á˸öMSSQLµÄ£¬²»Ì«ÊìϤORACLEµÄ¸ÃÔõôд¡£Ï£Íû¸÷λ´óÏÀ°ïæ
SQL code:
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER PROCEDURE [dbo].[proc_getTotal]--<getTotal, gjj ......