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.4K People Reached
Favorite Tags
Member Avatar for Magic8Computing

I have some crystal reports that i would like to use PHP in order to execute the reports and then either view the reports in the browser as is or to generate PDF files. Does anybody know how to do this and what is required to be installed on the …

Member Avatar for rproffitt
0
809
Member Avatar for Magic8Computing

I have a table in and MSSQL DB that list period and week start dates for any date in a financial year but the page is only display the week numbers and period number none of the dates does any body have any ideas please. <?php $serverName = 'DESKTOP-R7RU80H\SQLEXPRESS'; $connectionInfo=array('Database'=>'WebPortal', …

Member Avatar for Dani
0
442
Member Avatar for Magic8Computing

Does anybody know how i can connect a PHP web site to an OpenEdge Progress Database. I have the following as a connection file that when I run it does not error but there is also nothing to say it has connected either. I have System DSN 32bit ODBC connection …

Member Avatar for rproffitt
0
228
Member Avatar for Magic8Computing

A long shot I know but a colleague has left, leaving behind a couple of access databases that query each other and a sql database, unfortunately one of the databases querys now takes a long time to run to the point that the excel report calling the query timeouts. is …

Member Avatar for rproffitt
0
383
Member Avatar for Magic8Computing

The following code is erroring on the connection string line 5 it used to work but then i had to move the sql server to another box and now it fails have i forgotten to do something on the sql server or is there error in my code my error …

0
234
Member Avatar for Magic8Computing

I have a couple of SQL databases that i am trying to link results from. My first database is calendar that i need to return the details for today so current date and targets for sales and orders that works my second data base is for orders which i can …

0
272
Member Avatar for Magic8Computing

I have two values in my code one is from a SQL Server query echo to the screen as formattedNum10d my second value is stored in a MySQL database and echo to the screen as formattedNum10f. In a seperate column i would like to subtract foramattedNum10f from formattedNum10d and echo …

0
160
Member Avatar for Magic8Computing

I have an If Statement that isnt loading the right image any help would be great <?php if($formattedNum6 > $PeriodSalesTarget):{ echo '<img src="images/TargetMetGreen.png" alt="" />';} elseif($formattedNum6 > $CummulativePeriodSalesTarget):{ echo '<img src="images/TargetMet.png" alt="" />';} else:{ echo '<img src="images/TargetNotMet.png" alt="" />';} endif; ?> $formattedNum6 = 515,839 $PeriodSalesTarget = 1,366,000 $CummulativePeriodSalesTarget = 503,600 …

Member Avatar for Anil_17
0
456
Member Avatar for Magic8Computing

How do i formatt the dates do the come out as DD/MM/YYYY please <?php $convar = mysqli_connect("localhost","root","","ffp_calendar"); if(mysqli_connect_errno()) { echo "Error occured while connecting with the database ".mysqli_connect_errno(); } $sqlvar = "SELECT * FROM `calendar` WHERE `CurrentDate` = curdate()"; $resultvar = mysqli_query($convar, $sqlvar) or die("Bad Query: $sql"); while($rowvar = mysqli_fetch_assoc($resultvar)) …

Member Avatar for benanamen
0
308
Member Avatar for Magic8Computing

How do i format my Query result so it has thousand seperator and only to 2 decimal places <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Daily Sales</title> <link rel="stylesheet" href="../styles/login.css" media="all" /> </head> <body class="normal"> <?php include("../includes/x3connect.php"); ?> <?php $sql="SELECT SUM …

Member Avatar for rproffitt
0
464
Member Avatar for Magic8Computing

Hi I have the following code that i can run in MSSQL Query and the result are returned correctly but when i try to run it in PHP it errors what do I need to change to get it to work please. SELECT SUM (CASE WHEN FFP.BPARTNER.CUR_0='GBP' THEN (FFP.SORDERQ.YORIQTY_0 * …

Member Avatar for Magic8Computing
0
403
Member Avatar for Magic8Computing

I am querying a MYSQL database and would like to return the results so that all of the job numbers that are the same are grouped together and expandable when clicking on the common name. so when the bag loads all you see is a list of job numbers. I …

Member Avatar for diafol
0
1K
Member Avatar for Magic8Computing

Any ideas why this is not actuall writing to the database <form method="post" action=""> <p>&nbsp;</p> <table width="300" border="0" align="center" cellpadding="0" cellspacing="10"> <tr> <td width="100" align="right"> Film Title : </td> <td><input type="text" name="Film_Title"></td> </tr> <tr> <td width="100" align="right"> Film Format : </td> <td> <select name="Format_ID"> <option>- Select Film Format -</option> <option …

Member Avatar for Dani
0
311
Member Avatar for Magic8Computing

How do i get this to write to a txt file instead of message box pleaseWr Function ReceiveSerialData() As String ' Receive strings from a serial port. Dim returnStr As String = "" Dim com1 As IO.Ports.SerialPort = Nothing Try com1 = My.Computer.Ports.OpenSerialPort("COM3") com1.ReadTimeout = 10000 Do Dim Incoming As …

Member Avatar for Mr.M
0
171
Member Avatar for Magic8Computing

Hi, I am new to programming and have attached my code so far, i need to insert the code to read data from serial port but havent a clue where to put it or how any help would be great Imports System Imports System.IO.Ports Public Class Form1 Private mySerialPort As …

Member Avatar for ddanbe
0
808
Member Avatar for Magic8Computing

Hi, I have writen web sites before but have been asked to create a VB program, but dont know where to start so hoping someone can help me. I need to create a program that sits waiting for data from the serial port which is attached to a set of …

Member Avatar for Magic8Computing
0
3K
Member Avatar for Magic8Computing

Hi, We have a intranet with thousands of excel spreadsheets, we have set all the browsers so they open any excel spreadsheet in excel itself not within the browser which is how we wanted it all, unfortunately someone has now developed a spreadsheet they would like to open in the …

Member Avatar for patk570
0
116
Member Avatar for Magic8Computing

Hi, I am trying to get a random image as a background to a cell, and have tried many ideas but none work, in desperate need for help can anybody please. I have this in the header [code] <script language="javascript" type="text/javascript"> var img_rnd = new Array (); img_rnd[0] = "hp-1.jpg"; …

Member Avatar for nosleep365
0
206
Member Avatar for Magic8Computing

I have managed to get a random image setup to work on my cell using ASP and now want it to change the table size of the table over top of the image depending on the image, i know in my head what needs to be done (I think) just …

0
66
Member Avatar for Magic8Computing

Hi, I am developing a company intranet and was wondering is it possible to open the files from the server locations rather than using href as this opens the file from your local temp directory and subsequently read only too. Regards Matthew Clay

Member Avatar for harrierdh
0
115
Member Avatar for Magic8Computing

when i view an internal web page i have created in IE it doesnt do the same as it does in FireFox. I have an iFrame that loads a page by default that page has the two div listed below called to centre the text both vertically and horizontially and …

Member Avatar for zortec
0
95
Member Avatar for Magic8Computing

I have a site where i am returning listings from a database based on the page links and this works fine, i then try to get it so it returns a list that matches a criteria for two fields but this errors saying I have not supplied all the information, …

Member Avatar for Thirusha
0
68
Member Avatar for Magic8Computing

Is it possible to Echo a Web Page link in PHP? If it is can anyone supply the code please. Matthew

Member Avatar for diafol
0
154
Member Avatar for Magic8Computing

Hi, I have got some code that allows me to click an image map link that then changes text in a DIV further down the page though this is only doing plain text and i can't get it to write in links can any one help with the code???? Cheers …

Member Avatar for kvprajapati
0
67