Re: Error message with non-existent linie number!
- From: "Brendan Reynolds" <brenreyn@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 25 Nov 2005 21:24:29 -0000
Yes, 'interval' is a reserved word. See under 'I' at the URL below ...
http://support.microsoft.com/?id=321266
The solution is to either change the field name or use square brackets as
you have already discovered.
--
Brendan Reynolds
"PAF" <PAF@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6DBCA2D1-0BA6-479F-94AC-3B4E75F5D83E@xxxxxxxxxxxxxxxx
> This test code...:
>
> <%
> Set dbconn = Server.CreateObject("ADODB.Connection")
> dbconn.Open Application("sysvedligehold_ConnectionString")
> dbconn.Execute("SELECT Interval FROM Udstyr WHERE Udstyr_nummer=1025")
> dbconn.Close
> %>
>
> Results in the error:
>
> error '80004005'
> /logistik/pta/sysvedligehold/test.asp, line 49
>
> - which is strange, as test.asp has only 20 lines!
>
> When I change the SQL-query to:
>
> "SELECT [Interval] FROM Udstyr WHERE Udstyr_nummer=1025"
>
> ...then it works fine (Only difference is the "[" and "]")
>
> What is the explanation to this? Is "Interval" some kind of reserved word?
>
> The same SQL-query works without and with brackets directly in MS Access.
> The test is done at Windows Server 2003 / IIS6 with latest service pack
> and
> all security patches, with Frontpage 2003 server extensions.
>
> Regards,
> Peter
.
- Prev by Date: Recordset open behave different for same query on same database da
- Next by Date: Re: Error message with non-existent linie number!
- Previous by thread: Recordset open behave different for same query on same database da
- Next by thread: Re: Error message with non-existent linie number!
- Index(es):
Relevant Pages
|
|
