Search results for query: *

Just an update on this one - have decided although not impossible to convert this file into a CSV with CF, it would more than likely grind our server to a halt owing to the sheer size of the file and the convoluted parsing we would need to do to convert it. We're getting a 3rd party supplier to...

not sure if the link will work but the tag you want is called CF_TwoSelectsRelated http://www.macromedia.com/cfusion/exchange/index.cfm#loc=en_us&view=sn106&viewName=Exchange%20Search%20Details&authorid=7653985&page=0&scrollPos=0&subcatid=0&snid=sn106&itemnumber=0&extid=1000288&catid=0

There are various custom tags available that will do this for you ... look at the developers exchange on Macromedia.com HTH

i would do this with javascript instead of cflocation diggy brain not working so can't provide code right now! will come back later

ok, will have a play with it using your suggestions bb thanks again :)

adding anything manually just isn't an option with a 133Mb text file!

another thought - would it be better to post this on the MySQL forum and avoid going through CF altogether?!

thanks again bb for taking the time to reply am reading up on CFHTTP here ... i can see where you're coming from, but I can't see how replacing the record delimiter (**) with a comma is going to help - the field contents will have commas in them, so I would also need to escape these somehow...

Forgot to add - the file is in the region of 130 Mb in size ... AAAAAAAAARGH!

Thanks for your replies bombboy - we're using MySQL Front for administering the db, and it doesn't wanna know about importing a file in this format! I can't really see how CFHTTP can help us either, but to be fair I've never used it before, so perhaps I'm missing something. The first two...

I'm developing a books acquisition system, and have been given some sample bibliographic data as a text file, which I will need to import into my db on a weekly basis. I've only dealt with straightforward comma delimited text imports previously, so any suggestions for an efficient method to...

hvass - i have now restructured the database and eliminated the need for joins in that query, and it's running fine now. Learnt that lesson the hard way - thanks for your advice :)

Thanks hvass ... i wish it was a wind up, but it's not (i did say i'm a beginner!). I wouldn't go so far as to say I didn't understand a word of your answer, but I can see I've got a long way to go to get this right. The query does work, but your answer does explain to me why it's so slow. Any...

Hi all I am really new to mySQL, and have just completed my first web app using mySQL instead of Access. The problem is that users are reporting that the app is running very slowly and I suspect it may be something to do with the following query: <cfquery name=&quot;GetOffers&quot...