RURL question - fields update wrong column in database

[JasonSpr]

Hello,

I have a Rurl that I am running which gathers customer information,
and stores it in a MSsql database. Everything was working fine, but I
recently added some additional fields to the project, and whenever I
change those fields, they all updated my "Industry_S" column in the
database. "Industry_S" was one of the fields that was working fine
before I made these changes.

I added columns for the fields to the database and added the adors to
the plan as adors and as schema, and rechecked in the plan.

I updated the .aspx file to show the new Checkbox and the two new
Select forms. I have also added the new adors to these lines:

Under "<XMPCtrls:uCreateXMUserControl"
ADORNames='<%# "\"MyCheckBox\",\"MySelectBox\", etc...

ADORNames='<%# "\"MyCheckBox\",\"MySelectBox\", etc...

ADORValues='<%# "\"" + (Request.Form["MyCheckBox"] != null ?
Convert.ToString(Request.Form["MyCheckBox"]).Replace("\"", "\"\"") :
"") + "\"" + "," + etc...

In other words, wherever there were instances of code pointing to
previous fields, I also added my new fields.

Why would all the new fields submit to "Industry_S"?

[Bill]

Did you use the "Update" button in the uCreate XM toolbar, or did you
edit the ASP code?

When you added the new ADORs in the plan, could you have copied the
Write expressions a little "fast", and have let all of them as "|->
[Industry_S] := value"? (instead of changing the field name for each
of them?).

[JasonSpr]

Thank you for the reply-

I editted the ASP code, not using Update from within Dreamweaver.
Someone else said this might be the cause too, so I'm going to check
and post back. I will also check that I properly created the Ador
objects and changed all "|->[items]".

> > Why would all the new fields submit to "Industry_S"?- Hide quoted text -
>
> - Show quoted text -

[Stephen Jones]

This has happened to me before and it turned out to be me trying to be 'too fast' (as per Bill) in the write expression of uPlan, I would double check this aswell.

[Michael]

Hi,

The best way to solve this kind of problems is to
create a complete new planfile. When the wizard
starts check the "webready" box.

Also be sure that you edit the right landing page.
(on your XMPie server there are two directories,
Test and deployed.

Regards,

Michael

[JasonSpr]

Thank you for the replies. I can confirm that the Adors all point to
their individual names, and are read+write adors. Corresponding Schema
all exist. I edited the file in dreamweaver and all the adors are
correctly linked with the "update" function. I'm positive I'm editing
the correct landing page because all the formatting changes I've made
appear correctly when following the Rurl+rid address (and it is
accessible both by the alias, and by the actual URL.

Still, I am getting the same problem - the new adors are updating the
wrong column in the database, or do not update at all. Does anyone
have any other possibilities for why this is happening?

Cheers,
JG

[Timothy Perrett]

You must have a duff write expression in the plan someplace - it
simply would not be able to update the wrong column in the database
otherwise. My suggestion would be to either work through each ADOR in
uPlan checking both READ and WRITE expressions, or just open the plan
in an XML editor and do some manual find checks.

Cheers, Tim

[Michael Bova]

JG,
I had an issue where adors were not updating and I found I had some
errant code on of my purl pages. I had a multi page site, and
information collected on page 2 was not writing to the database. I
found on page 4 I was inadvertently updating adors on page 2, which of
course wrote empty expressions. I don't know about updating to the wrong
column though, haven't had that issue.

Michael Bova

[Stephen Jones]

Just a thought - the Read and Write expressions may match but are the Ador Objects mapped correctly to the Recipient Information Scmeme names? I would also setup a new form from scratch and setup within the same campaign and update the same amount of fields but keep it seperate from all the actual project web page files, if this new form works then the problem is with the code on your actual project if it does not work then the problem lies with uPlan or DB.

SJ

[JasonSpr]

Update:

I fixed the issue, but I don't know what was causing the problem. I
recreated the plan file from scratch, and also had to create a new
port in uProduce. The fields then updated correctly.

As far as I could view, the new plan and the old plan were identical -
the adors were the same, configured the same, and the html was the
same too. There was some hidden value created by uPlan - adding adors
manually is not the same as using the wizard to create my adors and
schema from the database.

I can reproduce this discrepency between what should logically be
identical .plan files, but I hope I never do.

Thanks very much for the help!