Recent content by raymundo

Brendan, Thanks for the quick response. I tried the command but I can't tell if it has created a file. That is I can't find one. Is their anyway to tell it to write to a certain directory. I don't have direct access to my MySQl directory as Iam on a shared server. I tried: mysql> mysql -u...

Is there a way to extract/export the contenets of a MySQL table into a coma delimited text file for use with MS Excel? If yes. What are the commands? Thanks, Ray

Steve, Thanks for the insightful comments. I came to the same conclusion, fortunately before I did any XML work for my client. He seems satisfied with the normal php/mysql report I came up with. Again Thanks and Happy New Years. Ray

Specifically, I have set up a login with session information set to the user Id. What I want to do is after logging in with the user id and the viewer is on a specific page how do you get just one cell from one row of a MySQL db to display it's contents in the page with the user id as the...

Actually, the client was driving this. Their management attended a lecture or something and heard all the hype about XML. Their intranet is a unix/apache server with MySQL. I've just been trying to see if it is doable.

For now we will only be producing a static report that will display information from a database in xml. Not sending information to the database. Specifically, an employees benefits statement that he can login to and view. No imput from the employee other than a login and pasword for his/her...

Anyone know where a hosting provider is that runs unix Apache server with the Apache::ASP module with a MySQL database?

Thanks, I will. This is turning in to a bigger project than I first imagined, but I will just have to persist. Again, Thanks.

Great! I have php4 installed on my server with mysql. Do you know of any resources/references that discuss using php and xml to querry mysql? Any help would be appreciated. Ray

Actually, we are considering using Cocoon from Apache.org which retrieves data from the database with a SQLProcessor module which uses JDBC.<br><br>Are you familiar with this particular middle ware?&nbsp;&nbsp;If so is there anything I should watch out for?<br><br>Thanks,<br><br>Ray

We have a unix machine running the Apache server with MySql installed.&nbsp;&nbsp;We plan to use the tcp/ip protocol. We have enabled the mime type for XML for viewing of XML documents.&nbsp;&nbsp;<br><br>We plan to target the IE5 browser as this will be on a company wide Intranet and all the...

Pete, thanks for the quick reply.&nbsp;&nbsp;As you can probably tell from my original post I'm new to this.&nbsp;&nbsp;Can one build an online report using XML that would display information contained in a MySQL database.&nbsp;&nbsp;There would not need to be any calculations...

I have done a lot of searching and can not find XML and MySQL in the same sentance.&nbsp;&nbsp;Is their a way for an XML document to use MySQL as its data source?<br><br>Any references, suggestions would be greatly appreciated.

I have done a lot of searching and can not find XML and MySQL in the same sentance.&nbsp;&nbsp;Is their a way for an XML document to use MySQL as its data source?<br><br>Any references, suggestions would be greatly appreciated.