Maybe you should try to enclose your table name with ''
SELECT *
FROM 'Data.txt'
If the Dreamweaver keep altering your code, try to save all your changes and edit your file using a text editor for your future amendments.
I couldnt get the movie displayed too because i don't have the plugin. I suggest u can put up a link to download Quicktime plugin for visitors.
Try to use flash or windows media file since it's more common..
Hello, we have a win 2000 server and we have a few folders assigned to a few user. Each user should have only 5MB of maximum usage for their individual's folder. We are using the WarFTP server. Is there anyway to control the user disk usage? Any 3rd party software to control this? Coz currently...
Hello, I'm using Microsoft Access & I'm trying to comparing values from the following tables.
Hi all, I have 2 tables. One is called [master] and another is [details].
[Master] will hold all the unique counter name where else the [details] will hold all the records of
the counters.
Master...
Hello, I wrote some scripts using ASP to update the SQL Server 2000.
I have include the following codes at my ASP :
Response.Buffer = "True"
Response.Flush
Server.ScriptTimeOut =3600
But I keep getting this message displayed before the update query is completed
Microsoft OLE DB...
Hello, I wrote some scripts using ASP to update the SQL Server 2000.
I have include the following codes at my ASP :
Response.Buffer = "True"
Response.Flush
Server.ScriptTimeOut =3600
But I keep getting this message displayed before the update query is completed
Microsoft OLE DB...
Yes, I tried putting C.CounterDate, still the same err msg
Column 'C.CounterDate' is invalid in the select list because it is not contained in either an aggregate function
or the GROUP BY Clause
Yes, I tried yours, William. I got this error message :
Column 'C.CounterDate' is invalid in the select list because it is not contained in either an aggregate function
or the GROUP BY Clause
This one is for the version of Raj1Patel.
There's an error message of :
Column 'C.High' is invalid in the select list because it is not contained in either an aggregate function
or the GROUP BY Clause
Hi Williamu, I tried your statement and it gives me the error message of
Column 'C.CounterDate' is invalid in the select list because it is not contained in either an aggregate function
or the GROUP BY Clause
There's an error message of :
Column 'C.High' is invalid in the select list because it is not contained in either an aggregate function
or the GROUP BY Clause
UPDATE SecCounter
SET HHigh = Max ( SELECT TOP 200 C.High
FROM CONS C
GROUP BY C.CounterName
WHERE C.CounterName = S.CounterName
ORDER BY CounterDate DESC
)
, CloseV = Max ( SELECT TOP 1 C.CloseV
FROM CONS C
GROUP BY C.CounterName
WHERE...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.