data is not making it to DB 1

[OnAFan]

I have the connection, user logs in, takes test, test results open. THere is a button with an "update record" server behavior attached; but the record is not being updated. Any suggestions?

 

[schase]

is this the same as the one with insert error?

 

[OnAFan]

Yes, I did however go the FAQs, and realized it was happening because I had a Date field on the registration page.

 

[schase]

ok, well check the usual suspects. Are you posting or getting, is it going to the right place.

Is it trying to mail instead of posting.

 

[OnAFan]

All of the pages are set to post. I think I need to pass the data from the logon page somehow, and I am not sure how...any suggestions?

 

[schase]

I'm still in fact-finding mode.

on the test results page - does it display the users name?

 

[OnAFan]

No it just gives the number right, wrong, and the grade

 

[schase]

ok so it probably doesnt know where to put it.

you have Session MM_Username already established?

 

[OnAFan]

No, where do I put that? test, results?

 

[schase]

this is providing you used a UD4 login page - and providing whatever they use to login with is a name instead of an ID.

Open data bindings window
click the + button
choose session variable
in the box that pops up put MM_Username

now, on the page your displaying the test results.
Click once on the submit button, and remove the insert behavior.

and btw - you can now drag over the session just like a recordset field into any portion of any page. It'll display the person who's logged in.

now crack open the code part.

and right below <Form action=
put this

<input type=&quot;hidden&quot; name=&quot;name&quot; Value=&quot;<%= Session(&quot;MM_Username&quot %>&quot;>

change whats in blue to your database field name.


Click on the submit button - and add the insert record behavior - making sure all fields goto their respective slots.

 

[OnAFan]

I got an error
&quot;The method specified in the Request Line is not allowed for the resource identified by the request. Please ensure that you have the proper MIME type set up for the resource you are requesting&quot;

 

[schase]

ok go back to your login page
you'll see something like

MM_valUsername<>&quot;&quot;

whats the exact MM_val.....

 

[OnAFan]

var MM_valUsername=String(Request.Form(&quot;userid&quot);

 

[schase]

ok try this,

back where you have them enter info for a test

put this in the code where you want the textbox to be

<input type=&quot;text&quot; name=&quot;name&quot; value=&quot;<%= Session(&quot;MM_Username&quot %>&quot;>

change the blue to the actual field name of the database field.

Then on the results page pull it across like any other field.
--oh yeah - remove that <input type=&quot;hidden&quot; name=&quot;name&quot; Value=&quot;<%= Session(&quot;MM_Username&quot %>&quot;>

 

[OnAFan]

Data still doesnt go to db.

 

[mlawson]

Hi Terry,

Can you open the Access database that the record lives in and see if it IS actually being deposited into the database but your pages looking for it aren't seeing it?

What do you ask the system to do after you submit it to the database?

M

 

[OnAFan]

When I look in the record, the registration info is there, but not the stuff from the results page. When the user clicks the &quot;update record&quot; button on the results page, the page then opens up to a survey.

 

[schase]

it's gotta be the unique key - it's not finding it.

Terry do you mind emailing the database and the related pages? There doesnt have to be actual info in the database, just a couple of dummy records

I'm afraid we're just going to be shooting in the dark.

 

[OnAFan]

I will not be at my desk (work)until tomorow morning at 5am EST. I will send it to you then. What time do you get in? Thanks

 

[mlawson]

sounds like schase is on the case. Go for it!

Let us know how it goes.

M