Hi,
I'm trying to read from text file that is currently being used by other application (more precisely I'm trying to open current IIS log file).
I get EInOutError 32 (sharing violation). I tried to use "FileMode := fmOpenRead;" to open file in read-only mode, but it does not help...
Hi,
I would like to divide my new 80GB harddrive into 3 parts (C,D,E)
What would be more efficient:
1) To have 3 primary partitions
or
2) To have 1 primary partition + extended partition with 2 logical drives?
I'm planning to use only one operating system (Win2k pro) and I don't care about...
Is there way in MS SQL to insert mulptiple rows at the same time?
I'm trying to achieve something like this(I know it works in DB2):
---------------------------------
INSERT INTO mytable
(a,b)
VALUES
(1,2),
(5,4),
(15,2),
....
--------------------------------
Thanks
Could anyone tell me please, how Coldfusion MX 6.1 compared to Coldfusion 5 in terms of speed?
I've heard that CF MX works much slower than CF 5. Is this true? How about MX6.1 compared to MX6.0?
I'm not worried about new functions in MX. I just want somebody's opinion on execution speed.
Thanks,
Hi,
I want to select first 10 distinct values from the table.
If I try
SELECT TOP 10 distinct target
FROM myTable
ORDER by target
then SQL Server gives error:
"Server: Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'distinct'."
What's wrong with this...
Hi,
I have a weird problem.
The table in the database has a column name with a "minus" sign ("mobile-phone").
When I'm trying to do the following...:
<cfoutput query="test">
#mobile-phone#
</cfoutpu>
..I'm getting error message from CF "Invalid...
Hi,
I'm running Windows 2000 Server, IIS 5
I installed SSL certificate, rebooted, and after this I can not open IIS. When I click on IIS icon it gives me error message "Error connecting to bts. The system can not find the path specified".
('bts' is the server name)
Even though I...
Hi,
Recently my full-text catalogs stopped populating. I tried to rebuild them, to recreate them, etc, but nothing helps. I looked at the win2k log files. It has the following warning messages whenever I try to populate catalogs:
1) The crawl for project <SQLServer$SQL2000 SQL0000700008> could...
Hi,
Recently my full-text catalogs stopped populating. I tried to rebuild them, to recreate them, etc, but nothing helps. I looked at the win2k log files. It has the following warning messages whenever I try to populate catalogs:
1) The crawl for project <SQLServer$SQL2000 SQL0000700008> could...
Hi,
Here is sql type of query I'm trying to execute:
SELECT a=3,b=4,c=a+b
However, it does not let me do it, because I'm trying to use variebles "a" and "b" in calculating "c".
Any suggestions, why it does not let me do it?
P.S. In my real query "a"...
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.