CodeCharge Studio
search Register Login  

Web Reports

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

YesSoftware Forums -> CodeCharge Studio -> ASP

 Concatenate two fields

Print topic Send  topic

Author Message
itw_peter

Posts: 6
Posted: 05/27/2009, 11:03 AM

Hi,

I have 3 fields: account, acct_obj, and acct_sub where the field account is made of acct_obj.acct_sub.
I want user just to enter or update acct_obj and acct_sub, and the form will automatically grab the two values, concatenate them, and update the value of the account field.
Is there a way to do that in codecharge?

Any help will be much appreciated. Thank you in advance.

Regards
Peter
View profile  Send private message
Edd


Posts: 547
Posted: 05/27/2009, 4:28 PM

Peter,
CCS has a fantastic facility to custom Insert / Update and Deletes. They don't talk about it much but it is a real winner in my books

Have a look there - you can create your own SQL taking the fields from the forms to do the inserts and updates.

Cheers - Edd



_________________
Accepting and instigating change are life's challenges.

http://www.syntech.com.au
View profile  Send private message
Oper


Posts: 1195
Posted: 05/28/2009, 7:36 AM

also create account hidden field


During the event on before update or insert

formobj.datasource.account.value=acct_obj & acct_sub.
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)

http://www.PremiumWebTemplate.com
Affiliation Web Site Templates

Please do backup first
View profile  Send private message
itw_peter

Posts: 6
Posted: 05/28/2009, 8:58 AM

Edd and Oper,
Great, thank you very much for your help.
I solved my problem.
View profile  Send private message

Add new topic Subscribe to topic   


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.