Forum


12:40

30/01/2009

Hi there. This is my first post.
I've been testing this grid for a week so far (samples run fine), but for some reason my first real test (against one of my ongoing project's DB) shows me no records at all.
I am using url:'ajax/some_ajax.php' and datatype: 'xml' to get the records from the DB.
If I run ajax/some_ajax.php alone, it pulls a nice and beautiful xml stream.
If I replace the url:'ajax/some_ajax.php' by url:'ajax/output.xml', being this xml file the static version of what I get from the ajax/some_ajax.php, the damn thing works fine and I see the records.
My first thought was that I was making a mistake with the header files in the php, but I triple checked and they are exactly the same as the sample provided in the grid package...
Do you know of any other common mistake one can make when pulling records form a php script generating the required xml?
I am testing with FFox 3 and Opera. Thanks in advance, and congratulations for this terrific piece of software.
Gabriel
Gabriel Schillaci
13:01

30/01/2009

Ok, 10 minutes after I posted this question, I found the cause.
My PHP script wasn't setting the $_GET[sidx] variable, making my SQL syntax as this:
SELECT ...
FROM ...
ORDER BY 0
and thus the SQL sentence giving an error. This wasn't happening when I run my php script from the browser bc $_GET[sidx] was not defined.
So beware folks to properly manage default variables in your PHP scripts! they might come empty!
Regards
Gabriel
Gabriel Schillaci
Most Users Ever Online: 715
Currently Online:
45 Guest(s)
Top Posters:
OlegK: 1255
markw65: 179
kobruleht: 144
phicarre: 132
YamilBracho: 124
Renso: 118
Member Stats:
Guest Posters: 447
Members: 11373
Moderators: 2
Admins: 1
Forum Stats:
Groups: 1
Forums: 8
Topics: 10592
Posts: 31289
Newest Members:
, razia, Prankie, psky, praveen neelam, greg.valainis@pa-tech.comModerators: tony: 7721, Rumen[Trirand]: 81
Administrators: admin: 66