Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Find command in ado
Message
 
To
06/02/2000 07:25:58
General information
Forum:
Internet
Category:
Active Server Page
Miscellaneous
Thread ID:
00327196
Message ID:
00328037
Views:
22
>>>How to use find command in ado.
>>>My database is sql.
>>>Thanks.
>>
>>object.Find (criteria, SkipRows, searchDirection, start)
>>
>>For example: rs.find "Name like 'Moreau%'", 0, adSearchForward
>Hi Eric;
>Excuse for my bad english.
>
>When i try
>rs.find "Name like 'Moreau%'", 0, adSearchForward
>
>i recieve this errorcode.
>
>ADODB.Recordset error '800a0bb9'
>
>The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another
>
>Then i have try this
>
>rs.find ("Name like 'Moreau%'", 0, adSearchForward)
>
>i recieve this errorcode
>
>Microsoft VBScript compilation error '800a0414'
>
>Cannot use parens when calling a Sub
>
>/kayit.asp, line 31
>
>orecordset.find ("kodu like '001%'", 0, adSearchForward, adBookmarkFirst)

I can see 2 things:
1- What is the data type of kodu? I hope it is character. If it is numeric, you can't use like but you can use: orecordset.find "kodu = 001"
2- You use VBScript! I'm not sure that you have all the constants. Try this instead:
orecordset.movefirst
orecordset.find "kodu like '001%', 0
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform