[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