|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
August 12th, 2005, 09:43 AM
|
|||
|
|||
|
SQL help needed?
Hi.
In a ASP / Access page I had this code on a dynamic page that inserted "one hit" in the database each time the page was displayed. Like this page has been viewed 100 times. Code: <% Dim profiler Dim profiler_numRows Set profiler = Server.CreateObject("ADODB.Recordset") profiler.ActiveConnection = MM_mypage_STRING profiler.Source = "SELECT * FROM profiler WHERE ID = " + Replace(profiler__MMColParam, "'", "''") + "" profiler.CursorType = 0 profiler.CursorLocation = 2 profiler.LockType = 3 profiler.Open() profiler.Fields("ViewCount") = profiler.Fields.Item("ViewCount").Value + 1 profiler.Update profiler_numRows = 0 %> ViewCount is the name of the integer db field that stores the number value. In MSSQL this recordset causes a "0x80040E31 timeout error" and the page cant be displayed. Any suggestions for this error? If I remove the "insert one hit in db function" in the recordset everything works ok. Bjorn.
|
|
#2
August 12th, 2005, 10:52 AM
|
||||
|
||||
|
Example:
Code:
<%
Set Conn = Server CreateObject("ADODB.Connection")
Conn.Open MM_mypage_STRING
Conn.Execute("INSERT INTO profiler(ViewCount) VALUES(ViewCount + 1)")
Conn.Close
Set Conn = Nothing
%>
Dreamweaver sucks at generating ASP code.
|
|
#3
August 12th, 2005, 11:23 AM
|
|||
|
|||
|
Error
Hi.
Thanx for your help. Tried your code but got this error; Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC SQL Server Driver][SQL Server]The name 'viewCount' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted. Any ideas? Bjorn. 
|
|
#4
August 15th, 2005, 03:36 AM
|
|||
|
|||
|
What is wrong with this?
Quote:
|
|
| Viewing: ASP Free Forums > Database > Microsoft SQL Server > SQL help needed? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
