CodeCharge Studio
search Register Login  

Web Reporting

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

YesSoftware Forums -> Archive -> CodeChargeStudio.Discussion

 After Insert->Custom Code->own query (PHP)

Print topic Send  topic

Author Message
Tobias Ferdinand
Posted: 09/04/2002, 7:22 AM

Hi!
Can anyone help me? I want to add my own insert-Query in a custom Code
(After Insert). But I don#t find any funcutions for that.

In CodeCharge, I just used $db->query("UPDATE [...]"); and it worked fine!
I tried it that way in CodeCharge Studio, but it doesn't work. I also
searched functions for that in the helpfile but could only find some for
asp, not for php.

Is there any solution or do I have to use the PHP-Functions instead?

Thanks!
Tobias Ferdinand

Jeroen Steggink
Posted: 09/05/2002, 1:00 AM

Hi Tobias,

You will need to use the functions you can find in the Programming
Reference.

Just do it like this:

global $DB<dbname>; //without < and >
CCDLookup("user_id", "users", "user_login='user'"), $DB<dbname>); //first
the field you want to retrieve, then the table and then the where condition,
but this is ofcourse only when you want to do a select

To do a sql expression use this:
CCGetDBValue("UPDATE [...]", $DB<dbname>);

"Tobias Ferdinand" <Tobias.Ferdinand@i12.de> wrote in message
news:al54ud$ebf$1@news.codecharge.com...
> Hi!
> Can anyone help me? I want to add my own insert-Query in a custom Code
> (After Insert). But I don#t find any funcutions for that.
>
> In CodeCharge, I just used $db->query("UPDATE [...]"); and it worked fine!
> I tried it that way in CodeCharge Studio, but it doesn't work. I also
> searched functions for that in the helpfile but could only find some for
> asp, not for php.
>
> Is there any solution or do I have to use the PHP-Functions instead?
>
> Thanks!
> Tobias Ferdinand
>
>


   


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.