Search found 11 matches

by cjcj01
Fri Feb 15, 2008 9:30 am
Forum: Joomla! Extensions Directory Forum
Topic: Extensions comments ranking - please change to list by most
Replies: 5
Views: 1211

Re: Extensions comments ranking - please change to list by most

You guys are awesome! - Looks great - thanks for your hard work and for listening :D
by cjcj01
Fri Feb 01, 2008 9:58 am
Forum: Joomla! Coding 101
Topic: php and mysql Order By help
Replies: 10
Views: 1268

Re: php and mysql Order By help

CirTap - I just can't say how useful your advice has been - Thank you for all your time and advice.  Once I've added the admin interface I'll let you know if you're interested to see it working...  the component provides full text indexing of docs in the docman folder (pdf's and office doc...
by cjcj01
Thu Jan 31, 2008 5:37 pm
Forum: Joomla! Coding 101
Topic: php and mysql Order By help
Replies: 10
Views: 1268

Re: php and mysql Order By help

Last thing... If I'm doing this: $db =& JFactory::getDBO(); $query = 'CREATE TABLE ' . $table . ' (         rank int(10) NOT NULL,         filename varchar(150) NOT NULL,         filesize varchar(10) NOT NULL,         IN...
by cjcj01
Thu Jan 31, 2008 5:25 pm
Forum: Joomla! Coding 101
Topic: php and mysql Order By help
Replies: 10
Views: 1268

Re: php and mysql Order By help

You need to call $db->query() to execute it. :-[ whoops!  Thanks! ---- Delay while testing ------ ;D ;D ;D ;D  It's working!!! CirTap Thank you!!  woohoo!  I now have a working set of results joining indexing server query results with #__docman enabling sorting by ranking etc......
by cjcj01
Thu Jan 31, 2008 1:40 pm
Forum: Joomla! Coding 101
Topic: php and mysql Order By help
Replies: 10
Views: 1268

Re: php and mysql Order By help

Have fun :D thanks! PS the ranking data is only available in the array rather than the database, thus I think I need to create the in-memory table to then JOIN it with docman to then use the subquery... The problem though is that when I use e.g. $db =& JFactory::getDBO(); $table = "#__docsearch_res...
by cjcj01
Wed Jan 30, 2008 3:03 pm
Forum: Joomla! Coding 101
Topic: php and mysql Order By help
Replies: 10
Views: 1268

Re: php and mysql Order By help

The filenames must not be in asc/desc order but by the order provided in the IN() clause CirTap - Thanks so much for your reply.  Yes - you are right I need to do the above. You are also right in saying that MySQL is returning the data by order of the primary key - not datepublished - they jus...
by cjcj01
Wed Jan 30, 2008 12:59 pm
Forum: Joomla! Coding 101
Topic: php and mysql Order By help
Replies: 10
Views: 1268

php and mysql Order By help

Hi. I'm writing a component for joomla which searches inside files stored on the server and I'm returning a list of filenames from a search engine indexing catalog (implode from an array) into a query that looks like this: SELECT * FROM #_document_table WHERE filename in ('filename1', 'filename2', '...
by cjcj01
Tue Jan 15, 2008 10:56 am
Forum: Joomla! Coding 101
Topic: J!1.5 M-V-C - view.html... How to pass a variable back to a function in a model?
Replies: 1
Views: 465

Re: J!1.5 M-V-C - view.html... How to pass a variable back to a function in a mo

ok -  :D I got my head all twisted.

I'm trying to do something in the template that should be done in the view!

I've restructured my code and all working. phew!
by cjcj01
Tue Jan 15, 2008 10:53 am
Forum: Joomla! Extensions Directory Forum
Topic: Extensions comments ranking - please change to list by most
Replies: 5
Views: 1211

Re: Extensions comments ranking - please change to list by most recent

Hey Rliskey - great idea -  :D commeting via version number would be great, however I imagine it's quite difficult to incorporate existing comments into this..?

If extensions were just listed by date, at least the latest review would correspond more accurately to the latest version number...
by cjcj01
Mon Jan 14, 2008 3:30 pm
Forum: Joomla! Coding 101
Topic: J!1.5 M-V-C - view.html... How to pass a variable back to a function in a model?
Replies: 1
Views: 465

J!1.5 M-V-C - view.html... How to pass a variable back to a function in a model?

Hi.  I'm trying to work my way through this M-V-C thing.. Basically, I've got a variable in com_mycomponent/views/mycomponent/tmpl/default.php Which looks like this: $file = $fileRS->fields['filename']->value;   It returns the filename of a document from an Indexing Server Catalog object.&...
by cjcj01
Wed Jan 09, 2008 1:08 pm
Forum: Joomla! Extensions Directory Forum
Topic: Extensions comments ranking - please change to list by most
Replies: 5
Views: 1211

Extensions comments ranking - please change to list by most

Guys - Thanks for a great site.  Just wanted to post a request for a change to the Extensions Directory... The list of User Reviews seems to be ranked by Number of people who found this review helpful rather than date. This is actually really frustrating as a lot of extensions l'm looking at downloa...