From: "Tom Smith" <[EMAIL PROTECTED]> Reply-To: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Subject: Re: [ cf-dev ] 404 error Date: Wed, 7 Apr 2004 16:32:35 +0100
> <cfquery name="rsSearch" datasource="sanjay_1"> > SELECT employee_name, company_name, country, region, > position,department, section, random > FROM tblAdmins > WHERE 1 = 1 > <cfif isdefined("form.employee_name") and form.employee_name neq ""> > AND employee_name LIKE '%#form.employee_name#%' > </cfif> > </cfquery>
> <cfoutput query="rsSearch"> > #employee_name# > </cfoutput>
this bit here's going to throw some errors - where's the rest of the query tag, or should this code be in the above query, Also note, I change the case of the tags to lower case as it's easier to read.
> <cfif isdefined("form.company_name") and form.company_name neq ""> > AND company_name = '#form.company_name#' > <cfif isdefined("form.country") and form.country neq ""> > AND country = '#form.country#' > </cfif> > <cfif isdefined("form.region ") and form.region neq ""> > AND region = '#form.region #' > </cfif> > <cfif isdefined("form.section ") and form.section neq ""> > AND section = '#form.section #' > </cfif> > <cfif isdefined("form.position") and form.position neq ""> > AND position = '#form.position#' > </cfif> > <cfif isdefined("form.department ") and form.department neq ""> > AND department = '#form.department #' > </cfif> > </cfquery>
----- Original Message ----- From: "sanjay sidar" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, April 07, 2004 4:20 PM Subject: Re: [ cf-dev ] 404 error
> <cfquery name="rsSearch" datasource="sanjay_1">
> SELECT employee_name, company_name, country, region,
> position,department, section, random
> FROM tblAdmins
> WHERE 1 = 1
> <CFIF isDefined("form.employee_name") and form.employee_name neq "">
> AND employee_name LIKE '%#form.employee_name#%'
> </cfif>
> </cfquery>
> <cfoutput query="rsSearch">
> #employee_name#
> </cfoutput>
>
>
>
> <CFIF isDefined("form.company_name") and form.company_name neq "">
> AND company_name = '#form.company_name#'
> <CFIF isDefined("form.country") and form.country neq "">
> AND country = '#form.country#'
> </CFIF>
> <CFIF isDefined("form.region ") and form.region neq "">
> AND region = '#form.region #'
> </CFIF>
> <CFIF isDefined("form.section ") and form.section neq "">
> AND section = '#form.section #'
> </CFIF>
> <CFIF isDefined("form.position") and form.position neq "">
> AND position = '#form.position#'
> </CFIF>
> <CFIF isDefined("form.department ") and form.department neq "">
> AND department = '#form.department #'
> </CFIF>
> </cfquery>
>
>
> >From: "Tom Smith" <[EMAIL PROTECTED]>
> >Reply-To: <[EMAIL PROTECTED]>
> >To: <[EMAIL PROTECTED]>
> >Subject: Re: [ cf-dev ] 404 error
> >Date: Wed, 7 Apr 2004 16:17:08 +0100
> >
> >post the code here, and we might spot the error...
> >
> >----- Original Message -----
> >From: "Damian Watson" <[EMAIL PROTECTED]>
> >To: <[EMAIL PROTECTED]>
> >Sent: Wednesday, April 07, 2004 4:14 PM
> >Subject: RE: [ cf-dev ] 404 error
> >
> >
> > > Hmmm... I've been through this meticulously with Sanjay (over
Messenger)
> > >
> > > Commented out all code on action page and replaced with "hello", then
> > > the form hit the action page fine. As soon as there is anything that
> > > could error in the page then this happens.
> > >
> > > He seems to be able to get no error messages whatsoever... I don't
know
> > > much on the CF server side of things so am out of ideas. Debugging
> > > settings etc are turned on.
> > >
> > > !?!?!?!
> > >
> > > -----Original Message-----
> > > From: Lovelock, Richard J [mailto:[EMAIL PROTECTED]
> > > Sent: 07 April 2004 16:10
> > > To: '[EMAIL PROTECTED]'
> > > Subject: RE: [ cf-dev ] 404 error
> > >
> > > yes but the spyware only replaces the default IIS messages as far as I
> > > am
> > > aware (!??) so if it is not a mispelled page name or is not a missing
> > > action
> > > page file then the CF Error message should still get shown ? )
> > >
> > > which would suggest that the action page isn't there or is mis-spelled
> > > in
> > > the form page
> > >
> > > _______________________________________________________
> > > Regards,
> > > Richard Lovelock,
> > > Senior Application Analyst.
> > >
> > > Westminster City Council - Web Support
> > > Cap Gemini Ernst & Young
> > > Southbank
> > > 95 Wandsworth Road
> > > London
> > > SW8 2HG
> > > Tel: 0870 906 7482
> > >
> > > _______________________________________________________
> > >
> > >
> > > -----Original Message-----
> > > From: Damian Watson [mailto:[EMAIL PROTECTED]
> > > Sent: 07 April 2004 16:08
> > > To: [EMAIL PROTECTED]
> > > Subject: RE: [ cf-dev ] 404 error
> > >
> > >
> > > Ah, so it b Spyware :)
> > >
> > > -----Original Message-----
> > > From: Damian Watson [mailto:[EMAIL PROTECTED]
> > > Sent: 07 April 2004 16:04
> > > To: [EMAIL PROTECTED]
> > > Subject: RE: [ cf-dev ] 404 error
> > >
> > > That's not the case, I've been through this with Sanjay. This "404"
> > > happens when an error occurs in the action page (or elsewhere in his
> > > wwwroot). We set up a site wide error handler but is that not working
> > > now Sanjay?
> > >
> > > d
> > >
> > > -----Original Message-----
> > > From: Stephen Moretti [mailto:[EMAIL PROTECTED]
> > > Sent: 07 April 2004 16:02
> > > To: [EMAIL PROTECTED]
> > > Subject: Re: [ cf-dev ] 404 error
> > >
> > > sanjay sidar wrote:
> > >
> > > > i think it may be, im not to sure, whenever i press submit, the page
> > > > gets redirected to a searchengine page called www.perfectnav
etc....,
> > > > it may be how do i check if its an internal error, and would you
know
> > > > how to rectify it?
> > >
> > >
> > > Sounds like you've mis-typed the domain name in the action of your
form
> > > to something that doesn't exist and IE is kindly redirecting you to
that
> > > search engine for you. As everyone else has said make sure you have
the
> > > correct file name in the action of your form.
> > >
> > > Also, when you post a new question to the list or the forums please
> > > create a new email rather than replying to an existing thread. Thank
> > > you.
> > >
> > > Stephen
> > >
> > >
> > >
> > > --
> > > 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 by CFMXhosting.co.uk* :: *ActivePDF
> > > provided by activepdf.com*
> > > *Forums provided by fusetalk.com* :: *ProWorkFlow provided by
> > > proworkflow.com*
> > > *Tutorials provided by helmguru.com* :: *Lists hosted by
> > > gradwell.com*
> > >
> > > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > >
> > >
> > > --
> > > 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 by CFMXhosting.co.uk* :: *ActivePDF
> > > provided by activepdf.com*
> > > *Forums provided by fusetalk.com* :: *ProWorkFlow provided by
> > > proworkflow.com*
> > > *Tutorials provided by helmguru.com* :: *Lists hosted by
> > > gradwell.com*
> > >
> > > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > >
> > >
> > > --
> > > 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 by CFMXhosting.co.uk* :: *ActivePDF
> > > provided
> > > by activepdf.com*
> > > *Forums provided by fusetalk.com* :: *ProWorkFlow provided by
> > > proworkflow.com*
> > > *Tutorials provided by helmguru.com* :: *Lists hosted by
> > > gradwell.com*
> > >
> > > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > >
> > >
> > > =======================================================
> > >
> > > This message contains information that may be privileged or
> > > confidential and is the property of the Cap Gemini Ernst & Young
> > > Group. It is intended only for the person to whom it is addressed. If
> > > you
> > > are not the intended recipient, you are not authorised to read,
print,
> > > retain, copy, disseminate, distribute, or use this message or any part
> > > thereof. If you receive this message in error, please notify the
sender
> > > immediately and delete all copies of this message.
> > >
> > > =======================================================
> > >
> > >
> > > --
> > > 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 by CFMXhosting.co.uk* :: *ActivePDF
> > > provided by activepdf.com*
> > > *Forums provided by fusetalk.com* :: *ProWorkFlow provided by
> > > proworkflow.com*
> > > *Tutorials provided by helmguru.com* :: *Lists hosted by
> > > gradwell.com*
> > >
> > > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > >
> > >
> > > --
> > > 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 by CFMXhosting.co.uk* :: *ActivePDF
> >provided
> >by activepdf.com*
> > > *Forums provided by fusetalk.com* :: *ProWorkFlow provided by
> >proworkflow.com*
> > > *Tutorials provided by helmguru.com* :: *Lists hosted by
> >gradwell.com*
> > >
> > > To unsubscribe, e-mail: [EMAIL PROTECTED]
> >
> >
> >--
> >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 by CFMXhosting.co.uk* :: *ActivePDF
provided
> >by activepdf.com*
> > *Forums provided by fusetalk.com* :: *ProWorkFlow provided by
> >proworkflow.com*
> > *Tutorials provided by helmguru.com* :: *Lists hosted by
> >gradwell.com*
> >
> >To unsubscribe, e-mail: [EMAIL PROTECTED]
> >
>
> _________________________________________________________________
> Sign-up for a FREE BT Broadband connection today!
> http://www.msn.co.uk/specials/btbroadband
>
>
> --
> 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 by CFMXhosting.co.uk* :: *ActivePDF provided
by activepdf.com*
> *Forums provided by fusetalk.com* :: *ProWorkFlow provided by
proworkflow.com*
> *Tutorials provided by helmguru.com* :: *Lists hosted by
gradwell.com*
>
> To unsubscribe, e-mail: [EMAIL PROTECTED]
--
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 by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com*
*Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com*
*Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com*
To unsubscribe, e-mail: [EMAIL PROTECTED]
_________________________________________________________________
Express yourself with cool emoticons - download MSN Messenger today! http://www.msn.co.uk/messenger
-- 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 by CFMXhosting.co.uk* :: *ActivePDF provided by
activepdf.com*
*Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com*
*Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com*To unsubscribe, e-mail: [EMAIL PROTECTED]
