Recent content by davejoyce

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

they are called from reports. See following for example:<br><br>&lt;CFPARAM name=&quot;szDate&quot; default=#DateFormat(Now(), &quot;mm/dd/yy&quot;)#&gt;<br><br>&lt;cfoutput&gt;<br><br>&lt;CFQUERY NAME=&quot;GetStatusData&quot; DATASOURCE=&quot;Sites&quot;&gt;<br> (SELECT&nbsp;&nbsp;plant...

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