Greetings all,
I am having a bit of a problem with my toolbar class I've created. It was created to take the place of several menu-items that weren't menus at all but rather single-click form openers.
The toolbar works great and I set it to dock at the top of the page. This makes it dock...
Sometimes with php/html just removing the slash won't work either. If removing the slash doesn't work, try preceding it with a "./" like so:
include ('./Common/MySQL.php');
I've only been using ADP for a couple of months now but I would say your theory is correct. I have utilized it because we wanted to upgrade our Access database to SQL server to allow PHP scripts and such to access it. However, we also wanted to keep the Access interface as is for the people...
It seems as though ODBC_fetch_into only grabs the array for one column. Try putting the ODBC_fetch_into statement into a while loop. This way it will keep fetching until there are no more columns to fetch. If you're only interested in the column name, put the column names into their own...
I have done something similar to this recently using an MSSQL image field. I'd imagine it to be the same in MySQL except using a long BLOB field rather than an image field. Here is the code I got from php.net:
// storing a file
$datastring = file_get_contents("img.jpg");
$data =...
Why not try the odbc_fetch_into() function.
Keep your first line as is but then do:
$rowcount = odbc_fetch_into($columns, $namearray);
if ($rowcount != FALSE)
{
foreach ($rowcount as $elem)
print $elem;
}
else
print "Could not fetch rows...";
Hope this helps
Devon
Hello,
Your layout looks good to me. For displaying the relevant scheduling data, I would use an INNER JOIN statement. Something to the effect of:
SELECT tblProfile.EmployeeID, tblProfile.EmpName, tblActivity.Date, tblActivity.Shift, tblTraining.Training
FROM tblProfile INNER JOIN...
Greetings all,
I am having a problem displaying images on my ADP form. The images were inserted as raw binary data or BLOBs into an image field using a PHP script. I have an ADP to access my MSSQL database that works perfectly except when it comes to displaying this image. When i look at the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.