I want to store PDF's in blobs NOT in folders.
No I don't want to hear about the decrease in speed or functionality or whatever. I just want to store PDFs INSIDE the database. Thanks.
No I don't want to hear about the decrease in speed or functionality or whatever. I just want to store PDFs INSIDE the database. Thanks.
ok. It should be possible to do that.
Is there a built in wizard in your software?
There is no wizard specifically for BLOB storage, but there are wizards for inserting/updating/deleting records in a database and it should work with blob fields.
This happens not infrequently. I test the database connection and the connection is successful however no function detects any tables. I check my MySQL workbench and see everything is still there. Webassist doesn't see them. Why does this happen so often? Refresh and rebooting does not help.
Update: This is on my laptop, which I had installed the update, and rolled it back through the Adobe Cloud thing. Its a different version than the last version of DW without the update - I didn't install the update on my work computer - and the DW looks different between the two. Uninstalling and reinstalling the WA apps corrected the problem. I had not been able to use my laptop for this until reinstalling the apps. FYI i had a lot of 'undefined error's' when trying to access views and tables for this.
I haven't seen that problem before. Can I get a copy of your site definition and FTP access to reproduce the problem? If I can reproduce it, I can debug it and find out the cause.
It resolved itself spontaneously, which is what always happens.
I can get the file in, but I can't get the file out.... many tutorials on the web for displaying blobs, tried every combination of code imaginable.. no luck.
Are you trying to get the file out as a download? You will probably have to create a page that dumps the value and add the necessary headers to get it to initiate the download dialog.
Yes I've done all sorts of things. Confimed the file is in the db, correct size using Webassist - boy that was a time-saver. I now have a getfile.php page which queries the db to get the data, filesize, file name, mime. Inserted the headers. Base64 encode, no base64 encode, over and over and over again every permutation. I've got it to the point where it will download a file, which is the wrong size and acrobat declares it as corrupt. DB file type is longblob.
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.