CodeCharge Studio
search Register Login  

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> GotoCode Archive

 Automatically Populating Record

Print topic Send  topic

Author Message
Jellyfish
Posted: 11/25/2002, 6:27 AM

I am adding a record in my db that enables logged in members to edit their user information. I can use the CCGetUserLogin() function to default the login name to the proper field but I don't know how to automatically populate the rest of the record with the data to be edited by the user.

Any help or ideas would be greatly appreciated. I am new to all of this, so if you have any ideas could you please be specific.

Thanks,
John
Jellyfish
Posted: 11/25/2002, 6:41 AM

I forgot to add that I am using PHP and MySQL.
xbill
Posted: 11/25/2002, 9:38 AM

A good place to start is the
portal or the bookstore sample-
both these samples have "Myinfo" or user
editable address and user information.

Basically- it is a record that can be edited.
The fields can be populated by using the record builder.
The record builder in CCS is in the
builders toolbox - second icon.

If you have fields defined in the database
to hold the information that you need- you just
use the record builder to display the fields
and allow the user to update the record.

You can set the selection criteria for the record
using the three dots beside the data source.

Assuming user_id is the key to your user table and
UserID is the default session variable for the logged
in user- add a rule like:

user_id-----equals(=)-----UserID---type Session

To set default values- you can use the field definitions
on each of the fields - or a BeforeShow event.

-bill
Jellyfish
Posted: 11/25/2002, 11:08 AM

Bill:

I've been staring at the code for the Bookstore example for two days now and my head was spinning. I pretty much had everything set as you had suggested except for the rule for the data source. It finally works and a couple of days of frustration have just left.

THANK YOU for your time and your help.

John

   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.

CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.