- support - lists.drupal.org

FCKeditor
by Sivahari Nandakumar 30 Mar '11

30 Mar '11

In FCKeditor's image insert option the browse server option is not there how to enable it. In fckconfig.js all options are true. -- with warm regards Sivahari Nandakumar Appropriate Technology Promotion Society Eroor, Vyttila 09446582917 http://sivaharicec.blogspot.com -------------------------------------------------------- fighting for knowledge freedom

2 3

How to get the auto-increment value
by Austin Einter 29 Mar '11

29 Mar '11

Hi All I have a table, where 'cid' field is of type "serial". Schema declaration is -> *"'cid' => array('type' => 'serial', 'unsigned' => TRUE, 'not null' => TRUE, ),"* Aim is to have an incremented value for it. The code is as below *$lastid = 0; for($delta = 0; $delta < $all_companies; $delta++) { $lastid = db_last_insert_id(rs_companies, cid) + 1; db_query( 'INSERT INTO {rs_companies} ( cid, uid, prevcompany, joindate, releasedate) ' ."VALUES (%d, '%d', '%s', '%d', '%d')", $lastid, * With this, I find this 'cid' field is not auto incrementing. Any idea, whats the wrong here. Best Regards Austin.

3 3

Doubt on Index and Primary key
by Austin Einter 29 Mar '11

29 Mar '11

HI All In .install file, in hook_schema unction, we are mentioning index field and primary key field. I am wondering, how to choose which one should be index and which one should be primary key. Does that affect the performance (in search, add, delete of records). What I am thinking at this point of time, my database will contain job seekers name, mail-id, contact number, skill set (as comma separated values) and resume. For index purpose, I am thinking I will use '$user->uid' as Index and and 'name' as primary key. I am bit confused how it it is going to affect search/add/delete time (assuming huge number of records in database) and also database management. Please guide me. Regards Austin

5 15

Custom user experience
by Joel Willers 28 Mar '11

28 Mar '11

I’ve got a project where the client wants users to be able to move around their landing page to organize it the way they want. I was thinking about tying a content type to their account that just had weights for each section and then building the landing page based on those weights. This is a really simple solution, though, and I was wondering if perhaps there was something more elegant with the ability to drag and drop the sections into their new spaces and then save the layout. If a module already exists, that would be nice. Thoughts? Joel

4 6

Re: [support] [development] How to get the auto-increment value
by Austin Einter 28 Mar '11

28 Mar '11

Hi All As you suggested, I changed the code where I do not put auto-increment field in db_query. The code looks as below (Please note that $cid is not used in db_query). * for($delta = 0; $delta < $all_companies; $delta++) { drupal_set_message(t('delta = ').$delta.t('last id = ').db_last_insert_id(rs_companies, cid)); db_query( 'INSERT INTO {rs_companies} (uid, prevcompany, joindate, releasedate) ' ."VALUES ('%d', '%s', '%d', '%d')", $user->uid, $form_state['values']['allcompanies'][$delta]['companies'], $form_state['values']['allcompanies'][$delta]['startdate'], $form_state['values']['allcompanies'][$delta]['enddate'] );* So I have not put $cid, when I checked the table, I see $cid values are inserted properly. $cid in row 1 value is 155694 $cid in row 2 value is 155695 $cid in row 3 value is 155696 etc... My question is , why the value is starting from 155694, why not from 0 or 1. Is there anyway I force it to start from 0 or 1. Regards Austin. On Mon, Mar 28, 2011 at 7:50 PM, Larry Garfield <larry(a)garfieldtech.com>wrote: > Yep, you're doing it backwards, actually. :-) > > In D6: > > db_query("INSERT INTO {foo} (a, b) VALUES (%d, '%s')", 1, 'hi'); > $cid = db_last_insert_id(); // The DB auto-generated this value. > > In D7: > > $cid = db_insert() > ->fields(array( > 'a' => 1, > 'b' => 'hi' > )) > ->execute(); > // db_insert()->execute() returns the new auto-inc value automatically. > > Note: In D7, you can do a multi-insert statement where several inserts run > as > a set. That is faster than issuing separate queries, but the return value > is > then undefined and you do not have access to the last-insert-id. Decide if > you *actually* need to auto-generated ID right then and then pick > multi-insert > or not as appropriate. > > As to your other question, the max number of rows, bear in mind that the > number of rows may not correspond go the largest auto-inc value. If you > ever > delete a row then the two will no longer match up. Depending on which you > care about, either of the following are valid (this is D7 syntax): > > $num_records = db_query("SELECT COUNT(*) FROM {foo}")->fetchField(); > > $max_cid = db_query("SELECT MAX(cid) FROM {foo}")->fetchField(); > > Cheers. > > --Larry Garfield > > On Monday, March 28, 2011 5:59:14 am Austin Einter wrote: > > Thanks Nancy. > > Do you mean that in my code I should not put the value for "cid". That > > means $lastid (in red) should be removed. > > > > > > *$lastid = 0; > > for($delta = 0; $delta < $all_companies; $delta++) > > { > > $lastid = db_last_insert_id(rs_companies, cid) + 1; > > db_query( > > 'INSERT INTO {rs_companies} ( cid, uid, prevcompany, joindate, > > releasedate) ' > > ."VALUES (%d, '%d', '%s', '%d', '%d')", > > $lastid, * > > *$user->uid* > > > > > > Regards > > Austin > > > > On Mon, Mar 28, 2011 at 4:20 PM, nan wich <nan_wich(a)bellsouth.net> > wrote: > > > You don't need to provide the value for an auto increment field. > > > > > > "Db_last_insert_id()" is how you get the value *after* the insert, if > you > > > need it at all. > > > > > > > > > *Nancy* > > > > > > > > > > > > Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. > > > King, Jr. > > > > > > ------------------------------ > > > *From:* Austin Einter > > > > > > I have a table, where 'cid' field is of type "serial". > > > > > > *$lastid = 0; > > > > > > for($delta = 0; $delta < $all_companies; $delta++) > > > { > > > > > > $lastid = db_last_insert_id(rs_companies, cid) + 1; > > > > > > db_query( > > > > > > 'INSERT INTO {rs_companies} ( cid, uid, prevcompany, joindate, > > > > > > releasedate) ' > > > > > > ."VALUES (%d, '%d', '%s', '%d', '%d')", > > > > > > $lastid, * >

1 0

how to use an argument to get a row to appear first in a View
by Idan Arbel 28 Mar '11

28 Mar '11

Hello, I have a views slideshow, and in some cases I'd like a certain node to appear first in the order, I don't really care about the rest of the nodes just to move a certain node to be first in the slideshow. I'm looking to achieve this using an argument, maybe sending in the nid, or even better a certain value for another field. This is the use case - I have a slideshow of a certain product, where each row/node is a different color. I have a page with a bunch of these slideshows for different nodes. I'm looking for a way to have list page, display all the slideshows where the "Green" color nodes appear first, this is for a D7 site with drupal commerce - you can see it here: http://www.premiumbaby.co.il/koziol/drupal-7.0/%D7%9E%D7%95%D7%A6%D7%A8%D7%9 9%D7%9D Any pointers would be much appreciated. Idan

1 0

Facebook
by James Bensley 28 Mar '11

28 Mar '11

Hi all, I want to embed the status updates of a Facebook profile on a Drupal site. My understanding is that Facebook dish out a JSON representation of your data (http://graph.facebook.com/ACC_ID_/feed&limit=5) and I saw this guide on how to implement it but its not actually very detailed; http://thereisamoduleforthat.com/content/ingesting-facebook-stream-using-fe… Can anyone expand on this, or explain a better method because I can't get this to work (mostly because they haven't actually explained it very well for beginners like me!). Thanks, -- James. http://www.jamesbensley.co.cc/ There are 10 kinds of people in the world; Those who understand Vigesimal, and J others...?

3 5

how can I hide left&right column on forum-pages?
by Jarry 26 Mar '11

26 Mar '11

Hi, I'd like to hide left and right column on all my forum-pages and use the whole width for central column (displayin topics). How could I do that? I know there is a "page specific visibility settings" for each block, which I could use. But how can I filter all forum-related content out, and nothing more? I left "show on every page except the listed pages" setting activated, and in "page" I put: forum forum/* It works well, but only for all forum listing-pages. When I click on certain forum-topic, blocks are displayed again, because url is "/content/<topic>". And that is the problem: if I add "content/*" to the above mentioned settings, it will work, but for every content on my web-page. And I do not want it for every content, only for forum-content. But I do not know how to distinguish between forum-content, and generally any content... Jarry -- _______________________________________________________________ This mailbox accepts e-mails only from selected mailing-lists! Everything else is considered to be spam and therefore deleted.

4 6

Auto email node content
by Ayath ULLAH 26 Mar '11

26 Mar '11

Hi Guys, I've made some custom content types with two fields: "question and answer". I'd like all my site users to get an email with a question everyday. So I'd like the email operation to loop through the content type from the begining and send an email on every cron run. Are there any modules to help me do this? Another feature I'd like is the ability for users to submit their answers to the questions they get emailed. Are there any ways to automate this so I can compare the submitted answer to the stored answer for that question? Many thanks for your help. Kind regards, Ayath ULLAH Ayath Ullah | Free Webhosting http://ayathullah.co.cc

1 0

Display view's Exposed Filters with Term Reference Field as select list. (drupal 7).
by Praveen M 26 Mar '11

26 Mar '11

Hi, I am using drupal 7, and views 2. I created a content type one of whose field is a term reference. In of my views i would like to use this field as a exposed filter. But I am unable to switch it to a select list option. It always defaults to the textfield. Has someone tried to do something similar, is there a way around this? Thanks, Praveen

1 0