>- see footer for list info -< If you get no errors but the query doesn't work, that rather implies your just not returning any data in the query.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Shawn Fawcett Sent: 10 October 2005 16:06 To: Coldfusion Development Subject: RE: [CF-Dev] radio button and query problems >- see footer for list info -< no error The only thing that stop those query's working is if the application variables used for DSN/username/password don't exist outside the admin. do u mean in the application.cfm? In the application.cfm I do have <cfset application.DS = "araxi"> <cfset application.dbuser = ""> (no user & no password) <cfset application.DBpass = ""> I don't see anything really different in the admin application.cfm Shawn At 16:45 10/10/2005, you wrote: > >- see footer for list info -< >Do u have an error? >The only thing that stop those query's working is if the application >variables used for DSN/username/password don't exist outside the admin. > > > >-----Original Message----- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of Shawn Fawcett >Sent: 10 October 2005 15:46 >To: Coldfusion Development >Subject: Re: [CF-Dev] radio button and query problems > > >- see footer for list info -< >That's pretty much what's there already. I tried it anyway but still >doesn't work. I think for some reason the queries only work in the 'members area' >but don't really know in which file this would be 'protecting' the rest >of the site. Any ideas? > >At 16:09 10/10/2005, you wrote: > > >- see footer for list info -< > ><cfquery name="getSLang" datasource="#application.DS#" > >username="#application.dbuser#" password="#application.dbpass#"> > >Select Distinct S_Lang > > From Lang_rates > >order by S_Lang > ></cfquery> > > > ><cfquery name="getTLang" datasource="#application.DS#" > >username="#application.dbuser#" password="#application.dbpass#"> > >Select Distinct T_Lang > > From Lang_rates > >ORDER BY T_Lang > ></cfquery> > > > > > >Duncan Cumming > >New Media Developer > >Customer Relations Management / Education Fife Council 700 4105 / > >01592 > >414105 > > > > >>> [EMAIL PROTECTED] 10/10/2005 14:53:57 >>> > > >- see footer for list info -< > >Frankly I think it's a bizzare way to set up radio buttons but it > >does work in the 'secure members area'. I just tried a radio group > >and it works >fine. > >I don't think it's woth trying to figure out what the person wanted > >to >do... > > > >the query is still a problem though: > >Lang_rates is the name of the table (for translations) with the > >following > >fields: ID, S_Lang (Source Language), T_Lang (Target Language), > >euro_cost (price for language combination) > > > >I simply need to query this table to get a list of 1) source > >languages and > >2) target languages > > > >don't think I mentioned but the DB is Access2000 > > > >Shawn > > > > > >At 15:10 10/10/2005, you wrote: > > > >- see footer for list info -< > > ><cfif ("NoEstimate" EQ "YesEstimate")>CHECKED</cfif> - this > > >condition will NEVER be True. Like saying IF 1 = 0. > > > > > >Similarly for: > > ><cfif ("NoOrder" EQ "NoOrder")>CHECKED</cfif> - this condition will > > >ALWAYS be True. Like saying IF 1 = 1. > > > > > >Can you give us more information about exactly how these radio > > >buttons aren't working? Also I'm not sure what the getSLang query > > >has to do with anything here? > > > > > > > > > > > >Duncan Cumming > > >New Media Developer > > >Customer Relations Management / Education Fife Council 700 4105 / > > >01592 414105 > > > > > > >>> [EMAIL PROTECTED] 10/10/2005 14:03:05 >>> > > > >- see footer for list info -< > > > > > > > > > >I'm updating part of the website and I'm moving a version of a > > > >"translation estimate" out of the 'protected 'members area to the > > > >general area. My problem is the "radio" buttons and the queries > > > >aren't working outside of the members area. How can I run simple > > > >queries and get the "radio" buttons to work out of the memebers > > > >area? I'm sure there's some code in the member's area or maybe > > > >even the admin area but since I wasn't the one whou built it I'm > > > >not really >sure what I'm looking for. > > > > > > > >The code that isn't working is: > > > ><input <cfif ("NoEstimate" EQ "YesEstimate")>CHECKED</cfif> >type="radio" > > > >name="Translationtype" value="Estimate" checked> > > > > <b>Order > > > > <input <cfif ("NoOrder" EQ "NoOrder")>CHECKED</cfif> > > > >type="radio" name="Translationtype" value="Order"> > > > > > > > ><cfquery name="getSLang" datasource="#application.DS#" > > > >username="#application.dbuser#" password="#application.dbpass#"> > > > >Select Distinct S_Lang as SLang From Lang_rates </cfquery> > > > > > > > >Thanks for your help, > > > >Shawn > > > > > > > > > > > > > > > > > >ARAXI > > >100 Passage Henri Régnault - 92400 Paris La Défense 6 Tél. : 01 49 > > >03 > > >41 41 - Fax : 01 49 03 41 42 > > >_______________________________________________ > > > > > >For details on ALL mailing lists and for joining or leaving lists, > > >go to http://list.cfdeveloper.co.uk/mailman/listinfo > > > > > >-- > > >CFDeveloper Sponsors:- > > > >- Hosting provided by www.cfmxhosting.co.uk -< > > > >- Forum provided by www.fusetalk.com -< > > > >- DHTML Menus provided by www.APYCOM.com -< > > > >- Lists hosted by www.Gradwell.com -< > > > >- CFdeveloper is run by Russ Michaels, feel free to volunteer > > > >your help -< > > > > > > > > >******************************************************************* > > >** > > >* This email and any files transmitted with it are confidential and > > >intended solely for the use of the individual or entity to whom > > >they are addressed and should not be disclosed to any other party. > > >If you have received this email in error please notify your system > > >manager and the sender of this message. > > > > > >This email message has been swept for the presence of computer > > >viruses but no guarantee is given that this e-mail message and any > > >attachments are free from viruses. > > > > > >Fife Council > > >Tel: +44 (0) 1592 414141 > > >******************************************************************* > > >** > > >* _______________________________________________ > > > > > >For details on ALL mailing lists and for joining or leaving lists, > > >go to http://list.cfdeveloper.co.uk/mailman/listinfo > > > > > >-- > > >CFDeveloper Sponsors:- > > > >- Hosting provided by www.cfmxhosting.co.uk -< > > > >- Forum provided by www.fusetalk.com -< > > > >- DHTML Menus provided by www.APYCOM.com -< > > > >- Lists hosted by www.Gradwell.com -< > > > >- CFdeveloper is run by Russ Michaels, feel free to volunteer > > > >your help -< > > > > > >ARAXI > >100 Passage Henri Régnault - 92400 Paris La Défense 6 Tél. : 01 49 03 > >41 41 - Fax : 01 49 03 41 42 > >_______________________________________________ > > > >For details on ALL mailing lists and for joining or leaving lists, go > >to http://list.cfdeveloper.co.uk/mailman/listinfo > > > >-- > >CFDeveloper Sponsors:- > > >- Hosting provided by www.cfmxhosting.co.uk -< > > >- Forum provided by www.fusetalk.com -< > > >- DHTML Menus provided by www.APYCOM.com -< > > >- Lists hosted by www.Gradwell.com -< > > >- CFdeveloper is run by Russ Michaels, feel free to volunteer your > > >help -< > >_______________________________________________ > > > >For details on ALL mailing lists and for joining or leaving lists, go > >to http://list.cfdeveloper.co.uk/mailman/listinfo > > > >-- > >CFDeveloper Sponsors:- > > >- Hosting provided by www.cfmxhosting.co.uk -< > > >- Forum provided by www.fusetalk.com -< > > >- DHTML Menus provided by www.APYCOM.com -< > > >- Lists hosted by www.Gradwell.com -< > > >- CFdeveloper is run by Russ Michaels, feel free to volunteer your > > >help -< > > >ARAXI >100 Passage Henri Régnault - 92400 Paris La Défense 6 Tél. : 01 49 03 >41 41 >- Fax : 01 49 03 41 42 _______________________________________________ > >For details on ALL mailing lists and for joining or leaving lists, go >to http://list.cfdeveloper.co.uk/mailman/listinfo > >-- >CFDeveloper Sponsors:- > >- Hosting provided by www.cfmxhosting.co.uk -< > >- Forum provided by www.fusetalk.com -< > >- DHTML Menus provided by www.APYCOM.com -< > >- Lists hosted by www.Gradwell.com -< > >- CFdeveloper is run by Russ Michaels, feel free to volunteer your > >help -< > > >_______________________________________________ > >For details on ALL mailing lists and for joining or leaving lists, go >to http://list.cfdeveloper.co.uk/mailman/listinfo > >-- >CFDeveloper Sponsors:- > >- Hosting provided by www.cfmxhosting.co.uk -< > >- Forum provided by www.fusetalk.com -< > >- DHTML Menus provided by www.APYCOM.com -< > >- Lists hosted by www.Gradwell.com -< > >- CFdeveloper is run by Russ Michaels, feel free to volunteer your > >help -< ARAXI 100 Passage Henri Régnault - 92400 Paris La Défense 6 Tél. : 01 49 03 41 41 - Fax : 01 49 03 41 42 _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help >-< _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
