Multiple row insert not working as before after applying hotfix apsb13-13

-

coldfusion 9.01

windows server 2003

microsoft access database (yeah, know)

 

before hotfix applied, add multiple rows (anywhere 1-100 or more) , we're limited 15 rows @ time after applying hotfix. we've narrowed down hotfix being culprit had rebuild server not long after hotfix applied (~ 1 month) , multiple row inserts once again working fine until got point of applying hot fix again.

anyone heard of happening? ideas how correct?

 

thanks in advance,

fmhelp

 

 

below code  of how we're doing multiple row insert (it's performed on 3 pages):

page 1

<cfform name="form1" method="post" action="handler.cfm?page=update_2">

<input type="hidden" name="sproductid" value="<cfoutput>#qproducts.sproductid#</cfoutput>">

<table width="100%" border="0" cellspacing="3" cellpadding="3">

  <tr>

    <th scope="row" colspan="2" align="center">update inventory product</th>

  </tr>

  <tr>

    <th width="42%" scope="row">product id</th>

    <td width="58%"><cfoutput>#qproducts.sproductid#</cfoutput></td>

  </tr>

  <tr>

    <th width="42%" scope="row">friendly name</th>

    <td width="58%"><cfoutput>#qproducts.sfriendly_name#</cfoutput></td>

  </tr>

  <tr>

    <th width="42%" scope="row">description</th>

    <td width="58%"><cfoutput>#qproducts.sdescription#</cfoutput></td>

  </tr>

  <tr>

    <th width="42%" scope="row">vendor</th>

    <td><select name="svendor">

      <cfoutput><option value="#qproducts.svendor#">#qproducts.svendor#</option></cfoutput>

      <option value=""></option>

      <cfoutput query="qvendor">

        <option value="#svendor#">#svendor#</option>

      </cfoutput>

    </select></td>

  </tr>

  <tr>

    <th scope="row">order no.</th>

    <td><cfinput name="sorder_no" type="text" value="" required="yes" message="order number required field."></td>

  </tr>

  <tr>

    <th scope="row">lot no.</th>

    <td><input name="slot" type="text" value=""/></td>

  </tr>

  <tr>

    <th scope="row">date expires</th>

    <td><input name="dtexpire" type="text" value=""/></td>

  </tr>

  <tr>

    <th scope="row">boxes received</th>

    <td><input name="iboxes" type="text" value="" /></td>

  </tr>

  <tr>

    <th scope="row">doses/units</th>

    <td><input name="pcount" type="text" value="" /></td>

  </tr>

  <tr>

    <th scope="row">note</th>

    <td><cfoutput>#qproducts.snote#</cfoutput></td>

  </tr>

  <tr>

    <th scope="row"> </th>

    <td> </td>

  </tr>

  <tr>

    <th scope="row" colspan="2" align="center"><input type="submit" value="submit" /></th>

  </tr>

</table>

</cfform>

</table>

 

page 2

<form name="form1" method="post" action="handler.cfm?page=update_3">

<cfoutput><input type="hidden" name="pcount" value="#form.pcount#"></cfoutput>

<table width="100%" border="0" cellspacing="0" cellpadding="0">

    <tr>

          <td colspan="6" align="left">record count (doses/units)= <cfoutput>#form.pcount#</cfoutput></td>

    </tr>

    <tr>

        <td>product id</td>

        <td>vendor</td>

        <td>order no.</td>

        <td>lot no.</td>

        <td>expiration date</td>

        <td>num. of boxes</td>

    </tr>

    <cfset peoplecount = 0>

    <cfloop index="add" from="1" to="#form.pcount#" step="1">

        <tr>

            <cfset peoplecount = peoplecount + 1>

            <td><input  <cfoutput> value="#form.sproductid#" </cfoutput> name="sproductid_<cfoutput>#peoplecount#</cfoutput>" type="text" id="sproductid_"></td>

            <td><input <cfoutput>value="#form.svendor#"</cfoutput> name="svendor_<cfoutput>#peoplecount#</cfoutput>" type="text" id="svendor_"></td>

            <td><input  <cfoutput> value="#form.sorder_no#" </cfoutput> name="sorder_no_<cfoutput>#peoplecount#</cfoutput>" type="text" id="sorder_no_"></td>

            <td><input <cfoutput>value="#form.slot#"</cfoutput> name="slot_<cfoutput>#peoplecount#</cfoutput>" type="text" id="slot_"></td>

            <td><input  <cfoutput> value="#dateformat(form.dtexpire, 'mm/dd/yy')#" </cfoutput> name="dtexpire_<cfoutput>#peoplecount#</cfoutput>" type="text" id="dtexpire_"></td>

            <td><input <cfoutput>value="#form.iboxes#"</cfoutput> name="iboxes_<cfoutput>#peoplecount#</cfoutput>" type="text" id="iboxes_"></td>

        </tr>

    </cfloop>

    <tr>

        <td> </td>

        <td>

            <input type="submit" name="submit" value="submit">

            <input name="howmany" type="hidden" id="howmany" value="<cfoutput>#form.pcount#</cfoutput>">

        </td>

    </tr>

