Web Wiz Support and Community Forums : line 82 in functions_date_time_format.asp https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 13 Apr 2026 07:14:53 +0000 Thu, 23 Jun 2005 05:46:29 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=15551 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[line 82 in functions_date_time_format.asp : i understand. here&#039;s another...]]> https://forums.webwiz.net/line-82-in-functions-date-time-format-asp_topic15551_post85618.html#85618 Author: snooper
Subject: 15551
Posted: 23 June 2005 at 5:46am

i understand.
 
here's another weird thing about it: a few minutes later, it all came back, and was fine - without me or the host changing anything - AT ALL.
 
i looked up the error, and it seems it may have something to do with a session issue, and support made a similar commenty, but they couldnt check it out properly, because it started working again.  see here: http://support.microsoft.com/kb/q197323 
 
this is on Win6, by the way, on Jodo.
 
all other comments welcome!
]]> Thu, 23 Jun 2005 05:46:29 +0000 https://forums.webwiz.net/line-82-in-functions-date-time-format-asp_topic15551_post85618.html#85618 <![CDATA[line 82 in functions_date_time_format.asp : It&#039;s looking for an integer...]]> https://forums.webwiz.net/line-82-in-functions-date-time-format-asp_topic15551_post85610.html#85610 Author: dpyers
Subject: 15551
Posted: 23 June 2005 at 2:06am

It's looking for an integer constant and not finding one where it expects to for the particular operation.
You'd need to response.write strSQL, adoVon, and also check the stored proc.
]]> Thu, 23 Jun 2005 02:06:09 +0000 https://forums.webwiz.net/line-82-in-functions-date-time-format-asp_topic15551_post85610.html#85610 <![CDATA[line 82 in functions_date_time_format.asp : Hi all i am using the latest...]]> https://forums.webwiz.net/line-82-in-functions-date-time-format-asp_topic15551_post85593.html#85593 Author: snooper
Subject: 15551
Posted: 22 June 2005 at 7:00pm

Hi all
 
i am using the latest version on SQL.
 
today, for the 2nd time, i am suddenly getting the following error:
 

ADODB.Recordset error '800a0bb9'

Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

/lishka/functions/functions_date_time_format.asp, line 82

its important to stress, that i have not made ANY changes in the coding or DB at all in this time.
 
 
last time it happened, the host (jodo) was kind enough to restore a DB from a few hrs back and it seemed to solve the issue, whatever it may have been.
 
today, it happened again, and stephen isnt in to help out like last time, so it may b a little longer.... anyway...  i want to get to the root issue.
 
anyone got any idea what this could be?
 
line 82 is marked:
 
 
 'Craete a recordset to get the date and time format data
 Set rsDateTimeFormat = Server.CreateObject("ADODB.Recordset")
  
 'Initalise the strSQL variable with an SQL statement to query the database
 If strDatabaseType = "SQLServer" Then
  strSQL = "EXECUTE " & strDbProc & "TimeAndDateSettings"
 Else
  strSQL = "SELECT " & strDbTable & "DateTimeFormat.* FROM " & strDbTable & "DateTimeFormat;"
 End If
  
 'Query the database
'***NEXT LINE IS 82****
 rsDateTimeFormat.Open strSQL, adoCon
 
 'If there are records returned then enter the data returned into an array
 If NOT rsDateTimeFormat.EOF Then
  
  'Redimension the array
  'This is done as a dynamic array oterwise it can't be filled by the application array next time around
  ReDim saryDateTimeData(17)
'....
 
 
any ideas?
 
thanks!
]]> Wed, 22 Jun 2005 19:00:25 +0000 https://forums.webwiz.net/line-82-in-functions-date-time-format-asp_topic15551_post85593.html#85593