Re: OLE ADO & Win32

The problem is that the Filter property... is a property, not a method.

$recordSet->Filter => $myFilter;
[download]

should be:

$recordSet->{Filter} = $myFilter;
[download]

Also, it appears you're using the => operator incorrectly and you fatfingered $recordSet as $recordSer in your code.

Comment on Re: OLE ADO & Win32 Select or Download Code

Replies are listed 'Best First'.
Re^2: OLE ADO & Win32 by Anonymous Monk on Aug 10, 2004 at 14:46 UTC
I know its a property and I apologize for my typing. I have tried it both ways $recordSet->{'Filter'} $recordSet->Filter(); I tried everything, and I get the same error every time. I finally just converted to DBI and hashes. works great, but I still would liket o know why the OLE didn't work.	[reply]
Re^3: OLE ADO & Win32 by spoulson (Beadle) on Aug 10, 2004 at 15:22 UTC
I'm not sure if this'll apply to you; I know that in some cases with Sort, I need to do a MoveFirst to ensure I'm at the top. You're probably better off with DBI anyway. ADO is so slow anyway.	[reply]
Re^4: OLE ADO & Win32 by Anonymous Monk on Aug 10, 2004 at 15:56 UTC
yeah I tried that too, still didn't work. Guess I'll chalk it up to MS not playing nice and making their interface complete. DBI did what I needed it to do anyway, so I'm happy. Thanks	[reply]