Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Codfusion 4.5 and Oracle 8.1
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> -
access database locking
Still having same problem <p>Dave Joyce<br><a href=mailto:DaveJoyce@hotmail.com>DaveJoyce@hotmail.com</a><br><a href= > </a><br> -
Netscape vs Internet Explorer
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> -
using tables in multiple databases
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><CFQUERY NAME="GetStatusData" DATASOURCE="Sites"><br>INSERT INTO GeneralArchive.StatusSnapshot_tbl... -
Please Help.
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> -
Changing Password(Urgent Please)
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> -
Netscape vs Internet Explorer
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... -
Creating files on the Users Local Hard Drive
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... -
What is the best way to handle external database uploading
<CFSchedule> 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... -
ODBC Error Code = S0002 (Base table not found)
sounds like the table sellers does not exist in the specified database. -
Creating files on the Users Local Hard Drive
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> Thanks,<br> Dave Joyce -
Allowing User to Define Filename to be Created
The following:<br><br><br><br>File to create: <INPUT NAME="filename" SIZE=50 TYPE=FILE ><br><br><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... -
access database locking
...DATASOURCE="Sites"><br> (SELECT plant, status, status_date, N1, Start_Date,<br> (Select count(*) FROM punch_list_tbl<br> WHERE resp_person = 'test_person' <br> AND status = 'Open'<br> AND plant = checklist_tbl.plant) as test_open... -
access database locking
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... -
Error Code = 22001 (String data right truncation) ??
Potinenip,<br><br> Usually this error occurs when one of your fields has a length that is bigger than the size in he database. <br><br> 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... -
Access database locking after scheduled event
I have a scheduled event that occurs once per day. It executes the following code:<br><br><cfoutput><br><cfloop query=GetStatusData><br><CFSET nWeek = #DateDiff("WW", Start_Date, Now())# + 1><br><CFQUERY DATASOURCE="AFSM_GeneralArchive"><br>INSERT INTO... -
Recursive use of forms and sending parameters
That did the trick. The odbcdate wasn't a problem, but removing the field worked great. Thanks for the help.<br><br><br> Thanks,<br> Dave<br> -
Need help: "Outputing a date range from a query"
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> Regards,<br> Dave Joyce<br><br> -
Recursive use of forms and sending parameters
Hi, <br><br> 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...
