getting variables into database

sq000 · Jul 16, 2001

hi im trying to get variables into a database,
can anyone see anything obviousley wrong with this code?
i would be very greatful for any help

i think the problem is in the "insert" lines thanks again

<%@LANGUAGE="JAVASCRIPT"%>

<%

var Command1 = Server.CreateObject("ADODB.Command&quot

;
Command1.ActiveConnection = MM_lostat_STRING;
Command1.CommandText = "INSERT INTO tblStats (Recorded, RemoteAddress, HttpReferer, HttpUserAgent, WebPage) VALUES ('" & Request("date&quot

& "', '" & Request("REMOTE_ADDR&quot

& "', '" & Request("HTTP_REFERER&quot

& "', '" & Request("HTTP_USER_AGENT&quot

& "', '" & Request("URL&quot

& "') ";
Command1.CommandType = 1;
Command1.CommandTimeout = 0;
Command1.Prepared = true;
Command1.Execute();

%>
<SCRIPT RUNAT=SERVER LANGUAGE=VBSCRIPT>
function DoDateTime(str, nNamedFormat, nLCID)
dim strRet
dim nOldLCID

strRet = str
If (nLCID > -1) Then
oldLCID = Session.LCID
End If

On Error Resume Next

If (nLCID > -1) Then
Session.LCID = nLCID
End If

If ((nLCID < 0) Or (Session.LCID = nLCID)) Then
strRet = FormatDateTime(str, nNamedFormat)
End If

If (nLCID > -1) Then
Session.LCID = oldLCID
End If

DoDateTime = strRet
End Function
</SCRIPT>
<html>
<head>
<title>test</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<p>
<input type="hidden" name="12" value="<%= DoDateTime( Request("date&quot

, 2, 2057) %>">
<input type="hidden" name="13" value="<%= Request("REMOTE_ADDR&quot

%>">
<input type="hidden" name="14" value="<%= Request("HTTP_REFERER&quot

%>">
<input type="hidden" name="15" value="<%= Request("HTTP_USER_AGENT&quot

%>">
<input type="hidden" name="16" value="<%= Request("URL&quot

%>">
test</p>
<p> </p>
</body>
</html>

shaddow · Jul 16, 2001

The problem is that u trying to add a string like VBScript not JavaScript
myStr="somstring"&otherString
this work only in VB but in java u have to put + not &
& in vb add two strings but in java means AND

This is Java
<%@LANGUAGE="JAVASCRIPT"%>

<%

var Command1 = Server.CreateObject("ADODB.Command&quot

;
Command1.ActiveConnection = MM_lostat_STRING;
Command1.CommandText = "INSERT INTO tblStats (Recorded, RemoteAddress, HttpReferer, HttpUserAgent, WebPage) VALUES ('" + Request("date&quot

+ "', '" + Request("REMOTE_ADDR&quot

+ "', '" + Request("HTTP_REFERER&quot

+ "', '" + Request("HTTP_USER_AGENT&quot

+ "', '" + Request("URL&quot

+ "') ";
Command1.CommandType = 1;
Command1.CommandTimeout = 0;
Command1.Prepared = true;
Command1.Execute();
%>

This is in VB
<%@LANGUAGE="VBSCRIPT"%>

<%

Command1 = Server.CreateObject("ADODB.Command&quot

Command1.ActiveConnection = MM_lostat_STRING
Command1.CommandText = "INSERT INTO tblStats (Recorded, RemoteAddress, HttpReferer, HttpUserAgent, WebPage) VALUES ('" & Request("date&quot

& "', '" & Request("REMOTE_ADDR&quot

& "', '" & Request("HTTP_REFERER&quot

& "', '" & Request("HTTP_USER_AGENT&quot

& "', '" & Request("URL&quot

& "') "
Command1.CommandType = 1
Command1.CommandTimeout = 0
Command1.Prepared = true
Command1.Execute
%>

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

getting variables into database

sq000

Technical User

shaddow

Programmer

Similar threads

Part and Inventory Search

Sponsor