Inserting delimiting character in hex char string

> Hi,
>
> I've got an app that accepts the ethernet address as defined as a string of
> 6 hex character pairs delimited by either ":" or "-" characters. This string
> is then inserted into a database column with an SQL statement that replaces
> the ":" with "-". The net result is that irrespective of whether the user
> types in aa:bb:cc:dd:ee:ff or aa-bb-cc-dd-ee-ff the input is "normalised" to
> aa-bb-cc-dd-ee-ff.
>
> I'd like to expand this so that if the user inserts aabbccddeeff it gets
> delimiting chars iserted so thge output is aa-bb-cc-dd-ee-ff. Useful thing
> to do as our users just tend to cut and paste ethernet addresses into the
> field and then have to play about with cursor keys to insert either a : or -
> character.
>
> I've currently  got
>
>          <xforms:instance id="add-instance">
>                <radius_client>
>                    <mac_address/>
>                    <user_name/>
>                    <registering_user_name/>
>                    <dest_auth_vlan/>
>                    <dest_unauth_vlan>UNAUTH_VLAN</dest_unauth_vlan>
>                    <mac_info/>
>                </radius_client>
>            </xforms:instance>
>
>           <xforms:bind nodeset="instance('add-instance')">
>               <xforms:bind nodeset="mac_address"
> constraint="matches(.,'^([0-9a-fA-F]{2}([:-]|$)){6}$')" required="true()"/>
>               <xforms:bind nodeset="user_name" required="true()"/>
>               <xforms:bind nodeset="registering_user_name"
> required="true()"/>
>               <xforms:bind nodeset="mac_info" constraint="string-length(.)
> &lt; 100" required="true()"/>
>            </xforms:bind>
>
>          <xforms:submission id="add-submission"
> ref="instance('add-instance')" replace="none" instance="main" method="post"
> action="/mac-auth-mgt/add">
>               <xforms:message ev:event="xforms-submit-error"
> level="modal"><xhtml:h1>Oops! </xhtml:h1><xhtml:br/>An error occurred while
> adding your client details.
>                    <xhtml:p>Are you sure you have specified a valid MAC
> address? Click on the blue ? to the left of an input field for information
> on that field.</xhtml:p>
>               </xforms:message>
>               <xforms:message ev:event="xforms-submit-done"
> level="modal">Mac address submitted successfully</xforms:message>
>               <xforms:insert ev:event="xforms-submit-done"
> nodeset="instance('netdev-instance')/radius_devices/radius_client"
> at="last()" position="after"/>
>               <xforms:setvalue ev:event="xforms-submit-done"
> ref="instance('netdev-instance')/radius_devices/radius_client[last()]/registering_user_name"
>                      value=
> "instance('netdev-instance')/request/remote-user"/>
>                <xforms:setvalue ev:event="xforms-submit-done"
> ref="instance('netdev-instance')/radius_devices/radius_client[last()]/user_name"
>
>  value="instance('netdev-instance')/request/remote-user"/>
>                <xforms:setvalue ev:event="xforms-submit-done"
> ref="instance('netdev-instance')/radius_devices/radius_client[last()]/date_added"
> value="now()"/>
>                <xforms:setvalue ev:event="xforms-submit-done"
> ref="instance('netdev-instance')/radius_devices/radius_client[last()]/auth_vlan"
>                      value="instance('add-instance')/auth_vlan"/>
>                <xforms:setvalue ev:event="xforms-submit-done"
> ref="instance('netdev-instance')/radius_devices/radius_client[last()]/mac_info"
>                       value="instance('add-instance')/mac_info"/>
>                <xforms:setvalue ev:event="xforms-submit-done"
> ref="instance('netdev-instance')/radius_devices/radius_client[last()]/unauth_vlan"
>                      value="instance('add-instance')/unauth_vlan"/>
>                <xforms:setvalue ev:event="xforms-submit-done"
> ref="instance('netdev-instance')/radius_devices/radius_client[last()]/mac_address"
>                       value="instance('add-instance')/mac_address"/>
>            </xforms:submission>
>
> Where the submission calls service-add.xpl
>
> with
>
> <p:config xmlns:p="http://www.orbeon.com/oxf/pipeline"
>          xmlns:sql="http://orbeon.org/oxf/xml/sql"
>          xmlns:xs="http://www.w3.org/2001/XMLSchema"
>          xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
>          xmlns:oxf="http://www.orbeon.com/oxf/processors">
>
>   <p:param type="input" name="instance"/>
>
>    <p:processor name="oxf:sql">
>        <p:input name="data" href="#instance"/>
>        <p:input name="config">
>            <sql:config>
>                <result>
>
>  <sql:connection>
>                        <sql:datasource>radSupport</sql:datasource>
>                        <sql:execute>
>                            <sql:update>
>                                insert into mac_auth
> (mac_address,user_name,registering_user,dest_auth_vlan,dest_unauth_vlan,mac_info)
> values (
>                                    LOWER(REPLACE(<sql:param type="xs:string"
> select="/radius_client/mac_address"/>,':','-')),
>                                    <sql:param type="xs:string"
> select="/radius_client/user_name"/>,
>                                    <sql:param type="xs:string"
> select="/radius_client/registering_user_name"/>,
>                                    <sql:param type="xs:string"
> select="/radius_client/dest_auth_vlan"/>,
>                                    <sql:param type="xs:string"
> select="/radius_client/dest_unauth_vlan"/>,
>                                    <sql:param type="xs:string"
> select="/radius_client/mac_info"/>
>                                    )
>                                on duplicate key update
> mac_address=VALUES(mac_address),user_name=VALUES(user_name),
>
>  registering_user=VALUES(registering_user),
>                                    dest_auth_vlan=VALUES(dest_auth_vlan),
>
>  dest_unauth_vlan=VALUES(dest_unauth_vlan),
>                                    mac_info=VALUES(mac_info);
>                            </sql:update>
>                        </sql:execute>
>                    </sql:connection>
> .........
>
> So the constraint need to be modified to accept a 12 char hex strting as
> well,  but is there anywhere in the submit statement or the service-add.xpl
> where I can munge the hex address around
>
> Rgds
> Alex
>
>
>
>
> --
> You receive this message as a subscriber of the [hidden email] mailing
> list.
> To unsubscribe: mailto:[hidden email]
> For general help: mailto:[hidden email]?subject=help
> OW2 mailing lists service home page: http://www.ow2.org/wws
>
>

