yakli
|
| Posted: 05/28/2002, 5:42 AM |
|
Property Get RecordsCount()
Dim Command
If IsEmpty(prvRecordsCount) Then
If IsEmpty(CountSQL) Then _
CountSQL = "SELECT Count(*) FROM (" & builtSQL & " cnt)"
Select Case DataSourceType
Case dsTable, dsSQL
Set Command = CreateObject("ADODB.Command")
Command.CommandType = adCmdText
Command.CommandText = CountSQL
Set Command.ActiveConnection = Connection.Connection
Set Recordset = Connection.Execute(Command)
Set Command = Nothing
prvRecordsCount = CInt(Recordset.Fields(0).Value) 'error in here line 1412
Case dsListOfValues
prvRecordsCount = Recordset.RecordsCount
End Select
End If
RecordsCount = prvRecordsCount
End Property
This is a default classes.asp code and I got an error.
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[TCX][MyODBC]You have an error in your SQL syntax near 'SELECT * FROM categories1 ORDER BY scategory_name cnt)' at line 1
/Classes.asp, line 1412
I tried to solve and again I have another error
I changed this line
prvRecordsCount = Recordset.RecordsCount
Error Type:
Microsoft VBScript runtime (0x800A01B6)
Object doesn't support this property or method: 'Recordset.RecordsCount'
/Classes.asp, line 1412
I tried mysql_num_rows as I saw in this newsgroup but I couldn't reach the result.
I want to use Navigator efficiently How Can I Solve This Problem??
I am new for asp and excuse me for my english. Thanks for all...
|
|
|
 |
Nicole
|
| Posted: 05/28/2002, 6:13 AM |
|
Hello,
upgrade to CCS Beta 4. This problem is already solved there. Just use MySQL db for design and live modes. Note, that you should regenerate whole site with Beta 4. In case you have modified anything in Classes.asp or other file then remove code in CCS code editor and regenerate it.
Beta 4 is available at: www.codecharge.com/studio/
|
|
|
|
|
