Re: SQL database order tracking

[Dan Busarow <dan@dpcsys.com>]

******    message to minivend-users from Dan Busarow <dan@dpcsys.com>     ******

On Mon, 10 May 1999, William Tan wrote:
> 	I'm trying to record orders into mySQL database.  I've split the
> order into 2 tables -- orders and orderitems.  So, according to the docs,
> I can place them in /etc/report using the [import] directive.
> 
> Since my db design is different from GDBM style, i did something like this
> for the 'orders' table:
> 
> Add main order [value mv_order_number] to orders: 
> [import table=orders type=LINE continue=NOTES]
> status: 0
> code: [value mv_order_number]

Try using [sql set].  The way I read the docs for [import table] it
is not for use with SQL, although you might try adding type=SQL to
the [import table] statement.

Doing this using [sql set] goes like this:

[sql set]
    insert into Orders values (
        '[value mv_order_number]',
        CURDATE(),
        '[data session source]',
        '[value name escape]',
	...
        '[value email escape]'
    )
[/sql Orders]
 


Dan
-- 
 Dan Busarow                                                  949 443 4172
 Dana Point Communications, Inc.                            dan@dpcsys.com
 Dana Point, California  83 09 EF 59 E0 11 89 B4   8D 09 DB FD E1 DD 0C 82

-
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