Ask a Question related to Coldfusion Database Access, Design and Development.
-
jiggar #1
Manipulating CSV files with SQL
Can UPDATES and INSERTS be used on CSV files when using the "cfquery" tag of
ColdFusion? I've tried but so far no luck. My thinking is that this is not
possible, but I could be wrong and might be doing something wrong. I understand
that SELECT statements can be used on .csv files, but it would be nice to be
able to use manipulation statements for people who don't want to deal with big
databases. Thanks.
jiggar Guest
-
Manipulating XML File
Assume you're working with a vendor that doesn't understand web services and implements their version of a web service solution that only returns... -
Manipulating a 3d object
Hi, I am very new to Director, but I have made a 3d model in 3ds max, and have been able to import it as a new cast member. I want the user to... -
Manipulating Dataset
Dear gurus, I have a stored procedure which returns a set of rows. How do I suppress a number of columns (not display) from dataset? Is is... -
Help with manipulating a string.
I've got a multiline text box that will feed the ^M at the end of each line. I want to capture it into a single line (which is done), but how do I... -
Manipulating arrays
Hello.... Where can I see (web pages) examples of manipulating arrays, calculos with elements of arrays or something like that?, I am writing a... -
Dan Bracuk #2 Re: Manipulating CSV files with SQL
You could probably do it with the cffile tag.
Originally posted by: jiggar
Can UPDATES and INSERTS be used on CSV files when using the "cfquery" tag of
ColdFusion? I've tried but so far no luck. My thinking is that this is not
possible, but I could be wrong and might be doing something wrong. I understand
that SELECT statements can be used on .csv files, but it would be nice to be
able to use manipulation statements for people who don't want to deal with big
databases. Thanks.
Dan Bracuk Guest
-
philh #3 Re: Manipulating CSV files with SQL
Comma-separated, text, and Excel drivers do not as a rule support inserts,
updates, or deletes. As Dan said, if you are truly working with a CSV file,
then it would be a trivial matter to update the information through CFFILE.
I'd rather rely on a real database to manipulate data. That's what they're for.
philh Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
