DatabaseValue ¸Å°³º¯¼ö¸¦ Cassette for BankServACH °è»ê¿ø ÇÁ·ÎÆÄÀÏ¿¡ Ãß°¡

°è»ê¿ø ÇÁ·ÎÆÄÀÏÀº BankServACHCashierExtensionÀ̶ó´Â CashierExtension Ŭ·¡½º¸¦ »ç¿ëÇÏ¿© Çʼö $STATEPROVINCE ¸Å°³º¯¼ö¿¡ ´ëÇÑ 2¹®ÀÚÀÇ »óÅ Äڵ带 È®º¸ÇÕ´Ï´Ù. ÀÌ Å¬·¡½º´Â {billto_state} ȯ°æ º¯¼ö¿¡ »óÅ À̸§À¸·Î ÁöÁ¤µÈ °ªÀ» »ç¿ëÇÏ¿© STATEPROV Å×ÀÌºí¿¡¼­ »óÅ Äڵ带 ã½À´Ï´Ù. ¾Æ´Ï¸é, ADDRESS Å×À̺íÀÇ STATE ¿­¿¡¸¸ ¿Ã¹Ù¸¥ »óÅ À̸§ÀÌ °ªÀ¸·Î µé¾î ÀÖ´Ù´Â °ÍÀ» ¾Æ´Â °æ¿ì $STATEPROVINCE ¸Å°³º¯¼ö¿¡ ´ëÇÑ DatabaseValue¸¦ »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù.  

DatabaseValue¸¦ »ç¿ëÇÏ·Á¸é ´ÙÀ½À» ¼öÇàÇϽʽÿÀ..

  1. ´ÙÀ½ ¸í·É¹®À» <CollectPayment> ÅÂ±× ¾Õ¿¡ Ãß°¡ÇϽʽÿÀ.
    <SelectStatement id="1" >
    SELECT DISTINCT STATEPROVABBR FROM StateProv WHERE countryAbbr = 'US' AND name = {billto_state}
    </SelectStatement>
  2. <Parameter name=$STATEPROVINCE .......> ............ </Parameter> ÀýÀ» ´ÙÀ½À¸·Î ´ëüÇϽʽÿÀ.
    <Parameter name="$STATEPROVINCE" maxBytes="2" encoding="ASCII">
    <DatabaseValue statementID="1" columnName="STATEPROVABBR" />
    </Parameter>

°ü·Ã °³³ä(1275¹ÙÀÌÆ®)

°ü·Ã °³³ä(1275¹ÙÀÌÆ®)

IBM copyright