CodeCharge Studio
search Register Login  

Visual PHP Web Development

Visually Create Internationalized Web Applications, Web Reports, Calendars, and more.
CodeCharge.com

YesSoftware Forums -> Archive -> GotoCode Archive

 Oracle join with Perl DBI not working in CC2

Print topic Send  topic

Author Message
Jeff Scott
Posted: 11/19/2002, 9:38 AM

If I build a grid that does a straight select everything is fine. But if I build a Grid, with a Search form, the prepare statement fails. I'm running on Solaris, Oracle 8 enterprise, Perl 5 w/templates.
Tom
Posted: 11/26/2002, 10:22 AM

No perl experience but are you searching with a date field? They are a pain with Oracle. Make sure format of the date is right with an alter session command. See CC tips for more on Oracle dates.
Also, turn on your debug so you can see the sql statement that is trying to execute. It may give you more clues.

   


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.