From beertastic at gmail.com Mon Sep 14 06:24:36 2009 From: beertastic at gmail.com (Tris) Date: Mon, 14 Sep 2009 12:24:36 +0100 Subject: [thelist] Data capture in Drupal... In-Reply-To: <17534870-D2DD-4999-B07D-FA8D286C6AC0@boldfish.co.uk> References: <8b20a7490909100211k55e6b486t2dd3dabaa1e815a5@mail.gmail.com> <1252580062.7759.3.camel@dell> <177c0a10909100556necc23aal58b88d4da6d76e79@mail.gmail.com> <89D25D04-2801-45C3-9173-BF1A67566BEF@boldfish.co.uk> <4AA931E8.9030909@gmail.com> <17534870-D2DD-4999-B07D-FA8D286C6AC0@boldfish.co.uk> Message-ID: <8b20a7490909140424m48c48ca3n5e19456c00965b48@mail.gmail.com> Many thanks all! I think that I'm going to investigate both options.. With the data I capture, I'm gonna need to do some calculations, make a few graphs based on that data... But as long as the data is in the DB, I can get it and do what I want to it... Basically, what I'm building is weblog viewer for a client... One bod enters in a bunch of stats (using forms that I'll create using CCK for example) and then the view takes that data and prettys it up for some big wig to drool over for a few moments... Seems like it's doable... ;-p Right.. a reading I will go...!! Tris... 2009/9/10 Tony Crockford : > > On 10 Sep 2009, at 18:05, Sarah Adams wrote: > >> Tony Crockford wrote: >>> I didn't get that the OP wanted to email data from a form or save it >>> to a CSV file - WebForm would need an extra processing script to save >>> the data to a database? >> >>> From the Webform page: "Submissions from a webform are saved in a >> database table and can optionally be mailed to a nominated e-mail >> address upon submission. Past submissions are viewable for users with >> the correct permissions." > > Gulp? > > I missed that. > sorry. > > > (time to crawl back under the desk?.) > > -- > > * * Please support the community that supports you. ?* * > http://evolt.org/help_support_evolt/ > > For unsubscribe and other options, including the Tip Harvester > and archives of thelist go to: http://lists.evolt.org > Workers of the Web, evolt ! > -- "The only people who don't make mistakes are those who don't do anything" Give a man a fish and he'll feed himself for a day. Give a man a religion and he'll starve to death praying for a fish. Anon `We are what we pretend to be, so we must be careful what we pretend to be.` Kurt Vonnegut `When a person can no longer laugh at himself, it is time for others to laugh at him.` Thomas Szasz From danielk at umd.edu Mon Sep 14 10:44:34 2009 From: danielk at umd.edu (Daniel Kessler) Date: Mon, 14 Sep 2009 11:44:34 -0400 Subject: [thelist] image scroller to the right Message-ID: <1D14702A-3D6A-481A-AEA6-257F5ECCA45E@umd.edu> I'm using jquery to scroll through this set of images. I'm having trouble getting the image scroller to go to the right of the first paragraph. http://sph.umd.edu/test/image.cfm Any help would be much appreciated. thank you. -- Daniel Kessler University of Maryland College Park School of Public Health 3302E SPH Building College Park, MD 20742-2611 Phone: 301-405-2545 http://sph.umd.edu From david at chelseacreekstudio.com Mon Sep 14 11:25:00 2009 From: david at chelseacreekstudio.com (David Laakso) Date: Mon, 14 Sep 2009 12:25:00 -0400 Subject: [thelist] image scroller to the right In-Reply-To: <1D14702A-3D6A-481A-AEA6-257F5ECCA45E@umd.edu> References: <1D14702A-3D6A-481A-AEA6-257F5ECCA45E@umd.edu> Message-ID: <4AAE6E5C.30006@chelseacreekstudio.com> Daniel Kessler wrote: > I'm using jquery to scroll through this set of images. I'm having > trouble getting the image scroller to go to the right of the first > paragraph. > http://sph.umd.edu/test/image.cfm > > .sep { margin-top:25px; float: left; <----------------- :: add :: } #slide_images p { <----------------- :: delete declaration :: width: 100px; height:246px; margin:0; } #slide_images { <----------------- :: delete declaration :: width: 100px; height:246px; margin:0; float:right; } PS Nice doctype. :-) From david at chelseacreekstudio.com Mon Sep 14 11:27:38 2009 From: david at chelseacreekstudio.com (David Laakso) Date: Mon, 14 Sep 2009 12:27:38 -0400 Subject: [thelist] image scroller to the right In-Reply-To: <1D14702A-3D6A-481A-AEA6-257F5ECCA45E@umd.edu> References: <1D14702A-3D6A-481A-AEA6-257F5ECCA45E@umd.edu> Message-ID: <4AAE6EFA.2050506@chelseacreekstudio.com> Daniel Kessler wrote: > I'm using jquery to scroll through this set of images. I'm having > trouble getting the image scroller to go to the right of the first > paragraph. > http://sph.umd.edu/test/image.cfm > > > > > thank you. > Should read: #slide_images { <------------ :: add deeclaration :: width: 100px; height:246px; margin:0; float:right; } > > From danielk at umd.edu Mon Sep 14 12:28:33 2009 From: danielk at umd.edu (Daniel Kessler) Date: Mon, 14 Sep 2009 13:28:33 -0400 Subject: [thelist] image scroller to the right Message-ID: > .sep { > margin-top:25px; > float: left; <----------------- :: add :: > } > > #slide_images p { <----------------- :: delete declaration :: > width: 100px; > height:246px; > margin:0; > } > > > #slide_images { <----------------- :: add declaration :: > width: 100px; > height:246px; > margin:0; > float:right; > } That worked great thank you. In my rush, I didn't realize that I was working on the p. > PS Nice doctype. :-) ya well, if I post the actual page, I get all sorts of heck because of my template (which does not validate), so to post here I need to make another page and again, in my rush, I replaced all the code of my temporary page instead of just the content. I really appreciate the assistance. -- Daniel Kessler University of Maryland College Park School of Public Health 3302E SPH Building College Park, MD 20742-2611 Phone: 301-405-2545 http://sph.umd.edu From joel at bizba6.com Mon Sep 14 21:00:54 2009 From: joel at bizba6.com (Joel Canfield) Date: Mon, 14 Sep 2009 19:00:54 -0700 Subject: [thelist] multi-use javascript form update function Message-ID: <619d00930909141900n3a2e462bs24f283f0ca763a11@mail.gmail.com> My memories of javascript are faded. I have three PayPal buttons on a page; each form allows the user to choose a quantity, and domestic or foreign shipping. When the quantity is selected or the shipping radio button changed, the form updates the shipping amount and quantity in the form. With one form, I had it working. With three, my never-strong js skills are out of their depth. Pointers for making this code work with all three forms would be great. the function: function updateShipping() { document.form.quantity.value = document.form.QtyCE.value var ShippingRate = 0; for(i = 0; i < document.form.ShippingLocation.length; i++) { if(document.form.ShippingLocation[i].checked == true) ShippingRate = document.form.ShippingLocation[i].value; } var ShippingQuantity = 2; if(document.form.QtyCE.value > 2) { ShippingQuantity = document.form.QtyCE.value } document.form.shipping.value = (ShippingRate * 1) + ((ShippingQuantity - 2) * (ShippingRate/4)) } and three forms very much like this, but the select id and the shipping location radio buttons are IDed differently in each

