Re: from CSV to XML

2007-07-08 Thread [Sunshine Tech Solutions] Ravi Gehlot
Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On 7/8/07, [Sunshine Tech Solutions] Ravi Gehlot [EMAIL PROTECTED] wrote: Hey Sean, I never asked you to do my homework. I have always worked for my salary

from CSV to XML

2007-07-07 Thread [Sunshine Tech Solutions] Ravi Gehlot
Hi, I was asked to convert a CSV file to XML. Is there free a converter out there? Also, is there a free XML plugin for Eclipse? Ravi. -- --- Ravi Gehlot. Sr. Management Sunshine Technology Solutions, LLC http://www.sunshinetechsolutions.com/ [EMAIL

Re: from CSV to XML

2007-07-07 Thread [Sunshine Tech Solutions] Ravi Gehlot
. But using CFHTTP to produce the query from the CSV file is quite possible and then having it imported some how in XML format. I never used the CFWDDX tag so will research on that. Also, is XMLBuddy free? Didn't find it for FREE. Ravi. Sean Corfield wrote: On 7/7/07, [Sunshine Tech Solutions

Re: from CSV to XML

2007-07-07 Thread [Sunshine Tech Solutions] Ravi Gehlot
was immediately available for use. Ravi. Sean Corfield wrote: On 7/7/07, [Sunshine Tech Solutions] Ravi Gehlot [EMAIL PROTECTED] wrote: But using CFHTTP to produce the query from the CSV file is quite possible and then having it imported some how in XML format. Once you have a query

Re: from CSV to XML

2007-07-07 Thread [Sunshine Tech Solutions] Ravi Gehlot
that wants it in XML. He got his reasons. Raiv. Sean Corfield wrote: On 7/7/07, [Sunshine Tech Solutions] Ravi Gehlot [EMAIL PROTECTED] wrote: Cool, so I got the query successfully in the memory. It works just as nice as I thought it would. How do I go about generating the whatever XML I need

from CSV to XML

2007-07-07 Thread [Sunshine Tech Solutions] Ravi Gehlot
How could I better answer your question? Could you be more specific? The XML needs to be one that it can be used to import those delimited column fields in the previous CSV file. I know you might be thinking...well...why don't they just import the CSV into the SQL database. Well, that's the

Re: from CSV to XML

2007-07-07 Thread [Sunshine Tech Solutions] Ravi Gehlot
Hey Sean, I never asked you to do my homework. I have always worked for my salary. Sorry to have bother. Thank You. Ravi. Sean Corfield wrote: On 7/7/07, [Sunshine Tech Solutions] Ravi Gehlot [EMAIL PROTECTED] wrote: How could I better answer your question? Could you be more

Re: from CSV to XML

2007-07-07 Thread [Sunshine Tech Solutions] Ravi Gehlot
Hey Sean, I will do a little research on the type of XML I need and then will get back at you. As far as tag-wise would use CFWDDX? Ravi. Sean Corfield wrote: On 7/7/07, [Sunshine Tech Solutions] Ravi Gehlot [EMAIL PROTECTED] wrote: How could I better answer your question? Could you

Re: from CSV to XML

2007-07-07 Thread [Sunshine Tech Solutions] Ravi Gehlot
Hey Dave, Is there a list of specific XML languages? They company has a portal that knows how to treat XML data so it let's the end user upload an XML file that is then imported into a SQL database through their portal. Ravi. Dave Watts wrote: No, *you* need to be more specific. XML can

Re: from CSV to XML

2007-07-07 Thread [Sunshine Tech Solutions] Ravi Gehlot
So in this case, the XML type is tables. Correct? After I read the CSV file with CFFILE action set to read, built a query in memory with CFHTTP what would be the next step in building this XML file? Ravi. Claude Schneegans wrote: To elaborate on this a little bit, XML isn't a language.

Re: from CSV to XML

