Re: mSQL

[mike@minivend.com]

******    message to minivend-users from mike@minivend.com     ******

Quoting Adam Goodman (adam@a-domain.com):
> 
> I am trying to set up a catalog but it is a big database ~12000 records, so
> I am thinking that a CSV table might not work. So I setup an msql DB.

Not really necessary if you use a TAB-delimited database; it will
be much faster than mSQL.

> 
> Using the [sql list....] tag i am able to query the products table (that's
> the msql one) and get a "big" list of records.
> 
> The [more-list] in the sample catalog is not working. So:

But the [more-list] is not a part of the [sql list ...] tag, and never
was. It has to do with searches.

> 
> 1.   Does anyone know how to solve this?
> 2.   Is there a "sample" catalog working with msql and SQL queries?

3.  You can achieve much the same thing as [sql list ... with]

[search-region
	arg="
			st=sql
			sq=select code from products where a_field = 'what you want'
			ml=25
		"]

[search-list]
[item-code] [item-field description] [item-data table field]<BR>
[/search-list]

[more]More matches: [more-list][/more]

[no-match]There were no matches.[/no-match]

[/search-region]



> 4.   I have the DBI.pm Msql.pm etc. installed already, but I see that MiniVend
>      Uses modules in lib/Vend/Table ??? This really might not have anything
> to do with nothing, I was just wondering :-)
> 5.    Here are some lines from my error.log
> 
> ============= cut =================
> 208.251.123.154 77PT5uPa:208.251.123.154 - [23/December/1998:12:19:18
> -0500] rec /index.cgi/process Runtime error: execute error: Bad type for
> comparison of 'code' at /home/mvend/mvend/lib/Vend/Data.pm line 235 
>  
> 208.251.123.154 77PT5uPa:208.251.123.154 - [23/December/1998:12:22:56
> -0500] rec /index.cgi/order Runtime error: Bad type for comparison of
> 'code' at /home/mvend/mvend/lib/Vend/Table/DummyDB.pm line 43 
> ============= cut =================

In addition, you have a query error. You need to set some field
types if you are using a numeric key. mSQL is very inflexible in
this regard.

-- 
Mike Heins                          http://www.minivend.com/  ___ 
                                    Internet Robotics        |_ _|____
Fast, reliable, cheap.              131 Willow Lane, Floor 2  | ||  _ \
Pick two and we'll talk.            Oxford, OH  45056         | || |_) |
 -- unknown                         <mikeh@minivend.com>     |___|  _ <
                                    513.523.7621 FAX 7501        |_| \_\
-
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