[mv] MV4, SQL query and DBI/DBD Interbase

["Stefan Schaffner [ASS mv-d]" <mv-user@ass-software.de>]

******    message to minivend-users from "Stefan Schaffner [ASS mv-d]" <mv-user@ass-software.de>     ******

Hello list,

1. I try to use a SQL statement to access an InterBase database (external on
an Win NT Server - MV4 is located on a linux system). The MV4 documentation
does not show any information about my problem. Using the following code,
the result page is displayed without any rows shown.

The HTML page:
--- snip ----------------------------------------------------------
<form action=[area search] method=post>
  <input type=hidden name=mv_doit value=search>
  <input type=hidden name=mv_search_page value=sqltest/results2>
  <input type=hidden name=mv_searchtype value=sql>
  <INPUT TYPE=hidden NAME=mv_sql_query
    VALUE="SELECT NAME FROM hotels WHERE ( plz = 64354 ) ">
  <input type=submit value=Suchen>
</form>
--- snap ----------------------------------------------------------


The error.log in the catalog directory shows:

The error.log:
--- snip ----------------------------------------------------------
hotellist /cgi-bin/pizzamafia.cgi/search.html search error: Limit subroutine
creation: Can't use an undefined value as an ARRAY reference at
/usr/local/mvend/lib/Vend/Search.pm line 671.
--- snap ----------------------------------------------------------


2. My second problem is the syntax to access the result table columns in the
result page. I don't think, that I may use the |item-code] tag, do I?


Need help!

Best,
   Stefan

-
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