Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: alexerm
  • Order by date
  1. alexerm

    Opening file as read-only

    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...
  2. alexerm

    primary partition vs extended partition

    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...
  3. alexerm

    inserting multiple rows

    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
  4. alexerm

    Coldfusion MX 6.1 compared to 5.0

    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,
  5. alexerm

    form variables not passed to action page - please help!

    I would recommend you to do it without javascript. Here is how you do it: 1) remove all javascript 2) in main file put: <form name=&quot;the_form&quot; method=&quot;post&quot; action=&quot;resolveform.cfm&quot;> 3) buttons: <input type=&quot;submit&quot; name=&quot;action&quot...
  6. alexerm

    using distinct with top

    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: &quot;Server: Msg 156, Level 15, State 1, Line 1 Incorrect syntax near the keyword 'distinct'.&quot; What's wrong with this...
  7. alexerm

    Uninstalling DirectX 9.0a

    Hi, everybody. I finally found tool on the web that uninstalled DirectX 9.0a for me. I used beta version of &quot;DirectX Eradicator 1.09&quot;. It worked for me! (I have win2k prof. sp3). So if anybody needs to get rid off &quot;DirectX 9&quot;, you may try this tool. (you will need &quot;win2k...
  8. alexerm

    Uninstalling DirectX 9.0a

    Hi, Is there any way to remove DirectX 9.0a and put back DirectX 8.1 (without reinstalling Windows) Thanks, Alex
  9. alexerm

    &quot;Minus sign&quot; in variable name

    Thanks a lot, Tek. Your suggestion with workaround helped me a lot. The reason, why I did not want to use aliases, because I'm writing a tool, that takes table name as parameter and then does &quot;some&quot; stuff with data and then imports to other database. I posted my question in very...
  10. alexerm

    &quot;Minus sign&quot; in variable name

    Hi, I have a weird problem. The table in the database has a column name with a &quot;minus&quot; sign (&quot;mobile-phone&quot;). When I'm trying to do the following...: <cfoutput query=&quot;test&quot;> #mobile-phone# </cfoutpu> ..I'm getting error message from CF &quot;Invalid...
  11. alexerm

    SSL Problem

    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 &quot;Error connecting to bts. The system can not find the path specified&quot;. ('bts' is the server name) Even though I...
  12. alexerm

    Problem with full-text catalogs

    No, I'm not using any type of XML interface Alex
  13. alexerm

    Problem with full-text catalogs

    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...
  14. alexerm

    moving a database from one server to another

    If the servers are on the same network, you may use &quot;Copy Database Wizard&quot;. Otherwise you could do it by creating and restoring backups
  15. alexerm

    Full text catalogs do not work

    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...
  16. alexerm

    Expressions in &quot;select&quot; and &quot;order by&quot;

    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 &quot;a&quot; and &quot;b&quot; in calculating &quot;c&quot;. Any suggestions, why it does not let me do it? P.S. In my real query &quot;a&quot...

Part and Inventory Search

Back
Top