I am trying to insert into a visual foxpro database with the following code:


<%@ LANGUAGE = JavaScript%>
<%
var adoConnection = Server.CreateObject("ADODB.Connection");

var constring = "Provider=VFPOLEDB.1;Data Source=D:\\test\\test.dbc";

adoConnection.Open(constring);
var today

today = "12/12/2003";

adoConnection.Execute("INSERT INTO table1 (date) VALUES(today)");

adoRecordSet.Close();
adoRecordSet = null;
adoConnection.Close();
adoConnection = null;
%>

Apparently the variable is not being seen by the command. What am I doing wrong???????????????

I receive the following error message when running the script.

HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services

Technical Information (for support personnel)
· Error Type:
Microsoft OLE DB Provider for Visual FoxPro (0x80004005)
Variable 'TODAY' is not found.
/counter2.asp, line 12
· Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; T312461; AT&T CSM7.0; .NET CLR 1.0.3705; .NET CLR 1.1.4322)
· Page:
GET /counter2.asp
· Time:
Sunday, November 30, 2003, 1:57:04 PM
· More information:

"today" is buried inside the command string. You need to insert the actual value.

adoConnection.Execute("INSERT INTO table1 (date) VALUES('"+today+"')");

Peter
------------------------------------------------------
Work smarter, not harder.

Sounded good but in practice I receive another runtime error

Error Type:
Microsoft JScript compilation (0x800A03EE)
Expected ')'
/counter2.asp, line 12, column 57
adoConnection.Execute("INSERT INTO table1 (date) VALUES("'today'")");
--------------------------------------------------------^

I also tried
VALUES("+'today'+") and got

Error Type:
Microsoft OLE DB Provider for Visual FoxPro (0x80004005)
Variable 'TODAY' is not found.
/counter2.asp, line 12


Any other ideas?

I don't think you are understand the problem...

"today" is a variable in javascript. The way you are trying to use it is as a variable/field/value in the query. You can't do that, because that variable doesn't exist in the context of the query. It exists in the context of your ASP script. So you have to insert the value of the variable into the string of the query so the query actually contains a literal value.

Using this code:

today = "12/12/2003";
adoConnection.Execute("INSERT INTO table1 (date) VALUES('"+today+"')");

should result in this actual call:

adoConnection.Execute("INSERT INTO table1 (date) VALUES('12/12/2003')");

Maybe my syntax is incorrect for inserting dates into FoxPro. Maybe you need hashes (#):

today = "12/12/2003";
adoConnection.Execute("INSERT INTO table1 (date) VALUES(#"+today+"#)");

MS Access uses hashes around date values, MS-SQL can use single quotes.

Peter
------------------------------------------------------
Work smarter, not harder.

Peter,

I assumed it was something like that but wasn't sure how to approach it.

After playing with the code I found a combination that worked.
The code:
var today;

today = "12/12/2003";
mysql = "INSERT INTO table1 (date) VALUES(";
mysql = mysql + '"'+(today) + '")';


Produced this:
INSERT INTO table1 (date) VALUES("12/12/2003")

Thanks Again!

Don