Re: Using XML to Create schema/database
Tom, Usually the detail portion of the error will include more information - usually the error returned from the database. Make sure that the database exists and has CREATE and ALTER permissions (if you want DataMgr to create tables and columns). If you have any more trouble, you can check out the DataMgr Group http://groups.google.com/group/datamgr or contact me directly http://www.bryantwebconsulting.com/contact.cfm Thanks, Steve I do have one question on the loadXml function. I'm getting a error that says LoadXML Failed(verify datasource MySQLDS is correct). The DSN is valid, where/ how can I trouble shoot this? Thanks, tom ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329035 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Using XML to Create schema/database
Tom, As Isaac mentioned his DataFaucet project and my DataMgr project will both create tables and columns from XML. DataMgr will also allow you to define the data (not sure about DataFaucet): http://www.bryantwebconsulting.com/docs/datamgr/synchronize-database-structure-activeschema.cfm http://www.bryantwebconsulting.com/docs/datamgr/seed-data.cfm Thanks, Steve Hello, I was wondering if there were any libraries or functions which can be used to create database tables on the fly based on XML data and then insert the data. So all I had to worry about was formatting the xml data. Thanks, tom ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329003 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Using XML to Create schema/database
I was wondering if there were any libraries or functions which can be used to create database tables on the fly based on XML data and then insert the data. So all I had to worry about was formatting the xml data. This isn't exactly what you asked for, but the bundled Hibernate functionality in CF 9 will create database tables on the fly based on value object CFCs you've defined. And it's just as easy, I think, to write those as to write XML data. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329020 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Using XML to Create schema/database
Ahh cool. I hadn't seen that before. DataFaucet doesn't currently have any seed-data feature in the XML, so you'd have to write your own code for doing that part of it with the current version of DF. As Isaac mentioned his DataFaucet project and my DataMgr project will both create tables and columns from XML. DataMgr will also allow you to define the data (not sure about DataFaucet): http://www.bryantwebconsulting.com/docs/datamgr/synchronize-database-structure-activeschema.cfm http://www.bryantwebconsulting.com/docs/datamgr/seed-data.cfm -- s. isaac dealey :: AutLabs Creating meaningful employment for people with Autism http://www.autlabs.com ph: 817.385.0301 http://onTap.riaforge.org/blog ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329019 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Using XML to Create schema/database
Wow, the DataMgr project is very cool. I can use it right away for other parts of my application. thanks, tom Tom, As Isaac mentioned his DataFaucet project and my DataMgr project will both create tables and columns from XML. DataMgr will also allow you to define the data (not sure about DataFaucet): http://www.bryantwebconsulting. com/docs/datamgr/synchronize-database-structure-activeschema.cfm http://www.bryantwebconsulting.com/docs/datamgr/seed-data.cfm Thanks, Steve Hello, I was wondering if there were any libraries or functions which can be used to create database tables on the fly based on XML data and then insert the data. So all I had to worry about was formatting the xml data. Thanks, tom ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329026 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Using XML to Create schema/database
I do have one question on the loadXml function. I'm getting a error that says LoadXML Failed(verify datasource MySQLDS is correct). The DSN is valid, where/ how can I trouble shoot this? Thanks, tom ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329032 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Using XML to Create schema/database
Hello, I was wondering if there were any libraries or functions which can be used to create database tables on the fly based on XML data and then insert the data. So all I had to worry about was formatting the xml data. I've not done anything for performing the inserts/updates using XML, but the DataFaucet orm ( http://datafaucet.riaforge.org ) creates DB tables using XML and so does Steve Bryan'ts DataMgr project ( http://datamgr.riaforge.org ). Shouldn't be too difficult to add something for performing the inserts/updates with either tool. hth ike -- s. isaac dealey :: AutLabs Creating meaningful employment for people with Autism http://www.autlabs.com ph: 817.385.0301 http://onTap.riaforge.org/blog ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329001 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4