create sql

Załóż eBloga

Temat: Using RDF feed to generate static HTML pages?
Hi there again, If you need to have the actuall content on your server and are having probs figuring it out, let me know and I will help you do it free. I am currently working on the nutch.org code and revamping etc, and have been able to not only parse, but create sql databases from it. Once the actuall parse, and sql database is formed the rest of the script is very easy, we can use the free version of the script you were looking at and simply add a admin interface, along with sql support so that all search requests come from your server and database-not the odp. Let me know if you would like my help, I could do it in about a day....Free. Let me know buddy.
Źródło: resource-zone.com/forum/index.php?showtopic=24098

Temat: Retrieval of record count in relational activerecord
Just some thoughts. I haven't tested it :) I'd look at it from an SQL perspective. Your approach will create SQL similar to: SELECT c.*, COUNT(co.id) as numofcontacts FROM category c LEFT JOIN category-contact cc ON cc.category_id=c.id LEFT JOIN contact co ON cc.contact_id=co.id AND co.deleted_time="..." To make this work you need an additional GROUP BY c.id. You could create a CDbCriteria for your query and add that there. You'll also have to add the numofcontacts to the criteria's select property. See here:...
Źródło: yiiframework.com/forum/index.php?showtopic=4010

Temat: CDbExpression and MySQL function
2 letscode: I think your approach is not really good, what will be if user will want to change only email and password left as is, after save his password hash will be corrupted. 2 GoofyX: I'm not sure, but if you want to use mysql hashing function to hash password you will nedd to manually create sql for inserting. I think model can't help you with that. But I'm not sure...
Źródło: yiiframework.com/forum/index.php?showtopic=2099

Temat: Tightauctions Jak Zainstalować? proszę o pomoc!!!
Mam pytanie jak zainstalować TightAuctions? Niestety jakoś nie mogę zrozumieć README ponieważ pisze ,że najpierw wrzucić na serwer a potem odpalić z folderu /misc/sql plik " create.sql" który tworzy bazę do skryptu ale jak to odpalić przez Total Comandera. I w tym jest cały problem :( . Kto mi pomoże???
Źródło: forum.ks-ekspert.pl/index.php?showtopic=100348