Re: [mv] MV4.0alpha10 SQL parse problem

["Christian J. Müller" <cmueller@polinet.ch>]

******    message to minivend-users from "Christian J. =?iso-8859-1?Q?M=FCller?=" <cmueller@polinet.ch>     ******

Thanks for answering so quickly.


Mike Heins wrote:
> 
> You need the standard:
> 
>         [area scan
>                         st=db
>                         sq=select ....
>                         ]
> 
> st=sql is a synonym for st=db. This, by the way, will work on not only
> MySQL but MiniVend databases. You need SQL::Statement for any of this to
> work. When I release MiniVend 4 beta I will probably once again put it
> on CPAN and make SQL::Statement a requirement.

I have SQL::Statement installed.

This produces the correct URL, however, the requested fields are simply
translated into *. I need  5 fields out of the 90 that the db has. Well,
I guess that doesnt hurt, but there is another strange thing happening:

1. The generated URL is correct.
2. The search reports **no matches for Architecture**. The same
identical command in mySQL comes up with 93 records.
3. The mySQL log shows the query. There is no error in mySQL.
4. MV reports "died in select"! The catalog,however, reports no error.

Question:
Does MV4 support JOIN statements?

Thanks Chris
> 
> In MV, it would be:
> 
>         [area scan
>                         se=architecture
>                         sf=searchcrit
>                         rf=code,isbn,title,author
>                         st=db
>                         op=eq
>                         co=yes
>                         ]
> 
> This would not require SQL::Statement.
> 
> --
> Mike Heins                          http://www.minivend.com/  ___
>                                     Internet Robotics        |_ _|____
> In character, in manners, in        131 Willow Lane, Floor 2  | ||  _ \
> style, in all things, the           Oxford, OH  45056         | || |_) |
> supreme excellence is               <mikeh@minivend.com>     |___|  _ <
> simplicity. -- Longfellow           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
-
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