[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: SQL database order tracking
****** message to minivend-users from William Tan <william@absolutely.com.sg> ******
Hi,
Thanks Dan. You're right, I think [import] is not meant to be
used for SQL database. It now works with [sql type=set base=table].
Thanks.
On Mon, 10 May 1999, Dan Busarow wrote:
> ****** 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
>
-
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
