Recent content by jorbroni

How to I call this method?

I am new to programming in ruby. I was trying to write a method that will display my query results on screen in the format that I want it in. below is my script: #!/usr/bin/ruby def getbatch( batchno ) sql = " SELECT * FROM feecalc.payments WHERE batchnumber = '#{batchno}'"...

Thanks!

Hello I'm a Linux user and I written a script in Emacs Text Editor. I was wondering if there was a way that I can have MySql read my script by the file name instead of copying and pasting the script in Mysql. Reggie

Our company just recently switch over all pc to Linux. Our accounting department has alot of reports written for crystal report. The problem is crystal report is not compatable with Linux. Can Anyone suggest a reporting system similar to crystal report that will run on Linux? Thanks Reggie

Actually, I am looking for the last 5 payments for each client.

Sorry About the lack of detail. The table I am using consist of the Client code, Payment Date, Amount of each payment. Thank you

Hi I am trying to write a query that will give me the last 5 payments for each of our clients. Can anyone give me some ideas on how to write this query? Thank you Reggie

Hello when trying to print a spreadsheet out in excel, I notice that printout does not have any data on it. However, it does print out the format of the spreadsheet (color shading etc.)The only thing missing from the printed document are the actual numbers and words. I look at print preview and...

I have two types of transactions, one are "a" type transactions and the others are "A" type transactions. The "a" type transactions are the ones I want to select but I dont know how to select by case. Can anyone help me?

Hi Can anyone tell me how do I generate a list of the stored procedures in a database? Thanks

Hello I have windows 98 and when I am on the the internet, I notice that pictures are not showing on some sites while other sites are showing just fine. I've check the accessibility in internet options to make sure that nothing was selected under formatting and I am still lost. Reggie

Hello I have written a script that will give me the sum amount of sales per day. Howevever, I need the summary group by date "dd/mm/yyyy". When I put the group by statment in my script and ran the query, it still gave me the individual transactions. The problem is in the date. The...

Hi I just installed a new burner in my computer. I downloaded the software and I was ready to go. However, when the systems start scanning the burner's connections, it freezes my computer. Is this due to lack of memory?

I am trying to figure out how to have a form that I created to open up in full screen automatically when I open my access file. Can anyone help me. Reggie