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