Knowledge Base Contributions

Below is a list of the knowledge base entries that Nathan Wallace has contributed to:

Page:  1 2 3 4 5 
• Special behavior when reading files
  

• Regular expression problem with quotes
  

• Regular expressions & parsing with quotes
  

• Applying a filter to all files in a directory
  

• Key bindings in Tkinter
  

• Parsing chemical formula
  

• Fast intersect, unique, ...
  

• New (?) suggestion to solve "assignment-in-while" desire
  

• Filename utility routine (drives)
  

• Normalizing pathname
  

• Normalizing pathname
  

• Sorting a dictionary by its values
  

• Block structure parser
  

• Inverting a dictionary
  

• Sub last match
  

• Better "apply" function
  

• Machine precision in Python
  

• List of references
  

• Assistance on first program (molecular mass)
  

• Boolean type
  

• Specifications for SYLK format
  

• Help with first Python program
  

• List size hints
  

• What is the standard way of compiling a source file into bytecode?
  

• Generating bytecode
  

• pydoc (easy doc generation)
  

• Sieves
  

• Sieves
  

• Speedy sieves
  

• Sieves / List size hints
  

• Is there a way to read and write base-n strings using pack or unpack?
  

• Sieves / List size hints
  

• Sieves / List size hints
  

• List size hints
  

• Speedy sieves
  

• Possix access() and ttyname() missing?
  

• Strip newline without losing implied space
  

• How to copy lists and dictionaries?
  How to copy lists and dictionaries?
  

• Problems with frand()
  

• while r.readline()... construction
  

• Using __init__.py
  

• Re-importing modules
  

• Finding an instance's class
  

• Using Perl-like flags
  

• Currying
  

• Translating regsub.splitx() to re.split()
  

• Quicker file processing
  

• Creating class instances in batch
  

• Enumeration (was: Parsing chemical formula)
  

• Perl regex code to Python
  

• Perl regex code -> Python
  

• os.path.split() with DOS path names
  

• Obfuscated IP-decoder
  

• Obfuscated single-line scripts
  

• Obfuscated Python
  

• Importing modules in JPython
  

• Why do the patterns ^[ \t] and ^[^ \t]* get the same result?
  

• Substituting strings
  

• Parsing sys.version
  

• Convertings strings to/from lists
  Convertings strings to/from lists
  

• Converting strings to/from lists
  Converting strings to/from lists
  

• Extracting tagged text from an HTML file
  

• Extracting fields from HTML table
  

• Extracting fields from HTML table
  

• Extracting fields from HTML table
  

• Extended slicing
  

• Printing % literally
  

• Trouble with display of a HTML TEXTAREA:
  

• test for voting on an unanswered question
  

• test for double spacing on edit answer emails
  

• Escape sequences like \n and \t are not working. What actually is the purpose of escape sequences?
  

• How can I copy rows from a temporary table into a real table?
  

• How can I limit the size of MySQL tables?
  

• What date formats does MySQL accept?
  Can I use loose date formats in MySQL?
  

• How can I determine the "health" of my MySQL server?
  How can I get an insight into how well my MySQL server is running?
  

• Can I use multiple character sets in MySQL simultaneously?
  

• How can I update my development database with data from the production server?
  

• Can I put the data file and index file on different disk drives?
  Can I put the data file and index file in different directories?
  

• How can I get the date 7 days prior to today?
  

• What are some design techniques for multi-language sites?
  How can I build a site that supports multiple languages?
  

• What's the best way to start writing a PHP program?
  

• How can I make sure a session stays open during a long file download?
  

• How can I convert the last modified time for a file to a MySQL datetime?
  How can I convert the last modified time for a file to a MySQL datetime?
  

• Why do my strings contain strange "%20" type things?
  

• How can I see all the indexes for a table?
  How can I see all keys for a table?
  What is the name of the INDEX for the PRIMARY KEY of a table?
  What is the name of a key placed on a single column?
  

