[mv] SQL Query not Working

[Warren Tokujo <warren@papaya.islandwebstar.com>]

******    message to minivend-users from Warren Tokujo <warren@papaya.islandwebstar.com>     ******

Hi all,

I've installed Minivend 4.03 on Linux 6.0 and have basically the simple
catalog using the default database running okay on it.  But do have
problems getting any of the SQL Query commands to work.  They are of the
form:

[query sql="select * from products"][/query]

Very basic, but this command returns nothing.  I'm assuming that it
should return all the records in the product.txt database.

To add to that,  I also have a problem getting the Order Status to work
in Minimate.  It always say "No pending orders for <whatever user>" even
when I create a pending order situation- order is in the basket, but not
yet checked out.. I checked into the check_orders.html, and found that
it uses an SQL Query  in there as well.  Slightly different and it looks
like

[query st=db arrayref=orders
  sql="SELECT

code,status,nitems,subtotal,shipping,handling,total_cost,payment_method,order_date

   FROM transactions
   WHERE username = '[data base=session field=username filter=sql]'
   ORDER by code
  "][/query]

So I'm thinking that the problems are related.  I cannot seem to run SQL
Queries.  I have not check all of the pages for other SQL Queries, but
it does seem curious that I am having problems with the basic command
and a page which uses it.

My suspicion now is that for some reason, I do not have support for SQL
Query commands.  Could there be support module that I may have missed
during the installation? Or is there a module that needs to be installed
to support SQL queries? Or am I off-base and just not using it right?

Any assistance or pointers would be appreciated.  Thanks in advance.

Warren




-
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