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

DFP and Data Assist

Thread began 6/29/2009 12:14 pm by Steve | Last modified 6/30/2009 1:11 pm by Steve | 1296 views | 5 replies |

Steve

DFP and Data Assist

Hello,
A couple problems I have ran into with this combination (most recent versions) are as follows:

1 ) The recordset can not be generated if you specify localhost with a port designation. For instance localhost:3307
To get around this you have to use a named server or the IP address then the : port #... DW can handle localhost:port number without error though...

2 ) Saving and updating an uploaded file.
Without using the wizard set of insert, update DA and DFP work nice together allowing you to create your own pages then add the update and insert functionality. But the options for saving the file name seems to lack the ability of the full file name. This leaves us inserting the [name] but not the [type] (gif , jpeg, pdf, etc). It would be nice if DFP had an option to allow you to have the name and type (extension) concatenated so uploading gifs and jpgs could be used interchangeably in other dynamic pages.

3) Updating a record that already has an image uploaded. I'm not sure how the extension expects to handle the case when you have a record you are updating but do not want to upload a new image. Seems some logic like if imageName isset or !empty do not pass the values for the file field. But it you did chose a new image, then use the file fields [name].[type] as the text to insert in the record.
It was easy enough to create a linked page that passes the recordID and allows a new image upload and remove the file field from the update page, but this is not the most efficient method and in the Adobe Developer Toolkit there seems to be this logic so one page could efficiently handle a new image update or leave the prior undisturbed if not needed to be changed.


Maybe being able to use localhost : port # , actual filename (based on concatenated array values of [name].[type] , and an aware update behavior that allows prior unchanged file field values or new uploads to all work well together would be a consideration in some update version...?

Sign in to reply to this post

Ray BorduinWebAssist

1) What recordset? Where do you get this error. I'm not exactly sure of the problem so I'd like to reproduce it.

2) The full server file name should be available through bindings as well as the file name and extension individually.

3) This is correct it doesn't have the option to ignore or cancel the upload if the file exists, only to overwrite or rename.

Sign in to reply to this post

Steve

Originally Said By: Ray Borduin
  1) What recordset? Where do you get this error. I'm not exactly sure of the problem so I'd like to reproduce it.

2) The full server file name should be available through bindings as well as the file name and extension individually.

3) This is correct it doesn't have the option to ignore or cancel the upload if the file exists, only to overwrite or rename.  




1) Create a DB connection and use the logic I noted. Then try to find any table when you first open the Update Record Wizard. You'll be able to selection your connection file but no tables will be offered. It may be that no DBs are offered but since I've moved on from that roadblock I am not sure.

2) I don't see it. Screen shot attached

3) Please consider passing this to the powers that be as a viable update/enhancement. An update page should be able to actually update without requiring every value to be changed. Having to bounce to a second page to change out an image is not as efficient as it could be. Check out your copy of ADDT (if you have one) as i've done this on a number of prior occasions. But since Adobe is planning to shelve that product, it's forcing some of us to buy WA extensions (or properly learn PHP and save our snippets as we should) as a replacement. So if you have this, we will not need to learn the means to accomplish this on our own (counter productive to your Marketing teams goals).

Sign in to reply to this post

Ray BorduinWebAssist

1) Thanks I will try to reproduce it

2) It is in the file upload bindings above, not in the form field bindings.

3) Thank you for the suggestions

Sign in to reply to this post

digitaldesign

1) I've had this happen sometimes when the testing server URL was incorrect

Sign in to reply to this post

Steve

Originally Said By: digitaldesign
  1) I've had this happen sometimes when the testing server URL was incorrect  



Not relative to this thread as there is not a problem creating a DB connection script in DW to use localhost and a specific port number.

In some cases we need to have specific ports rather than the default 3306. In this case I have some old clients that are not willing to update their old sites and their DB is in an earlier version than MySQL 5. So we run two instances of MySQL, one old version and one new version...using a different port for each of the two MySQL servers.

Sign in to reply to this post

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...