2007-07-07 Thread [Sunshine Tech Solutions] Ravi Gehlot
with the portal. The portal is going to be designed to work with XML laid out in a certain fashion. On 7/7/07, [Sunshine Tech Solutions] Ravi Gehlot [EMAIL PROTECTED] wrote: So in this case, the XML type is tables. Correct? After I read the CSV file with CFFILE action set to read, built

Re: from CSV to XML

2007-07-07 Thread [Sunshine Tech Solutions] Ravi Gehlot
Hey Claude, That helps. Thanks! CFHTTP is already in use. What would WDDX stand for? Just curious...gotta google. it. Ravi. Claude Schneegans wrote: what would be the next step in building this XML file? I would rather try to read the table using CFHTTP to build a query, although

Re: from CSV to XML

2007-07-07 Thread [Sunshine Tech Solutions] Ravi Gehlot
and become a better programmer. What may seem simple and straight forward for you may not be for others. So I would say don't worry about baking the cake so I can eat it alone. I know how to find my food. Sincerely, Ravi. Sean Corfield wrote: On 7/7/07, [Sunshine Tech Solutions] Ravi Gehlot [EMAIL

Re: from CSV to XML

2007-07-07 Thread [Sunshine Tech Solutions] Ravi Gehlot
Corfield wrote: On 7/7/07, [Sunshine Tech Solutions] Ravi Gehlot [EMAIL PROTECTED] wrote: My sole goal is to learn and become a better programmer. In my first response to you in this thread I suggested CFHTTP and CFWDDX as possible solutions. You can learn and become a better programmer

Re: from CSV to XML

2007-07-07 Thread [Sunshine Tech Solutions] Ravi Gehlot
then make a working example. On 7/7/07, [Sunshine Tech Solutions] Ravi Gehlot [EMAIL PROTECTED] wrote: Hey Sean, Yes, I am a beginner in the ColdFusion world. You shouldn't be worried about providing me the straight solution so that I could get by. If you think that my interest here

Re: from CSV to XML

2007-07-07 Thread [Sunshine Tech Solutions] Ravi Gehlot
Wow! This makes a lot more sense now Dave. So the WDDX from the CFWDDX means the type of XML struct used. Great. Thanks, Ravi. Dave Watts wrote: But Ravi told use he has a CSV file he wants to be formated in XML. For me it is clear: a CSV file is a format to represent a table. A table can

Re: from CSV to XML

2007-07-07 Thread [Sunshine Tech Solutions] Ravi Gehlot
Sean, I have to say THANK YOU! I got the file converted in seconds with the software you indicated me. Now I know what wddx means and I also know how the XML file needs to look like. I won't sleep tonight till I read and learn about XML. Will try the ColdFusion tags also. Ravi. --

Re: from CSV to XML

2007-07-07 Thread [Sunshine Tech Solutions] Ravi Gehlot
Cool. That's why they say that XML is not a language but a meta-language. Unlike HTML that it has its own tags, XML can have tags created by the developer accordingly by creating DTD or schemas. Ravi. Dave Watts wrote: Is there a list of specific XML languages? No, because anyone can

Re: Web Developers soon to be extinct?

2007-06-25 Thread [Sunshine Tech Solutions] Ravi Gehlot
They need to start participating in meetings like the CFUnited happening in Washington and soon enough they will change their minds. Ravi. Claude Schneegans wrote: OK, I know everyone is already familiar with the age old argument stirred up once again by the a

Re: Server Error

2007-06-23 Thread [Sunshine Tech Solutions] Ravi Gehlot
Hey Pete, Check to see if your version of access works fine with ColdFusion 7.0.2. Sometimes, you have to download a special driver and install it on your ColdFusion directory so that your datasources may work ok. Just a thought, Ravi. Peter Tanswell wrote: Hi there I have recently

Re: Server Error

2007-06-23 Thread [Sunshine Tech Solutions] Ravi Gehlot
Pete, You can also try to connect to your datasource using a JDBC driver like this: jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=[Full path to your database file];DriverID22; Ravi. [Sunshine Tech Solutions] Ravi Gehlot wrote: Hey Pete, Check to see if your version of access

Re: Server Error

