I have also found EmEditor, just need to test it out a bit. However yes apparently I could use VS as a text editor, though I haven't tested it yet on the file that is 77,000 columns. Basically it's a data file all on one line with 74 white spaces defining a page break.

Just tried it, and it overwrote the file changes without asking... This check before saving thing is basically because of one file that should be a database table. Thanks for the suggestion though...

Wasn't exactly sure where to put this question... We are currently using Programmers File Editor (which hasn't had an update since 1999 I think) to edit and view large and small data files before processing. Since moving to 2008 R2 it's been acting up a bit and will just close and other normal not supported software behavior. The key features I'm looking for is the ability to view files with large rows (col count over 35,000), checking for updated files before saving (basically have a file open twice, make changes in both places it should notify you that the file has changed before the second save happens), and kinda going with the last, notifying you of file changes if you move off it and go back (drop focus then gain focus), displaying row and col position is very handy as well. Thanks!

That is correct, it is however working "fine" on the other 2008 R2 Server. The window grays out and has "not responding" in the ribbon, but it still carries on and completes. However on this server it quits.

This application is working fine on 2003 R2 and 2000 Servers and even our other 2008 R2 server but I keep getting the error on this new server. I could have sworn I had to do some tweak to get it working on 2008 R2 but I can't remember what it was. Basically what is happening is the application is doing a DB "query" that is taking a fair amount of time and as a result the UI is no longer "responding" even though the applicaion is working away and in fact not frozen/locked/in an infinite loop. The application is written in VS 6 and as you can see in both the description and below using MFC.

Problem signature:
Problem Event Name: APPCRASH
Application Name: qexectest.exe
Application Version: 1.0.0.1
Application Timestamp: 46b1e781
Fault Module Name: MFC42D.DLL
Fault Module Version: 6.0.8168.0
Fault Module Timestamp: 358870e1
Exception Code: c0000005
Exception Offset: 0002b4af
OS Version: 6.1.7601.2.1.0.16.7
Locale ID: 1033
Additional Information 1: d67f
Additional Information 2: d67fe74012b2fff2bcc60d9e40d9bbd3
Additional Information 3: 7b8d
Additional Information 4: 7b8d5be233f423bf0e8bf92697c74b98

I'm still pretty new to Java so I'm sure I'm missing something. Basically just trying to update a database here so nothing that should be too difficult. If I run the program in Netbeans it runs fine... however if I run the executable from the commandline I get a error: C:\Users\Derek>java -jar "C:\Path...\dist\BirthDayUpdate.jar" Trying the connection now... Connection Exception: I/O Error: SSO Failed: Native SSPI library not loaded. Check the java.library.path system property. This is the connection code where it's failing:

public Connection openConn() {
try {
System.out.println("Trying the connection now...");
Class.forName("net.sourceforge.jtds.jdbc.Driver");
conn = java.sql.DriverManager.getConnection("jdbc:jtds:sqlserver://localhost:1433/Intranet");
System.out.println("Connection ok.");
} catch (ClassNotFoundException | SQLException e) {
System.out.println("Connection Exception: " + e.getMessage());
//e.printStackTrace();
}
return conn;
}

Thanks in advance!

Ok, combo of hatred of M$ and Java here.... apparently when I installed Visual Studio Web edition or IIS it put a copy of SQL Server 2008 Express and Java was nice enough to grab that one vs the 2012 which Visual studio was... Stopped the service for 2008 and now it's working... I'm going to go grab a drink now.

This is my first Java database application so I'm sure I'm missing something. This is the code I have...

import java.sql.*;

public class ClsConn {
private Connection conn;

public Connection openConn() {
    try {
        System.out.println("Trying the connection now...");
        //Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        Class.forName("net.sourceforge.jtds.jdbc.Driver");
        //conn = DriverManager.getConnection("jdbc:odbc:IntranetSql");
        conn = java.sql.DriverManager.getConnection("jdbc:jtds:sqlserver://localhost:1433;databaseName=Intranet;user=sa;password=passwrd");
        System.out.println("DSN Connection ok.");
    } catch (Exception e) {
        System.out.println("DSN Exception: " + e.getMessage());
        e.printStackTrace();
    }
    return conn;
}

}

This was originally using a DSN, but that didn't seem to work (I was getting some interesting behavior) so I've gone to what you see there. I'm getting this error message: Cannot open database "Intranet" requested by the login. The login failed. For reference on the same server for my asp pages I have the following which is working:

