Search results for query: *

If oracle 8.1 has an odbc driver, create an odbc datasource and connect that way <p>Dave Joyce<br><a href=mailto:DaveJoyce@hotmail.com>DaveJoyce@hotmail.com</a><br><a href= > </a><br>

Still having same problem <p>Dave Joyce<br><a href=mailto:DaveJoyce@hotmail.com>DaveJoyce@hotmail.com</a><br><a href= > </a><br>

The mime type had to be set on the netscape server to associate excel with the .csv file <p>Dave Joyce<br><a href=mailto:DaveJoyce@hotmail.com>DaveJoyce@hotmail.com</a><br><a href= > </a><br>

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...

Use the string Handling functions such as SpanExcluding to span to the first space. This will be the first name.<br><br>See Ben Forta's Book Pg 883. <p>Dave Joyce<br><a href=mailto:DaveJoyce@hotmail.com>DaveJoyce@hotmail.com</a><br><a href= > </a><br>

you are asking if record count eq 0 in the if statement shouldn't it be Not Equal 0<br><br> <p>Dave Joyce<br><a href=mailto:DaveJoyce@hotmail.com>DaveJoyce@hotmail.com</a><br><a href= > </a><br>

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...

The intent was for the user to request the file to be generated. This is a regular practice in the case of the user having an option to save a file to their hard disk. Any attachments to e-mail allow the user to save the attached file to their hard disk, so I don't think that this is cutting...

&lt;CFSchedule&gt; can schedule a form to be run periodically(daily). This form can use the CFFILE tag to upload the file to the server. See Ben Forta's book - Chapter 28 Pg 677 for an example of uploading files.<br><br>Hope this helps.<br><br> <p>Dave Joyce<br><a...

sounds like the table sellers does not exist in the specified database.

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...

...DATASOURCE=&quot;Sites&quot;&gt;<br> (SELECT&nbsp;&nbsp;plant, status, status_date, N1, Start_Date,<br> &nbsp;&nbsp;&nbsp;&nbsp;(Select count(*) FROM punch_list_tbl<br>&nbsp; WHERE resp_person = 'test_person' <br> AND status = 'Open'<br> AND plant = checklist_tbl.plant) as test_open...

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...

Potinenip,<br><br>&nbsp;&nbsp;Usually this error occurs when one of your fields has a length that is bigger than the size in he database. <br><br>&nbsp;&nbsp;For instance if Property Address is 50 characters in the database and you allow the user to type 60 characters on the screen, when you try...

I am using version 4.0 and it has a CFScheduler tag or you can schedule tasks through the administrator

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...

That did the trick. The odbcdate wasn't a problem, but removing the field worked great. Thanks for the help.<br><br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Thanks,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Dave<br>

Use order by in your select statement and then in you rcfoutput, set the start date from the first record and the end date from the last record.<br><br>&nbsp;&nbsp;&nbsp;&nbsp;Regards,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Dave Joyce<br><br>

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...