I'm having problem to search for record in MySQL using inline in lasso 9.

This will search and Find the record.

<?lasso
local('VendorEmail') = Action_Param('VendorEmail')
local('VendorPass') = Action_Param('VendorPass')
local('note') = Action_Param('note')
local('Goto') = Action_Param('GoTo')

inline(
-Database = 'GetTickets',
-Table = 'Vendor',
'VendorPass' = #VendorPass,
'VendorEmail' = #VendorEmail,
-Search)
...........
?>

This will search and Find 0 records

<?lasso
..........

inline(
-Database = 'GetTickets',
-Table = 'Vendor',
-EQ,
'VendorPass' = #VendorPass,
-EQ,
'VendorEmail' = #VendorEmail,
-Search)
...........
?>

I also tried
-op = 'eq',
instead of the -EQ.

Any body run into similar problem.

I simply want to match the email and password exactly and then let the user login.

Cheers, Pavel
4000ft





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