[Q] Help With Running DB Queries and Emailing Results - Off-topic

Hi all!
I know this is probably way off topic and this forum might not even be the best place to ask but before I venture to unknown forums I wanted to start at home! I'm not sure if SQL is best to perform the task at hand or maybe a batch or Python script to run the SQL. Just looking for your thoughts and any ideas are much appreciated! Below is what I'm looking to do. Let me know if you need additional info to get me the best response!
We have an existing Database that is continuously being updated. What I need to do is run a Query, daily, and email the results to a particular email address. Each day I want the script to grab only the top 15 results. It would need to sorted by Due Date. We have a column for Completed but it doesn't need to show in the report but I would imagine that I need it in the query so the results can be updated each day. Out of all the columns in the DB I only need to Query about 6 and display in the results all 6 besides the Completed column.
If possible, I'd like the email to include the results in HTML format rather than an attachment. Thanks in advance for you help all!

Related

(Oct-20) Little App: FuelCal v0.1.1

Hi everybody,
I wanted to learn some (basic) programming in VC# and the .Net Framework. So i looked for an idea. After a short time i had this idea, to create a program, in which you can keep track of your Fuel consumption of your car. (i think it is kind of useful, because the prices are changing every day).
I thought i'd share it here.. maybe someone is looking for a piece of software like this.. if not, just ignore it
you can test it, use it etc (whatever you want)..
Currently, there are two languages: German and English, but i dont love my English translation...
News:
v0.1.1 is now online:
I fixed the bug but another problem appeared: people who upgrade to the new version will lose all their data stored in data.xml with the uninstaller...
So i decided to create a simple Backup-Restore Function. Now, with the new version, you can Backup your Data before Upgrading and after that, you can restore it... If you use the Backup - the files will remain in your memory, until you delete them..
This is not the best way to solve the problem, because these files will stay on Memory even if the user uninstalls the program...
I read, that there is a way to costumize the setup process with a custom "Setup.dll" but i could not figure out how this works.. if anyone knows how to do this, please PM me..
Changelog:
v0.1.1 - 10/20/2008
fixed: storing units did not work
added: simple backup-function
added: simple restore-function
v0.1 - 10/19/2008
inital release
Beware: I will not guarantee for damage on your devices
If you have Bugs, ideas for new features or other feedback - let me know ..
This is a cool little program, would help a lot of people who have to teavel to work, etc..
I wish i had this when i was having some mileage problems with my car.
FuelCal
It looks good. I will give it a try.
Don't worry about your English, you can program!!!
Have a great day.
Glenn
FuelCal
Now for some more fun programming.
The store function is not storing the updated info.
It would be very useful for me if it would also calculate Mile/Gallon
Thanks.
Glenn
thanks for the feedback...
well i did not test the "Store" Feature for the Units ... bad in this case...
is will release a fixed version soon, stay tuned...
have a nice day
Just what i was looking for.
Thank you very much.
A bug
Hi. Excellent idea. You should check that on "Evaluation" the "price per Km" should be divided by 100 because it is done in cents but the unit says, when you change it, $/Km and not $cents/Km
Thanks.
Suggestion
Nice idea g3eB4Y. I will try the app.
This is something that could grow into a larger application if you want to track vehicle maintenance too. Also, I think that it would be helpful if you could simply enter the odometer reading and fuel quantity and allow the program to calculate distance.
First of all, thank you for your feedback...
maxzr said:
Hi. Excellent idea. You should check that on "Evaluation" the "price per Km" should be divided by 100 because it is done in cents but the unit says, when you change it, $/Km and not $cents/Km
Thanks.
Click to expand...
Click to collapse
I think there is nothing really wrong with the calculation.
When you change something on the settings page, you will only change the mask, but it will not affect the calculation..
The first Textbox under "Currency" will change the display for the "big-currency-unit" (€,$...) and the other textbox will change the "small-currency-unit" ($Cent, €Cent.. )
I can include a feature, that you really can change the calculation and display mode (€/km, €Cent/km, €Cent/20km ...) but at this moment, it does not
artyjeep said:
Nice idea g3eB4Y. I will try the app.
This is something that could grow into a larger application if you want to track vehicle maintenance too. Also, I think that it would be helpful if you could simply enter the odometer reading and fuel quantity and allow the program to calculate distance.
Click to expand...
Click to collapse
i have some idea for new features, i will try do implement them in one of the next versions, stay tuned...
its great to see, that somebody uses it... thank you!
g3eB4Y,
Very nice app you have. I've been using a excel spreadsheet to do this and now, I'm moving over to your app.
I wonder if you could add in another method of calculating the fuel consumption.
Distance travelled / No. of Litres = km/litre
Hope you can add that in to your next update.
Thanks once again.
PS:
No big deal but if you could name your cab file with the version number, it would be great!

