>- 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 -<
