473,396 Members | 1,714 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

Automating exports of some files

[8.2.1 on LUW, Suse 9]

I've got various affiliates that want to be emailed a report on a
weekly basis.

Could I write a stored procedure that took two parameters: the
affiliate's id, and a filename, and then used EXPORT to create a file
with the specified filename, using a query that used the affiliate's id
to get the right bookings?

I know I could just write a lot of sql and cron it up to dump out a
file for each affiliate in turn, but (a) I'm lazy and (b) if we could
do it using a stored procedure, then I can probably let my marketing
people do it instead of me, so they can add more affiliates as and when
they need to.

Thoughts? I'm wondering to myself if this is just a case of treating
everything like a nail because all I've got is a hammer...

Nov 12 '05 #1
0 951

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Michael Chiu | last post by:
Does anyone know of a PHP based CMS that exports its pages into static html? Exporting into PHP files would be fine too. Actually, if you know of a CMS that can create directories for new areas...
7
by: Limey Drink | last post by:
Hi all, Firstly :-) , is there any where I can search through archived newsgroup posts so I am not cluttering up the newsgroup with repeated queries ? And secondly :-), I know this has...
6
by: Charles Banas | last post by:
weird subject - i hope more than just one curious regular will hear me out. :) ok, i've got a bit of a big problem, and i need answers as soon as possible. i know this forum is meant for web...
7
by: xzzy | last post by:
I need to automate a report in a different database (and thank yous to Terry Kreft for pointing me in the right direction). below is the code with the one line that does not work, marked: 'Does...
3
by: Smithers | last post by:
I have been manually creating navigation/menu buttons (.gif files) using Fireworks. The buttons typically have some text in them. There are typically three versions of each button - one for...
0
by: rcoutts | last post by:
I have a custom Access database that is a bulk mailing program for my small business to send emails to my customers (not spam!). Before sending mail, I export a folder in Outlook to an Access MDB...
5
by: Arno R | last post by:
Hi all, I need to get at specific (shared) agenda-data from MS outlook 2003. I need every day to get the scheduled 'appointments' for some rooms to Access. In Access I will show the...
2
by: Dave | last post by:
I have to download files every day from a web based application and it's getting very repetitious. I would like to find a way to automate the task. What I have to do each day is go to a website...
13
by: Bartc | last post by:
I noticed that in C, functions in any module are automatically exported. So that it's not possible to use the same function name in two modules (ie. source files). Now that I know that, I get...
11
by: KingKen | last post by:
Database A is distributed across 21 different agencies in a wide geographic area. They all use Access 2007 to run the database. Head office has a copy of database A and would like to have it store...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.