sql

SQL ICE Demo - How to Use SQL ICE to Access Your Drupal Data

Join us for a Webinar on Tuesday, March 22, 10am Central

Reserve your Webinar seat now at:
https://www1.gotomeeting.com/register/882042968

Are you a Drupal user and do you know SQL? If you answered "yes", then SQL ICE could be a useful tool to have on your desktop.

In this session, we will demonstrate how you can use SQL ICE to access your Drupal data, using the same version of SQL ICE (v.1.1.1) that is available as a free download from our site, to run queries against the data from our live Drupal site.

SQL ICE Demo - How to Use SQL ICE to Access Your Drupal Data

Join us for a Webinar on Tuesday, March 22, 10am Central

Reserve your Webinar seat now at:
https://www1.gotomeeting.com/register/882042968

Are you a Drupal user and do you know SQL? If you answered "yes", then SQL ICE could be a useful tool to have on your desktop.

In this session, we will demonstrate how you can use SQL ICE to access your Drupal data, using the same version of SQL ICE (v.1.1.1) that is available as a free download from our site, to run queries against the data from our live Drupal site.

Hi all,

I need to do modify the form where the user need to check some boxes and after that display in the textfield just the childres items that are in the parents select .

this is the code where i did the autocomplete but i need to add the parent select any idea? im really stuck, thanks

function cookbook_ingredients_xhr($name) {
$name = urldecode($name);

$query = "SELECT nid, title FROM node WHERE status = 1 AND type = 'ingredient'";
$query_args = array();

// Check language
if (module_exists('i18ntaxonomy')) {
$query .= " AND language IN('','%s')";

Hello,

I've just set up a github repo with a couple of drush extra commands for provinding secure and compressed SQL dumps.

The secure version uses openssl for encrypting the compressed dump. I thought this might be of use to someone, and who knows, the drush team can find it interesting enough to be included in the official release ;)

Thanks,
António

Tjo.

Behöver lite hjälp med en vision som jag har för min hemsida som ska Drupaliseras med version Drupal6.

Jag skulle vilja ha tre olika block på hemsidan:

1) Visa max 5 småartiklar som har ett visst datum som överensstämmer med dagens (allt enligt min fråga http://groups.drupal.org/node/98144)
2) Visa de 10 sista inlagda småartiklarna från databasen
3) Ett block där det visas 4 stycken slumpvist utvalda småartiklar kopplat till en slumpvist utvald tagg.

Hej

Om man vill skriva om den sql som skapas av en vy finns den möjligheten?

jag vet att man via $views->build_info['query'] kan hitta/sätta den sql som skapas för default vyn men låt säga man vill ändra den sql som skapas för något av de block/page/feed som man skapar, hur hittar man den build_infon?

hälsningar Peter

On my site, i've installed several modules which leads to about:
+ 250+ queries on admin page
+ 160+ queries on every other page accessed , including frontpage.

I'm amazed by the number of queries it used up...
Thats why the site seems to be quite slow...
Anyone have any suggestion?
I know i need to trim down on my modules, but i think some of the large number of queries are from drupal core itself...

Saindo do forno(sim, foi hoje!!), esse novo módulo do Drupal(http://drupal.org/project/qviews) tem tudo para auxiliar e muito na utilização do Drupal como plataforma de desenvolvimento de sistemas, assim como integrador de informações de diversas fontes, no estilo portal mesmo.

Usando o Drupal para lidar com informações que não estão na "sua" base de dados, várias vezes desejei que alguns dos recursos disponíveis quando utilizamos o módulo Views(http://drupal.org/project/views) estivessem ali também. São muito úteis. Esse novo módulo preencheu essas lacuna.

I am looking for a way to use sql query in condition of rule - if sql query returns something - proceed with rule, if it returns nothing - skip rule. Can anyone suggest way to go in this case? Thanks.

Hi,

I know drupal is heavily database run to pull a single page.

I'd like to know the average number of sql queries run to construct a tipical (front) page.

I ran devel to collect query info on one of my sites I work on, and it shows that 800+ queries ran! Is this normal? I thought it was too many for a single page. If this is more than average, could you suggest ways to reduce the the number of sql queries? Did I miss big things to check as a new comer?

Thanks.