[ic] updating data without a form?

Dan Browning interchange-users@icdevgroup.org
Tue Sep 3 16:19:02 2002


At 02:18 PM 9/3/2002 -0500, you wrote:


>Simple question, I know...  didn't see this anywhere.
>
>How do I update userdb values without a form?
>
>At the top of the page, I tried [userdb field="value"] which even returned a
>"1" onto my page, but the change didn't persist to the table.  No errors in
>the log...
>
>_Am

After flagging the table writable, try

[query sql=|UPDATE userdb SET field='value' WHERE username='[data session 
username]'|]

Does that help?

/~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\
| Dan Browning, Kavod Technologies      <dan.browning@kavod.com> |
| (360) 882-7872 x7, 6700 NE 162nd Ave, Suite 210, Vancouver, WA |
\~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~/
The sooner you make your first 5000 mistakes, the sooner you will be
able to correct them.
                 -- Nicolaides