Public Function OpenConnection() As Boolean
Dim connString As String
cnn = New SqlConnection
connString = "server=localhost; uid=sa; pwd=password; database=intranet"
Try
cnn.ConnectionString = connString
cnn.Open()
Return True
Catch ex As SqlException
GlobalClasses.Client_Alert(ex.Message)
Return False
End Try

End Function

I have opened up 1433 on the server so I have no idea what's going on... Any ideas would be greatly appreciated... --Update 1-- For "fun" I just changed the Database to "Master" and the gosh darn thing "works"... well my query fails because the table it's looking for isn't in Master but the connection is working. I really need to start drinking or something. So it appears that everything is working for for some reason I can't see the database??? --Update 2-- Ok so I change my query figured that would be a good idea right? Nah... So I put in "use Intranet SELECT...." and get "Exception: Database 'Intranet' does not exist. Make sure that the name is entered correctly.". So I did what any good frustrated developer would do and opened up the mgmt studio for SQL Server and went to master and ran the same

I figured it out... I checked the type of the variables and it thought the second was a string :doh: so I made some code changes and it's now a INT. Love those descriptive error messages, guess they have learned a few things from M$

This is the code I'm having a problem with:

//$sql = "SELECT SQL_CALC_FOUND_ROWS * FROM " . TBL_MEMBERS . " ORDER BY $order LIMIT :startRow, :numRows";
$sql = "SELECT SQL_CALC_FOUND_ROWS * FROM " . TBL_MEMBERS . " ORDER BY $order LIMIT $startRow, $numRows";

