MiniVend Akopia Services

[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date ][Minivend by thread ]

ARRAY(0xbfbfbfb) error on SQL search with commas



******    message to minivend-users from Erik Aase-Remedios <EAR@fourfish.com>     ******

It's late and I just can't find the part of the modules that makes my
search_spec like this "123.5, 123, 6673, 12"  get interpreted into my SQL
query like this: 
"Select tl_num From products Where Floor(tl_num) IN(ARRAY(0x87ff0b8)) Order
by tl_num.

What I had intended was of course
"Select tl_num From products Where Floor(tl_num) IN(123.5, 123, 6673, 12)
Order by tl_num.

I'm getting it from a text entry box, and here's the profile I'm using with
that text entry box.
__NAME__ tl_search
mv_searchtype=sql
mv_matchlimit=25
mv_sql_query=Select tl_num From products Where Floor(tl_num) IN( ? ) Order
by tl
_num
mv_last=1
__END__

It works well If I don't use commas.

mysql
minivend 3.12beta10

-Erik
-
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


Search for: Match: Format: Sort by: