DatabaseValue ¸Å°³º¯¼ö¸¦ Cassette for BankServACH °è»ê¿ø ÇÁ·ÎÆÄÀÏ¿¡ Ãß°¡
°è»ê¿ø ÇÁ·ÎÆÄÀÏÀº BankServACHCashierExtensionÀ̶ó´Â CashierExtension
Ŭ·¡½º¸¦ »ç¿ëÇÏ¿© Çʼö $STATEPROVINCE
¸Å°³º¯¼ö¿¡ ´ëÇÑ 2¹®ÀÚÀÇ »óÅ Äڵ带 È®º¸ÇÕ´Ï´Ù. ÀÌ Å¬·¡½º´Â
{billto_state} ȯ°æ º¯¼ö¿¡ »óÅ À̸§À¸·Î ÁöÁ¤µÈ °ªÀ» »ç¿ëÇÏ¿©
STATEPROV
Å×ÀÌºí¿¡¼ »óÅ Äڵ带 ã½À´Ï´Ù. ¾Æ´Ï¸é, ADDRESS
Å×À̺íÀÇ STATE ¿¿¡¸¸ ¿Ã¹Ù¸¥ »óÅ À̸§ÀÌ °ªÀ¸·Î µé¾î ÀÖ´Ù´Â °ÍÀ» ¾Æ´Â °æ¿ì
$STATEPROVINCE ¸Å°³º¯¼ö¿¡ ´ëÇÑ DatabaseValue¸¦ »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù.
DatabaseValue¸¦ »ç¿ëÇÏ·Á¸é ´ÙÀ½À» ¼öÇàÇϽʽÿÀ..
- ´ÙÀ½ ¸í·É¹®À» <CollectPayment> ÅÂ±× ¾Õ¿¡ Ãß°¡ÇϽʽÿÀ.
<SelectStatement id="1" >
SELECT DISTINCT STATEPROVABBR FROM StateProv WHERE countryAbbr = 'US' AND
name = {billto_state}
</SelectStatement>
- <Parameter name=$STATEPROVINCE .......> ............
</Parameter> ÀýÀ» ´ÙÀ½À¸·Î ´ëüÇϽʽÿÀ.
<Parameter name="$STATEPROVINCE" maxBytes="2"
encoding="ASCII">
<DatabaseValue statementID="1" columnName="STATEPROVABBR"
/>
</Parameter>