try {
$st = $conn->prepare( $sql );
$st->bindValue( ":startRow", $startRow, PDO::PARAM_INT );
$st->bindValue( ":numRows", $numRows, PDO::PARAM_INT );
echo "sql string = " . $sql . "
";
echo "just before we hit the execute
";
$st->execute();
echo "just hit the execute
";
$members = array();
foreach ( $st->fetchAll() as $row ) {
echo "pre";print_r($row);echo "/pre";
$members[] = new Member( $row );
echo "pre";print_r($members);echo "/pre";
}

ok had to remove the <> from the pre tags to makes it easier to read... Ok, if I run the non-commented out version of the SQL it works fine and I get the result I expect, however if I run the commented out version I get the following error: Query failed 1: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''5'' at line 1 I printed this out at the start of the function to check the values: startRow = 0 and numRows = 5 I'm sure it's something stupid as I only spend about 5 - 10 hours a month doing PHP, so thank you in advance! oh yeah: mysql> select version(); +-------------------------+ | version() | +-------------------------+ | 5.5.24-0ubuntu0.12.04.1 | +-------------------------+ 1 row in set (0.00 sec)

Recently I had to go back though some old VB6 code and make some fixes. It was odd, we changed our Database server to something newer but kept with SQL 2000 :wtf: (yeah we're current in some things ) When we did that for some reason our one application query that uses temp tables went from running in under 1 second to 30+. For what ever reason using the same connection for temps and the "regular" tables no longer worked after 12 years (go figure). Not knowing what the problem could be I started to throw together a test program and what a pain in the butt that was. I wanted to check the one table and then remembered that I couldn't do a ExecuteScalar and I can't count the times I did something like conn.close() and then found out that oh yeah you don't use the (). Heck even For Each loops work a bit different, oh and then there is the starting at 1 and not 0 for arrays. I started my programming career using VB around half way through the life of VB5, then moved to 6 and then jumped to 2005 and haven't looked back. The best way I can describe VB6 now is it's like running 15 miles. It basically sucks while your doing it, but you look back and think "hmm, that wasn't too bad and somewhat enjoyable... I think I'll do that again". Don't get me wrong I still enjoy VB and it's usually my goto language, but I think I'll stick with .Net

Habit of using Do loops...

Ok so if I make some changes and add an event to the Tab3 selected event (for lack of a better term) and then populate the DGV it displays. I'd rather it get populated in the first run rather than each time a tab is selected if possible....

I have a form with 4 datagrids, 3 of which are on a tabcontrol. All the grids are coming from the same source. The problem I'm running into is the grids on Tabs2 and 3 are not displaying the data. I stepped though the code and it's there but not displaying. I also changed the tab order to see if I had a code issue but again the grid in tab1 is the only one displayed. This is what I have for code:

For Each dgv As DataGridView In {dgvMain, dgvTab1, dgvTab2, dgvTab3}
'dgv.AutoGenerateColumns = True
dgv.DataSource = ds.Tables("TaskList")
dgv.AutoGenerateColumns = False
Next
Dim dgvRow As Integer = 0
Do Until (i = 15)
dgvMain.Item("RetrievalKey", dgvRow).Value = ds.Tables("TaskList").Rows(i).Item("RetrievalKey")
dgvMain.Item("TaskDescription", dgvRow).Value = ds.Tables("TaskList").Rows(i).Item("TaskDescription")
dgvMain.Item("LastDoneOn", dgvRow).Value = ds.Tables("TaskList").Rows(i).Item("LastDoneOn")
dgvMain.Item("Agent", dgvRow).Value = ds.Tables("TaskList").Rows(i).Item("Agent")
dgvMain.Item("AgentOrder", dgvRow).Value = ds.Tables("TaskList").Rows(i).Item("AgentOrder")
dgvMain.Item("Query", dgvRow).Value = ds.Tables("TaskList").Rows(i).Item("Query")
dgvTab1.Item("Param0", dgvRow).Value = ds.Tables("TaskList").Rows(i).Item("Param0")
dgvTab1.Item("Param1", dgvRow).Value = ds.Tables("TaskList").Rows(i).Item("Param1")
dgvTab1.Item("Param2", dgvRow).Value = ds.Tables("TaskList").Rows(i).Item("Param2")
dgvTab1.Item("Param3", dgvRow).Value = ds.Tables("TaskList").Rows(i).Item("Param3")
dgvTab1.Item("Param4", dgvRow).Value = ds.Tables("TaskList").Rows(i).Item("Param4")
dgvTab2.Item("Param5", dgvRow).Value = ds.Tables("TaskList").Rows(i).Item("Param5")
dgvTab2.Item("Param6", dgvRow).Value = ds.Tables("TaskList").Rows(i).Item("Param6")
dgvTab2.Item("Param7", dgvRow).Value = ds.Tables("TaskList").Rows(i).Item("Param7")
dgvTab2.Item("Param8", dgvRow).Value = ds.Tables("TaskList").Rows(i).Item("Param8")
dgvTab2.Item("Param9", dgvRow).Value = ds.Tables("TaskList").Rows(i).Item("Param9")
dgvTab3.Item("ErrorMessage", dgvRow).Value = ds.Tables("TaskList").Rows(i).Item("ErrorMessage")
dgvTab3.Item("QueryPath", dgvRow).Value = ds.Tables("TaskList").Rows(i).Item("QueryPath")

        dgvRow += 1

Ok so I made some progress... if I use

savedSquares = document.images['A2'].alt;

it retreives the alt value which is a step in the right direction. Just wondering if there is a better way?

Ok I'm trying to figure out how to loop through the values of my table cells (they all have a image in them). When I created the cells I named them with a id="A2" (for example). the code I've been trying in testing looks like this:

savedSquares = document.getElementById('A2');
alert("a2 = " + savedSquares);
alert(document.getElementById("innerSquares").rows[0].cells.length);
//alert(document.images('a2').src);
address = document.getElementById("innerSquares").rows[0].cells[3].value;
alert("cell = " + address);

The results in order are A2 = [object HTMLTableCellElement] 10 (this is correct) cell = undefined I've tried a bunch of other combos but this is what I currently have. The images are also named the same so the image in "A2" is also named the same way:

<img src="images/o.jpg" border="0" height="100" width="100" name="A2" alt="Open">

Not sure if that will make it easier but I haven't been able to read those with my limited knowledge of JavaScript. The looping through part won't be a issue, I just need to figure out how to get the name of the image or even the alt text would be doable. Thanks in advance!!

Thanks for the link, that really helps

Now I see what I did wrong in my other version, I forgot the escape character... the joys of learning new languages. Thanks, it seems to be working now. Putting a variable inside {} adds it to a string? I didn't know that. :thumbsup: I really appreciate the help!!

I think this belongs better in the forum as I believe the problem to be on the PHP side. What I'm doing is creating a table dynamically that has some JavaScript function calls in it (well I'm trying to). The page is displaying ok in Chrome and Firefox but IE is complaining about it and not displaying at all. However in Chrome and Firefox it's not "working" just displaying right. this is the code I'm trying to use...

$display_string .= "<td><a href='javascript:choice('".$row .$col ."')'><img src='images/o.jpg' border=0 height=100 width=100 name='" .$row .$col ."' alt='Open'></a></td>";

When you hover over one of the cells on the loaded page you see javascript:choice(. It should read something like javascript:choice(A3) If I do an inspect element with chrome I get

so it appears the issue is in the creation of the javascript call? Thanks in advance!!

Well if double is the standard then I'll go with double. Thanks for the help!!