Recent content by newjim

Yes, this works. To choose the JSON key dynamically, you would have to break the square braces up, like this: <script language='javascript'> var JSON_text = { "first Name": "John", "lastName": "Smith" } function showData(theDiv) { document.getElementById(theDiv).innerHTML =...

Can you put spaces in a JSON key? My JSON object comes from a database so I can't change it. For example, "first Name" below has a space in it. var JSON_text = { "first Name": "John", "lastName": "Smith } Using eval("JSON_text." + "first Name") or eval("JSON_text[" + "first Name" +...

The problem is that the CHM that you launch from the Python program closes when the Python program ends. Here's a solution: cause the Python program to pause, then call the Python program again. For example, in a program called close_chm.py... import win32gui import win32help import os...

Actually, it does work from the interactive shell. So with some refining, it should work from a Python program run on the command line. Thanks JustinEzequiel.

The code by JustinEzequiel causes a CHM to briefly display on my screen but not stay open (I commented out the last line, that close it). I've looked at the win32help module on ActiveState, and the code looks correct. It should bring up the CHM, but it should not close. Am I missing something...

Is it possible to close a window or program in Python? I use Python to programmatically open a CHM in its own window by giving it the path and filename. Later I want to close that CHM. I would like to do that by somehow accessing it from Python and closing it. Is that possible? Thanks.

Has anyone seen this error message? Unable to process the crystal report...Error:656 Error in File... <Retrieve> ParamFields[8].Ranges <PEGetNParameterCurrentValues> I'm using 8.5 and running Crystal inside of a second program. The report works fine when I run it outside of this second...

Thanks, that worked perfectly. The only tricky part is seeing that when you click {?History Order} as "Field(s) to link to", you click the down arrow of the "Sub report parameter field to use" listbox and there is a tiny scrollbar that allows you to select either "{?pm-?History Order}" or...

I would like to have a parameter in my main report where the user can specify the sort order for a subreport, for example, "category" or "startdate". I've made a formula to create a shared variable from this main report parameter: Shared StringVar subReportOrder; subReportOrder := {?History...

Thank you! This stored procedure told me that I already had a link to MYLINKEDSERVER sp_linkedservers If I didn't, I would have created a linked server using: sp_addlinkedserver(syntax is in Books Online) Then I logged in to MYLINKEDSERVER by: exec sp_addlinkedsrvlogin MYLINKEDSERVER...

Thank you. Can you run by me the process for creating a linked server?

I need to compare userids in tables in databases in two SQL Servers running on two machines. I would like to do this using the Query Analyzer, for speed. Something like: --connect through Query Analyzer gui to 1stSQLServer select userid from 1stSQLServer.users --connect to 2nd SQL Server...

The reason that we can't use stored procedures is that the Crystal report viewer runs inside of another program. This program wants to append the userid of the current user to the query that it fires to SQL Server, which does not work when the query is a stored procedure. It might do the same...

Can you call a SQL Server function from Crystal 8.5? I can't use stored procedures in my environment, so have created a SQL Server function that accepts a parameter and returns a single value. However, I can't see that function in the Database window of Crystal, so can't use it. I've also...

Anyone know why NetBeans wizards are partially disabled in 3.5.6 and greater? I have 3.5.1., and when I invoke the new class wizard, it gives me several pages where I can add new members, methods, superclasses etc. All of that is gone in 3.5.6; you just get the basic shell of the class.