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!
-
Vbscript calling Batch file with FTP Commands
I think I just had my functions called in the wrong order. Sorry to waste your time! -
Vbscript calling Batch file with FTP Commands
My batch file: cd c:\photos start /wait ftp -i -s:c:\ftp\upload.ftp del /Q *.* Is this what you mean? -
Vbscript calling Batch file with FTP Commands
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... -
Vsftpd - Netout: Connection Reset by Peer
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?- ryanrat
- Thread
- Replies: 0
- Forum: Linux (server)
-
Inner and Outer Join Combo
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... -
Actuate 6 - question on dynamic text
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...- ryanrat
- Thread
- Replies: 1
- Forum: Actuate Reporting Solutions
-
Help w/ a query
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 =... -
Help w/ a query
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... -
Help w/ a query
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... -
Help with a query
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... -
Fusebox 3 and <cfcontent>
I would prefer to not web share the directory containing the PDF's for security reasons. -
Fusebox 3 and <cfcontent>
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? -
#Attributes#, FB3, and CF
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="selectUser" ACTION ="#self#fuseaction=#XFA.submitForm#" METHOD=POST >... -
#Attributes#, FB3, and CF
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... -
Dreaded Access...
Thank you so much for your posts! They have helped me tremendously! -
Dreaded Access...
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... -
SQL Question
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... -
Help with SQL Query
Okay - hope you're still looking at this thread. I had trouble with the ANSI Join syntax that you provided. "Syntax error (missing operator) in query expression 'SubInfo.UserID = Email.UserID INNER JOIN JobInfo ON Email.JobNumber = JobInfo.JobNumber'" The second query that you... -
Help with SQL Query
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... -
Help with SQL Query
How exactly do you mean, define that relationship?