• Does every row in a MySQL table have a unique row ID?
  

• How can I rename a table?
  

• Do I need to backup MySQL's update logs?
  When is it necessary to backup the MySQL update logs?
  

• How can I get a sequence of days from MySQL?
  

• How can I see the entire SQL queries that are currently executing?
  How can I see a list of the current MySQL processes?
  How can I see all currently executing queries?
  

• Why does my data get imported in a random order?
  Can I import data in a certain order?
  

• Why are there 2 functions : OCIParse and OCIExecute?
  

• How can I access a secure database server from a PHP web server?
  How should I setup my web server network so the database server is not accessible to people?
  

• How can I create a color a shade darker than a given hex value?
  

• What are the advantages of storing session data in a database and not a file?
  Should I use database session handling or file session handling?
  

• Why do I keep getting a "permission denied" error for Postgres queries?
  How can I give a user permissions in Postgres?
  

• can php update a textfile that i can use for a flash movie?
  

• Is it possible to scale a PHP system to several computer through load balancing or similar?
  

• Can I use PHP with Oracle on Windows?
  How do I enable the Oracle functions with PHP on Windows?
  If I add "extension=php3_oci80.dll" in php.ini PHP don't work (even scripts without Oracle)
  I've Oracle Personal8.0.5 an PHP4 but when I add the "extension=php3_oci80.dll" php don't work!
  

• Windows 98, PHP4RC2 - mail function does not work. Anyway what happened to the php3_*.dll's? Will there be a PHP4 version?
  

• How can I find out what the date of the last monday was without year/month concerns?
  

• How do you get Xitami & php4 to work together with xitami aliases?
  Sorry, I don't know how Xitami setup Perl. Could you explain in more detail?
  

• How can I produce WML from PHP?
  

• How can I build WAP services with PHP?
  

• How can I do simple natural language processing with PHP?
  How can I parse queries to remove natural language?
  

• Where can I get more information about building international web sites?
  How can I set the language and char sets in the META HTTP-EQUIV directives?
  

• How can I use a global variable inside a class?
  

• How can I control error handling in PHP?
  Can I log all PHP errors to a file?
  

• How do I use the gettext function?
  

• How can I create a script that allows people to comment on products?
  

• How can I get a list of all users logged in to a MySQL server?
  

• Does MySQL strip whitespace from character fields?
  

• Are Unix users and MySQL users related?
  

• Does MySQL support cursors?
  

• What type JDBC driver should I use?
  Where can I get a JDBC driver for MySQL?
  

• Which is faster, UPDATE or REPLACE?
  

• What's the best way to store a year and month in a field?
  

• When were temporary tables introduced into MySQL?
  

• Will indices speed up '%..%' queries?
  

• How can I use perl to split a string into equal size pieces?
  How can I break up a string into equal pieces placed in an array?
  

• How to make MySQL support into an installed PHP without reinstalling other modules?(On apache, LINUX)
  

• How do I create a dynamic hyperlink in PHP?
  

• how to setup Apache to use PHP CGI with VirtualHosting and suEXEC?
  How do you keep the #!/usr/local/bin/php from displaying on the page?
  

• How can I setup ipchains to log matching packets?
  

• I have two ethernet cards, how can I use ipchains to accept telnet and ftp on one interface only?
  How can I configure ipchains by device?
  

• Why do ipchains scripts set deny by default but then later explicitly deny some connections?
  

• How can I mount a Windows partition on my Linux box using Samba?
  

• Can I disable all passwords in Samba so I can just connect without logging in?
  Is there a way to send files from the Linux box to the Windows box using Samba?
  

• I can run my PPP script manually, but diald keeps saying "Peer is not authorized to use...". Why?
  

• How can I cause a script to delay processing?
  What is sleep used for?
  

• What does the rp parameter in the workstation printcap expect?
  Should I use the printer name or the spool directory for the rp parameter?
  

