2. PHPRunner General questions
  3. Connectionstring and Images
This topic is locked

Connectionstring and Images

 		2/8/2009 12:51:28 PM
PHPRunner General questions
A
 Ausi author

Hi All;
I need to know how to change the connectionstring on a project without changing any other settings e.g (Changing the connection strings for the LiveDemo project).
I also have a bit of a problem with the images and files, I need save pictures in the database and not in the folder. I am using the msSQL and have a field called photo with and is a binary field and need to upload pictures in there.
<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=10858&image=1&table=forumtopics' class='bbc_emoticon' alt=':rolleyes:' />
J
 		Jane 2/9/2009

Hi,
to change connection string open project file in any text editor an edit it manually.
To save images in the database set up it as Picture/Picture on the "View as" settings and "Edit as" settings dialog on the Visual Editortab.
A
 		Ausi author 2/11/2009

Hi,

to change connection string open project file in any text editor an edit it manually.
To save images in the database set up it as Picture/Picture on the "View as" settings and "Edit as" settings dialog on the Visual Editortab.


Thanks Jane for a prompt reply. In connection with the connectionstring I tried doing that and it still fails, it give me the following error: (Fatal error: Call to undefined function mysql_connect() in C:...\include\dbconnection.php on line 9). With this I edited the connectionstring in a dbcommon.php file and I get this error. When I edit the connectionstring on XXXX.phpr, i get the same error again.
With pictures, that method saves the file name on the database and not the picture itself and saves the picture in .../files. That will not work for me. I am looking at saving a picture as a binary/blob in the databse.
Please check on the following link: http://www.faqts.com/knowledge_base/view.p.../35994/fid/1805, it does not work for me. I do not have an option that says database pictures. I am using phprunner 5.0 on build 444.
Is there something I am missing?
Thanks
J
 		Jane 2/13/2009

Hi,
first please download and install latest PHPRunner build 766.

Then publish your project on Demo Account and open a ticket at http://support.xlinesoft.com sending a URL to your pages along with instructions on reproducing this error.