[allphoneso]

Hello All,

 

I'm newbie

 

anybody can help me?

 

how to convert my query statement

[allphoneso]

Sorry missing posting

anybody can help me?
how to convert my queries statement


select mmt.ORG_ID, mmt.TRAN_ID, mil.DESC
from  MT_MAT_TRANS mmt , MT_ITEM_LOC mil
where mmt.ORG_ID=mil.ORG_ID
and mil.DESC is not null


How can I do this by the library??

[heruprambadi]

please, read the documentation first.

[allphoneso]

hello heruprambadi,

 

i'm newbie with grocerycrud.

 

i still confused to implement statement query on controller.

 

can you help me?

 

thanks

[davidoster]

Hello [member=allphoneso] and welcome to the forums.

Well except the need that you must read the documentations you need to know the following:

 

1. Grocery CRUD (Grocery CRUD) is an auto generator library for the framework CodeIginter (CI)

2. GC generates withing a very few lines of code a full blown administration system of your tables

3. GC doesn't give (at least for now) the ability to define your own custom sql queries

4. most of the things are accomplished via calling all ready made functions (this is why you need to read the documentation!)

 

Saying this let's convert your query to grocerycrudian language!!! (Hahahahaha I like this!!!)

 

Well you are using actually two tables. This can't be done on GC library.

[alain]

Saying this let's convert your query to grocerycrudian language!!! (Hahahahaha I like this!!!)

 

lol

 

allphoneso > It's a CRUD generator, no need to know how the SQL works