Snitz Forums 2000 - Correct Syntax for ASP

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Community Forums

Code Support: ASP (Non-Forum Related)

Correct Syntax for ASP

New Topic

Topic Locked

Printer Friendly

Author

Topic

Martha2Mary
Junior Member

New Zealand
250 Posts

Posted - 19 August 2001 : 17:56:20

Hi,

Firstly, here is the code I have already:


Set objRS2 = Server.CreateObject("ADODB.Recordset")
	strSQL =  "INSERT INTO " & strTablePrefix & "ONLINE (UserID,UserIP,DateCreated,CheckedIn,LastChecked,M_BROWSE) VALUES ('"
	strSql = strSQL & strOnlineUser & "','" & strOnlineUserIP & "','" & strOnlineDate & "','" & strOnlineCheckInTime & "','" & strOnlineCheckInTime & "','" & strOnlineLocation & "')" 
	my_Conn.Execute (strSql)

Now, I would like to add a new field to the 'Insert Into' statement above named 'M_CHATTER', with a value of '1' but am having trouble getting the correct syntax. So, can anyone help me do this?

Many thanks!

*If Knowledge is Power, and Power Corrupts, what hope is there for Mankind

Doug G
Support Moderator

USA
6493 Posts

Posted - 19 August 2001 : 18:04:44

Unless I'm missing something, you just need to add the field name to the field list, and the value for the field in the corresponding position in the value list.


Set objRS2 = Server.CreateObject("ADODB.Recordset")
	strSQL =  "INSERT INTO " & strTablePrefix & "ONLINE (UserID,UserIP,DateCreated,CheckedIn,LastChecked,M_BROWSE,M_CHATTER) VALUES ('"
	strSql = strSQL & strOnlineUser & "','" & strOnlineUserIP & "','" & strOnlineDate & "','" & strOnlineCheckInTime & "','" & strOnlineCheckInTime & "','" & strOnlineLocation & ",1')"
	my_Conn.Execute (strSql)

======
Doug G
======

Edited by - Doug G on 20 August 2001 22:57:58

Topic

New Topic

Topic Locked

Printer Friendly

Jump To:

Snitz Forums 2000

This page was generated in 0.22 seconds.