[ic] form action, result display not immediate

Paul Jordan interchange-users@icdevgroup.org
Tue Jun 25 13:40:01 2002


Hello

I have a page that lists a set of "mediaboxes"(favorites folders):

    [query
        table="mb_boxlist"
        ml=100
        type=list
        sp="@@MV_PAGE@@"
        sql=|
    		SELECT  boxname, description
    		FROM    mb_boxlist
    		WHERE   username = "[data session username]"
    		ORDER BY boxname
        |]
.....etc...
[/query]

Below this I have the ability to ADD a mediabox (folder):


<FORM ACTION="[process-target]" METHOD="POST" name=add_new>
<INPUT TYPE=hidden NAME=mv_session_id VALUE="[data session id]">

Name:                 <input type="text" name="n_name" value=""><br>
Short description:    <input type="text" name="n_desc" value=""><br>
client password:      <input type="text" name="n_pass" value="">

[button
        form=add_new
        mv_click=Add
     	text="redeem promo"
	src="__BUTTON_DIR__/redeem.gif"
	hidetext=1
	]
	    mv_todo=return
	    mv_nextpage=@@MV_PAGE@@
[/button]


    [set Add]
[if cgi n_name]
[tag flag write]mb_boxlist[/tag]

   [query table="mb_boxlist" sql=|
       REPLACE mb_boxlist
       (username, boxname, password, description)
       VALUES
       ('[data session username]', '[cgi n_name]', '[cgi n_pass]', '[cgi
n_desc]')
   |][/query]

[/if]
    [set]

</form>


The problem is, when the page reloads (after submitting the form) the new
mediabox (folder) does not appear in the mediabox query above until after I
refresh the page *again*.

Is there some sort of positional criteria I am not understanding here?

TIA

Paul