Hi I'm trying to search database field for 2 different values on one field (named status) and for one specific value on 2 other fields (vendorID and Exp).

I have this Inline ( I included the line numbers)

129 [inline(
130 -database='MYDB',
131 -SQL = '(SELECT * FROM mybd.mytable WHERE `VendorID` = #VendorID AND `Exp` >= #Exp AND `status` = 'active' OR `status` = 'private' ORDER BY `exp` LIMIT 0,10)')]
132 [local('ProductID') = Field('ProductID')]
133 [local('Product') = Field('Product')]

<OPTION value="[#ProductID]">A- [#Product]</OPTION>

[/inline]

Looks like the syntax is not correct. Is there any reference I can look up, or does somebody what is not correct.

Here is the error
An unhandled failure during a web request
Error Code: -1
Error Msg: Parser error. //Library/Server/Web/Data/Sites/getfreeticketshere.com//inc/PartnerCampNewProd.lasso: Error while parsing. Unexpected: PRIVATE line: 131, col: 125

Thanks, Pavel



#############################################################

Attend the Lasso Developer Conference 2013!
Sept 12-14, 2013 in Niagara Falls, Canada
http://www.lassosoft.com/LDC-niagara-falls-2013

#############################################################
This message is sent to you because you are subscribed to
the mailing list Lasso
Lasso@lists.lassosoft.com
To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.lassosoft.com>
Send administrative queries to <Lasso-request@lists.lassosoft.com>