Welcome Guest, Not a member yet? Register   Sign In
sql problem using CI and ActiveRecord

I'm really just getting started with CI. I am connecting to an IBM Iseries(AS400,I5)
I finally got the db2 driver(located in the wiki) working and connecting to my Iseries.

I have been working through a simple tutorial that lists jobs and has a link to view a specific job.

The first part of listing all the jobs works howeve when i try to select the specific job it does not work.

The problem seems to be with the DB_active_record.php. I have noticed that there is a lack of spaces in the query.

for my list of all jobs the query is 'Select *from tstmis.jobs' (notice no space between * and from)

Although this seems to work ok.

However when i add a where clause

'Select *from tstmis.jobsWHERE "id" = '1' '

again notice the lack of spaces between tstmis.jobs and WHERE

This query does not run.
Maybe it has something to do with DB2 that doesn't allow it, but at anyrate I'm not quite sure what to do about it.

Any ideas?

Messages In This Thread
sql problem using CI and ActiveRecord - by El Forum - 08-26-2008, 12:13 PM
sql problem using CI and ActiveRecord - by El Forum - 08-28-2008, 07:30 AM

Theme © iAndrew 2016 - Forum software by © MyBB