> Alex,
>
> So you want to insert the separators in the SQL processor, as opposed
> to the XForms side?
>
> One issue is that the SQL processor only supports XPath 1, not XPath
> 2, so what you can do there is pretty limited!
>
> -Erik
>
> On Tue, Jun 28, 2011 at 3:39 AM, alex sharaz <[hidden email]> wrote:
>> Hi,
>>
>> I've got an app that accepts the ethernet address as defined as a string of
>> 6 hex character pairs delimited by either ":" or "-" characters. This string
>> is then inserted into a database column with an SQL statement that replaces
>> the ":" with "-". The net result is that irrespective of whether the user
>> types in aa:bb:cc:dd:ee:ff or aa-bb-cc-dd-ee-ff the input is "normalised" to
>> aa-bb-cc-dd-ee-ff.
>>
>> I'd like to expand this so that if the user inserts aabbccddeeff it gets
>> delimiting chars iserted so thge output is aa-bb-cc-dd-ee-ff. Useful thing
>> to do as our users just tend to cut and paste ethernet addresses into the
>> field and then have to play about with cursor keys to insert either a : or -
>> character.
>>
>> I've currently  got
>>
>>          <xforms:instance id="add-instance">
>>                <radius_client>
>>                    <mac_address/>
>>                    <user_name/>
>>                    <registering_user_name/>
>>                    <dest_auth_vlan/>
>>                    <dest_unauth_vlan>UNAUTH_VLAN</dest_unauth_vlan>
>>                    <mac_info/>
>>                </radius_client>
>>            </xforms:instance>
>>
>>           <xforms:bind nodeset="instance('add-instance')">
>>               <xforms:bind nodeset="mac_address"
>> constraint="matches(.,'^([0-9a-fA-F]{2}([:-]|$)){6}$')" required="true()"/>
>>               <xforms:bind nodeset="user_name" required="true()"/>
>>               <xforms:bind nodeset="registering_user_name"
>> required="true()"/>
>>               <xforms:bind nodeset="mac_info" constraint="string-length(.)
>> &lt; 100" required="true()"/>
>>            </xforms:bind>
>>
>>          <xforms:submission id="add-submission"
>> ref="instance('add-instance')" replace="none" instance="main" method="post"
>> action="/mac-auth-mgt/add">
>>               <xforms:message ev:event="xforms-submit-error"
>> level="modal"><xhtml:h1>Oops! </xhtml:h1><xhtml:br/>An error occurred while
>> adding your client details.
>>                    <xhtml:p>Are you sure you have specified a valid MAC
>> address? Click on the blue ? to the left of an input field for information
>> on that field.</xhtml:p>
>>               </xforms:message>
>>               <xforms:message ev:event="xforms-submit-done"
>> level="modal">Mac address submitted successfully</xforms:message>
>>               <xforms:insert ev:event="xforms-submit-done"
>> nodeset="instance('netdev-instance')/radius_devices/radius_client"
>> at="last()" position="after"/>
>>               <xforms:setvalue ev:event="xforms-submit-done"
>> ref="instance('netdev-instance')/radius_devices/radius_client[last()]/registering_user_name"
>>                      value=
>> "instance('netdev-instance')/request/remote-user"/>
>>                <xforms:setvalue ev:event="xforms-submit-done"
>> ref="instance('netdev-instance')/radius_devices/radius_client[last()]/user_name"
>>
>>  value="instance('netdev-instance')/request/remote-user"/>
>>                <xforms:setvalue ev:event="xforms-submit-done"
>> ref="instance('netdev-instance')/radius_devices/radius_client[last()]/date_added"
>> value="now()"/>
>>                <xforms:setvalue ev:event="xforms-submit-done"
>> ref="instance('netdev-instance')/radius_devices/radius_client[last()]/auth_vlan"
>>                      value="instance('add-instance')/auth_vlan"/>
>>                <xforms:setvalue ev:event="xforms-submit-done"
>> ref="instance('netdev-instance')/radius_devices/radius_client[last()]/mac_info"
>>                       value="instance('add-instance')/mac_info"/>
>>                <xforms:setvalue ev:event="xforms-submit-done"
>> ref="instance('netdev-instance')/radius_devices/radius_client[last()]/unauth_vlan"
>>                      value="instance('add-instance')/unauth_vlan"/>
>>                <xforms:setvalue ev:event="xforms-submit-done"
>> ref="instance('netdev-instance')/radius_devices/radius_client[last()]/mac_address"
>>                       value="instance('add-instance')/mac_address"/>
>>            </xforms:submission>
>>
>> Where the submission calls service-add.xpl
>>
>> with
>>
>> <p:config xmlns:p="http://www.orbeon.com/oxf/pipeline"
>>          xmlns:sql="http://orbeon.org/oxf/xml/sql"
>>          xmlns:xs="http://www.w3.org/2001/XMLSchema"
>>          xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
>>          xmlns:oxf="http://www.orbeon.com/oxf/processors">
>>
>>   <p:param type="input" name="instance"/>
>>
>>    <p:processor name="oxf:sql">
>>        <p:input name="data" href="#instance"/>
>>        <p:input name="config">
>>            <sql:config>
>>                <result>
>>
>>  <sql:connection>
>>                        <sql:datasource>radSupport</sql:datasource>
>>                        <sql:execute>
>>                            <sql:update>
>>                                insert into mac_auth
>> (mac_address,user_name,registering_user,dest_auth_vlan,dest_unauth_vlan,mac_info)
>> values (
>>                                    LOWER(REPLACE(<sql:param type="xs:string"
>> select="/radius_client/mac_address"/>,':','-')),
>>                                    <sql:param type="xs:string"
>> select="/radius_client/user_name"/>,
>>                                    <sql:param type="xs:string"
>> select="/radius_client/registering_user_name"/>,
>>                                    <sql:param type="xs:string"
>> select="/radius_client/dest_auth_vlan"/>,
>>                                    <sql:param type="xs:string"
>> select="/radius_client/dest_unauth_vlan"/>,
>>                                    <sql:param type="xs:string"
>> select="/radius_client/mac_info"/>
>>                                    )
>>                                on duplicate key update
>> mac_address=VALUES(mac_address),user_name=VALUES(user_name),
>>
>>  registering_user=VALUES(registering_user),
>>                                    dest_auth_vlan=VALUES(dest_auth_vlan),
>>
>>  dest_unauth_vlan=VALUES(dest_unauth_vlan),
>>                                    mac_info=VALUES(mac_info);
>>                            </sql:update>
>>                        </sql:execute>
>>                    </sql:connection>
>> .........
>>
>> So the constraint need to be modified to accept a 12 char hex strting as
>> well,  but is there anywhere in the submit statement or the service-add.xpl
>> where I can munge the hex address around
>>
>> Rgds
>> Alex
>>
>>
>>
>>
>> --
>> You receive this message as a subscriber of the [hidden email] mailing
>> list.
>> To unsubscribe: mailto:[hidden email]
>> For general help: mailto:[hidden email]?subject=help
>> OW2 mailing lists service home page: http://www.ow2.org/wws
>>
>>
>
> --
> You receive this message as a subscriber of the [hidden email] mailing list.
> To unsubscribe: mailto:[hidden email]
> For general help: mailto:[hidden email]?subject=help
> OW2 mailing lists service home page: http://www.ow2.org/wws

