Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Adding a toolbar to the menu bar
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...- devwilcat
- Thread
- Replies: 1
- Forum: Microsoft: FoxPro
-
Include file
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'); -
Access ADP Use
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...- devwilcat
- Post #2
- Forum: Microsoft: Access Project (ADP)
-
Help with displaying columns/fields of a table, please
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... -
PHP Upload with MySQL
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 =... -
Help with displaying columns/fields of a table, please
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 -
Staff Movement Database
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...- devwilcat
- Post #2
- Forum: Microsoft: Access Project (ADP)
-
Displaying BLOBs as images
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...- devwilcat
- Thread
- Replies: 0
- Forum: Microsoft: Access Project (ADP)
