Here's what ya need to do: 1) Give a direct path to your file D:\Program Files\Microsoft SQL Server\80\Tools\Binn\cust.sql
2) Wrap your infile with quotes: "D:\Program Files\Microsoft SQL Server\80\Tools\Binn\cust.sql" 3) Be sure to specify what database you are querying in "cust.sql": SELECT * FROM DATABASE..TABLENAME OSQL defaults to the local server, however it can be used to make remote server calls (run OSQL with '?' and it will list the available args). So if you wanted to, you could pass the server and database, or just the ODBC DSN as args in the command line. END RESULT: <cfexecute name="D:\Program Files\Microsoft SQL Server\80\Tools\Binn\osql.exe" arguments="-Usa -Pwindows95 -i "" D:\Program Files\Microsoft SQL Server\80\Tools\Binn\cust.sql""" timeout="10" /> NOTE that I am using double quotes inline to escape them and pass it to the command line. You can also pass a straight query to OSQL: C:>osql -Usa -P -Q "SELECT * FROM DATABASE..TABLENAME" Hope this helps! -----Original Message----- From: Kola Oyedeji [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 23, 2002 3:08 AM To: CF-Talk Subject: Using cfexecute to call SQL server fron the command line Hi I am trying to use cfexecute to call SQL server from the command line. The following command works on the command line it executes the query script and displays the results of the query however when i call it using cfexecute it returns a list of parameters as if the parameters being sent are wrong. I'm wondering if cf is changing the case of the parameters as the parameters are case sensitive. Is there anyway to see what was passed to cfexecute? <cfexecute name="D:\Program Files\Microsoft SQL Server\80\Tools\Binn\osql.exe" arguments="-Usa -Pwindows95 -i cust.sql" timeout="10" /> contents of cust.sql : select * from customers i placed cust.sql in the same directory as osql and the template so i dont think thats the problems thanks kola ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists