support March 2011

support@drupal.org

89 participants
100 discussions

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

hindi font in drupal
by Alok Singh Mahor 25 Mar '11

25 Mar '11

Hi all, I am using wysiwyg editor to write content. I am not able to see content in hindi when I am writing something in hindi. I can only see the question marks in place of hindi text. I have enabled the Internationalization module still drupal is showng question marks in place of hindi text. please someone guide me to make drupal show hindi font. thank you -- Alok Singh Mahor http://alokmahor.co.cc Join the next generation of computing, Open Source, and Linux/GNU!

1 0

Creating new page.tpl.php
by Unknown 25 Mar '11

25 Mar '11

I need to create a viewspage.tpl.php to display and print a calendar in a particlular format. Are there any good tutorials on the step by step process? thanks Roger

3 2

Views help
by Joel Willers 25 Mar '11

25 Mar '11

If I have a View and want a certain sort order, how would you guys approach it? My solution is to just break it apart in the tpl.php file, but I’m curious if there’s a better way. So let’s say we have days of the week (just an example, could be other items, but this seems universally available). I can’t sort alphabetically, I need it to be Sunday, Monday, Tuesday, etc. Thoughts? Joel

4 3

Re: [support] Views help
by Marty Landman 25 Mar '11

25 Mar '11

Joel, In the case where the data I want to sort on isn't sortable I create a new field that is. So if it's day of the week then I'll create a day_idx field eg. Sunday - 01, Monday - 02 etc.. hth, Marty At 10:18 AM 3/25/2011, you wrote: >Content-class: urn:content-classes:message >Content-Type: multipart/alternative; > boundary="----_=_NextPart_001_01CBEAF7.940E9931" > >If I have a View and want a certain sort order, >how would you guys approach it?Â My solution is >to just break it apart in the tpl.php file, but >Iâm curious if thereâs a better way. > >So letâs say we have days of the week (just an >example, could be other items, but this seems >universally available).Â I canât sort >alphabetically, I need it to be Sunday, Monday, Tuesday, etc. > >Thoughts? > >Joel -- http://www.face2interface.com/ https://addons.mozilla.org/af/firefox/addon/181910/

2 1

← Newer
1
2
3
4
5
6
7
8
9
10
Older →

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

support March 2011