Re: [ cf-dev ] Slect Multiple

2004-09-20 Thread Stephen Moretti (cfmaster)
Russ Michaels (Snake) wrote: Put the selected sizes in a list, and then when you loop over the query to create the selectlist options, check if each value is in the list. E.G cfset selectedItems = Valuelist(GetItemSizes.FKSizeIF) select multiple name=ModifiedSize cfoutput query=GetSizes option

RE: [ cf-dev ] Flash SWF to JPG

2004-09-20 Thread James Buckingham
Hi Tim/Alex, Thanks again. I'll persist with it and see where we get. Alex, I'll get one of my colleagues to drop you an email. Thanks very much!!! JamesB -Original Message- From: Alex Skinner [mailto:[EMAIL PROTECTED] Sent: 17 September 2004 16:50 To: [EMAIL PROTECTED] Subject: RE: [

RE: [ cf-dev ] Slect Multiple

2004-09-20 Thread Andy Allan
Wouldn't this do the trick... select multiple name=ModifiedSize cfoutput query=GetSizes cfif SizeID eq GetItemsizes.FKSizeID option value=#SizeID# selected=selected#Size#/option /cfif option value=#SizeID##Size#/option /cfoutput /select And it's certainly better performance wise to use a

Re: [ cf-dev ] Slect Multiple

2004-09-20 Thread Paul Swingewood
Thanks for that guys. It makes sense and seems to work all ok... Regards - Paul From: Stephen Moretti (cfmaster) [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Slect Multiple Date: Mon, 20 Sep 2004 07:39:41 +0100 Russ Michaels (Snake) wrote: Put the

RE: [ cf-dev ] Slect Multiple

2004-09-20 Thread Andy Allan
Ar$e ... I missed the 'multiple' in the select - it's Monday morning :) Andy Quoting Andy Allan [EMAIL PROTECTED]: Wouldn't this do the trick... select multiple name=ModifiedSize cfoutput query=GetSizes cfif SizeID eq GetItemsizes.FKSizeID option value=#SizeID#

RE: [ cf-dev ] Slect Multiple

2004-09-20 Thread Russ Michaels \(Snake\)
Yes sorry, I used the wrong function. If your searching for 1 listcontains will also pickup 11 110 31 etc. So use listfind to make sure you only find the exact occurance. Russ -Original Message- From: Stephen Moretti (cfmaster) [mailto:[EMAIL PROTECTED] Sent: 20 September 2004

RE: [ cf-dev ] Slect Multiple

2004-09-20 Thread Russ Michaels \(Snake\)
Oh don't start with that IIF performance , you must save 1th of a millisend crap please... It's pathetic. -Original Message- From: Andy Allan [mailto:[EMAIL PROTECTED] Sent: 20 September 2004 09:33 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Slect Multiple Wouldn't this do

RE: [ cf-dev ] Slect Multiple

2004-09-20 Thread Andy Allan
No need to be nasty ... the intention wasn't meant to start a debate about IIF. Andy Quoting Russ Michaels (Snake) [EMAIL PROTECTED]: Oh don't start with that IIF performance , you must save 1th of a millisend crap please... It's pathetic. -Original Message- From: Andy

RE: [ cf-dev ] Slect Multiple

2004-09-20 Thread Russ Michaels \(Snake\)
Sorry but I just get sick of people quoting that in some attempt to be smart when they obviously haven't tested it. -Original Message- From: Andy Allan [mailto:[EMAIL PROTECTED] Sent: 20 September 2004 11:20 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Slect Multiple No need to

[ cf-dev ] OT: XP SP2 and ASP/ADO SQL Server Database Connection

2004-09-20 Thread Paul Johnston
Anyone care to tell me how to get an ASP ADO connection to SQL Server with XP Service Pack 2 installed? I have just spent a couple of hours trying to figure out what's wrong... Looked at the ms knowledge base, but it's not helping! I can make SQL server available, just can't use it from ASP! I

RE: [ cf-dev ] Slect Multiple

2004-09-20 Thread Andy Allan
My apologies too ... you're absolutely 100% correct in that a situation like this, using cfif or iif will not make a difference. My intentions certainly weren't to be smart. Maybe I'm being naive in quoting Macromedia themselves, but they do publicly state that IIF requires more processing power

RE: [ cf-dev ] OT: XP SP2 and ASP/ADO SQL Server Database Connect ion

2004-09-20 Thread Robertson-Ravo, Neil (RX)
Here are the bad boys you need. http://www.microsoft.com/sql/techinfo/administration/2000/security/winxpsp2f aq.asp http://support.microsoft.com/default.aspx?scid=kb;en-us;841251product=sql N -Original Message- From: Paul Johnston [mailto:[EMAIL PROTECTED] Sent: 20 September 2004

RE: [ cf-dev ] OT: XP SP2 and ASP/ADO SQL Server Database Connect ion

2004-09-20 Thread Paul Johnston
On Mon, 2004-09-20 at 14:48, Robertson-Ravo, Neil (RX) wrote: Here are the bad boys you need. http://www.microsoft.com/sql/techinfo/administration/2000/security/winxpsp2f aq.asp http://support.microsoft.com/default.aspx?scid=kb;en-us;841251product=sql Thanks Neil... seems as though the

RE: [ cf-dev ] Slect Multiple

2004-09-20 Thread Russ Michaels \(Snake\)
silentmust not start another thread on IIF() /silent Russ -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided

RE: [ cf-dev ] farcry

2004-09-20 Thread ColdFusion MailingLists
Hi Russ, We've been using Farcry for yonks now. And we love it. We've used it on the UKCFUG website (http://www.ukcfug.org/), MX Europe website (just about to go through a redesign - http://www.mxeurope.org/), a Flash website (http://www.franciscocentofanti.com/) (we used Farcry for the content

RE: [ cf-dev ] farcry

2004-09-20 Thread Robertson-Ravo, Neil (RX)
Really? The IIS setup is a piece of pisstrue enough though it misses off some simple stuff such as missing virtual directories and when to create them. N -Original Message- From: Russ Michaels (Snake) [mailto:[EMAIL PROTECTED] Sent: 17 September 2004 16:48 To: [EMAIL PROTECTED]

RE: [ cf-dev ] farcry

2004-09-20 Thread Robertson-Ravo, Neil (RX)
As Niklas stated, any FC help which can be provided...let us know. We too have used it since early public release. -Original Message- From: ColdFusion MailingLists [mailto:[EMAIL PROTECTED] Sent: 20 September 2004 16:56 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] farcry Hi Russ,

RE: [ cf-dev ] OT: XP SP2 and ASP/ADO SQL Server Database Connection

2004-09-20 Thread Colm Brazel
not played with this, but you might find something here http://www.tutorial-web.com/asp/database/asp.asp also check you have .net framework 1.1 installed, assume extenion .asp is in IIS and you can already verify datasource, sorry if above is way off the mark! Colm -Original Message-

RE: [ cf-dev ] farcry

2004-09-20 Thread Aidan Whitehall
1. Going by the documentation, it looks like you can only run a single copy of farcry on your server as you have to install a central Incorrect. You can run multiple Farcry applications on the same server. You do have one Farcry core and fourq directories, but then you have Farcry

RE: [ cf-dev ] farcry

2004-09-20 Thread ColdFusion MailingLists
Erm, so which bit of Russ' assertion is incorrect? You do have a single copy of farcry, the files of which multiple sites use. Russ said but it still looks like you can only have one site as they would all login to same admin and thus the same database. Which is incorrect. You install one

RE: [ cf-dev ] farcry

2004-09-20 Thread Russ Michaels \(Snake\)
Any chance I can have a look at your admin and see what you have done. I think I need something to install some confidence in me cozz I just think it's a pile of poo so far. -Original Message- From: ColdFusion MailingLists [mailto:[EMAIL PROTECTED] Sent: 20 September 2004 16:56

RE: [ cf-dev ] farcry

2004-09-20 Thread Russ Michaels \(Snake\)
When u figure out for yourself what your meant to do yes. But the docs tells you to create mappings when really you should be creating a virtual directory. Again it's trial and error. Also the stupid thing deleted my entire website rather than install files in the folder I specified, and no