2007-06-23 Thread [Sunshine Tech Solutions] Ravi Gehlot
and quite likely a CF error or permission setting. I get the same error message when I try to browse for files when trying to set up mappings. Regards Pete On 6/24/07, [Sunshine Tech Solutions] Ravi Gehlot [EMAIL PROTECTED] wrote: Hey Pete, Check to see if your version of access

MySQL question

2007-06-20 Thread [Sunshine Tech Solutions] Ravi Gehlot
I know this question is prolly out topic but he it goes. How do I sort by the last inserted Id on a sql query? Ravi. -- --- Ravi Gehlot. Sr. Management Sunshine Technology Solutions, LLC http://www.sunshinetechsolutions.com/ [EMAIL PROTECTED] Cell Phone:

Re: MySQL question

2007-06-20 Thread [Sunshine Tech Solutions] Ravi Gehlot
? cheers, barneyb On 6/20/07, [Sunshine Tech Solutions] Ravi Gehlot [EMAIL PROTECTED] wrote: I know this question is prolly out topic but he it goes. How do I sort by the last inserted Id on a sql query? Ravi. -- --- Ravi Gehlot. Sr

Re: MySQL question

2007-06-20 Thread [Sunshine Tech Solutions] Ravi Gehlot
Oh God...it must be all of that pot I have been smoking. SorryI knew that... ;-) Ravi. Casey Dougall wrote: On 6/20/07, [Sunshine Tech Solutions] Ravi Gehlot [EMAIL PROTECTED] wrote: I know this question is prolly out topic but he it goes. How do I sort by the last inserted Id

Re: ColdFusion MX 7.0.2 and MySQL 4.1.12

2007-06-15 Thread [Sunshine Tech Solutions] Ravi Gehlot
James, I turned it off but no chance so far... Ravi. James Holmes wrote: Turn off the Windows firewall and try again... On 6/15/07, [Sunshine Tech Solutions] Ravi Gehlot [EMAIL PROTECTED] wrote: I ran telnet localhost 3360 and got connection failed. Ravi. Jochem van Dieten wrote

Trac Project

2007-06-15 Thread [Sunshine Tech Solutions] Ravi Gehlot
Does anyone know if the Trac Project works fine with MySQL? Ravi. -- --- Ravi Gehlot. Sr. Management Sunshine Technology Solutions, LLC http://www.sunshinetechsolutions.com/ [EMAIL PROTECTED] Cell Phone: (407) 860-3775 Business Line: (407) 745-1433

Re: Trac Project

2007-06-15 Thread [Sunshine Tech Solutions] Ravi Gehlot
with it. J.J. On 6/15/07, [Sunshine Tech Solutions] Ravi Gehlot [EMAIL PROTECTED] wrote: Does anyone know if the Trac Project works fine with MySQL? Ravi. -- --- Ravi Gehlot. Sr. Management Sunshine Technology Solutions, LLC http

Re: Trac Project

2007-06-15 Thread [Sunshine Tech Solutions] Ravi Gehlot
Alright then. Thanks. Ravi. J.J. Merrick wrote: I am going to say yes since I installed it on the same machine as a MySql database was running on in development and don't remember any conflicts. J.J. On 6/15/07, [Sunshine Tech Solutions] Ravi Gehlot [EMAIL PROTECTED] wrote: Yep

Re: Trac Project

2007-06-15 Thread [Sunshine Tech Solutions] Ravi Gehlot
Tech Solutions] Ravi Gehlot Sent: Friday, June 15, 2007 8:18 AM Subject: Trac Project Does anyone know if the Trac Project works fine with MySQL? http://trac.edgewall.org/wiki/TracInstall either SQLite, PostgreSQL, or MySQL works Mind if I ask why you don't use something that would

Re: Trac Project

2007-06-15 Thread [Sunshine Tech Solutions] Ravi Gehlot
Will try it now. Ravi. Damien McKenna wrote: -Original Message- From: [Sunshine Tech Solutions] Ravi Gehlot Sent: Friday, June 15, 2007 8:18 AM Subject: Trac Project Does anyone know if the Trac Project works fine with MySQL? http://trac.edgewall.org/wiki/TracInstall

