ceinj
Posts: 10
|
| Posted: 09/09/2007, 4:03 PM |
|
There seems to be some issues with CCDLookup that were not fixed in the bug patch.
I am using PHP and MySQL, A few fields in the database seem to not work well with CCDLookup. An example of two of such fields are:
Country/Region
Password
When I use these fields in CCDLookup they either return blanks or worse, the results of the last good CCDLookup call. I know the fields are valid because I can use them in text boxes connected to the table.
I have tried to enclose the field names with ` (backward quote) and [ ] (brackets) with no success.
Langston
|
 |
 |
paxero
Posts: 6
|
| Posted: 09/09/2007, 4:58 PM |
|
I completely agree.
CCDLookUp it's not working correctly now!
|
|
|
|
klwillis
Posts: 428
|
| Posted: 09/09/2007, 10:11 PM |
|
Peter -
Any idea when a patch will be available?
- Kevin
_________________
Kevin Willis, VP/CIO
HealthCare Information Technology Specialist
http://www.nexushealthcare.com
"Fast - Convenient - Quality-Care"
Medical Software Consulting Services
Email : klwillis@nexushealthcare.com
Skype : klwillis2006 |
|
|
|
wkempees
|
| Posted: 09/10/2007, 5:04 AM |
|
post you CCDLookup code here please
for us to have a look at.
Walter
"klwillis" <klwillis@forum.codecharge> schreef in bericht
news:546e4d2070ede8@news.codecharge.com...
> Peter -
>
> Any idea when a patch will be available?
>
> - Kevin
>
> _________________
> Kevin Willis
> http://www.nexushealthcare.com
> "Fast - Convenient - Quality-Care"
>
> CCS - Medical Software Consulting Services
> Email :klwillis@nexushealthcare.com
> Skype : klwillis2006
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.yessoftware.com/
>
|
|
|
|
ceinj
Posts: 10
|
| Posted: 09/10/2007, 6:40 AM |
|
//DLookup @118-A66F2379
global $DBDBConn;
$Page = CCGetParentPage($sender);
$ccs_result = CCDLookUp("`Password`", "lipflix_users", "LipFlix_ID = '" . $Container->LipFlix_ID->GetText() . "'", $Page->Connections["DBConn"]);
$ccs_result = strval($ccs_result);
$Container->acctpass->SetValue($ccs_result);
//End DLookup
I have also tried:
$ccs_result = CCDLookUp("`Password`", "lipflix_users", "LipFlix_ID = '" . $Container->LipFlix_ID->GetText() . "'", $Page->Connections["DBConn"]);
$ccs_result = CCDLookUp("Password", "lipflix_users", "LipFlix_ID = '" . $Container->LipFlix_ID->GetText() . "'", $Page->Connections["DBConn"]);
$ccs_result = CCDLookUp("[Password]", "lipflix_users", "LipFlix_ID = '" . $Container->LipFlix_ID->GetText() . "'", $Page->Connections["DBConn"]);
$ccs_result = CCDLookUp(Password, "lipflix_users", "LipFlix_ID = '" . $Container->LipFlix_ID->GetText() . "'", $Page->Connections["DBConn"]);
The field "Password" is defined in the database as clear text and has values in it. When I use some other field in the call above I get results.
I think because "Password" is some type of reserved keyword, this function has a problem with it. I think the same problem exists if the field name has some special characters in it. I had the same problem with the field "Country/Region".
Langston
|
|
|
|
datadoit.com
|
| Posted: 09/10/2007, 7:17 AM |
|
Langston, to verify that it's a CodeCharge problem, have you done the
same query in the database directly? Either via MySQL CLI client,
phpMyAdmin, whatever?
SELECT Password FROM lipflix_users WHERE LipFlixID='whatever'
Also, instead of using $Page->Connections["DBConn"], try using a new
connection to see if you get the same result:
global $DBDBConn;
$db = new clsDBDBConn();
$css_result = CCDLookUp("Password", "lipflix_users",
"LipFlix_ID='".$Container->LipFlix_ID->GetText()."'", $db);
$db->close();
I've tried to recreate your problem on CCS3.2.0.2, Apache2.2.4,
PHP5.2.2, and MySQL5.0.37 w/ODBC driver 3.51 using a new connection, but
could not.
|
|
|
|
ceinj
Posts: 10
|
| Posted: 09/10/2007, 9:15 AM |
|
Sorry all... My mistake.
The CCDLookup was returning the correct data for field "Password".
The Country/Region field works if you enclose the field name with back quote (`) (This is for MySQL)
Issue resolved.
Langston
|
|
|
|
datadoit.com
|
| Posted: 09/10/2007, 9:25 AM |
|
ceinj wrote:
> The Country/Region field works if you enclose the field name with back quote
> (`) (This is for MySQL)
>
> Langston
> ---------------------------------------
Perhaps PHP is trying to divide Country by Region? In the US that would
be 50. :)
|
|
|
|
wkempees
|
| Posted: 09/10/2007, 4:29 PM |
|
LOL.
SQL fields with that sort of special characters need to be enclosed by
backticks (`).
Also note te use of single and double quotes.
single for literals double for parsables.
Not wrong per se but PhP will always try and parse double quoted variables,
time time time.
Walter
"datadoit.com" <datadoit@forum.codecharge> schreef in bericht
news:fc3r5i$tlm$1@news.codecharge.com...
> ceinj wrote:
>
>> The Country/Region field works if you enclose the field name with back
>> quote
>> (`) (This is for MySQL)
>>
>> Langston
>> ---------------------------------------
>
> Perhaps PHP is trying to divide Country by Region? In the US that would
> be 50. :)
|
|
|
|
klwillis
Posts: 428
|
| Posted: 09/10/2007, 5:59 PM |
|
JavaScript code placed within CCS client-side events (i.e. onClick)
is still an issue which has not been resolved.
I've been told that CCS Developers are aware of this issue and working on a solution,
but so far, no word on the upgrade.
_________________
Kevin Willis, VP/CIO
HealthCare Information Technology Specialist
http://www.nexushealthcare.com
"Fast - Convenient - Quality-Care"
Medical Software Consulting Services
Email : klwillis@nexushealthcare.com
Skype : klwillis2006 |
|
|
|
|
