Recent content by tonedef

I have a client that I set up Apache/PHP/MySQL on a Win2K box and it has been up and running for a year or two. The client (and another outside vendor) applied some windows updates and installed IIS on the same box. IIS is set to listen on port 81 and Apache settings were not touched so it...

Make sure you have all of the SQL Service Packs (and hot fixes) installed. I found this helped when some code that used DMO worked on my machine but not on a coworker. We appliedn the Service Packs and hotfixes and it then worked on his machine as well.

I'm having a proplem getting my PHP installation to talk to Oracle. I have been running Win2K/Apache/PHP for a while and talking to MySQL. The client has an Oracle database that they would like to get some information from for the web site. They installed the Oracle Client software on the...

You could just use the query: SELECT a.City, b.Currency FROM TableA as a INNER JOIN TableB as b ON a.Country = b.Country

I am teaching a Win2K server class currently. To demonstrate installation and the use of Active Directory and DC replication I have every student installing the server and configuring as a DC. Each student has an account on an existing DC (my instructor server) that is in the Administrators...

I have a form where a user can fill out some information and attach a document that is uploaded to a MySQL table and the document is stored as a LONGBLOB. For some reason files over a certain size will not upload. I have not figured out the exact threshold, but as an example I can upload a 40K...

Has anyone found a way to get email from Netscape 7 email to Outlook 2000? Netscape 7 is kind enough not to have an export mail feature, and MS was kind enough not to allow importing from NS6/7 or Mozilla.

I am getting an error whenever I build my project/app/exe. Memo file <path>\<projectname>.pjt is missing or is invalid Is this a useful error first of all? What I mean is, is .pjt a memo file. I thought .dct or .fpt were memos. Second can I recover from this. I would really like to be able...

rgbean, THANK YOU THANK YOU THANK YOU

Is there a way to see the SQL of a local view that was created by CREATE SQL VIEW ... that is too complex to be opened by clicking MODIFY? Thanks, tone

I have a local view that is selecting information from a number of tables. The problem is the view is picking up records from the tables that are marked for deletion even though my application has set deleted on. Is there a way to prevent the view from doing this? It is causing a report to...

Thanks danceman, TABLEUPDATE() did the trick! I would have pounded my head off my desk for days before I looked at table buffering. Thanks again, tone

I'm having a strange problem inserting values into a table from code in a form. Inside a button on my form I update values in one table and that works fine. Right after that I perform an insert statement on another table and it doesn't give any errors (compile or run) yet it doesn't insert...

Thanks Dave, As a note to anyone else who is reading this thread. For the requery to work your view can not be read only. tone

there is no requery for a grid or a cursor in the dataenvironment. tone