Recent content by connectionscentres

Hi, I have a simple ms access application that allows you to scan barcodes in to a form which stores them in the database. The barcodes are 6 digits in length e.g. 555666 but my handheld scanner always adds a leading zero - e.g. 0555666. You can get round this problem by changing the database...

Seems that this is an issue caused by upgrading to MySql 4.1 http://www.informit.com/articles/article.asp?p=328641&seqNum=3 which introduces charsets and collations, the default ones being Latin1 and latin1_swedish_ci respectively. The illegal mix of collations issue must be because the data...

Using phpMyAdmin 2.6.0-pl3 and MySQL 4.1.7. Anyone know why (1) all of a sudden PhpMyAdmin displays a collation column for all my tables (2) the collation for fields of Char or VarChar is set to latin1_swedish_ci (3) when I try to run SQL it complains of Illegal mix of collations between...

Hi, I cant find the answer on the manual pages. Maybe I should look harder. Basically I'm putting dates into a table using: INSERT INTO TEMP date_format(INVOICEDATE, '%Y-%m-%d %H:%i:%s') As datei then I can select dates that have put an INVOICEDATE in by doing: SELECT * FROM TEMP WHERE...

I have a small site of about 66 pages using php and mysql to offer various database driver services. On each page where a database connection is required I have a php include directive at the top of the page. This includes a file where I make a single (non persistent) database connection each...

Hey Reta, I have EXACTLY the same problem when trying to copy parts of a query to an Excel workbook. Here is my code: Dim objXL As Object Set objXL = CreateObject("Excel.Application") objXL.Visible = True objXL.Application.workbooks.Add Dim objActiveWkb As Object Set objActiveWkb =...

Hi RSfromCO. I have EXACTLY the same problem as you did. Did you manage to fix it?

This may save you a lot of aggravation. When invoking the gd function "imagefilledrectange()" I noticed that it worked on one server but not on another. The first one had php5.0.3 installed with gd 2.0.28 and the second had php4.1.2 with gd 1.6.2. Other gd functions were working fine, just...

Hi, I have created a nice graph in php using gd's functions which generates a png image. Any suggestions on how to embed this into a web page? Simply doing <?php include"graph.php"; ?> doesnt work because the headers have already been sent off by the parent page.

thanks, it works, you rock!

Hi, I am running php version 5.0.3 and I think I have GD enabled. On the php info page for my server it says: GD Support enabled GD Version bundled (2.0.28 compatible) FreeType Support enabled FreeType Linkage with freetype FreeType Version 2.1.7 T1Lib Support enabled GIF Read Support...

sorry, posted before reading your message. I think you're right and that's probably what I'll do.

Problem: I've tried setting up URL rewriting by inserting <DefaultContext cookies='false' /> into the Host element of the server.xml file. Tomcat restarts successfully but urls do not contain any extra parameters. So I then wrote a jsp containing the following Integer num = new...

You're right, it returns the IP of the proxy not the browser. So- in this case do you think URL rewriting would work?

I guess so - I didnt realise session data was stored on the client - I just assumed it was stored on the host machine with tomcat, as the book i'm reading refers to them as session "objects" implying that they are dealt with in java. Thanks for the help!!!- you've given me a good starting point...