</table>

</form>

</table>

 

page 3

<cfquery name="qgetonhand" datasource="#variables.dsnci#">

select        *

from        products

where        sproductid = '#session.sproductid#'

</cfquery>

 

<cfquery datasource="#variables.dsnci#">

update        products

set            ionhandqty = (#form.pcount# + #qgetonhand.ionhandqty#)

where        sproductid = '#session.sproductid#'

</cfquery>           

 

<cfset quantity = #form.pcount#>

 

<cfset pcount = 0>

<!-- start loop -->

<cfloop index="add" from="1" to="#form.howmany#" step="1">

    <cfset pcount = pcount + 1>

    <cfset product = "form.sproductid_#pcount#">

    <cfset product = evaluate(product)>

    <cfset vendor = "form.svendor_#pcount#">

    <cfset vendor = evaluate(vendor)>

    <cfset order  = "form.sorder_no_#pcount#">

    <cfset order = evaluate(order)>

    <cfset lot = "form.slot_#pcount#">

    <cfset lot = evaluate(lot)>

    <cfset expires = "form.dtexpire_#pcount#">

    <cfset expires = evaluate(expires)>

    <cfset boxes = "form.iboxes_#pcount#">

    <cfset boxes = evaluate(boxes)>

    <cfquery datasource="#variables.dsnci#" name="insertdata">

        insert received_history (sproductid, svendor, sorder_no, slot, dtexpire, iboxes, dtreceived)

        values ('#product#', '#vendor#', '#order#', '#lot#', <cfif expires "">null<cfelse>#createodbcdate(expires)#</cfif>, #boxes#, #createodbcdate(now())#)

    </cfquery>

</cfloop>



More discussions in ColdFusion


adobe

Comments

Post a Comment

Popular posts from this blog

Thread: gpg: Conflicting Commands

-
Image
hi, relatively new linux (have used many live disks) , have had install of ubuntu 12.04 few days now. part have found easy use , have been comfortable it. have first question can't resolve myself: adding googles repository list. when first ran command supplied google found did not have wget installed. used apt-get install it. worked fine (as far can tell) re-ran googles code : wget -q https://dl-ssl.google.com/linux/linux_signing_key.pub -o- | sudo apt-key add -deb http://dl.google.com/linux/deb/ stable non-free , message 'gpg: conflicting commands' tell me going wrong , how fix please new script : wget -q https://dl-ssl.google.com/linux/linux_signing_key.pub -o- | sudo apt-key add linux_signing_key.pub need edit /etc/apt/sources.list , add line @ end deb http://dl.google.com/linux/deb/ stable non-free end hope find usefull edit: need root or use sudo make changes /etc/apt/sour...
Read more

Thread: World of Warcraft private server with wine?

-
hello! title reads trying on world of warcraft horse heck of it, , having spent last 8 hours trying virtualbox windows vista figure out drivers needed cannot installed able play game , configuring/installing wine , wow itself, beginning run out of patience , lust figure out... turn more direct help! has tried this? had success? comments or tips? cheers! yes world of warcraft private server doable. have been playing world of warcraft private servers years using wine. stay away player vs player servers there people cheat. , bother other players. wont go experiences that. right i’m using wine 1.5.3 ever comes ubuntu should work fine. if video card bit old recommend using -opengl extension better graphics , performance. pre-cataclysm play pve deathpod, works little no lag. cataclysm have been playing pve astralwow, buggy playable. Forum The Ubuntu Forum Community ...
Read more

Thread: video metadata editing??

-
Image
i have been searching time way edit metadata of video file created along de-novo file. specifically, vlc example, displays metadata text when begins playing file. trying access to. seems me, if there way create metadata in first place, there *must* way edit it. how? using either 11.04 or 12.04 kubuntu. nautilus it's nice icon displays of photos , vids. typically use gwenview , gimp photos , vlc , avidemux video. these tools work things, occasionally, there video has wrong or verbose metadata , far have found no way edit stuff. vlc has option purports work in cases, not reliable, looking swiss-army-knife solution can handle multiple formats (avi/wmv/mpg/mp4/etc/etc) in manner exfalso audio files. "ffmpg" command-line tool not work way, may part of app does. there video geek out there in ubu-land has known solution? folks use create these files in first place? thanks, ct use c...
Read more