Community Member Profile

Recent Blog Comments By JimBastard

• Ask Ben: Converting XML Data To ColdFusion Queries

  Posted on Jul 9, 2008 at 3:15 PM

  Well hopefully....one day we can replace those DBA's with my 1337 scripts. ^_^ See you around the NYC! Let me know if you ever head out to the Hamptons, pool party at my house.... read more »

• Ask Ben: Converting XML Data To ColdFusion Queries

  Posted on Jul 9, 2008 at 2:54 PM

  Ben - Thanks for trying to help, I appreciate it. If we know the structure of the XML and what we'd like our database to look like it's just some simple parsing... you kinda missed the whole point. What this problem really boils down to is AI, as I do not know the table structure or X... read more »

• Ask Ben: Converting XML Data To ColdFusion Queries

  Posted on Jul 8, 2008 at 10:22 AM

  Well I suppose it doesn't have to be a query object....but I always have to start with XML of unknown structure. The idea is to be able to take in XML and auto-generate a database table from it. Turn the XML from flat data into a RDBMS without necessarily knowing the schema. The data... read more »

• Ask Ben: Converting XML Data To ColdFusion Queries

  Posted on Jul 8, 2008 at 10:06 AM

  Ben - Thanks for the quick response, you are the man! I looked a bit more into this last night. The custom tags above are pretty defunct, circa 2002. I've already got my XML converting into a struct but the thing is a struct isn't necessarily going to translate "nicely" into a query o... read more »

• Ask Ben: Converting XML Data To ColdFusion Queries

  Posted on Jul 7, 2008 at 10:42 PM

  Ben - I know its a bit late to be posting......I'm trying to come up with a slick way to display XML in a CFGrid simply by using the "query" attribute of CFGRID. The method you have described above is sufficient.....but what if you don't know the column names ahead of time? Maybe you... read more »