This is what I currently have and it is not working. What might I be missing or am I overlooking something altogether?
Thanks,
Katie
#!/afs/isis.unc.edu/pkg/perl-582/bin/perl
use Spreadsheet::Wr iteExcel::FromD B;
use Spreadsheet::Wr iteExcel::FromD B::Query;
my $dbh = DBI->connect("dbi:O racle:oracle.un c.edu",'usernam e','password',
{ RaiseError =>...
newtechiebug
Last Activity: Apr 11 '07, 07:17 PM
Joined: Mar 8 '07
Location:
-
Whatever is the easiest way to accomplish this task is what I'm interested in.
I have a table conferences and in this table I have 4 columns (1,2,3,4) that I want to write to a csv, xls, tab delimited. What I'm hoping to happen is for a person to click on a link that says "Click here for data" and when they click a file is created which they can then view in Excel. I understand that .NET would be so much easier unfortunately...Leave a comment:
-
Writing from an Oracle Database to an Excel File.
I am really new with Perl and I am trying to write data from an Oracle database to an Excel Spreadsheet simply by clicking on a link. I have read over CPAN Spreadsheet::Wr iteExcel and I really am not sure where to even begin. Do I have to write a .pl page for this Write Excel or can I write to an Excel file from an ASPX or ASP page? Also will it be one page that I create or multiple pages?
I'm assuming this task shouldn't be too difficult,... -
After some more effort, I was able to get this working:
Count(case
when [elphoursflag]=0 Or [elphoursflag]=2 then
case
when [envelopes].isitecode=[logsheets].isitecode then
case
when [recdate] Between DateAdd([d],7,[dFirstPSYDate]) And (DateAdd([d],13,[dFirstPSYDate])) then
[zip]
end
end
end) AS wk2count,
Round(Avg(case...Leave a comment:
-
Creating "Cross Tab tables in SQL?
I know that Transform and Pivot are not recognized commands in SQL and I have looked everywhere on how to covert the below query to run properly in SQL, but I can't seem to find the answer.
If someone could help, that would be awesome.
Thanks!
TRANSFORM Count(ConfirmOr iginRecords.PHN um) AS [The Value]
SELECT ConfirmOriginRe cords.SendZip, Count(ConfirmOr iginRecords.PHN um) AS [Total Of PHNum]
FROM ConfirmOriginRe cords... -
newtechiebug started a topic I am trying to convert a MS Access Query to a SQL query and I need help?in SQL ServerI am trying to convert a MS Access Query to a SQL query and I need help?
I am trying to convert a MS Access Query to a SQL query and I need help with some IIF Statements?
2 in particular that I've encountered problems with are:
Count(IIf([elphoursflag]=0 Or [elphoursflag]=2,IIf([envelopes].isitecode=[logsheets].isitecode,IIf([recdate] Between DateAdd([d],7,[dFirstPSYDate]) And (DateAdd([d],13,[dFirstPSYDate])),[zip]))))'AS wk2count,
AND
Format(Avg(IIf([elphoursflag]=0...
No activity results to display
Leave a comment: