Martin K.
|
| Posted: 01/07/2006, 4:27 AM |
|
Hello
I do not get an own SELECT more in the 3er version.
In the 2.2... Version folds that immediately.
e.g. a simple DLookUp.
$db = new clsDBSIMBerichtText();
$result = CCDlookUp("auftrag_end", "mmd_auftragsnummer", "franchise_id=2", $db);
$results = "outstanding account: ". $result;
echo $results;
Now should look $results e.g. in such a way:
Outstanding account: 19
If I however e.g. the first field in the DLookUp auftrag_end in auftrag_endkk do not change get I MYSQL errors how:
DATA cousin error: Invalid SQL: SELECT auftrag_endkk FROM of office_mmd_auftragsnummer WHERE franchise_id=2 MySQL error: 1054 (Unknown column ' auftrag_endkk ' in ' field cunning ') session halted.
although there is not the field.
Now looks $results in such a way:
Outstanding account:
No error in the side!
If I write a SELECT, for e.g. a Grid in Grid, happens nothing.
No Result.
Now I provided and do not get ahead a new project with the 3er version.
If I make in the 2er version, that folds everything immediately as used.
There the desire passes....
With kind regards Martin Kutschka
PS. Sorry about the english
|
|
|
 |
mamboBROWN
Posts: 1713
|
| Posted: 01/08/2006, 6:27 AM |
|
Martin K.
Try this instead.
global $DBSIMBerichtText;
$result = CCDLookUp("auftrag_end", "mmd_auftragsnummer", "franchise_id=2", $DBSIMBerichtText);
$results = "outstanding account: ". $result;
echo $results;
Do you still get the same results??
|
 |
|
Martin K.
|
| Posted: 01/09/2006, 12:00 AM |
|
Hello.
My problem is, that threre comes no error when e.g. the Fieldname or the databasename is not right write.
Try it.
Make an dlookup and write a tablezell that is not there.
Than there must comes a SQL error like:
DATA cousin error: Invalid SQL: SELECT auftrag_endkk FROM of office_mmd_auftragsnummer WHERE franchise_id=2 MySQL error: 1054 (Unknown column ' auftrag_endkk ' in ' field cunning ') session halted.
In my 3.0 Version nothing comes.
No SQL error like :
1054 (Unknown column ' auftrag_endkk ' in ' field cunning ')
Greets Martin K.
|
|
|
|
mamboBROWN
Posts: 1713
|
| Posted: 01/09/2006, 10:29 AM |
|
Martin k.
Take your (CCDLookUP) select statement and run it in MySQL. See if it works. If not try to fix it in MySQL. After it works there then try it in CCS again.
OORRRRR............
Check to make sure that all of your columns exist in your database (the column must exist in order for the select statement to work properly). If it does not exist then make sure that you are connected to the right database and or add the field to the database. Sometimes you may be pointing to the wrong database.
Hope this helps.....
|
|
|
|
Martin K.
|
| Posted: 01/09/2006, 11:56 PM |
|
Hello.
Sorry that my question comes not right.
Please make a dlookup with hand code.
I'am working the last 5 years with yessoftware and a dlookup is nothing....
When i copy the code into phpmyqdmin / SQL it works.
When i copy the code into CCS 2.... it works.
But when need the code in CCS 3.0... it will not work right.
There comes no error when the db name or the fielname is not write right.
When i write a SELECT myfield FROM mytable...
and the Field or the Table was not there, in all Programms there comes a error message.
MySQL Error .....
In CCS3.0... there comes nothing.
I have install the CCS 3... Version a couple of times.
No SQL Error when I make an error like a false Fieldname.
I can not work more with the 3.0.. Version.
Please PeterR, what can I do?
Greets Martin K.
|
|
|
|
peterr
Posts: 5971
|
| Posted: 01/10/2006, 12:02 AM |
|
Martin,
I don't know the answer. Maybe you are connecting to different database in CCS2 vs CCS3? But please try contacting the support if something doesn't work as it should.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
Martin K.
|
| Posted: 01/10/2006, 12:14 AM |
|
Hello Peter.
Nice that your answer comes so quick.
I wrote the question to the support right now.
greets martin k.
|
|
|
|
