Search results for query: *

Is there a way to select data from a table in database a and insert into a table in database b. For use in archiving for instance. Each database has a seperate DSN.<br><br>&lt;CFQUERY NAME=&quot;GetStatusData&quot; DATASOURCE=&quot;Sites&quot;&gt;<br>INSERT INTO GeneralArchive.StatusSnapshot_tbl...

I have a .csv file on my coldfusion server. I want the user to be able to display this file in excel and/or be able to download it to his/her local hard drive. This works fine in Internet Explorer, but in netscape, the .csv file is brought up in the browser window with the commas in...

Is there a way through CFFILE or some other way to create a file on the users local hard drive? For instance to save the results of a query into an excel file?<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Thanks,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Dave Joyce

The following:<br><br>&lt;br&gt;<br>File to create: &lt;INPUT NAME=&quot;filename&quot; SIZE=50 TYPE=FILE &gt;<br>&lt;br&gt;<br><br>only allows the user to select a file that currently exists.<br><br>Is there a way to allow the user to use the above to navigate to the correct directory and then...

After many of my queries my access database continues to be locked(.ldb file exists). This stops me from updating the table definitions and deleting data during testing. There must be a timeout that occurs and releases the lock file after some period of time. Is there something that needs to be...

I have a scheduled event that occurs once per day. It executes the following code:<br><br>&lt;cfoutput&gt;<br>&lt;cfloop query=GetStatusData&gt;<br>&lt;CFSET nWeek = #DateDiff(&quot;WW&quot;, Start_Date, Now())# + 1&gt;<br>&lt;CFQUERY DATASOURCE=&quot;AFSM_GeneralArchive&quot;&gt;<br>INSERT INTO...

Hi, <br><br>&nbsp;I am trying to create a form that calls itself on a submit and passes one of the fields on the form to the new instance. I can't get <font color=red>UserEnteredDate</font> to be recognized? <br><br>any...

I want to be able to perform a complicated select statement and then write the results, row by row to a snapshot table. I don't believe cold fusion will allow you to nest CFOUTPUT statements, so the only way I can think of to accomplish this is to generate the results set, store in an array of...

Is there a way to automate the archiving of data in an access database?<br><br>For instance, everyday at midnight all rows in a table are copied to another table.<br><br>The only way I can think of doing this is to check a table to see the last time the table was update each time a user enters a...

I am trying to e-mail multiple contacts based on a flag in a database. It will not allow nesting of &lt;CFMAIL&gt; within &lt;CFOUTPUT&gt;. Any suggestions on how to do this??<br><br>The following code does not work:<br><br>&nbsp;&lt;CFQUERY DATASOURCE=&quot;xxx&quot;&gt;<br>&nbsp;UPDATE...

I want to dynamically create a page with the files that exist in a directory and a link to those files so the user can view the document in word. Can this be done in coldfusion, and is there a qualifier that will only return .doc...

I am trying to set and unset a value in a database based on the value of a field the user has checked. I am able to set the field in the database but when the user unchecks, the field in the database remains the same. Any Ideas?? Attached is code...