sillyarms Posted May 23, 2006 Share Posted May 23, 2006 I'm having trouble with a particular chunk of code. I cut and pasted the sql statement from access so I know the sql statement works in access. The variable I am looking up is a text field in the db. I am using v3.1.1.123 (beta). I've searched, I've rewritten. Wtf am i doing wrong?$oConn = ObjCreate("ADODB.Connection") $oRS = ObjCreate("ADODB.Recordset") $oConn.Open("Driver={Microsoft Access Driver (*.mdb)};Dbq=transactions.mdb") $oRS.Open('SELECT longtrader.Online FROM Cards, longtrader WHERE (((Cards.HashSet)="2184514647") AND ((Cards.CardName)=[longtrader]![Card Name]) AND ((Cards.Set)=[longtrader]![Set]))', $oConn, 1, 3) if $oRS.RecordCount <> 0 Then ;we own some $ary_hldr[3] = $oRS.Fields("Online").Value ;add the number owned Else ;we own none $ary_hldr[3] = 0 EndIf $oRS.Close $oConn.CloseI get this error:Thank you, in advance for any help you are willing to give. Link to comment Share on other sites More sharing options...
ptrex Posted May 23, 2006 Share Posted May 23, 2006 Maybe you can start to add the COM error handler. This will give you more details about the errors using COM objects. See my signature (for example the MS LogParser) have the COM error handler of SvenP. Success Contributions :Firewall Log Analyzer for XP - Creating COM objects without a need of DLL's - UPnP support in AU3Crystal Reports Viewer - PDFCreator in AutoIT - Duplicate File FinderSQLite3 Database functionality - USB Monitoring - Reading Excel using SQLRun Au3 as a Windows Service - File Monitor - Embedded Flash PlayerDynamic Functions - Control Panel Applets - Digital Signing Code - Excel Grid In AutoIT - Constants for Special Folders in WindowsRead data from Any Windows Edit Control - SOAP and Web Services in AutoIT - Barcode Printing Using PS - AU3 on LightTD WebserverMS LogParser SQL Engine in AutoIT - ImageMagick Image Processing - Converter @ Dec - Hex - Bin -Email Address Encoder - MSI Editor - SNMP - MIB ProtocolFinancial Functions UDF - Set ACL Permissions - Syntax HighLighter for AU3ADOR.RecordSet approach - Real OCR - HTTP Disk - PDF Reader Personal Worldclock - MS Indexing Engine - Printing ControlsGuiListView - Navigation (break the 4000 Limit barrier) - Registration Free COM DLL Distribution - Update - WinRM SMART Analysis - COM Object Browser - Excel PivotTable Object - VLC Media Player - Windows LogOnOff Gui -Extract Data from Outlook to Word & Excel - Analyze Event ID 4226 - DotNet Compiler Wrapper - Powershell_COM - New Link to comment Share on other sites More sharing options...
sillyarms Posted May 24, 2006 Author Share Posted May 24, 2006 I think maybye that i should be using ADODB.record instead of ADODB.Recordset. I'm having troubles getting this attempt to work. Can anyone show me how use ADODB.Record? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now