|Hi, | |> -----Original Message----- |> From: webm...@w3space.com [mailto:webm...@w3space.com] |> Sent: Friday, November 30, 2001 12:18 PM |> To: win...@lists.mysql.com; Ivano Luberti |> Subject: Re: ADO,ASP and found rows |> |> |> Hi Ivano |> |> I've been working on it since your previous post (I'm interested |> too) but no answer... so far... |> I don't think it is related to ADO, and I couldn't find the MySQL |> command that would let us use it... |> |> Wait and see... | |You can make use of RecordsAffected property in the execute method. |Please take a look at the following link for more information: | |http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdm |thcnnexecute.asp | |Regards, Venu | |> |> -----Message d'origine----- |> De : Ivano Luberti <lube...@archicoop.it> |> À : win...@lists.mysql.com <win...@lists.mysql.com> |> Date : vendredi 30 novembre 2001 15:30 |> Objet : ADO,ASP and found rows |> |> |> |Hi posted this one also on myodbc list , but Venu answer didn't met my |> |needs (sorry VEnu i know you are doing a great job). |> |So i try posting on this list. |> | |> |I've a problem using an ADO in ASP pages (microsoft technologies). |> |Maybe thi is not the right place, but also an ASP list isn't. |> |This is the question. |> |In myobc connection options (accessibile from the configure command in the |> |control panel applet) there is the option |> |"Return matching rows" |> |i know the meaning of this parameter, but i can't find where the recordset |> |object provided by ADO to execute SQL statements, store the information |> |associated with the option. |> |I tried also printing the Properties, the result is at the end of this |> |post, but couldn't find anything useful. |> |BTW some of this voices are not mentioned in the mysql manual, so i believe |> |are ODBC pramaeters. |> |Prop(0) Name=IAccessor Value=True |> |Prop(1) Name=IColumnsInfo Value=True |> |Prop(2) Name=IColumnsRowset Value=True |> |Prop(3) Name=IConnectionPointContainer Value=False |> |Prop(4) Name=IConvertType Value=True |> |Prop(5) Name=IRowset Value=True |> |Prop(6) Name=IRowsetChange Value=True |> |Prop(7) Name=IRowsetIdentity Value=False |> |Prop(8) Name=IRowsetInfo Value=True |> |Prop(9) Name=IRowsetResynch Value=False |> |Prop(10) Name=IRowsetUpdate Value=True |> |Prop(11) Name=ISupportErrorInfo Value=True |> |Prop(12) Name=ISequentialStream Value=False |> |Prop(13) Name=Preserve on Abort Value=True |> |Prop(14) Name=Blocking Storage Objects Value=False |> |Prop(15) Name=Skip Deleted Bookmarks Value=False |> |Prop(16) Name=Bookmark Type Value=1 |> |Prop(17) Name=Fetch Backwards Value=False |> |Prop(18) Name=Hold Rows Value=False |> |Prop(19) Name=Scroll Backwards Value=False |> |Prop(20) Name=Change Inserted Rows Value=True |> |Prop(21) Name=Column Privileges Value=False |> |Prop(22) Name=Command Time Out Value=30 |> |Prop(23) Name=Preserve on Commit Value=True |> |Prop(24) Name=Delay Storage Object Updates Value=False |> |Prop(25) Name=Immobile Rows Value=True |> |Prop(26) Name=Literal Row Identity Value=True |> |Prop(27) Name=Maximum Open Rows Value=0 |> |Prop(28) Name=Maximum Pending Rows Value=0 |> |Prop(29) Name=Maximum Rows Value=0 |> |Prop(30) Name=Notification Phases Value=31 |> |Prop(31) Name=Column Set Notification Value=3 |> |Prop(32) Name=Row Delete Notification Value=3 |> |Prop(33) Name=Row First Change Notification Value=3 |> |Prop(34) Name=Row Insert Notification Value=3 |> |Prop(35) Name=Row Resynchronization Notification Value=3 |> |Prop(36) Name=Rowset Release Notification Value=3 |> |Prop(37) Name=Rowset Fetch Position Change Notification Value=3 |> |Prop(38) Name=Row Undo Change Notification Value=3 |> |Prop(39) Name=Row Undo Delete Notification Value=3 |> |Prop(40) Name=Row Undo Insert Notification Value=3 |> |Prop(41) Name=Row Update Notification Value=3 |> |Prop(42) Name=Own Inserts Visible Value=False |> |Prop(43) Name=Own Changes Visible Value=False |> |Prop(44) Name=Quick Restart Value=False |> |Prop(45) Name=Reentrant Events Value=True |> |Prop(46) Name=Remove Deleted Rows Value=False |> |Prop(47) Name=Report Multiple Changes Value=False |> |Prop(48) Name=Return Pending Inserts Value=False |> |Prop(49) Name=Row Privileges Value=False |> |Prop(50) Name=Row Threading Model Value=1 |> |Prop(51) Name=Server Cursor Value=False |> |Prop(52) Name=Strong Row Identity Value=False |> |Prop(53) Name=Objects Transacted Value=False |> |Prop(54) Name=Updatability Value=7 |> |Prop(55) Name=Query Based Updates/Deletes/Inserts Value=False |> |Prop(56) Name=Generate a Rowset that can be marshalled Value=False |> |Prop(57) Name=Position on the last row after insert Value=False |> |Prop(58) Name=IRowsetChangeExtInfo Value=False |> |Prop(59) Name=ODBC Cursor Type Value=0 |> |Prop(60) Name=ODBC Concurrency Type Value=11 |> |Prop(61) Name=BLOB accessibility on Forward-Only cursor Value=True |> |Prop(62) Name=Include SQL_FLOAT, SQL_DOUBLE, and SQL_REAL in QBU where |> |clauses Value=False |> |Prop(63) Name=Force SQL Server Firehose Mode cursor Value=False |> |Prop(64) Name=Force no parameter rebinding when executing a command |> |Value=False |> |Prop(65) Name=Force no command preparation when executing a parameterized |> |command Value=False |> |Prop(66) Name=Force no command reexecution when failure to satisfy all |> |required properties Value=True |> | |> | | |-- |For technical support contracts, go to https://order.mysql.com | __ ___ ___ ____ __ | / |/ /_ __/ __/ __ \/ / Mr. Venu <ve...@mysql.com> | / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer |/_/ /_/\_, /___/\___\_\___/ California, USA | <___/ www.mysql.com | | |--------------------------------------------------------------------- |Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before |posting. To request this thread, e-mail win3...@lists.mysql.com | |To unsubscribe, send a message to the address shown in the |List-Unsubscribe header of this message. If you cannot see it, |e-mail win3...@lists.mysql.com instead. |