Creating a new Data Assist page

Hi Ray
When trying to create a new DataAssist page
I create a new page which I open
I then open Webassist > Security Assist > Database > Data Assist pages and get the attached image detail.
I have tried a restart but this made no difference.

Thanks for any advice John

Close dreamweaver and delete the winfilecache.dat file in the user's configuration folder. Then open Dreamweaver again. This looks like a cached issue.

Thanks for the prompt reply Ray.

I cleared the cache and then tried to create a new insert page via webassist/database/dataassistpages/
The wizard opened OK but when I generated the new page I received a numbers of error messages.
I tried the proceedure several times with the same result.

Regards

John

BTW
If I open these images on this page they are very small.
The originals are normal size

Try reinstalling DataBridge. If you still have issues, give me a call monday and I'll do screen sharing to debug it and see what is going on.

Hi Ray,
That's working a lot better now so I will investigate further and let you know how I get on.
Thanks for the help.

John

Please attach a copy of the page and I'll see if I can spot the problem. Just to be clear, you are reporting that after doing an insert, the values in the database don't match the values you selected from the insert page, correct?

Usually that is an issue with the bindings from the insert record server behavior. If you attach the page, I can take a look.

Apologies for the Overlook and Thanks
"reporting that after doing an insert, the values in the database don't match the values you selected from the insert page, correct"
That is correct.

Your insert server behavior is bound to the recordset values and not the form values.

See lines: 73, 74, 77, and 83

They should all be set to update from the $_POST values for the select lists, not the recordset values.

Line 73
$InsertQuery->bindColumn("Category1", "s", "".($rsCatBoats->getColumnVal("Category")) ."", "WA_DEFAULT");

So line 73 become as below
$InsertQuery->bindColumn("Category1", "s", "".($_POST["Category"]) ."", "WA_DEFAULT"); ?

Yes, that looks right.