Coldfusion help!!
- Started
- Last post
- 14 Responses
- eps
I've created a page to output data from a database to an XML file. The XML file is created, but it is totally empty. If I put a string in the cffile output it writes correctly. And the cfdump works properly and creates the visual of the XML file properly. It's very strange and I can't figure it out. Help please!! Windows server.
Eric
SELECT *
FROM artportfoliobuttons
- ********0
Are you trying to do something like this? Flash -> CFML -> MySQL -> CFML -> XML (parsing) -> Flash or maybe even less?
- eps0
I am trying to take info from a mySQL database, use coldfusion to create an XML file that will drive a flash menu. I have it working fine on my own Mac server but can't seem to get it up and running on the public windows server. It's gotta be something simple...
- ********0
yeah that is what I thought you might be doing using like Firefly and what not like here: http://www.macromedia.com/softwa… you might be able to find something in their learning area. Not exactly sure what you have in terms of your parsing XML file.
- enobrev0
so the file writes correctly locally and not on the server?
It's possible for the server admin to turn off cffile command in cfadministrator. You might want to try a cfcatch of sorts. OTherwise, it could be a permission issue, regarding write access to the folder (haven't worked with CF in a while)
- ********0
so did you get it? I don't know MACs well.
- eps0
I know the cffile tag is turned on because I use it in other pages of the application to upload files. And it will write the file to the server, it's just empty. If I hard-code in an output value to the cffile tag it's written properly so it's not permissions. It seems like a piece of the code for the cffile tag isn't executing properly. I don't get it.
- eps0
I'm trying to do the XML flash thing without firefly components because 1. they are only for pc and I'm on a mac. 2. they are WAY overpriced especially when I can do everything they do on my own for free. 3. They seem to be limited to certian uses. I want to build a full CMS for a flash site using CFMX instead of just doing the few small things that those components are good for. I have almost all the pieced together there is just one line of code that keeps fucking me up...
- eps0
I just realized that the code I posted initially got cut off. Here is the full code. THe last cffile tag seems to be where everything falls appart. Thanks...
SELECT *
FROM artportfoliobuttons
- ********0
Where is it? you can do this with just some tweaking invloved, I've helped do it with Flash on PC. Some fun dynamic stufff though.
- eps0
I'm not sure what you mean by where is it? Do you want know the IP address or where in the code I think the issue is? Looking online won't help you much as it's a blank page, with the code included in the previous email, that spits out an XML file into the same directory. And the rest of the site isn't designed yet. I wanted to see if I could get it to work first. As far as where I think the error is it has to be in the final cffile tag. Everything else is executed properly. Even the cfdump sends the right info to the browser so it must be reading from the database. For some reason the XML file isn't created properly.
Let me know any info that would specifically help you help me. Thanks!
Eric
- ********0
Hmm, ok, so you are saying it's an issue with XML. All I can say is re-check that thing.
- eps0
Anyone else? Help!
- dehryll0
unless i'm missing something your code is still getting cut off. all i see is:
SELECT *
FROM artportfoliobuttonstry posting your code again. if i could see it maybe i could help.
- unknown0
sounds like the variable (output xml data) is being read incorrectly if the file is being created on the server. If a file can be created on the server than cffile works, your code is messed up. Check that your variable holding your data is being called right.