RMS: Discussion Groups
News l Modules l TechInfo l FAQ/HOWTO l RoxenProviders l Discuss l
Login :
Don't have an account? Register Forgot your password? Retreive
Benefits of Registering * Privacy Policy

Roxen Discussions

General Discussion

Subject: Re: Roxen SQL Interactivity
Posted on: 16 September 1998 by Bill Welliver

What you can do is have a form surrounded by the sqloutput container like this:

<form action="blah.html">
<sqloutput query="select name,id from users where id='hww3'">
<input type=text name=name value="#name#"> Change your name
<input type=hidden name=id value="#id#">

and then in blah.html:

<formoutput quote="+">
<sqlquery query="UPDATE users SET name='+name+' WHERE id='+id+'">

And there you go! Use formoutput to insert the values from your form into the sql query string. The only downside is that RXML doesn't do validation of the values, so you have to accept what is input as the truth.

Hope this helps!


[ New Post ]   [ Post Reply ]   [ Previous Post ]   [ Next Post ]   [ Previous in Thread ]   [ Next in Thread ]   [ Forum Index ]

Follow Up:


Comments? Questions? < rms@riverweb.com >
visitors since .
This page last updated February 2002.
Riverweb Logo RMS is hosted by Riverweb Internet Commerce
Copyright © 1998 H. William Welliver III
This site is powered by Roxen Challenger 1.3 and mySQL.