Snitz Forums 2000 - minor formatting error in writing a record

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Community Forums

Code Support: ASP (Non-Forum Related)

minor formatting error in writing a record

New Topic

Topic Locked

Printer Friendly

Author

Topic

tane
Starting Member

2 Posts

Posted - 09 May 2007 : 05:57:21

Hi,
There is a minor error in the way I have written this but I can't put my finger on what it is. Can anyone help?
Thanks
Tane

<%
Dim rsPPPN3

Set rsPPPN3=Server.CreateObject("ADODB.Recordset")
rsPPPN3.Open "SELECT * FROM TBL_TEST_ENTRY_TIME",conn,1,2
rsPPPN3.AddNew
rsPPPN3("USER_ID")=""&user_name&""
rsPPPN3("TEST_ENTRY")= DateDiff("s", Request.QueryString("time"), Now())

rsPPPN3("USER_FNAME")=""&firstname&""
rsPPPN3.Update
rsPPPN3.Close
End If
Set rsPPPN3=Nothing
%>

Shaggy
Support Moderator

Ireland
6780 Posts

Posted - 09 May 2007 : 06:54:11

I'll guess at the stray "End If" on the third last line; without knowing the error, all we can do is guess - that may not be what's causing your error if there's an "If" further up in the code. If there is then set the recordset to nothing, before the "End If".

Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.”

pdrg
Support Moderator

United Kingdom
2897 Posts

Posted - 09 May 2007 : 08:57:56

please describe the problems you're seeing and someone may be able to help!

Topic

New Topic

Topic Locked

Printer Friendly

Jump To:

Snitz Forums 2000

This page was generated in 0.25 seconds.