close ad
WARNING: Do Not Install the DREAMWEAVER CC 2017 or 2018 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

I want to store PDF's in blobs NOT in folders.

Thread began 7/07/2017 8:31 pm by anonymous | Last modified 7/19/2017 10:46 am by Ray Borduin | 231 views | 28 replies |

anonymous

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.

Sign in to reply to this post

Ray BorduinWebAssist

ok. It should be possible to do that.

Sign in to reply to this post

anonymous

Is there a built in wizard in your software?

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post

anonymous

Now it doesn't see my tables.

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.

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post

anonymous

It resolved itself spontaneously, which is what always happens.

Sign in to reply to this post

anonymous

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.

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post

anonymous

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.

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

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.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...