Please send me copies of The Commonsense Entrepreneur (paperback) to be shipped


clearly, I have to tell the function which form to talk to; that's one of the many things I'm fuzzy about here -- Joel at Bizba6.com http://BusinessHeretics.com/ From evolt at roselli.org Tue Sep 15 07:30:52 2009 From: evolt at roselli.org (aardvark) Date: Tue, 15 Sep 2009 08:30:52 -0400 Subject: [thelist] multi-use javascript form update function In-Reply-To: <619d00930909141900n3a2e462bs24f283f0ca763a11@mail.gmail.com> Message-ID: <4AAF50BC.2839.162DBC@localhost> why not modify the function so that you pass in the id of the element you want to affect? function updateShipping(elemID) { var formItem = document.getElementById(elemID); [...] if(formItem.value > 2) [...] in your form just call the function with the appropriate element: or is that not the thing you want to do with the form? is it the looping you want to do? you can take the same approach and just pass in another variable... i have to admit, i'm sending this while also doing a couple other things, so i may not be reading it clearly... there are a lot of different ways to do this, but utlimately i recommend you just pass in the variants and treat them as variables within the function, this way you can re-use it over and over... On 14 Sep 2009 at 19:00, Joel Canfield wrote: > My memories of javascript are faded. > I have three PayPal buttons on a page; each form allows the user to choose a > quantity, and domestic or foreign shipping. When the quantity is selected or > the shipping radio button changed, the form updates the shipping amount and > quantity in the form. > > With one form, I had it working. With three, my never-strong js skills are > out of their depth. Pointers for making this code work with all three forms > would be great. [...] > clearly, I have to tell the function which form to talk to; that's one of > the many things I'm fuzzy about here From joel at bizba6.com Tue Sep 15 10:10:25 2009 From: joel at bizba6.com (Joel Canfield) Date: Tue, 15 Sep 2009 08:10:25 -0700 Subject: [thelist] multi-use javascript form update function In-Reply-To: <4AAF50BC.2839.162DBC@localhost> References: <619d00930909141900n3a2e462bs24f283f0ca763a11@mail.gmail.com> <4AAF50BC.2839.162DBC@localhost> Message-ID: <619d00930909150810w70fcb821ha132a86107eabf94@mail.gmail.com> On Tue, Sep 15, 2009 at 5:30 AM, aardvark wrote: > why not modify the function so that you pass in the id of the element > you want to affect? > > bingo! I knew there was an obvious solution, and that's it. thanks muchly for coming out of the shadows just for little ol' me joel From joel at bizba6.com Tue Sep 15 12:04:52 2009 From: joel at bizba6.com (Joel Canfield) Date: Tue, 15 Sep 2009 10:04:52 -0700 Subject: [thelist] are you a whiz at integrating Google analytics? I have a client with money Message-ID: <619d00930909151004pd8cb6der78ee32e1743c5841@mail.gmail.com> I have a client who wants to build a dashboard app which essentially tracks two bits of information: page views on a list of websites, and goal completion on those sites. It needs to be fronted by some user-friendly interfaces, and have some security for administrative users and clients. If I can find the right person, I'll be managing the project, and you'll be coding it. joel -- Joel at Bizba6.com http://BusinessHeretics.com/ From nan at nanharbison.com Wed Sep 16 11:59:28 2009 From: nan at nanharbison.com (Nan Harbison) Date: Wed, 16 Sep 2009 12:59:28 -0400 Subject: [thelist] Is there is a Wordpress theme that looks like this blogspot theme? Message-ID: <8884F07314484B51A4EF5227396C30B3@nancyb0bda4ba6> Hi folks, Before I spend hours searching for a similar theme on Wordpress (this blog is moving to its own site), maybe someone knows if there is a theme that looks similar to the theme being used here: http://hollywoodsuperspy.blogspot.com/ Thanks Nan From swatson at internavigate.com Wed Sep 16 12:42:42 2009 From: swatson at internavigate.com (Shelley Watson) Date: Wed, 16 Sep 2009 10:42:42 -0700 Subject: [thelist] Is there is a Wordpress theme that looks like this In-Reply-To: References: Message-ID: <007201ca36f5$1979f1b0$4c6dd510$@com> I would do a search on the codex for anything with a minimalist approach, white one column, etc. Take a look at: http://elementsofseo.com/ and see if that works for you Possibly a version of Cutline would work? Cheers, Shelley Message: 2 Date: Wed, 16 Sep 2009 12:59:28 -0400 From: "Nan Harbison" Subject: [thelist] Is there is a Wordpress theme that looks like this blogspot theme? To: Message-ID: <8884F07314484B51A4EF5227396C30B3 at nancyb0bda4ba6> Content-Type: text/plain; charset="us-ascii" Hi folks, Before I spend hours searching for a similar theme on Wordpress (this blog is moving to its own site), maybe someone knows if there is a theme that looks similar to the theme being used here: http://hollywoodsuperspy.blogspot.com/ Thanks Nan ------------------------------ _______________________________________________ Help: http://lists.evolt.org/mailman/listinfo/thelist Archives: http://lists.evolt.org End of thelist Digest, Vol 79, Issue 15 *************************************** From nan at nanharbison.com Wed Sep 16 12:51:21 2009 From: nan at nanharbison.com (Nan Harbison) Date: Wed, 16 Sep 2009 13:51:21 -0400 Subject: [thelist] Is there is a Wordpress theme that looks like this In-Reply-To: <007201ca36f5$1979f1b0$4c6dd510$@com> References: <007201ca36f5$1979f1b0$4c6dd510$@com> Message-ID: <4A17BB2D1FB54CEFB00CDC4C988C56F7@nancyb0bda4ba6> This is LOVELY and close enough, I predict. Thanks Shelley! Nan -----Original Message----- From: Shelley Watson [mailto:swatson at internavigate.com] Sent: Wednesday, September 16, 2009 1:43 PM To: thelist at lists.evolt.org Cc: nan at nanharbison.com Subject: RE: [thelist] Is there is a Wordpress theme that looks like this I would do a search on the codex for anything with a minimalist approach, white one column, etc. Take a look at: http://elementsofseo.com/ and see if that works for you Possibly a version of Cutline would work? Cheers, Shelley Message: 2 Date: Wed, 16 Sep 2009 12:59:28 -0400 From: "Nan Harbison" Subject: [thelist] Is there is a Wordpress theme that looks like this blogspot theme? To: Message-ID: <8884F07314484B51A4EF5227396C30B3 at nancyb0bda4ba6> Content-Type: text/plain; charset="us-ascii" Hi folks, Before I spend hours searching for a similar theme on Wordpress (this blog is moving to its own site), maybe someone knows if there is a theme that looks similar to the theme being used here: http://hollywoodsuperspy.blogspot.com/ Thanks Nan ------------------------------ _______________________________________________ Help: http://lists.evolt.org/mailman/listinfo/thelist Archives: http://lists.evolt.org End of thelist Digest, Vol 79, Issue 15 *************************************** From marun2 at gmail.com Thu Sep 17 10:25:00 2009 From: marun2 at gmail.com (Mohan Arun L) Date: Thu, 17 Sep 2009 20:55:00 +0530 Subject: [thelist] Is there is a Wordpress theme that looks like this blogspot theme? Message-ID: >>Before I spend hours searching for a similar theme on Wordpress (this blog is moving to its own site), maybe someone knows if there is a theme that looks similar to the theme being used here: http://hollywoodsuperspy.blogspot.com/ To narrow down your search, search for minimalistic wordpress themes. Here are some wordpress themes that look similar http://shaheeilyas.com/barecity/ http://www.ardamis.com/2007/06/03/apricot/ http://www.plaintxt.org/themes/blogtxt/ ************* www.webdesignexpert.me www.mohanarun.com Twitter: @marun2 ************* From nan at nanharbison.com Thu Sep 17 13:05:02 2009 From: nan at nanharbison.com (Nan Harbison) Date: Thu, 17 Sep 2009 14:05:02 -0400 Subject: [thelist] Is there is a Wordpress theme that looks like thisblogspot theme? In-Reply-To: References: Message-ID: Excellent! Thanks Mohan. Nan -----Original Message----- From: thelist-bounces at lists.evolt.org [mailto:thelist-bounces at lists.evolt.org] On Behalf Of Mohan Arun L Sent: Thursday, September 17, 2009 11:25 AM To: thelist at lists.evolt.org Subject: Re: [thelist] Is there is a Wordpress theme that looks like thisblogspot theme? >>Before I spend hours searching for a similar theme on Wordpress (this blog is moving to its own site), maybe someone knows if there is a theme that looks similar to the theme being used here: http://hollywoodsuperspy.blogspot.com/ To narrow down your search, search for minimalistic wordpress themes. Here are some wordpress themes that look similar http://shaheeilyas.com/barecity/ http://www.ardamis.com/2007/06/03/apricot/ http://www.plaintxt.org/themes/blogtxt/ ************* www.webdesignexpert.me www.mohanarun.com Twitter: @marun2 ************* -- * * Please support the community that supports you. * * http://evolt.org/help_support_evolt/ For unsubscribe and other options, including the Tip Harvester and archives of thelist go to: http://lists.evolt.org Workers of the Web, evolt ! From moseley at hank.org Thu Sep 17 17:35:42 2009 From: moseley at hank.org (Bill Moseley) Date: Thu, 17 Sep 2009 15:35:42 -0700 Subject: [thelist] Community organizing sites? Message-ID: <16f65d000909171535v6adc2e14l28b3a2d1b6acdfaa@mail.gmail.com> I was asked about sites to facilitate the management of volunteers for events during the year. Which would simply be a way to enter events on a calendar, specify times and the number of people needed. This specific request was for managing volunteers for a year at a school. i.e. On the 22nd we need four volunteers for a field trip. The idea is a central place people can go and find events that fit their schedule and sign up. In addition a way to review your upcoming commitments, and what would be great is to have the system send out reminders by email a few days before the event where each person would re-confirm their involvement. Anyone have recommendations for sites like this? Thanks, I've looked at wejoinin.com, which is too basic. Lotsa Helping Hands is nice, but not meant for this purpose. People have suggested just a google spreadsheet but would need to code some way to remind people. -- Bill Moseley moseley at hank.org From judah at wiredotter.com Thu Sep 17 17:52:26 2009 From: judah at wiredotter.com (Judah McAuley) Date: Thu, 17 Sep 2009 15:52:26 -0700 Subject: [thelist] Community organizing sites? In-Reply-To: <16f65d000909171535v6adc2e14l28b3a2d1b6acdfaa@mail.gmail.com> References: <16f65d000909171535v6adc2e14l28b3a2d1b6acdfaa@mail.gmail.com> Message-ID: You might want to check out CiviCRM: http://civicrm.org/ It was formerly called CivicSpace (and is based on Drupal) and was created off of volunteers working on Howard Dean's Presidential campaign. It is focused, last I saw, on organizing volunteers and collecting and disseminating information to/from them. Might be just what you are looking for. Cheers, Judah On Thu, Sep 17, 2009 at 3:35 PM, Bill Moseley wrote: > I was asked about sites to facilitate the management of volunteers for > events during the year. ?Which would simply be a way to enter events on a > calendar, specify times and the number of people needed. ?This specific > request was for managing volunteers for a year at a school. ?i.e. On the > 22nd we need four volunteers for a field trip. > > The idea is a central place people can go and find events that fit their > schedule and sign up. ?In addition a way to review your upcoming > commitments, and what would be great is to have the system send out > reminders by email a few days before the event where each person would > re-confirm their involvement. > > Anyone have recommendations for sites like this? > > Thanks, > > I've looked at wejoinin.com, which is too basic. Lotsa Helping Hands is > nice, but not meant for this purpose. ?People have suggested just a google > spreadsheet but would need to code some way to remind people. > > -- > Bill Moseley > moseley at hank.org > -- > > * * Please support the community that supports you. ?* * > http://evolt.org/help_support_evolt/ > > For unsubscribe and other options, including the Tip Harvester > and archives of thelist go to: http://lists.evolt.org > Workers of the Web, evolt ! > From moseley at hank.org Thu Sep 17 18:04:16 2009 From: moseley at hank.org (Bill Moseley) Date: Thu, 17 Sep 2009 16:04:16 -0700 Subject: [thelist] Community organizing sites? In-Reply-To: References: <16f65d000909171535v6adc2e14l28b3a2d1b6acdfaa@mail.gmail.com> Message-ID: <16f65d000909171604r25196851je600f82b35fd84f9@mail.gmail.com> On Thu, Sep 17, 2009 at 3:52 PM, Judah McAuley wrote: > You might want to check out CiviCRM: http://civicrm.org/ > > It was formerly called CivicSpace (and is based on Drupal) and was > created off of volunteers working on Howard Dean's Presidential > campaign. It is focused, last I saw, on organizing volunteers and > collecting and disseminating information to/from them. Might be just > what you are looking for. > Looks interesting and quite full featured. At this time I'm looking for a hosted service, though. Thanks, -- Bill Moseley moseley at hank.org From judah at wiredotter.com Thu Sep 17 18:07:51 2009 From: judah at wiredotter.com (Judah McAuley) Date: Thu, 17 Sep 2009 16:07:51 -0700 Subject: [thelist] Community organizing sites? In-Reply-To: <16f65d000909171604r25196851je600f82b35fd84f9@mail.gmail.com> References: <16f65d000909171535v6adc2e14l28b3a2d1b6acdfaa@mail.gmail.com> <16f65d000909171604r25196851je600f82b35fd84f9@mail.gmail.com> Message-ID: On Thu, Sep 17, 2009 at 4:04 PM, Bill Moseley wrote: > Looks interesting and quite full featured. ?At this time I'm looking for a > hosted service, though. I know there are companies that host it, since IT is not always the strong point of non-profits and they often look for hosted services. I haven't used any though, so check out the forums on the site, I believe there is one specifically for hosted versions of the project. Cheers, Judah From marun2 at gmail.com Fri Sep 18 05:40:07 2009 From: marun2 at gmail.com (Mohan Arun L) Date: Fri, 18 Sep 2009 16:10:07 +0530 Subject: [thelist] what's the hole in my contact form anti-spam? Message-ID: Came across this today. http://www.vileworks.com/php-screencast-hidden-captcha This looks like a reasonable compromise between/among a) not putting more roadblocks in the form of captcha for real browsing people with javascript enabled. b) spam bots most likely have javascript disabled, so they would face the captcha. ################ Twitter: @marun2 ################ From eccentric.one at gmail.com Fri Sep 18 10:19:16 2009 From: eccentric.one at gmail.com (Jeremy Weiss) Date: Fri, 18 Sep 2009 10:19:16 -0500 Subject: [thelist] combining two similar sql queries into one Message-ID: I'm trying to build a report that will display all parts and services on a certain workorder, ordered alphabetically by vendor name. I have a query to do just parts and the query to do just services, but I'm having trouble trying to combine the two. For what it's worth, I'm querying an Oracle db. Here's the parts query: SELECT CORR.WORKORDERS.WORKORDERNUMBER, CORR.PURCHASE_ORDERS_MASTER.PURCHASEORDERNUMBER, CORR.PURCHASE_ORDERS_MASTER.FORMATTEDPURCHASEORDERNUMBER, CORR.PURCHASE_ORDERS_MASTER.VENDORNAME, CORR.PURCHASE_ORDERS_COMMON.LINEITEMNUMBER, CORR.PURCHASE_ORDERS_COMMON.PARTNUMBER, CORR.PURCHASE_ORDERS_COMMON.PARTDESCRIPTION, CORR.PURCHASE_ORDERS_COMMON.ORDERDATE, CORR.PURCHASE_ORDERS_COMMON.PURCHASEPRICE, CORR.PURCHASE_ORDERS_COMMON.FORMATTEDPURCHASEORDERNUMBER, CORR.PURCHASE_ORDERS_PROCURE.QUANTITYPURCHASED FROM CORR.PURCHASE_ORDERS_COMMON Inner Join CORR.PURCHASE_ORDERS_MASTER ON CORR.PURCHASE_ORDERS_MASTER.PURCHASEORDERMASTERKEY = CORR.PURCHASE_ORDERS_COMMON.PURCHASEORDERMASTERKEY Inner Join CORR.WORKORDERS ON CORR.PURCHASE_ORDERS_COMMON.WORKORDERKEY = CORR.WORKORDERS.WORKORDERKEY Inner Join CORR.PURCHASE_ORDERS_PROCURE ON CORR.PURCHASE_ORDERS_COMMON.PURCHASEORDERCOMMONKEY = CORR.PURCHASE_ORDERS_PROCURE.PURCHASEORDERCOMMONKEY WHERE CORR.WORKORDERS.WORKORDERNUMBER='9113' ORDER BY CORR.PURCHASE_ORDERS_MASTER.VENDORNAME, CORR.PURCHASE_ORDERS_MASTER.PURCHASEORDERNUMBER, CORR.PURCHASE_ORDERS_COMMON.LINEITEMNUMBER Here's the services query: SELECT CORR.WORKORDERS.WORKORDERNUMBER AS WO2, CORR.PURCHASE_ORDERS_MASTER.PURCHASEORDERNUMBER, CORR.PURCHASE_ORDERS_MASTER.FORMATTEDPURCHASEORDERNUMBER, CORR.PURCHASE_ORDERS_MASTER.VENDORNAME, CORR.PURCHASE_ORDERS_COMMON.LINEITEMNUMBER, CORR.PURCHASE_ORDERS_COMMON.ORDERDATE, CORR.PURCHASE_ORDERS_COMMON.PURCHASEPRICE, CORR.PURCHASE_ORDERS_COMMON.FORMATTEDPURCHASEORDERNUMBER, CORR.PURCHASE_ORDERS_SERVICE.QUANTITYTOSEND, CORR.PURCHASE_ORDERS_SERVICE.SERVICEDESCRIPTION FROM CORR.PURCHASE_ORDERS_COMMON Inner Join CORR.PURCHASE_ORDERS_MASTER ON CORR.PURCHASE_ORDERS_MASTER.PURCHASEORDERMASTERKEY = CORR.PURCHASE_ORDERS_COMMON.PURCHASEORDERMASTERKEY Inner Join CORR.WORKORDERS ON CORR.PURCHASE_ORDERS_COMMON.WORKORDERKEY = CORR.WORKORDERS.WORKORDERKEY Inner Join CORR.PURCHASE_ORDERS_SERVICE ON CORR.PURCHASE_ORDERS_COMMON.PURCHASEORDERCOMMONKEY = CORR.PURCHASE_ORDERS_SERVICE.PURCHASEORDERCOMMONKEY WHERE CORR.WORKORDERS.WORKORDERNUMBER='9113' ORDER BY CORR.PURCHASE_ORDERS_MASTER.VENDORNAME, CORR.PURCHASE_ORDERS_MASTER.PURCHASEORDERNUMBER, CORR.PURCHASE_ORDERS_COMMON.LINEITEMNUMBER As you can see, the two queries are quite similar. But my attempts at merging the two have ended in everything from 0 records to hundreds of thousands of records and it should only be about 1500 for this particular work order. Thanks, Jeremy From marun2 at gmail.com Fri Sep 18 12:16:22 2009 From: marun2 at gmail.com (Mohan Arun L) Date: Fri, 18 Sep 2009 22:46:22 +0530 Subject: [thelist] Community organizing sites? Message-ID: >>The idea is a central place people can go and find events that fit their schedule and sign up. In addition a way to review your upcoming commitments, and what would be great is to have the system send out reminders by email a few days before the event where each person would re-confirm their involvement. Have a look: http://www.wildapricot.com/blogs/newsblog/archive/2009/08/19/6-free-or-cheap-web-tools-to-schedule-volunteers.aspx have you also looked at event management apps? eventbrite.com You get a hosted subdomain like this http://soapboxunderground.eventbrite.com/ for your event and you can send invites to people via email, manage the gathering with group communications, updates, pics, etc. Others: amiando.com matchboxcalendar.com mycharitymanager.com You can also use tgethr.com to create something like a google group to track and collaborate with volunteers. * * * www.mohanarun.com www.webdesignexpert.me Twitter: @marun2 * * * From rudy at r937.com Fri Sep 18 13:17:56 2009 From: rudy at r937.com (r937) Date: Fri, 18 Sep 2009 14:17:56 -0400 Subject: [thelist] combining two similar sql queries into one Message-ID: <64A753AE748D44FC84A4B07CD69AE4BB@curly> hi jeremy a UNION would be one way to "merge" the queries (presumably you cannot just add the additional join to purchase_orders_service into the first query because of cross join effects resulting from multiple purchase_orders_procure rows and/or multiple purchase_orders_service rows) care must be taken to align the SELECT clause columns properly, and this requires the use of some NULL placeholders SELECT wo.workordernumber , pom.purchaseordernumber , pom.formattedpurchaseordernumber , pom.vendorname , poc.lineitemnumber , poc.partnumber , poc.partdescription , poc.orderdate , poc.purchaseprice , poc.formattedpurchaseordernumber , pop.quantitypurchased , NULL quantitytosend , NULL servicedescription FROM corr.workorders wo INNER JOIN corr.purchase_orders_common poc ON poc.workorderkey = wo.workorderkey INNER JOIN corr.purchase_orders_master pom ON pom.purchaseordermasterkey = poc.purchaseordermasterkey INNER JOIN corr.purchase_orders_procure pop ON pop.purchaseordercommonkey = poc.purchaseordercommonkey WHERE wo.workordernumber='9113' UNION ALL SELECT wo.workordernumber , pom.purchaseordernumber , pom.formattedpurchaseordernumber , pom.vendorname , poc.lineitemnumber , NULL , NULL , poc.orderdate , poc.purchaseprice , poc.formattedpurchaseordernumber , NULL , pos.quantitytosend , pos.servicedescription FROM corr.workorders wo INNER JOIN corr.purchase_orders_common poc ON poc.workorderkey = wo.workorderkey INNER JOIN corr.purchase_orders_master pom ON pom.purchaseordermasterkey = poc.purchaseordermasterkey INNER JOIN corr.purchase_orders_service pos ON pos.purchaseordercommonkey = poc.purchaseordercommonkey WHERE wo.workordernumber='9113' ORDER BY 4 -- vendorname , 2 -- purchaseordernumber , 5 -- lineitemnumber i'm not sure if the ORDER BY clause is valid like this in oracle, so if there are any problems with the syntax, let me know rudy http://simply-sql.com/ From cmason at managersforum.com Fri Sep 18 11:30:29 2009 From: cmason at managersforum.com (Christie Mason) Date: Fri, 18 Sep 2009 11:30:29 -0500 Subject: [thelist] combining two similar sql queries into one In-Reply-To: References: Message-ID: <013301ca387d$577763b0$06662b10$@com> I'd suggest looking into derived tables. I haven't done them with Oracle but a quick Google indicated they're available in Oracle. Basic idea w/b one derived table for parts and one for services then outer link each to the other master tables as needed. Christie Mason From eccentric.one at gmail.com Fri Sep 18 22:34:05 2009 From: eccentric.one at gmail.com (Jeremy Weiss) Date: Fri, 18 Sep 2009 22:34:05 -0500 Subject: [thelist] combining two similar sql queries into one In-Reply-To: <64A753AE748D44FC84A4B07CD69AE4BB@curly> References: <64A753AE748D44FC84A4B07CD69AE4BB@curly> Message-ID: <4ab4512f.1a015a0a.7d28.3a48@mx.google.com> > care must be taken to align the SELECT clause columns properly, and this > requires the use of some NULL placeholders The Null placeholders was what I was missing. Thanks Rudy. -jeremy From ann at zumwinkle.com Sat Sep 19 12:33:03 2009 From: ann at zumwinkle.com (Ann Zumwinkle) Date: Sat, 19 Sep 2009 10:33:03 -0700 Subject: [thelist] Community organizing sites? In-Reply-To: References: Message-ID: <4AB515CF.5070202@zumwinkle.com> > On Thu, Sep 17, 2009 at 3:35 PM, Bill Moseley wrote: > > I was asked about sites to facilitate the management of volunteers for > > events during the year. ?Which would simply be a way to enter events on a > > calendar, specify times and the number of people needed. ?This specific > > request was for managing volunteers for a year at a school. ?i.e. On the > > 22nd we need four volunteers for a field trip. > > > > The idea is a central place people can go and find events that fit their > > schedule and sign up. ?In addition a way to review your upcoming > > commitments, and what would be great is to have the system send out > > reminders by email a few days before the event where each person would > > re-confirm their involvement. Hello Bill, I happen to be on the search for something similar at the moment and came across this page (from April 2009) with a listing of requirements and possible apps: http://www.coyotecommunications.com/tech/volmanage.html I started my search by looking on TechSoup:] http://forums.techsoup.org/cs/forums/p/20569/20569.aspx Right now we're leaning toward Volunteer Spot.... http://www.volunteerspot.com/ -- Ann Zumwinkle ann at zumwinkle.com www.zumwinkle.com From cervantes_vive at yahoo.com Sun Sep 20 19:36:10 2009 From: cervantes_vive at yahoo.com (ivo) Date: Sun, 20 Sep 2009 17:36:10 -0700 (PDT) Subject: [thelist] Querying Vendor-specific CSS extensions Message-ID: <565687.31133.qm@web53105.mail.re2.yahoo.com> Hello listers, Can I use the JavaScript API (in IE or Mozilla) to query for Vendor-specific CSS properties applied to an element? (http://www.w3.org/TR/CSS2/syndata.html#vendor-keywords) I have a stylesheet with vendor extensions and I need to check the elements to which specific ones are applied. Thanks, - Ivo