> hi,
> Well, I could write a wee bit of java to do all the processing on the "add" instance before it gets passed to the sql processor but just wondered if i could do it in xpath somewhere
> rgds
> Alex
> On 29 Jun 2011, at 06:22, Erik Bruchez wrote:
>
>> Alex,
>>
>> So you want to insert the separators in the SQL processor, as opposed
>> to the XForms side?
>>
>> One issue is that the SQL processor only supports XPath 1, not XPath
>> 2, so what you can do there is pretty limited!
>>
>> -Erik
>>
>> On Tue, Jun 28, 2011 at 3:39 AM, alex sharaz <[hidden email]> wrote:
>>> Hi,
>>>
>>> I've got an app that accepts the ethernet address as defined as a string of
>>> 6 hex character pairs delimited by either ":" or "-" characters. This string
>>> is then inserted into a database column with an SQL statement that replaces
>>> the ":" with "-". The net result is that irrespective of whether the user
>>> types in aa:bb:cc:dd:ee:ff or aa-bb-cc-dd-ee-ff the input is "normalised" to
>>> aa-bb-cc-dd-ee-ff.
>>>
>>> I'd like to expand this so that if the user inserts aabbccddeeff it gets
>>> delimiting chars iserted so thge output is aa-bb-cc-dd-ee-ff. Useful thing
>>> to do as our users just tend to cut and paste ethernet addresses into the
>>> field and then have to play about with cursor keys to insert either a : or -
>>> character.
>>>
>>> I've currently  got
>>>
>>>          <xforms:instance id="add-instance">
>>>                <radius_client>
>>>                    <mac_address/>
>>>                    <user_name/>
>>>                    <registering_user_name/>
>>>                    <dest_auth_vlan/>
>>>                    <dest_unauth_vlan>UNAUTH_VLAN</dest_unauth_vlan>
>>>                    <mac_info/>
>>>                </radius_client>
>>>            </xforms:instance>
>>>
>>>           <xforms:bind nodeset="instance('add-instance')">
>>>               <xforms:bind nodeset="mac_address"
>>> constraint="matches(.,'^([0-9a-fA-F]{2}([:-]|$)){6}$')" required="true()"/>
>>>               <xforms:bind nodeset="user_name" required="true()"/>
>>>               <xforms:bind nodeset="registering_user_name"
>>> required="true()"/>
>>>               <xforms:bind nodeset="mac_info" constraint="string-length(.)
>>> &lt; 100" required="true()"/>
>>>            </xforms:bind>
>>>
>>>          <xforms:submission id="add-submission"
>>> ref="instance('add-instance')" replace="none" instance="main" method="post"
>>> action="/mac-auth-mgt/add">
>>>               <xforms:message ev:event="xforms-submit-error"
>>> level="modal"><xhtml:h1>Oops! </xhtml:h1><xhtml:br/>An error occurred while
>>> adding your client details.
>>>                    <xhtml:p>Are you sure you have specified a valid MAC
>>> address? Click on the blue ? to the left of an input field for information
>>> on that field.</xhtml:p>
>>>               </xforms:message>
>>>               <xforms:message ev:event="xforms-submit-done"
>>> level="modal">Mac address submitted successfully</xforms:message>
>>>               <xforms:insert ev:event="xforms-submit-done"
>>> nodeset="instance('netdev-instance')/radius_devices/radius_client"
>>> at="last()" position="after"/>
>>>               <xforms:setvalue ev:event="xforms-submit-done"
>>> ref="instance('netdev-instance')/radius_devices/radius_client[last()]/registering_user_name"
>>>                      value=
>>> "instance('netdev-instance')/request/remote-user"/>
>>>                <xforms:setvalue ev:event="xforms-submit-done"
>>> ref="instance('netdev-instance')/radius_devices/radius_client[last()]/user_name"
>>>
>>>  value="instance('netdev-instance')/request/remote-user"/>
>>>                <xforms:setvalue ev:event="xforms-submit-done"
>>> ref="instance('netdev-instance')/radius_devices/radius_client[last()]/date_added"
>>> value="now()"/>
>>>                <xforms:setvalue ev:event="xforms-submit-done"
>>> ref="instance('netdev-instance')/radius_devices/radius_client[last()]/auth_vlan"
>>>                      value="instance('add-instance')/auth_vlan"/>
>>>                <xforms:setvalue ev:event="xforms-submit-done"
>>> ref="instance('netdev-instance')/radius_devices/radius_client[last()]/mac_info"
>>>                       value="instance('add-instance')/mac_info"/>
>>>                <xforms:setvalue ev:event="xforms-submit-done"
>>> ref="instance('netdev-instance')/radius_devices/radius_client[last()]/unauth_vlan"
>>>                      value="instance('add-instance')/unauth_vlan"/>
>>>                <xforms:setvalue ev:event="xforms-submit-done"
>>> ref="instance('netdev-instance')/radius_devices/radius_client[last()]/mac_address"
>>>                       value="instance('add-instance')/mac_address"/>
>>>            </xforms:submission>
>>>
>>> Where the submission calls service-add.xpl
>>>
>>> with
>>>
>>> <p:config xmlns:p="http://www.orbeon.com/oxf/pipeline"
>>>          xmlns:sql="http://orbeon.org/oxf/xml/sql"
>>>          xmlns:xs="http://www.w3.org/2001/XMLSchema"
>>>          xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
>>>          xmlns:oxf="http://www.orbeon.com/oxf/processors">
>>>
>>>   <p:param type="input" name="instance"/>
>>>
>>>    <p:processor name="oxf:sql">
>>>        <p:input name="data" href="#instance"/>
>>>        <p:input name="config">
>>>            <sql:config>
>>>                <result>
>>>
>>>  <sql:connection>
>>>                        <sql:datasource>radSupport</sql:datasource>
>>>                        <sql:execute>
>>>                            <sql:update>
>>>                                insert into mac_auth
>>> (mac_address,user_name,registering_user,dest_auth_vlan,dest_unauth_vlan,mac_info)
>>> values (
>>>                                    LOWER(REPLACE(<sql:param type="xs:string"
>>> select="/radius_client/mac_address"/>,':','-')),
>>>                                    <sql:param type="xs:string"
>>> select="/radius_client/user_name"/>,
>>>                                    <sql:param type="xs:string"
>>> select="/radius_client/registering_user_name"/>,
>>>                                    <sql:param type="xs:string"
>>> select="/radius_client/dest_auth_vlan"/>,
>>>                                    <sql:param type="xs:string"
>>> select="/radius_client/dest_unauth_vlan"/>,
>>>                                    <sql:param type="xs:string"
>>> select="/radius_client/mac_info"/>
>>>                                    )
>>>                                on duplicate key update
>>> mac_address=VALUES(mac_address),user_name=VALUES(user_name),
>>>
>>>  registering_user=VALUES(registering_user),
>>>                                    dest_auth_vlan=VALUES(dest_auth_vlan),
>>>
>>>  dest_unauth_vlan=VALUES(dest_unauth_vlan),
>>>                                    mac_info=VALUES(mac_info);
>>>                            </sql:update>
>>>                        </sql:execute>
>>>                    </sql:connection>
>>> .........
>>>
>>> So the constraint need to be modified to accept a 12 char hex strting as
>>> well,  but is there anywhere in the submit statement or the service-add.xpl
>>> where I can munge the hex address around
>>>
>>> Rgds
>>> Alex
>>>
>>>
>>>
>>>
>>> --
>>> You receive this message as a subscriber of the [hidden email] mailing
>>> list.
>>> To unsubscribe: mailto:[hidden email]
>>> For general help: mailto:[hidden email]?subject=help
>>> OW2 mailing lists service home page: http://www.ow2.org/wws
>>>
>>>
>>
>> --
>> You receive this message as a subscriber of the [hidden email] mailing list.
>> To unsubscribe: mailto:[hidden email]
>> For general help: mailto:[hidden email]?subject=help
>> OW2 mailing lists service home page: http://www.ow2.org/wws
>
>
>
> --
> You receive this message as a subscriber of the [hidden email] mailing list.
> To unsubscribe: mailto:[hidden email]
> For general help: mailto:[hidden email]?subject=help
> OW2 mailing lists service home page: http://www.ow2.org/wws
>
>