Search results for query: *

Hello, I'm trying to call a batch file from vbscript. The batch file contains an ftp command which uses an ftp script. I'm trying to get vbscript to wait until the transfer is completed before going onto the next step. Function Upload(uploadBatchFile_PATH) 'Starts upload of files dim sh...

I'm trying to ftp some jpg's to our Fedora Core box running vsftpd. I intermittenly receive the error message during an ftp session: "Netout: Connection Reset by Peer" I'm connecting with a Windows XP Professional machine using the XP ftp client. Has anyone run into this?

I've not too terribly skilled at SQL, and I'm having problems with this join. The current query is as follows: SELECT EM.*, Activity.*, CL.*, Contacts.*, Opportunity.* FROM EM, Activity, CL, Contacts, Opportunity WHERE EM.Employee = Activity.Employee AND CL.ClientID = Activity.ClientID AND...

We recently acquired Actuate 6 in a web based CRM application, so I can definitely be considered a "newbie." I'm attempting to write a report for my users, but am struggling a bit. In this report, I need to pull fields First_Name and Last_Name from the database. I'm having problems...

Hello all, I have a query that I have been using in Microsoft Access that doesn't work with mySQL. I was wondering if someone could help me convert this: SELECT user.usrID, user.ctGiven, user.ctSurname,user.coName FROM user WHERE user.usrID NOT IN( SELECT user.usrID...

Hello all, I have a query that I have been using in Microsoft Access that doesn't work with mySQL. I was wondering if someone could help me convert this: SELECT user.usrID, user.ctGiven, user.ctSurname,user.coName FROM user WHERE user.usrID NOT IN( SELECT user.usrID FROM...

Hello all, I'm trying to use <cfcontent> to display a PDF file in a fusebox 3 application. Instead of the PDF displaying in the browser, it prompts me to download the index.cfm file, which is actually the PDF just renamed to index.cfm. Does anyone know of a way around this?

I've started using the Fusebox 3 methodology for coding our site, and I've run into a bit of a snag. I've learned a lot of my fusebox knowledge from http://www.halhelms.com, and in one of the tutorials on the site, it shows how a simple login page might be coded. They pass the Username and...

Hey all - I'm developing a pretty simple CF application where most of the changes to the database will be handled by 1 administration person. The only addition/change to the db that will be made by the end user will be a self registration page (username, pass, Name, address etc.) I may have...

I'm having a bit of trouble getting the results I need on a query. My tables are as follows: SubInfo { UserID UserName Password SubName Contact_First_Name Contact_Lasst_Name Email } Email { Record UserID JobNumber EmailNote } JobInfo { JobNumber JobKey JobName...

Below is a query that I am using with an Access DB over ODBC: SELECT SubInfo.UserID, SubInfo.SubName, SubInfo.Email, SubInfo.UserName, JobInfo.JobName FROM SubInfo, Email, JobInfo WHERE (Email.UserID = SubInfo.UserID) AND (Email.JobNumber =#JobNumber#) AND (JobInfo.JobNumber...

My company has asked to me set up a site using ColdFusion, and I've heard tons of bad things about using Access for a production environment. I was going to try to use MySql since it's (almost) free, but didn't want to run it on a Linux box. Does anyone here have any recommendations for SQL...

I'm using Access, and because access doesn't support the &quot;Minus&quot; operation, I need to run the following query: <CFQUERY NAME=&quot;non_Email_Query_admin_emaillist&quot; DATASOURCE=#DataSource# SELECT SubInfo.UserID, Email.UserID, SubInfo.UserName, SubInfo.SubName, SubInfo.Email FROM...

I have a variable, #form.AddUserID#, that is passed into the page in a list format, sepearted by a comma. The list length is variable(guessing i need to use #ListLen()# at some point). From what I've read in the forums, a <cfloop> is what I need to use, but I'm a little confused on the...