Hi Marsd,
I have worked for 20 years in coding, design, maintenance and support (you don't know how "good" the language you are using is, until you take on support esp. overnight support!) - and I can tell you from personal experience that I have found Perl is better than Shell/Awk (which is...
Hi Engineuity,
Thanks for replying even though you solved the problem already, and it would still be nice to see your code as an example.
Best wishes,
- ProblemSolver
Hi Engineuity,
Can you post an example of the code you are using, so that we have something concrete to think on?
Great handle, BTW!
Regards,
- Problemsolver
Mike,
Sorry to join the party so late, but it sounds like you have an interesting practical problem, and I would like to give it a shot.
Several things come to mind:
-> What do you need the list for - to do a lookup?
-> Further to the point above, do you *need* the list to be in-memory? If...
eamc,
set1 has a list as it's basic element - so if you want to get a string entered by the user in response to a raw_input, this may be the way to go:
set1 = set([raw_input("What's the magic word?: ")])
Unfortunately, I don't have 2.4 installed (yet) so can't verify this, but if the above...
While working with Oracle, you frequently need the DDL i.e. definition information of a table or indexes on a table.
Instead of writing complex SQL to access System tables e.g. ALL_TAB_COLUMNS, ALL_IND_COLUMNS etc., Oracle 9i and onwards you can use DBMS_METADATA to get the information you...
Hi jwdcfdeveloper,
Can you give some more technical information about your problem e.g. how you are handling the job at present in Cold Fusion? The detailed code is not needed - high-level pseudocode is OK. Since the CF solution works (albeit slowly), it would be wise to take a look at how it...
Hi JoinerX,
Looks like your budget precludes any ETL solutions, and you have to create a custom programming solution.
You could try Perl or Python for doing the entire up-front processing, prior to putting the massaged data in the database. These (and other) scripting languages are powerful...
Hi nwyork,
Please take a look at the reply I posted for eve25's query (it's just a few threads back).
Also, take a look at:
http://search.cpan.org/dist/DBD-ODBC/ODBC.pm#Using_DBD::ODBC_with_web_servers_under_Win32
Best of luck!
Hi eve25,
A few points about your problem:
- Have you defined the ODBC DSN as a SYSTEM DSN (defining it as a USER DSN won't work)?
- Are you able to run a small perl program from the command-line i.e. as a non-CGI script to do a simple select (e.g. count(*) of the rows in any table) on the...
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.