how to manage notes

hello everybody,
its my first post and i'm trying to get help about manging notes. i've looked in other forums, used seach here, and i couln't find what any answer suitable.
the thing is that i use notes for my work a lot, but after a while i get stuck with lots of them that may be useful in the future but not right now. so i woukd like to know if there is a way (software) that would let store them by topic or any other form. i've read that we can't even read them in vista (pwi files).
the note option is great, after acaal you make one and it stores the contact and tima, but afterward you can only store them together.
thank you for your help.
filipe
If you have a full MS Offiice installation, check out OneNote. It will let you catagorize and sort to your hearts content. I am using Evernote, which I like it beacuse it is very searchable. You can even search for text in an uploaded image. If you are talking about the call notes, you might want to invest in a CRM program such as ACT.
I hope this helps

[Request]Simple SMS Insert (o2delivery)

Been reading these forums for a year or 2, thought I had an account but I guess I always used bugmenot to download.
I was wondering if either someone could point me in the right direction to create something myself (I have a basic knowlege in programming)
Or could come up with some kind of app or tweak so that every new sms that's create starts with *0# (this causes a delivery report for the o2 network)
I know this might seem very lazy but I was just wondering if it would be possible.
Thanks,
Tobin

[Q]Android Small Application Help

[Q]Android small application help
Im trying to make an application for my business. I currently have reports that i do wanted to start to get them done through my tablet rather than on paper. I have a full report template but was wondering how i would do this through let's say an android tablet. I usually circle things on the report that apply to the business i'm inspection and write small notes. I also wanted to be able to add pictures with let's say a foot note and then have them at the back of the report. If anyone could give me some advice or on my e-mail it would be greatly appreciated. [email protected]

Android Studio coding help needed

Hi, firstly I just wanna say I'm completely new to android studio & coding. I recently began building my first app & feel like my head is gonna explode
I've tried searching online for an answer to my question but couldn't find anything related, so I thought I'd post it here and see if any of you guys could help me out.
So I spent all of last night trying to create a splash screen and login page for my app, which I still haven't completed but thought I'd get ahead of myself and prepare for the next steps and potential issues I could encounter.
I want to create a circle image next to people's names which they can click and change with a different image (not on their phones device but within the app) just a simple image such as the letter from A-Z which are different colours. I have no idea how to do this or if it is even possible? Sorry if I am not explaining myself clearly but any help or advice would be much appreciated.
Thanks in advance
Spyro0408 said:
Hi, firstly I just wanna say I'm completely new to android studio & coding. I recently began building my first app & feel like my head is gonna explode
I've tried searching online for an answer to my question but couldn't find anything related, so I thought I'd post it here and see if any of you guys could help me out.
So I spent all of last night trying to create a splash screen and login page for my app, which I still haven't completed but thought I'd get ahead of myself and prepare for the next steps and potential issues I could encounter.
I want to create a circle image next to people's names which they can click and change with a different image (not on their phones device but within the app) just a simple image such as the letter from A-Z which are different colours. I have no idea how to do this or if it is even possible? Sorry if I am not explaining myself clearly but any help or advice would be much appreciated.
Thanks in advance
Click to expand...
Click to collapse
best resource for googling all coding questions is stackoverflow.com
i.e., related to your posting: google for "android click image change background resource stackoverflow"

Categories

Resources