Recent content by dps

SantaMusa - YOU'e a Genius!! I could not get any clear direction at all via GOOGLE; with people giving all sorts of remedies. By jo it's done it!!!

Can someone help in alleviating this problem?

Thanks for the response. I would just double click the file I suppose you can open with Excel and ensure the option for comma delimited is on. Do you mean SELECT c.PRD_CODE||',"'||AS "PRODUCT", c.CAM_NUM||',"'||AS "CAMP" FROM cantain c WHERE c.sls_grp_code = 'FX' ORDER BY...

If I place a spool c:\msql.csv spool off spool c:\next sql.csv ..ie after each script then at least I get a .csv file produced but cannot open it - unable to read file!

I get no .csv file when I know I should One of the queries is SELECT c.PRD_CODE AS "PRODUCT" FROM cantain c WHERE c.sls_grp_code = 'FX' ORDER BY c.sls_grp_code I have even tried spooloing off after each script

Hello. I have about 12 different sql queries currently in one sql file. Currently I have to manually run these scripts (using Navigator) one by one. If anything is retrieved then I save the reults as a .csv file. If nothing is retireved then I move onto the next script. Question is how...

The thing is My resultant spooled output from running the file containing the separate sql statements is not showing any headings for the values returned, i.e empid, ename....

I am currently trying to spool off the results of multiple sql statements(select empid from emp where deptno = 20 select ename from emp where deptno = 25, etc) contained within a file. Running this for the moment via command line in sqlplus. Not all my statements will return results and a 'nice...

Thanks very much!

Thanks for that. If I enter CPAN at DOS prompt it prompts for manual or automatic install - which is advisable?

Thanks for the info Paul TEG; I did mention that in my httpd.conf I had enabled my ScriptAlias /cgi-bin/ "D:/Program Files/Apache Group/Apache2/cgi-bin/" The way I got it to work is as follows: Closed my bowser from where I previously left off Placed an extra line in the hello.pl - print...

I have sorted it!!!!!!!!!!

Brian my path already has D:\Program Files\Apache Group\Apache2\cgi-bin

In the hello.pl I have #!D:\usr\Perl\bin Still when this is run I get following in error log Tue Oct 12 18:42:13 2004] [error] [client 127.0.0.1] (OS 3)The system cannot find the path specified. : couldn't spawn child process: D:/Program Files/Apache Group/Apache2/cgi-bin/hello.pl and also...

Thanks for that oversight Brian atwork with that I get a resulting Internal Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator, dps@ntlworld.com and inform them of the time the error...