• Is there a newsgroup form of the PHP mailing list?
  Is there a PHP newsgroup?
  

• What are the benefits of using --enable-sysvsem and --enable-sysvshm?
  

• What does --enable-dmalloc do?
  

• Can I sort a 3 dimensional array in PHP?
  

• How can I create DOS style new lines in PHP?
  Why are all my new lines messed up when I create a file for DOS / Windows?
  

• Does configure cache options?
  How can I get rid of the cached configure options?
  

• Why do I get the error "Maximum execution time exceeded"?
  How can I change the max execution time in PHP?
  

• What is PHP ?
  

• How do I supply a password on the command line to mysql shell programs?
  

• Is there an ODBC driver to connect to MySQL from MacOS?
  

• Is the LIKE statement case sensitive?
  Does LIKE '%ABC%' match ABC, abc, AbC and so on?
  

• What are the limits on a SELECT statement in MySQL?
  

• What causes "ERROR 2002: Can't connect to local MySQL server..."?
  error 2002 while i give mysql as root it works but when i give it as a user it gives me this error,
  

• How many licenses do I need for a web machine that houses a number of MySQL using clients?
  

• How can I stop MySQL from listening on a TCP socket?
  

• What are the basic steps to secure my box with a cable modem?
  

• Do I need to setup security for a cable modem server?
  Why should I bother securing a simple Linux box with a cable modem?
  

• How can I setup my own name server on a Linux PC?
  

• What characters are valid in a Linux password?
  

• How can I use Netscape for offline browsing in Linux?
  How can I download a web site for off line viewing?
  How do I use wget?
  

• What is the maximum size of a BLOB?
  Why does the doc say 4GB and the database say 16MB as the max size of a BLOB?
  

• How many columns can be in a single MySQL table?
  

• Can I order results from a MySQL query by two different columns?
  

• I'm new to PHP, where should I start.?
  

• What is the best way to write an application for different languages?
  What is gettext used for?
  

• Where is a safe temp directory for uploading files in safe mode?
  

• Why does the a GET variable called quote show up as a quote mark (")?
  Can I use quote as the name of a GET variable?
  

• What is the fastest way to get the MD5 checksum of a file?
  

• How can I get the mime type of an uploaded file?
  How does PHP work out the mime type of an uploaded file?
  

• How can I find all values in a column that are not unique?
  How can I get all duplicate values from a column?
  

• Why do I get "Can't get stat of 'test.txt' (Errcode: 2)" when using LOAD DATA INFILE?
  

• What is the difference between the e-mail support and the extended e-mail support from TCX?
  

• Does PHP work with Lotus Notes?
  

• What changes were made to the Apache directives?
  

• How can I randomly shuffle the contents of an array?
  

• Does empty return true or false if the given value is zero (0)?
  Are there any changes to the empty() function from PHP3 to PHP4?
  

• How can I turn off PHP execution on a per directory basis?
  What are the PHP3 and PHP4 directives to stop PHP execution in a directory?
  

• How can I get the size of a row of a two dimensional array?
  Can I use sizeof with multi-dimensional arrays?
  

• How can I print a dollar sign in a string?
  How can I format currency properly in PHP?
  

• What is page level locking?
  

• Does MySQL have row lock capabilities or only table lock?
  

• How many mysqld instances should I see for N connections?
  

• What are the issues with having several MySQL instances over the same file system?
  Should I use replication or have several MySQL instances running over the same file system?
  

• How can I import data with fixed size fields into MySQL?
  Is it possible to import fixed size data directly into MySQL tables?
  How get I get data from another dabase server?
  

• How do I pass a sting in a url eg. $MyString='Have a nice day'?
  

• Do MySQL connections time out?
  

• Do I have to do anything in MySQL to prevent collisions between multiple inserts?
  When do I need to lock tables for updating?
  

• Should I run MySQL on Linux or FreeBSD?
  

• Why do I keep getting the error "invalid column name" in ODBC queries?
  Should I use double or single quotes to enclose data in ODBC queries?
  Why does my query work if I execute it directly, but not work through ODBC?
  

• How can I setup MySQL to handle lots of concurrent connections?
  What is the default maximum number of threads in MySQL?
  

• Where can I find information about replication in MySQL?
  

• What is a PRIMARY KEY?
  

• What is an INDEX for?
  

• How can I abort a slow query in MySQL?
  Do all queries get killed if I kill the MySQL session?
  

• What does the period do in this statement: $svarname = "other_site" . $i; Concactenation?
  

• I'm typing a multi-line sql statement, how can I go back to correct errors?
  Does MySQL have a command line history?
  

• Is there a way to change the character set to accept arabic characters beside the normal english characters?
  

• I'm new to MySQL, where should I start?
  

• Will tabs in the data affect a mysqldump in tab delimited format?
  

• Do I have to use the index name when doing a query?
  Should I use the column or index name in my lookup query?
  

• What is UNIQUE() used for?
  Would INDEX name (last_name,first_name)) prevent duplicate entries?
  

