new error message after changing to VB
New Error Message:
Microsoft VBScript compilation error '800a0401'
Expected end of statement
/money/Grant_Finder.asp, line 4
var Recordset1_cmd = Server.CreateObject ("ADODB.Command");
----------------------------------------------------------^
Current Script:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%><!--#include file="../WA_DataAssist/WA_AppBuilder_VB.asp" -->
<!--#include file="../Connections/MainGrantHome.asp" -->
<%
var Recordset1_cmd = Server.CreateObject ("ADODB.Command");
Recordset1_cmd.ActiveConnection = MM_MainGrantHome_STRING;
Recordset1_cmd.CommandText = "SELECT * FROM FWGM";
Recordset1_cmd.Prepared = true;
var Recordset1 = Recordset1_cmd.Execute();
var Recordset1_numRows = 0;
%>
When establising site I received a message "Please edit the 'WADAFWGM' recordset and set the type for 'ParamID'"
I added record set to each dataassit page