ÇëÎÊÈçºÎÓÃsqlserver¶ÔpdfÎļþ½øÐÐÈ«ÎļìË÷¡£
sqlserver¿ÉÒÔÊÇsqlserver2000»òsqlserver2005¡£Ð»Ð»¡£
Up
ÏÂÔØ¸ö°ÑPDFת³ÉTXTµÄ²å¼þ£¬ÀûÓÃÕâ²å¼þת³ÉTXTÎļþ£¬¶ÔTXT¼ìË÷¾Í·½±ãÁË¡£
AcrobatÀï²»¾ÍÓвéÕÒô.
ѧϰ
ÒýÓÃ
AcrobatÀï²»¾ÍÓвéÕÒô.
¹À¼ÆÂ¥Ö÷µÄÒâ˼ÊÇimageÐ굀 ´æ´¢ÔÚÊý¾Ý¿âÖеÄP ......
СµÜÎÒÔÚserver2000Êý¾Ý¿âarticle±íµ¥ÖÐÓÐÒ»¸öÀàÐÍÊÇ¡®ntext¡¯µÄ×ֶΣ¬×Ö¶ÎÃûÊÇcontext¡£´Ë×Ö¶ÎÊÇÓÃÀ´´æ·ÅÎÄÕÂÄÚÈݵģ¬ÎÒÓÃphp¶ÁÈ¡´Ë×Ö¶ÎÄÚÈÝÓÃÓï¾ä£ºPHP code:
$result=mssql_query("select convert(text,content) as content from article where articleid='$articleid' ");
´ËÓï¾ä¿ÉÒÔÕýÈ·Ö ......
ÒòΪÔÚphpÖв»Ö§³ÖSQLserver2000Êý¾Ý¿âµÄ'ntext'ÀàÐ͵ÄÊý¾Ý£¬ËùÒÔÒª¶ÁÈ¡Êý¾Ý¿âÖÐ'ntext'ÀàÐÍ×Ö¶ÎʱֻÓÃ'text'À´´úÌæ'ntext'½øÐжÁÈ¡£¬´úÂëÈçÏ£º
PHP code:
$result=mssql_query("select convert(text,content) as content,title from article where articleid='$arti ......
±ÈÈçÒ»¸öÔ±¹¤ºÍ²¿ÃÅ±í£¬ÒªÎ¬»¤Ô±¹¤µÄ²¿ÃÅÐÅÏ¢£¬Ò»°ãÎÒµÄÔÚÓÃInterbaseÊý¾Ý¿âʱ£¬
ÔÚTIBDATASETµÄSqlÓï¾äÕâÑùд£º
select a.*,b.Name DName
from Emp a
left join Depart b on(a.DID = b.DID)
ÔÚcxDBGirdÖÐά»¤DNameµÄÖµ£¬¿ÉÒÔµ¯³öÒ»¸ö´°¿ÚÀ´Ñ¡Ôñ²¿ÃŲ¢ÐÞ¸ÄÔ±¹¤±í´ï²¿ÃÅ×ֶΣ»
¶ø¸ÄÓÃSqlServerµÄA ......
select source_id,deposit_comp,comp_phone,comp_addr,deposit_client,client_phone,sum(total_amt)
from sale_card_request
group by source_id,deposit_comp,comp_phone,comp_addr,deposit_client,client_phone
sale_card_request Óиö req_date µÄ×ֶΣ¬±ÈÈçÎÒÏë²é req_date between '2000-1-1 ......
ÈçÌ⣡лл!!!
»¹ÊÇÒ»ÑùµÄ дºÃÁ¬½ÓÎļþºÍµØÖ·¾ÍokÁË
mssql_contentÀý×Ó
²»ÄÜ´ò¿ªsaÓû§ÃûµÄÊý¾Ý¿â°¡
°ÑPHP¡£iniÁ¬½Ó´ò¿ª
ÎÒ»³ÒÉÎʵÄÎÊÌ⣡¹À¼ÆºÜÎÞÁÄ£¡Õ¦Ã»È˻ظ´°¡£¡£¡£¡£¡£¡
......