• How can I change the order of columns in a MySQL table?
  How can I move a table field to a new position?
  

• Why can't I get ENCRYPT() to match identical passwords?
  What is the effect of the salt in ENCRYPT()?
  

• Does MySQL have a full text search capability?
  

• What does the $$ mean in variables?
  

• How can I add/write to an existing file?
  

• How can I create an object instance giving its classname at runtime?
  

• Does python have a sleep function? e.g. sleep(60) to wait 60 seconds?
  Is there a command/function in python to put a delay or wait step into a program?
  

• How do you interrupt a program running under PythonWin?
  How can I stop or break out of my Windows Python program?
  

• How can I use the smtplib module to send email from Python?
  How can I send mail using the os module?
  How can I send mail through python?
  

• How do I retrieve raw HTTP POST data into a PHP script?
  How can I get POST data from a non-browser based application into PHP?
  How should I do to get raw data whose content-type is application/x-www-form-urlencoded with PHP?
  

• Which folder should I ask my question in?
  

• How do I navigate within the knowledge base folders?
  

• What is the FAQTs privacy policy?
  

• Is it necessary for me to logout of FAQTs?
  

• Where can I practice creating a knowledge base with entries?
  

• Do FAQTs knowledge bases have to be computer related?
  

• How do I delete a folder alert?
  

• How can I contribute to FAQTs?
  I am trying to host my web application using Apache and DynDns free DNS service, but I ran into a pr
  How to remove PHPsessionID from URL?
  how can I remove slow query problem in mysql?
  how can i get good freelancer from India?
  I have a image on website "A". when that image is clicked an alert box should apper saying "GAME O
  

• How can I get the currently running script name?
  

• How can I execute a program called zgv, for viewing jpeg files, on a linux server using php3?
  

• test
  

• Why does the onSubmit event not get triggered in my form with NN?
  

• How can I save a variable to a file on the client (without cookies) and retrieve its value later?
  How can I save a value to a file on the server?
  

• How do I check the user input password from a form with encrypted one in the Apache htpasswd file?
  

• Can I use FAQTS to setup a private (restricted) folder?
  

• how do Install PHP-3.0.16 with APACHE-1.3.9 on UNIX SCO?
  

• What is Linux?
  

• On which Operating systems is PHP (successfully) running?
  

• After using mysqldump, how can I load dump file back to database server?
  How can I back up a MySQL database?
  

• My hosting service just upgraded to PHP4, beta 2, from PHP3. My scripts which call "dbmopen()" no longer work - "undefined function". Ideas?
  

• Semicolon test
  

• How to pass login and password from first level script to third level script (that means one script is included in another,like that 3 levels)?
  

• How can you calculate the difference between 2 times?
  

• Is it possible to PUSH content through PHP3 like the server time every second?
  

