Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Unterminated string constant

Unterminated string constant

Thread began 10/25/2010 12:53 pm by mike174890 | Last modified 10/26/2010 8:07 am by Jason Byrnes | 8816 views | 6 replies |

10/25/2010 12:53 pm | #1 mike174890

Unterminated string constant

Here is the script that DataAssist built in Dreamweaver CS4

<%@LANGUAGE="JAVASCRIPT" CODEPAGE="1252"%>

<%
Can you tell me what to fix? Unterminated string constant Error says Line 2, line 2 starts <!--#include file="../Con

10/25/2010 1:36 pm | #2 Jason ByrnesWebAssist

that line would not cause that error.

can you copy and paste the exact error text you are getting.

10/25/2010 1:57 pm | #3 mike174890

copy of error

Microsoft JScript compilation error '800a03f7'

Unterminated string constant

D:\HOSTING\LOANS2FUND\MONEY\../WA_DataAssist/WA_AppBuilder_VB.asp, line 2

'-----------------------------------------------------------------------------
------------------------------------------------------------------------------^

10/25/2010 1:59 pm | #4 mike174890

web page

Grant_Finder.asp

10/25/2010 4:31 pm | #5 Jason ByrnesWebAssist

you have VBScript on the page,

but this line is telling it to use the Javascript Processing engine:
<%@LANGUAGE="JAVASCRIPT" CODEPAGE="1252"%>

change that to:
<%@LANGUAGE="VBScript" CODEPAGE="1252"%>

10/26/2010 7:41 am | #6 mike174890

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"%>

<%
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

10/26/2010 8:07 am | #7 Jason ByrnesWebAssist

You have a mix of ASP VBSript and ASP Javascript on this page. You cannot have both.

In you site definition, what is the Server language set as?

Chose one or the other and stick with that to eliminate these errors.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.