Database

Member 9467982 wrote: Could anyone help me with a PHP or ASP.Net code There's tutorials on the NET that show how to fetch data from a database. Also on sending emails with attachments. What part do you need help with? Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] They hate us for our freedom![^]

As Eddy said, you really should ask a question you want answered rather than state a problem. Try looking into string concatenation, you are going to have to CAST or CONVERT the datetime and int into varchar values and concatenate them! Never underestimate the power of human stupidity RAH

EricCiz wrote: I'm not really thrilled with either option. I don't know any others besides these, do you? The second option "sounds" like a simple one; just program against the latest interface and update all the components on the client-computers. The first option "is" the simple one; create a version-agnostic wrapper, and two version-specific implementations (as small as possible). Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] They hate us for our freedom![^]

It might be helpfull if you divide this script into several simpeler stored procedures. Complex tasks are always easier when broken into smaller pieces. Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] They hate us for our freedom![^]

Don't crosspost, choose one forum and stick to it. One of these days I'm going to think of a really clever signature.

thank you so much J4amieC, it worked for me,

Opening balance of current year is the closing balance of the previous year, and closing balance of the current year would be opening balance of the next year. If this is clear for you then you can calculate from your data. Let me know if you still having some issue. Thanks -Amit Gajjar (MinterProject)

Coming from MS SQL Server I do not mix databases in backups, however I do use zip technology to gang together backup files. I have used WinRAR and 7Zip

Hey i just used the trunc method for oracle, u can replace to yr old year and month method to get the result, but the concept is that we will use the union clause to get the data for those month for which we dont have the data than we will do a union with yr old query then on the top of that put a sum for monthcount with group by month and year. so yr query will be select years, month, sum(MonthCount) from ( SELECT YEAR(RequestedDate) as Years, Month(RequestedDate) as MonthInNumbers,Count(Month(RequestedDate)) FROM MYTABLE group by YEAR(RequestedDate),Month(RequestedDate) union select '2012' as years, 'JAN' as Month, 0 as MonthCount from dual union select '2012' as years, 'FEB' as Month, 0 as MonthCount from dual union select '2012' as years, 'MAR' as Month, 0 as MonthCount from dual union select '2012' as years, 'APR' as Month, 0 as MonthCount from dual union select '2012' as years, 'MAY' as Month, 0 as MonthCount from dual union select '2012' as years, 'JUN' as Month, 0 as MonthCount from dual union select '2012' as years, 'JULY' as Month, 0 as MonthCount from dual union select '2012' as years, 'AUG' as Month, 0 as MonthCount from dual union select '2012' as years, 'SEPT' as Month, 0 as MonthCount from dual union select '2012' as years, 'OCT' as Month, 0 as MonthCount from dual union select '2012' as years, 'NOV' as Month, 0 as MonthCount from dual union select '2012' as years, 'DEC' as Month, 0 as MonthCount from dual ) group by years, month

You are expecting too much of this site. Do some research with Google and look at the Java Tutorials[^] for the information you seek. Also, in future please use the correct forum. One of these days I'm going to think of a really clever signature.

berba wrote: It's just when exporting to excel the customer is getting an error Which means it is the WRONG tool for the job. The tool has a limitation, as pointed out by David and djj. Never underestimate the power of human stupidity RAH

Investigate wether you have a system restore point prior to the installation of the driver! Never underestimate the power of human stupidity RAH

It does indeed ! :D Thank you ;) Fratelli

Your description isn't clear enough, so here's a design that could be used for some interpretations of what you wrote. 0) There are several sites. 1) A check list has several check list items. 2) Each site has a check list with a subset of all available check list items. 3) Each check list item may be on several sites' check lists. This is a classic many-to-many relationship and the typical implementation is to have (at least) three tables: Site: ID, Name, etc. Item: ID, Name, etc. SiteList: SiteID, ItemID (usually no other data here, but maybe in some cases) Another schema would allow for defining lists and assigning them to sites: Site: ID, Name, etc. Item: ID, Name, etc. List: ID, Name, etc. ListItem: ListID, ItemID (usually no other data here, but maybe in some cases) SiteList: SiteID, ListID (usually no other data here, but maybe in some cases) This second way may be approriate for your needs, you can define a common list and custom lists and assign multiple lists to the sites. Getting a complete list of all items for a site is simple as well.

Hi, Mycroft Holmes Thank for reply. You means the data can not using Query (MySQL) but use PHP. Okay I move this forum to Web development. But how to move this topic to Web Development? Thanks

AnirbanM 2 wrote: Please suggest where is the problem, thanks to all in advance. Some posssible reasons. - The problem originates from some other place in the code. So nothing to do with the code that you posted. And one very obvious possibility is that there is code somewhere that is sorting based on alphabetic ("10", "11" versus "1", "2) instead of using the sort that you gave. - You are not looking at the actual data. - You are not running the code that you think you are.

Plz try this... http://stackoverflow.com/questions/5095533/storing-a-book-using-sql-server

Thanks. It works :)

thanks by the way. it seems I'd hardly find one.

As we are not telepathic we cannot help you without knowing what the error is. Try giving us some detail on the error message you are getting! The instance name is the name you gave the server when installing OR then name/IP of the server you installed it on. Never underestimate the power of human stupidity RAH