close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Recordset Problems

Thread began 12/07/2010 9:20 am by sabastian130416448 | Last modified 12/07/2010 11:47 am by Jason Byrnes | 1344 views | 10 replies |

sabastian130416448

Recordset Problems

I am having trouble Automatically populating form fields on my checkout page.

I have set up a database that stores everyting and all the pages exct. When I do get the page to display info it is normally only the first table/coloumn in my database no matter what username or password I enter. On my register page the info is enterd corectly into the database but it doesnt get entered into the form.

I have tried everything but I just dont know what else to do.

Attached Files
checkout page.txt
login page.txt
Sign in to reply to this post

Jason ByrnesWebAssist

you are using the Dreamweaver authenticate user behavior which works differently than the security Assist authenticate user behavior.


the Dreamweaver Authenticate user behavior is creating a session variable named MM_Username, this session variable stores the value from the tb_name column.



on the cehckout page, set the rsUsers recordset tp filter the tb_name column on the MM_Username session variable.

Sign in to reply to this post

sabastian130416448

Mmmm I have sort of an idiee what to do but not exactly, still learning this whole ecart and dreamweaver thing nut thanx for the help so far.

Sign in to reply to this post

Jason ByrnesWebAssist

you're welcome.

Sign in to reply to this post

sabastian130416448

"on the cehckout page, set the rsUsers recordset tp filter the tb_name column on the MM_Username session variable"

How do I go towork on doing that? I know a little about recordsets but the "filter the tb_name column on the MM_Username session variable" has me confused.

Plus, the data is already in the database after the user registers, isn't there a way to pull the data then just from the database or are what you talking about just that?

Sorry for all the questions but I have no clue where else to go look for info.

Sign in to reply to this post

Jason ByrnesWebAssist

Set up the filtering section of the recordset as:
'tb_name' '='
'Session variable' 'MM_Username'






this will return the record for the logged in user.

Sign in to reply to this post

sabastian130416448

You are a true genius mr Byrnes. It works perfectly now.

A nother question I have about login pages. On the Webassist site, when I log in, my username is loged in for the whole time I am online. How do I set up my site to do the same so that my users can log in and shop exct without having to log in numerous times?

Sign in to reply to this post

sabastian130416448

Oh a nother problem, when I press the same as billing radio button it updates the info but assoon as I press checkout the shipping info is cleared and just the billing info shows but I am still on the same page.

Sign in to reply to this post

Jason ByrnesWebAssist

session timeout is controlled by the server settings, see the following post from webmaster world for details:
12812.htm


the checkout form on the checkout page should be set to post to the confirm page.

Sign in to reply to this post

sabastian130416448

Thank you, Thank you, Thank you.

It is all working. Have a great week further.

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