Dear buddies!
Right now I am generating a report with some details for all the dealers.
I am required to separate the report for each dealer respectively in separate reports. I tried this method and its not of help.
Please advice.
procedure convert_excel
IS
dealer_name varchar2(100);
begin
-- Test statements here
for dealer_name in (select dealer_long_name from tbl_dealers) loop
print_report(
'select dealer_region as "Dealer Region",
dealer_long_name as "Dealer Name",
"# of Received" as "#of Customer Received",
"#of Converted",
"%of Conversion" ,
from dealer_performance t
where dealer_name = t.dealer_long_name',
'dealer_performance||dealer_name||.xml','Y');
end loop;
I didn't receive any compilation error. Compilation is successful.
I received an error when I was executing.
ORA-00904: "DEALER_NAME": invalid identifier
Please advice, where I am making the mistake.
Thanks.
problem with GROUP BY and ORDER BY
i usually use this query to display the last 10 entries from a sql table:Code: $query = "SELECT search_time, search_keywords FROM phpbb_popsearch ORDER BY search_time DESC limit 35"; as you
Shuffle Array
Hi,I am writing a script for a game that needs players to randomly be assigned a target (another player) in a loop so that each player is matched with someone other than who has them. See below:Andy
Help =( !! Upload Pics [PHP script]
HelloI need help with a php script [MULTIPLE UPLOAD IMAGES] , where I want to add a feature (watermark the uploaded pictures) , thats mean its watermark & upload in the same time . look this
Blogging s/w
heya frndz!!! i want to start a blog.... m looking for a s/w like oscommerce which is thr for e-comm websites... so can u please suggest me some s/w through which i can set up the blog... thnx in
Function
How can I make this function that once you click the link in the code it takes you to a new page without html but so the menu_name and content load in it.Code: function public_navigation($sel_subject
Not reloading page after php form submit
Hello helpful souls out there. You guys have come through for me in the recent past and I'm hoping someone out there can either help me or point me in the right direction.I have the following site,
DirectoryIterator and Hacked Website
Hi Everyone.My problem:Some one has been sneaking in to my website hidden Iframes. I've changed passwords & reset permissions to read, but then the permissions get changed to include write and
Required to login help
I'm trying to set up my site so users have to be logged into the forum to access the site.I've been working with this bit of codeCode: [Select]<?phpwriteLog();if
ereg_replace issue
hi there peoplei have this code happening with regards to my wamp server. is this something that can be sorted out? would this happen on a normal remote server that has lamp on with the necessary
do while conditions
i want to display 6 images in a 2x3 tablenow what would be the correct logic tocount that there are 6 images resultsand if there are more than 6 images loop and echo the rest but not in the tablebut
