Hi i tried your suggestions:
I still get the same ouotput. THe outout I get is the same output I get if I run it at the command line with no arguements. I added the USE <database> to the file but still get the same problem. Thanks > >-----Original Message----- > >From: Scott Van Vliet [mailto:[EMAIL PROTECTED]] > >Sent: 23 March 2002 11:54 > >To: CF-Talk > >Subject: RE: Using cfexecute to call SQL server fron the command line > > > > > >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 > > > > > > > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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
