Search results for query: *

I think I just had my functions called in the wrong order. Sorry to waste your time!

My batch file: cd c:\photos start /wait ftp -i -s:c:\ftp\upload.ftp del /Q *.* Is this what you mean?

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

I tried using this query: SELECT user.usrID, user.ctGiven, user.ctSurname, user.coName FROM user left outer join permissions on (user.usrID = permissions.usrID and permissions.jobNumber = #attributes.jobNumber#) WHERE permissions.usrID is null AND user.permissions =...

Thanks for the reply. I get the following error message (I assumed you meant "outer join" rather than "outher join"): TCX][MyODBC]You have an error in your SQL syntax near 'outer join permissions on (user.usrID = permissions.usrID and permissions.jobNum' at line 5 Any...

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

I would prefer to not web share the directory containing the PDF's for security reasons.

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 have read about <CF_FORMURL2ATTRIBUTES> because all I can find is documentation about FB2/FB1. I understand what you're talking about, and think I have it now. I have this form: <cfoutput> <FORM NAME=&quot;selectUser&quot; ACTION =&quot;#self#fuseaction=#XFA.submitForm#&quot; METHOD=POST >...

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

Thank you so much for your posts! They have helped me tremendously!

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

Just to let you guys know - WWebSpider is awesome! Here's the SQL I ended using. Select SubInfo.UserID, SubInfo.SubName, SubInfo.Email, SubInfo.UserName FROM SubInfo WHERE SubInfo.UserID NOT IN( SELECT SubInfo.UserID FROM SubInfo INNER JOIN Email on SubInfo.UserID = Email.UserID WHERE...

Okay - hope you're still looking at this thread. I had trouble with the ANSI Join syntax that you provided. &quot;Syntax error (missing operator) in query expression 'SubInfo.UserID = Email.UserID INNER JOIN JobInfo ON Email.JobNumber = JobInfo.JobNumber'&quot; The second query that you...

I'm using Access via ODBC for all my queries. This is my query that shows me who the userid's are that are receiving mail for the specific #jobnumber#: SELECT SubInfo.UserID, SubInfo.SubName, SubInfo.Email, SubInfo.UserName, JobInfo.JobName FROM SubInfo, Email, JobInfo WHERE...

How exactly do you mean, define that relationship?