Posts
 
Reputation
Joined
Last Seen
0 Reputation Points
Unknown Quality Score

No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.

0 Endorsements
~10.8K People Reached
Favorite Tags

10 Posted Topics

Member Avatar for agrarian

I have a project where I need to retrieve data from MS SQL Server and format it into an Excel Spreadsheet. I am using the OfficePartner component to try and make this easier, but I'm having a hard time figuring out how to get the VB help and Excel Object …

Member Avatar for Wolfgan
0
903
Member Avatar for agrarian

Any could give me a PHP script on how to call or execute a MS SQL Server stored procedure, passing parameters to it and receiving a value from it using an Output parameter?

Member Avatar for 99developer
0
4K
Member Avatar for agrarian

I need to create 14 javascript Ajax objects and assign properties and events to them. Since most of the code is just being repeated, I'd like to do the whole thing in a loop using an array for the object names. This is a portion of the code as it …

Member Avatar for Airshow
0
161
Member Avatar for agrarian

I am creating a Delphi program that needs to extract data from our database and create an Excel report. I would prefer to use the Delphi components TExcelApplication, TExcelWorkbook and TExcelWorksheet, but I haven't been able to get them to work. Most of the examples I have found are fairly …

Member Avatar for Wolfgan
0
2K
Member Avatar for agrarian

How do I retrieve data from MSSQL Server using Javascript? I am used to doing things in PHP, but I want to have an interactive form which is able to display Sales Tax after user types in his zip code. My query is similar to: "select top z.rate from zipcodes …

Member Avatar for agrarian
0
121
Member Avatar for agrarian

I have a form (Delphi 2010) that includes several data controls, including a DBImage. All these are hooked to a underlying MSSQL 2005 database and table. I'm using ADOConnection and ADO Table for ease of use. I need to include image data in this table, so I have set up …

Member Avatar for yousef.h85
0
216
Member Avatar for agrarian

I have some code in PHP which I need to translate into Delphi: [CODE]$xsl = new DOMDocument(); $xsl->load('http://www.fda.gov/oc/datacouncil/stylesheets/spl/spl.xsl'); $proc = new XSLTProcessor(); $proc->importStylesheet($xsl); $xml = new DOMDocument(); $xml->load($xmlFile); $domTranObj = $proc->transformToDoc($xml); $strHTML = $domTranObj->saveHTML();[/CODE] What I need to do is take a snippet of XML (from a database field), transform …

Member Avatar for agrarian
0
166
Member Avatar for praveen_dusari

Can you explain better what it is you are trying to do, what result you expect and what result you are getting? Do you want to know how to calculate next month and next year as your subject implies, or is your question about writing reports?

Member Avatar for praveen_dusari
0
149
Member Avatar for mmrhl

What you need to do is convert your string time back into MSSQL Date time before sending it back into the database. I would use the following: CONVERT(DATETIME, '2009-01-31 22:10:00', 102))

Member Avatar for agrarian
0
177
Member Avatar for agrarian

I am trying to use a Dojo (ajax) table on my page that has detail rows in which I want to draw detail tables. The tables have a format event which calls formatDetail. In this event I would like to build a simple table using JSON data. My problem is …

Member Avatar for agrarian
0
2K

The End.