CodeCharge Studio
search Register Login  

Web Reports

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

YesSoftware Forums -> Archive -> CodeCharge.Discussion

 Value modification before insert into the database

Print topic Send  topic

Author Message
Peter roth
Posted: 02/22/2001, 2:51 PM

Hi
I've one form the user can type it name and its e-mail adress.

Now I'd like to modify the e-mail value to a html syntax and store this into
the database. As I saw I'm able to fill some code into the "insert-event" -
but nothing happen. The value is stored as typed in by the user e.g.
muster@server.com.

After a short analyse of the generated code - my own statement is placed
after the sql - in this way I do not have any change to modify the value to
store into the database.

On my point of view - all the code, I've typed into the insert-event has to
be place before the sql statement is generated.

Is there a way to this. Because if I include the hole stuff (my value
modification and the sql) then it works. But - do not take a view on the
generated code the sql will be in place twice!!

Any ideas - behaps a new Event should be the solution "BeforeInsert"...

Regards
Peter Roth
software solutions, switzerland

CodeCharge
Posted: 02/22/2001, 5:35 PM

We're adding new events right now, which should be available next week.
We'll also look into your issue and see if there is already a workaround.

"Peter roth" <proth@softsol.ch> wrote in message
news:974559$k9f$1@news.codecharge.com...
> Hi
> I've one form the user can type it name and its e-mail adress.
>
> Now I'd like to modify the e-mail value to a html syntax and store this
into
> the database. As I saw I'm able to fill some code into the
"insert-event" -
> but nothing happen. The value is stored as typed in by the user e.g.
>muster@server.com.
>
> After a short analyse of the generated code - my own statement is placed
> after the sql - in this way I do not have any change to modify the value
to
> store into the database.
>
> On my point of view - all the code, I've typed into the insert-event has
to
> be place before the sql statement is generated.
>
> Is there a way to this. Because if I include the hole stuff (my value
> modification and the sql) then it works. But - do not take a view on the
> generated code the sql will be in place twice!!
>
> Any ideas - behaps a new Event should be the solution "BeforeInsert"...
>
> Regards
> Peter Roth
> software solutions, switzerland
>
>


   


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

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


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