Hello,
I am developing a page that is going to take some values from a database but I have this problem, I did a recorsed with dwcs3 and it is not working would you help please?
ADODB.Command error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/web/ildwnew/default.asp, line 9
and my code is:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<!--#include file="Connections/webdesignportofolio.asp" -->
<%
Dim rs_categories
Dim rs_categories_cmd
Dim rs_categories_numRows
Set rs_categories_cmd = Server.CreateObject ("ADODB.Command")
rs_categories_cmd.ActiveConnection = MM_webdesignportofolio_STRING
rs_categories_cmd.CommandText = "SELECT * FROM sections ORDER BY sectionName ASC"
rs_categories_cmd.Prepared = true
Set rs_categories = rs_categories_cmd.Execute
rs_categories_numRows = 0
%><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
ok, I am going to answer my own question:
check and make sure the syntax is correct in the connections/webdesignportofolio.asp, I did it and it worked perfect