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,
    When in doubt, try using the actual source code... its an invaluable resource!  On the other hand,
you'll need to know perl pretty well :-).   Search the documentation for the "[import]" tag -- this
allows you to modify db's.  I also remember a while ago that there was mention of people modifing the
berkley database, and then using the "[export]" tag -- you might want to do some digging around in the
archives.  Try about 18 months ago for that one though.

    Regards,

    Jason Korkin.


Chris Wenham wrote:

> ******    message to minivend-users from Chris Wenham <cwenham@netmonger.net>     ******
>
> >>>>> "Jason" == Jason M Korkin <jkorkin@korksoft.com> writes:
>
>     > ******    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]
>
>  Jason,
>
>  Thanks, but I am not using a SQL database for this site - nor can
>  I. This is a tab delimited database managed by Minivend.
>
>  Also, I can't find any documentation on the SQL tag besides an
>  unusable minimum in the Tag reference. Is there another reference
>  that I'm missing?
>
> 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