Hi,
I am facing some problem using MYSQL..When I am listing the records I am
getting the following error..
Microsoft Cursor Engine error '80004005'
The data provider or other service returned an E_FAIL status.
/keyknowledgev1.2/content/admin/productlist.asp, line 87
Line 87 Highlighted below
The following is my code..
If Request.QueryString("NAV") = "" Then
intPage = 1
Else
intPage = Request.QueryString("NAV")
End If
Set RecSetProduct =
Server.CreateObject("ADODB.RecordSet")
CheckSql="select * from PRODUCTS order by TITLE"
RecSetProduct.CursorLocation = 3 'adUseClient
RecSetProduct.CursorType = 3 'adOpenStatic
RecSetProduct.Open CheckSql, KeyConn
RecSetProduct.PageSize = 10
RecSetProduct.CacheSize = RecSetProduct.PageSize
intPageCount = RecSetProduct.PageCount
intRecordCount = RecSetProduct.RecordCount
If CInt(intPage) > CInt(intPageCount) Then intPage =
intPageCount
If CInt(intPage) <= 0 Then intPage = 1
If intRecordCount > 0 Then
RecSetProduct.AbsolutePage = intPage
intStart = RecSetProduct.AbsolutePosition
If CInt(intPage) = CInt(intPageCount) Then
intFinish = intRecordCount
Else
intFinish = intStart + (RecSetProduct.PageSize -
1)
End if
End If
Thanks in Advance
With Regards
Siva
Technical Manager
55 Greek Street
London W1V 5LR
Tel: +44 (0)20 7025 7200
Fax: +44 (0)20 7025 7201
Mob: 0777 361 807
http://www.terranovamedia.com
[EMAIL PROTECTED]
This electronic message (email) is intended only for the use of the
individual or entity named above, and may contain information that is
privileged, confidential and protected from disclosure under applicable
law. This communication represents the originator's personal views and
opinions, which do not necessarily reflect those of terra nova media
ltd.
If the reader of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or copying of this
communication, or the taking of any action relative to its contents, is
strictly prohibited. If you have received this communication in error,
please notify us immediately by telephone at 020 7025 7200 or by email.
Please destroy all hard copies of this communication and delete it from
all electronic files. Thank you.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
