Re: [mv] Updating Database Via Checkboxes

[Ed LaFrance <edlafrance@printexusa.com>]

******    message to minivend-users from Ed LaFrance <edlafrance@printexusa.com>     ******

At 11:24 AM 6/6/00 -0500, you wrote:
>******    message to minivend-users from "Cameron B. Prince" 
><info@InternetExpertsLLC.com>     ******
>
>Hi list,
>
>I am using a sql query to display a loop of items in a database like this:
>
>[search-region more=1 search="
>                 ra=yes
>         st=sql
>         sq=select * from invoices where to_print = 'yes'
>                 ml=999999
>                 tf=invoice_number
>                 "]
>
>In the search list I have checkboxes for each result like this:
>
><input type="checkbox" NAME="printed" value="[item-data invoices code]">
>
>
>So what this does is list all the invoices that are to be printed with 
>checkboxes by each one.
>
>What I need to do is create a form of some kind that will update the 
>database and set to_print to 'no' for each checkbox that is checked.
>
>I have had no problems updating Minivend databases when it comes to single 
>items, but I am stumped as to how to do this multiple field update.
>
>Can anyone provide any ideas?

I would study the page code for Minimate's spreadsheet edit mode to get an 
idea of how to go about doing this.

- Ed L.
Printex Marking Technologies
12113 Kirkham Rd.
Poway, CA  92064  U.S.A.
858-513-2418
800-982-1928
858-513-2419 FAX
http://www.printexusa.com


-
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