[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Why does MiniVend sometimes not find the database ?
Hello,
I've hit a stone wall again. Does where or how you access certain
MiniVend pages or is there certain code that forces it to look for a database
besides the product database in ...../products ?
Reason being, I have SQL databases set up. All the SQL databases are
in the Postgres directory and not the MiniVend .../products/ directory. I have
had NO problem accessing the products database/table. There are additional
tables that are not product tables One is set up for links. No problem. I
can display links on a results page from a search. There is a temp links table
set up for people to add their own link. After we check it out it will be
added to the main links table. I can write to this temp database from
MiniVend with no problem using the form entry code
Here is the problem. I have another table for product reviews. I
added a "Reviews" button to the index page. This button is a one click scan
SQL search. Each item on the index page has this button. I have it displaying
all review text files for that product when this button is clicked. I'm using a
modified results page for this display. That part works. Now I want to add a
section to allow someone to add their own review. I have the form code set up
like I did with the links entry however when I click on the "Set" for submit, I
get an error message that it can't find the table in ..../products/. I know
it's not in .../products/. None of SQL databases are in the ..../products/
directory. In fact the code above the form code reads from this table just
fine. It finds it then when I use an [sql type=list..........].
So why does it find tables sometimes and other times it doesn't ? What
am I doing wrong ? Any help will be appreciated. I will check the archieves
again but so far I've missed it if it's there.
I've got
MV 3.14-3
Postgres 6.5.1
DBD 0.92
DBI 1.13
Thanks
Karl