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

 Connecting to 2 databases from 1 page

Print topic Send  topic

Author Message
ryankelley@freightliner.com
Posted: 01/24/2003, 12:59 PM

Here is the problem i have. I have an inventory search database that i built that lets a potential customer search for a truck and then enter their information to to recieve more information on the truck. When they submit the form it sends an email with all of the data and it also logs their info into a table. Well i have built another database just for sales leads and i would like to make it dump information into that table as well. anybody have any ideas how i would tackle this problem?

Thanks,

Ryan
Wizwyg
Posted: 01/24/2003, 1:13 PM

Under Connections in the Project Explorer, you can set up more than one database.

currently, I have one db that handles the project, but IM taking user information from another.

You can set up your forms to grab or insert information into the 2nd database. Just have to tweak your design and code.
ryankelley@freightli
Posted: 01/24/2003, 1:19 PM

Is that in Codecharge or codecharge studio. I forgot to mention that i am using Codecharge with MySQL and PHP

Thanks
Wizywyg
Posted: 01/24/2003, 1:29 PM



This is with CCS. I havn't used CC for a while, so I dont know or rmember the set=up... sorry
feha
Posted: 01/24/2003, 3:48 PM

You can edit modules ...
The common.php
And add extra code to connect to the second DB ...
Try to use other variables ...
(This an idea only ...)



feha
[www.vision.to]

   


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

Web Database

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.