Re: Trac Project

2007-06-15 Thread [Sunshine Tech Solutions] Ravi Gehlot
do you delete stuff on the timeline? I am logged in but no special options were given. Ravi. Tom Chiverton wrote: On Friday 15 Jun 2007, [Sunshine Tech Solutions] Ravi Gehlot wrote: Yep. QuestionI got MySQL running..if I install SQLite it won't conflict with MySQL, correct? As far as I

Re: Trac Project

2007-06-15 Thread [Sunshine Tech Solutions] Ravi Gehlot
ok Thanks, Ravi Andy Allan wrote: You manage everything via trac-admin (command line based) http://trac.edgewall.org/wiki/TracAdmin Or you can install the WebAdmin plugin http://trac.edgewall.org/wiki/WebAdmin Andy On 15/06/07, [Sunshine Tech Solutions] Ravi Gehlot [EMAIL PROTECTED

Re: Trac Project

2007-06-15 Thread [Sunshine Tech Solutions] Ravi Gehlot
that way yet, as our trac database is fairly small (and it works fine using SQLlite), but if you really want to, you can make it use a MySQL db. Russ -Original Message- From: [Sunshine Tech Solutions] Ravi Gehlot [mailto:[EMAIL PROTECTED] Sent: Friday, June 15, 2007 8:18 AM

Re: Trac Project

2007-06-15 Thread [Sunshine Tech Solutions] Ravi Gehlot
Just gotta figure how to install webadmin Ravi. Damien McKenna wrote: -Original Message- From: [Sunshine Tech Solutions] Ravi Gehlot Sent: Friday, June 15, 2007 11:06 AM Subject: Re: Trac Project Damien, I like TRAC way better. OK, I'll let you ;-) Damien McKenna

Re: Trac Project

2007-06-15 Thread [Sunshine Tech Solutions] Ravi Gehlot
YEP. Ravi. Andy Allan wrote: Trac supports multiple projects just fine. Andy On 15/06/07, Damien McKenna [EMAIL PROTECTED] wrote: -Original Message- From: Andy Allan [mailto:[EMAIL PROTECTED] Sent: Friday, June 15, 2007 9:19 AM Subject: Re: Trac Project Mind if I

Re: Trac Project

2007-06-15 Thread [Sunshine Tech Solutions] Ravi Gehlot
Damien, I like TRAC way better. Ravi. Damien McKenna wrote: -Original Message- From: Andy Allan [mailto:[EMAIL PROTECTED] Sent: Friday, June 15, 2007 9:19 AM Subject: Re: Trac Project Mind if I ask why you don't use something that would be easier to install manage,

Re: Coldfusion Developer Exam - 2 different ones?

2007-06-15 Thread [Sunshine Tech Solutions] Ravi Gehlot
Hey Andy, Where can I take these tests? Ravi. Andy Matthews wrote: It appears that I made that mistake my first time out. I thought for SURE I was taking the 7 test, but I actually took the 6 test. I was made too because I got advanced on the MX test, but only standard on the 7 test.

Trac Project

2007-06-15 Thread [Sunshine Tech Solutions] Ravi Gehlot
Do I have to start a new daemon for every different Trac Project? Ravi. -- --- Ravi Gehlot. Sr. Management Sunshine Technology Solutions, LLC http://www.sunshinetechsolutions.com/ [EMAIL PROTECTED] Cell Phone: (407) 860-3775 Business Line: (407) 745-1433

Trac Project

2007-06-15 Thread [Sunshine Tech Solutions] Ravi Gehlot
Do I have to start a new daemon for every different Trac Project? Ravi. -- --- Ravi Gehlot. Sr. Management Sunshine Technology Solutions, LLC http://www.sunshinetechsolutions.com/ [EMAIL PROTECTED] Cell Phone: (407) 860-3775 Business Line: (407) 745-1433

Re: Trac Project

2007-06-15 Thread [Sunshine Tech Solutions] Ravi Gehlot
OK. will try Ravi. Russ wrote: Trac runs under apache, so all you need to do is to configure a separate virtual site. Russ -Original Message- From: [Sunshine Tech Solutions] Ravi Gehlot [mailto:[EMAIL PROTECTED] Sent: Friday, June 15, 2007 5:33 PM To: CF-Talk Subject

Re: Trac Project

2007-06-15 Thread [Sunshine Tech Solutions] Ravi Gehlot
Ok Barney. Thanks Ravi. Barney Boisvert wrote: I host them all through Apache's mod_python, along with all my SVN repositories. So everything (including some normal websites) are running through the single Apache daemon process. cheers, barneyb On 6/15/07, [Sunshine Tech Solutions] Ravi

ColdFusion MX 7.0.2 and MySQL 4.1.12

2007-06-14 Thread [Sunshine Tech Solutions] Ravi Gehlot
I am getting errors trying to connect to the DB even after following these instructions: http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_19170sliceId=2 The OS is Windows XP Connection verification failed for data source: aisg java.sql.SQLException: Cannot connect to MySQL server

Re: ColdFusion MX 7.0.2 and MySQL 4.1.12

2007-06-14 Thread [Sunshine Tech Solutions] Ravi Gehlot
netstat -a returns: TCP 3306 LISTENING Ravi. Dave Watts wrote: I am getting errors trying to connect to the DB even after following these instructions: http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_1 9170sliceId=2 The OS is Windows XP Connection verification failed for

Re: ColdFusion MX 7.0.2 and MySQL 4.1.12

2007-06-14 Thread [Sunshine Tech Solutions] Ravi Gehlot
[EMAIL PROTECTED] [Sunshine Tech Solutions] Ravi Gehlot wrote: netstat -a returns: TCP 3306 LISTENING Ravi. Dave Watts wrote: I am getting errors trying to connect to the DB even after following these instructions: http://kb.adobe.com/selfservice/viewContent.do?externalId

Re: ColdFusion MX 7.0.2 and MySQL 4.1.12

2007-06-14 Thread [Sunshine Tech Solutions] Ravi Gehlot
I ran telnet localhost 3360 and got connection failed. Ravi. Jochem van Dieten wrote: [Sunshine Tech Solutions] Ravi Gehlot wrote: That WindowsXP firewall is for the outsiders not for locals. That does not answer the question. Can you telnet to it? Jochem

Re: AJAX Libraries

2007-06-10 Thread [Sunshine Tech Solutions] Ravi Gehlot
ops...this was for Brook...my bad! Andrew Scott wrote: why me? I do not care, I use dojo. On 6/10/07, [Sunshine Tech Solutions] Ravi Gehlot [EMAIL PROTECTED] wrote: Andrew, Check this out: http://bluedragon.blog-city.com/ajaxlibraries.htm Ravi. Andrew Scott wrote: Hello

Re: Subversion and Dreamweaver 8

2007-06-09 Thread [Sunshine Tech Solutions] Ravi Gehlot
Hi Elena, SVN is an enhancement of CVS. Ravi. Elena Aminova wrote: Thanks for all the replies. Moving to Eclipse is a work in progress for the team, and since we are using Dreamweaver already, and there is a very tight deadline for this project, we cant afford to spend time on learning

Re: What's wrong with these related selects?

2007-06-09 Thread [Sunshine Tech Solutions] Ravi Gehlot
Will, How are you calling this API? Ravi. Will Tomlinson wrote: I'm using qforms to build related select menus. I have it working, except the last dropdown isn't populating. Go to: http://208.106.220.252/soundings/T8Report.cfm Choose Business Tech. Information Tech. That should

Re: AJAX Libraries

2007-06-09 Thread [Sunshine Tech Solutions] Ravi Gehlot
Andrew, Check this out: http://bluedragon.blog-city.com/ajaxlibraries.htm Ravi. Andrew Scott wrote: Hello, Does anyone have suggestions on an ajax library? I read that CF8 has an integrated AJAX 'gateway', but is that really worth waiting for? There most be some good AJAX