• Can php and perl run on the same server, and on the same site?
  

• How could I echo a variable which include "<? XXX ?>"
  

• How can I create a simple PHP 'mail to' form?
  How do I move from CGI to a PHP mailto form?
  

• Why can't I run php from command line?
  

• Is there any way to force PHP to do garbage collection before the end of the request?
  

• Can I execute an UPDATE query with multiple tables in the WHERE condition?
  

• I need to build a template-based PHP solution. Which one is a better choice to start from: FastTemplate or the functions in PHPLib?
  

• How can I capture the url of a remote logged-in user ?
  

• How can I run another application (non Python) from within a Python script and capture its output?
  Does os.popen() work from pythonw?
  

• How do I format my request to get an url/socket when there is a proxy in themiddle?
  

• Is it possible to not have to explicitly do imports?
  

• Can I use Python scripting inside a C app?
  How can I use Python as an internal scripting language?
  

• How do you redirect stdout to your own place, such as a Win32 anonymous pipe, before you even call Py_Initialize?
  

• How can I check that the Python version is recent enough to run my program?
  

• Are there any bug tracking systems written in Python?
  

• What files do I need on my web server to use Python for CGI?
  

• How can I extract all the keys in a formatting string to a list?
  How can I extract all the keys in a formatting string to a list?
  

• How can I use a line printer from Python on different systems?
  Is there system independent access to a line printer from Python?
  

• Is there anyway of using AuthDBI with a load balance mechanism?
  

• How can I duplicate every incoming message to two different hosts?
  

• How can I modify the LWQ startup scripts to start and stop only smtpd?
  

• Does qmail support VRFY user?
  Why do I always get 252 when I use VRFY?
  

• Are there any books available for qmail?
  

• How can I quickly delete a lot of messages from the queue that are for a domain that doesn't exist?
  

• What does qmail do if the same address appears multiple times in a message header?
  

• How can I access MySQL from Python?
  Should I use MySQLmodule or MySQLdb?
  

• How can I read all the lines from a file?
  How can I detect end-of-file when reading it?
  

• Why isn't a pyc file created upon execution of my script?
  Do scripts have pyc files?
  

• How can I trap a keyboard interrupt using Python?
  Ctrl-Break does not raise KeyboardInterrupt, how can it be caught?
  

• How can I use C code in my python script?
  

• How can I check if a number is contained in a range?
  

• How can I set my system path from within Python?
  

• How can I access a Postgres database from Python on Windows?
  

• How can I control MS-Access from Python?
  

• How can I connect to a MySQL server on a remote machine?
  

• What is the #!/usr/bin/python line for?
  What different forms of "#!" hack are used, and when?
  

• When might I need to LOCK TABLES in MySQL?
  Can you give me an example of table locking?
  

• How is ROUND() implemented in MySQL?
  Why does ROUND() return strange values?
  

• How can I setup a secure connection between the MySQL client and server?
  What alternatives are available to secure the connection between the MySQL server and its clients?
  

• How can I do Microsoft Access style reports from MySQL?
  Can I use Access to generate reports from a MySQL database?
  

• How can I access MySQL with a shared pool of connections from Perl?
  

• How can I run my Python programs in Windows?
  How can I setup Python file extensions on Windows?
  

• How can I convert a floating point number to a string?
  

• How do I use python code in ASP tags?
  

• How can I get the state of the other mouse buttons in the callback for a button1 event?
  How can I get the state of buttons and keys in an event instance?
  

• Can I get the variable name of an object instance?
  

• What does del do for an instance of a wrapped C class?
  Does del call the destructor of a wrapped C class?
  

• Where can I find a good simple example using threads in Python?
  

• Where can I get a complete version history of Python?
  

• Is there a extended library of Python functions for X windows?
  Can I track the X-Y co-ordinates of the mouse from Python even over other application windows?
  
  
  Page:  1 2 3 4 5