Re: [mv] Inserting a record into an arbitrary database

["Jason M. Korkin" <jkorkin@korksoft.com>]

******    message to minivend-users from "Jason M. Korkin" <jkorkin@korksoft.com>     ******

Chris,
    You can insert, update, or delete records through the [sql] tag... just shoot regular
SQL statements into your database and it should work OK.  Both of the following examples
have been pulled from sites which we've done recently.

    An example for MV4.04a:

        [sql interpolate=1]
        insert into userdb (username, password) values ('[value mv_username]', '[value
mv_password]')
        [/sql]

    Like wise, you can also remove records quite easily too:

        [sql interpolate=1]
        delete from userdb where email='[value email]'
        [/sql]


    Regards,

    Jason Korkin.

Chris Wenham wrote:

> ******    message to minivend-users from Chris Wenham <cwenham@netmonger.net>     ******
>
>  Does anyone know how to insert a record into an arbitrary
>  database. I've tried the manuals, but I can't find anything in the
>  documentation that explains how this is done. There's a reference to
>  a tag called [record], but the documentation on it is insufficient.
>
>  I also can't do it through a form submission ([process]), it needs to
>  be done inline.
>
> Regards,
>
> Chris Wenham
> -
> To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
> email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
> Archive of past messages: http://www.minivend.com/minivend/minivend-list

--
KORKSOFT - Software & Internet Solutions
System Integration, E-Commerce, C++/Perl/PHP/ASP
Web hosting, Server Co-Location, Dedicated Circuits
http://www.korksoft.com
http://www.atworkservers.com
Tel: (603) 672-1246 x 201


-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list