Naghibi
چهارشنبه 02 اردیبهشت 1394, 09:57 صبح
سلام و روزتون بخیر
من یه گریدویو دارم که قراره اطلاعات پرسنل رو نمایش بده و بایند شده به جدول پرسنل
وقتی فیلد تصویر که از نوع image هست Null باشه یه علامت ضربدر به جای عکس نشون میده. من میخوام یا خالی نشون بده یا اینکه یه تصویر پیش فرض برای فیلد های خالی نشون بده.
از دستور زیر استفاده کردم اما با خطا مواجه شدم.
SELECT ISNULL([Pic], CONVERT(VARBINARY(MAX), 0)) AS pic FROM Personel
یا
SELECT [pic]=case When [pic]IS NULL then '0xFFD8FFE000104A46494600010101004800480000FFDB004 3000604040405040605050609060506090B080606080B0C0A0 A0B0A0A0C100C0C0C0C0C0C100C0E0F100F0E0C13131414131 31C1B1B1B1C20202020202020202020FFDB0043010707070D0 C0D181010181A1511151A20202020202020202020202020202 02020202020202020202020202020202020202020202020202 0202020202020202020FFC0001108006000600301110002110 1031101FFC4001F00000105010101010101000000000000000 00102030405060708090A0BFFC400B51000020103030204030 50504040000017D01020300041105122131410613516107227 114328191A1082342B1C11552D1F02433627282090A1617181 91A25262728292A3435363738393A434445464748494A53545 5565758595A636465666768696A737475767778797A8384858 68788898A92939495969798999AA2A3A4A5A6A7A8A9AAB2B3B 4B5B6B7B8B9BAC2C3C4C5C6C7C8C9CAD2D3D4D5D6D7D8D9DAE 1E2E3E4E5E6E7E8E9EAF1F2F3F4F5F6F7F8F9FAFFC4001F010 00301010101010101010100000000000001020304050607080 90A0BFFC400B51100020102040403040705040400010277000 102031104052131061241510761711322328108144291A1B1C 109233352F0156272D10A162434E125F11718191A262728292 A35363738393A434445464748494A535455565758595A63646 5666768696A737475767778797A82838485868788898A92939 495969798999AA2A3A4A5A6A7A8A9AAB2B3B4B5B6B7B8B9BAC 2C3C4C5C6C7C8C9CAD2D3D4D5D6D7D8D9DAE2E3E4E5E6E7E8E 9EAF2F3F4F5F6F7F8F9FAFFDA000C03010002110311003F00F A1ADEDED4DB444C284945C9DA3D2B448906B7B5FF009E29FF0 07C8A76110B436FFF003CD7F2155615C81E387FB8BF90A7CA8 5720748FF00BA3F2AAE54172070BE94F950AE40E6AB950AE57 776F5A7C8857640F2C9FDE3F9D5722EC2E6640F3CDFF3D1BF3 355C91EC1CCC81EE6E3FE7ABFFDF469FB38F627998C82EAE4D D420CAE4175046E3EB4A708F2BD06A4EE7A0DBBFF00A345FEE 2FF002AE346E0CF5422166A622076A6054B8B9862C79922A6E E9B8819FCEA84655D788B46824F2E4BB4DC7FBB96FCCAE453B 88956E20986E8A45917D5483FCAA8446E6A8457735422B39AA 115DCD310DB63FE9907FD745FE74A7F0BF41C773D0217FDC47 FEE8FE55C28DD833D508859E98197AE6B10E9964D71272DF76 24FEF31E9FF00D7A623CAEF2EEE2EA5696E2432C8C724B7F4F 4A919589A6016F79736B2F9B6D2344FEAA719FAFAD311D6E83 E295BCC5B5E10975FC127015F9E9EC6B48C8968D9735A1240E 6A892BB9AA01B6A7FD320FF00AE8BFCE954F85FA04773BB8DF F00749FEE8AE28EC6EC467AA11133D303CE7C69A9B5D6AA6DF F00E595A7C83DD8F2C7FA54B19CE134808D9A9811B1A6223F3 1918329C329CA9F423A5303D0349D496FF4F8E7CE64C6D987A 38EB5BC4CD9339AB24AEE6A8425A9FF004D83FEBA27FE85535 3E17E838EE76CAFF20FA571C76376217AB248D9E803C86EA42 D713316DC4BB12C7BF3D6A0A2BB3500464D3111B353022634C 474BE0BB96DB7507F08DAE3A77E0FBF6AD60448E89DAB52481 CD5084B43FE9D6FFF005D13FF0042A9A9F0BF41C773B2DFC57 247635634BD5088DDB208F5A607946A56AF677B35B367F76C4 2B118C8EC6B328A84D0046CD4C08C9A622363408EB3C21046B 60F718FDE4AE549F65E98ADA08891B2ED5A9240ED54216CCFF A75BFFD754FFD0854D4F85FA0E3B9D6B3F35CB0D8D98D2F544 9197A6072FE31D2E7BA44BC8003F6746F34679D83E6C8FA735 32434CE20B5414309A62232D408680CEEA8BCB31000F735407 7BA5D97D82C52DB76F6192CDEE4E6B78A336C95DAAC92176A6 02D89FF004FB6FF00AEA9FF00A10A9A9F0BF41C773AA91FE76 FAD7343646AF7232F5648C2F4011C85594AB72AC3045303CD3 57D3A6D3EEDE1707CBCFEE5FB32F6FF00EBD64D15733CB5003 0B5006A786F4F92E6F96E08FDC5B9DC5BD58741FD6B48225B3 B166ADC82176A622166A6225D3FFE3FEDBFEBAA7FE842A6AFC 2FD0A8EE74733FEF5FF00DE3FCEB9E1B23496E465EA8430BD3 B08617A60729E39906CB45CF39738F6E2A26389C916A8288CB 500755E10907D8675EE25C9FC547F856D4CCE46D3356A490B3 5310CA6058D3FFE3FEDBFEBAA7FE842A2AFC2FD0A8EE6E5C3F EFE4FF78FF3AC61F0A2E5B916FAB24AF737F6B6EBBA795631F ED1C52039CD4BC688329609B8FF00CF67E9F82F53F8D4B9956 397BABCB8B994CB3C86490F73FD3D2A0A2B96A00616A621F6D 7F756927996F2146EF8E87EA3BD34237ECBC5D0BE12F17CA6F F009E8BCAFE5D456AA64729B30DCC13AEE8645907AA9CD6A22 4A0458D3FFE3FEDBFEBAA7FE842A2AFC2FD0A8EE5FD5EF63B4 FB55C49F7222C4FE7C0FC6B187C2BD0A7B9C0DE789356B9727 CF3121E91C7F2803EBD4D4F332AC66348CCDB98966F53C9A43 1A5A801A5A810C2D4C0616A60309A621280155991B7212ADEA 383401A16DAFEA90303E71957BA49CE7F1EB54A4C563B8D06E E3BB96CAE23E03C89C7A1DDC8AB9BBC1FA0A3B92F8C34FD52E 2D674B5B49A6DD3FF00CB38D9B8DC4E781ED5CEA6B956A5D9D CE37FE11BF11FFD02EEFF00EFC49FE153CC876627FC237E24F F00A05DDFFDF893FC29F3A0B310F86BC49FF40BBBFF00BF127 F851CEBB8598D3E19F12FFD02AEFF00EFC49FE1473AEE16634 F863C4BFF0040ABBFFBF127F853E75DC2CC6FFC22FE26FF00A 055DFFDF893FC28E78F7172B0FF00845BC4BFF40ABBFF00BF1 27F851CEBB872B0FF00845BC4BFF40ABBFF00BF127F851CEBB 872B0FF00845BC4BFF40ABBFF00BF127F851CEBB872B0FF008 45BC4BFF40ABBFF00BF127F851CEBB872B3ADF06E93ABDB242 B75653C3B6E037EF2375E3239E4553A91E47A8B95DCFFD9' else [pic] end FROM Personel
توضیح اینکه دستور دوم قراره یه تصویر رو به جای Null برگردونه
اینم تصویر خطا:
130548
کسی از دوستان میتونه منو راهنمایی کنه؟
من یه گریدویو دارم که قراره اطلاعات پرسنل رو نمایش بده و بایند شده به جدول پرسنل
وقتی فیلد تصویر که از نوع image هست Null باشه یه علامت ضربدر به جای عکس نشون میده. من میخوام یا خالی نشون بده یا اینکه یه تصویر پیش فرض برای فیلد های خالی نشون بده.
از دستور زیر استفاده کردم اما با خطا مواجه شدم.
SELECT ISNULL([Pic], CONVERT(VARBINARY(MAX), 0)) AS pic FROM Personel
یا
SELECT [pic]=case When [pic]IS NULL then '0xFFD8FFE000104A46494600010101004800480000FFDB004 3000604040405040605050609060506090B080606080B0C0A0 A0B0A0A0C100C0C0C0C0C0C100C0E0F100F0E0C13131414131 31C1B1B1B1C20202020202020202020FFDB0043010707070D0 C0D181010181A1511151A20202020202020202020202020202 02020202020202020202020202020202020202020202020202 0202020202020202020FFC0001108006000600301110002110 1031101FFC4001F00000105010101010101000000000000000 00102030405060708090A0BFFC400B51000020103030204030 50504040000017D01020300041105122131410613516107227 114328191A1082342B1C11552D1F02433627282090A1617181 91A25262728292A3435363738393A434445464748494A53545 5565758595A636465666768696A737475767778797A8384858 68788898A92939495969798999AA2A3A4A5A6A7A8A9AAB2B3B 4B5B6B7B8B9BAC2C3C4C5C6C7C8C9CAD2D3D4D5D6D7D8D9DAE 1E2E3E4E5E6E7E8E9EAF1F2F3F4F5F6F7F8F9FAFFC4001F010 00301010101010101010100000000000001020304050607080 90A0BFFC400B51100020102040403040705040400010277000 102031104052131061241510761711322328108144291A1B1C 109233352F0156272D10A162434E125F11718191A262728292 A35363738393A434445464748494A535455565758595A63646 5666768696A737475767778797A82838485868788898A92939 495969798999AA2A3A4A5A6A7A8A9AAB2B3B4B5B6B7B8B9BAC 2C3C4C5C6C7C8C9CAD2D3D4D5D6D7D8D9DAE2E3E4E5E6E7E8E 9EAF2F3F4F5F6F7F8F9FAFFDA000C03010002110311003F00F A1ADEDED4DB444C284945C9DA3D2B448906B7B5FF009E29FF0 07C8A76110B436FFF003CD7F2155615C81E387FB8BF90A7CA8 5720748FF00BA3F2AAE54172070BE94F950AE40E6AB950AE57 776F5A7C8857640F2C9FDE3F9D5722EC2E6640F3CDFF3D1BF3 355C91EC1CCC81EE6E3FE7ABFFDF469FB38F627998C82EAE4D D420CAE4175046E3EB4A708F2BD06A4EE7A0DBBFF00A345FEE 2FF002AE346E0CF5422166A622076A6054B8B9862C79922A6E E9B8819FCEA84655D788B46824F2E4BB4DC7FBB96FCCAE453B 88956E20986E8A45917D5483FCAA8446E6A8457735422B39AA 115DCD310DB63FE9907FD745FE74A7F0BF41C773D0217FDC47 FEE8FE55C28DD833D508859E98197AE6B10E9964D71272DF76 24FEF31E9FF00D7A623CAEF2EEE2EA5696E2432C8C724B7F4F 4A919589A6016F79736B2F9B6D2344FEAA719FAFAD311D6E83 E295BCC5B5E10975FC127015F9E9EC6B48C8968D9735A1240E 6A892BB9AA01B6A7FD320FF00AE8BFCE954F85FA04773BB8DF F00749FEE8AE28EC6EC467AA11133D303CE7C69A9B5D6AA6DF F00E595A7C83DD8F2C7FA54B19CE134808D9A9811B1A6223F3 1918329C329CA9F423A5303D0349D496FF4F8E7CE64C6D987A 38EB5BC4CD9339AB24AEE6A8425A9FF004D83FEBA27FE85535 3E17E838EE76CAFF20FA571C76376217AB248D9E803C86EA42 D713316DC4BB12C7BF3D6A0A2BB3500464D3111B353022634C 474BE0BB96DB7507F08DAE3A77E0FBF6AD60448E89DAB52481 CD5084B43FE9D6FFF005D13FF0042A9A9F0BF41C773B2DFC57 247635634BD5088DDB208F5A607946A56AF677B35B367F76C4 2B118C8EC6B328A84D0046CD4C08C9A622363408EB3C21046B 60F718FDE4AE549F65E98ADA08891B2ED5A9240ED54216CCFF A75BFFD754FFD0854D4F85FA0E3B9D6B3F35CB0D8D98D2F544 9197A6072FE31D2E7BA44BC8003F6746F34679D83E6C8FA735 32434CE20B5414309A62232D408680CEEA8BCB31000F735407 7BA5D97D82C52DB76F6192CDEE4E6B78A336C95DAAC92176A6 02D89FF004FB6FF00AEA9FF00A10A9A9F0BF41C773AA91FE76 FAD7343646AF7232F5648C2F4011C85594AB72AC3045303CD3 57D3A6D3EEDE1707CBCFEE5FB32F6FF00EBD64D15733CB5003 0B5006A786F4F92E6F96E08FDC5B9DC5BD58741FD6B48225B3 B166ADC82176A622166A6225D3FFE3FEDBFEBAA7FE842A6AFC 2FD0A8EE74733FEF5FF00DE3FCEB9E1B23496E465EA8430BD3 B08617A60729E39906CB45CF39738F6E2A26389C916A8288CB 500755E10907D8675EE25C9FC547F856D4CCE46D3356A490B3 5310CA6058D3FFE3FEDBFEBAA7FE842A2AFC2FD0A8EE6E5C3F EFE4FF78FF3AC61F0A2E5B916FAB24AF737F6B6EBBA795631F ED1C52039CD4BC688329609B8FF00CF67E9F82F53F8D4B9956 397BABCB8B994CB3C86490F73FD3D2A0A2B96A00616A621F6D 7F756927996F2146EF8E87EA3BD34237ECBC5D0BE12F17CA6F F009E8BCAFE5D456AA64729B30DCC13AEE8645907AA9CD6A22 4A0458D3FFE3FEDBFEBAA7FE842A2AFC2FD0A8EE5FD5EF63B4 FB55C49F7222C4FE7C0FC6B187C2BD0A7B9C0DE789356B9727 CF3121E91C7F2803EBD4D4F332AC66348CCDB98966F53C9A43 1A5A801A5A810C2D4C0616A60309A621280155991B7212ADEA 383401A16DAFEA90303E71957BA49CE7F1EB54A4C563B8D06E E3BB96CAE23E03C89C7A1DDC8AB9BBC1FA0A3B92F8C34FD52E 2D674B5B49A6DD3FF00CB38D9B8DC4E781ED5CEA6B956A5D9D CE37FE11BF11FFD02EEFF00EFC49FE153CC876627FC237E24F F00A05DDFFDF893FC29F3A0B310F86BC49FF40BBBFF00BF127 F851CEBB8598D3E19F12FFD02AEFF00EFC49FE1473AEE16634 F863C4BFF0040ABBFFBF127F853E75DC2CC6FFC22FE26FF00A 055DFFDF893FC28E78F7172B0FF00845BC4BFF40ABBFF00BF1 27F851CEBB872B0FF00845BC4BFF40ABBFF00BF127F851CEBB 872B0FF00845BC4BFF40ABBFF00BF127F851CEBB872B0FF008 45BC4BFF40ABBFF00BF127F851CEBB872B3ADF06E93ABDB242 B75653C3B6E037EF2375E3239E4553A91E47A8B95DCFFD9' else [pic] end FROM Personel
توضیح اینکه دستور دوم قراره یه تصویر رو به جای Null برگردونه
اینم تصویر خطا:
130548
کسی از دوستان میتونه منو راهنمایی کنه؟