try
isdefined(url.Task#i#)
hth
Charlie Hanlon
- Original Message -
From: Richard White [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Thursday, November 02, 2006 12:57 PM
Subject: url variables
hi, i have a page that submits values to a form as follows:
var
try this.
cfoutput#url[Milestone i]#/cfoutput
hth
charlie
- Original Message -
From: Richard White [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Thursday, November 02, 2006 4:01 PM
Subject: Re: url variables
forgive me for my ignorance but i have managed to
cfquery name= datasource=
SELECT s.staffTitle, s.staffFirstName, s.staffLastName
FROM STAFF s, STUDENTS p
WHERE s.staffEmail = p.staffEmail
AND p.studentEmail = cfqueryparam value=[EMAIL PROTECTED]
cfsqltype=cf_sql_varchar
/cfquery
Above is how I would write the query, but I am still
When I place a constant within a cfqueryparam, I am noticing performace
degradation.
SELECTmyField1, myField2, myField3
FROMmyDBtable
WHEREmyRecID = cfqueryparam value=#val(url.id)#
cfsqltype=CF_SQL_INTEGER
ANDmyTypeID = cfqueryparam value=22 cfsqltype=CF_SQL_INTEGER
The
You can use
pr_text = cfqueryparam value=You'll be responsible for implementing, all
of the responsibilities of cfsqltype=CF_SQL_VARCHAR
or
cfsqltype=CF_SQL_CHAR, depending on your data type on the field 'pr_text
hth
Charlie Hanlon
Web Applications Developer
Food Service Enablers, Inc
I took the FastTrack class in Toronto in 1999 or 2000 and it was a perfect
fit for my experience level and acted as a springboard for my current
career. I found it to be a terrific value.
Charles Hanlon
Senior Web Applications Developer
Food Service Enablers, Inc.
www.fsenablers.com
The
cfquery name=qcf_getSchools datasource=yourDSN
SELECT s.SchoolID, s.SchoolName, t.SchoolType
FROM Schools s, SchoolType t
WHERE s.SchoolTypeID = t.SchoolTypeID
ORDER BY t.SchoolType, s.SchoolName
/cfquery
cfoutput query=qcf_getSchools group=SchoolType
#qcf_getSchools.SchoolType#
cfoutput
Steve,
Not sure what you are asking, but I would set up the tables thus:
tbl_Schools
school_id ( primary key)
school_name
school_typeID
tbl_SchoolTypes
school_typeID (primary key)
school_type
then you join the tables using the school_typeID fieldthis structure
will
I am not sure this is the most efficient way to do this, but I pass the form
values, if any, in the url of the pager, then at the top of the results
page, I convert the url variable to a form variable ( which may be
unneccessary, but I steer clear of unscoped variables)
cfif
This is how I have learned to it. In this case, my iframe is going to set a
value for a form field on the parent window.
parent.myForm.myFormField.value='foo';
hth
Charles Hanlon
Senior Web Applications Developer
Food Service Enablers, Inc.
www.fsenablers.com
The People. The Platform. The
!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN
html
head
titleUntitled/title
/head
body onload=JavaScript:document.myForm.myField.focus();
form name=myForm action= method=post
textarea name=myField/textarea
/form
/body
/html
this works fine in IE and Firefox
hth
Charlie
Just tested my code with cfform instead of form and still functions as
desired.
Charles Hanlon
Senior Web Applications Developer
Food Service Enablers, Inc.
www.fsenablers.com
The People. The Platform. The Products.
Make the Difference
- Original Message -
From: Bryan Stevenson
charlie hanlon
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235859
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http
if anyone can enlighten me as my already busy
monday is disappearing..
charlie
Charlie Hanlon
Web Apps Developer
Food Service Enablers, Inc.
www.fsenablers.com
The People. The Platform. The Products.
Make the Difference
- Original Message -
From: Barney Boisvert [EMAIL PROTECTED
Also,this is only happening when the variables name ends in 'vars'
if I do client.varsMySrch, no problem, but if I name it client.mySrchVars,
the client variable is not getting written to our client storage table.
charlie
- Original Message -
From: Charlie Hanlon [EMAIL PROTECTED
This is usually how I code it
cfmail to=
from=[EMAIL PROTECTED]
subject=
cfmailparam name=from value=Tom Jones [EMAIL PROTECTED]
/cfmail
hth
charlie hanlon
- Original Message -
From: Mingo Hagen [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent
That's how I learned. I'll assume that you're implying that the
cfmailparam is unneccessary. Is this so?
thanks,
charlie hanlon
- Original Message -
From: Mingo Hagen [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Friday, March 10, 2006 9:53 AM
Subject: Re: simple
Thanks Jochem.
- Original Message -
From: Jochem van Dieten [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Friday, March 10, 2006 10:06 AM
Subject: Re: simple cfmail question...
Charlie Hanlon said:
That's how I learned. I'll assume that you're implying
Do you have lines longer then 998 characters?
The contents of the emails gets generated dynamically. I am not sure how I
would know the character count per line.
Charlie Hanlon
- Original Message -
From: Jochem van Dieten [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent
Claude said 'Flexibility? Framework means rules, how can rules add
flexibilty?'
I have often felt that rules (structure,framework) provides the enviroment
for flexiblity
just my 2 cents
charlie hanlon
- Original Message -
From: Claude Schneegans [EMAIL PROTECTED]
To: CF-Talk cf
Excuse me if this is too OT, but I have an end user who recieves HTML emails
from us, and the last few have been truncated with the bottom of the page
displayin [Message clipped].
Can anyone point me in the right direction to solve this.
thanks,
Charlie Hanlon
RobertoI would write the sql statement thus:
SELECT c.clientID, c.regionID, c.clientName, c.clientSSN, c.clientCity
FROM clients_tb c
WHERE c.regionID IN (cfqueryparam value=#valuelist(getRegions.regionID)#
list=yes cfsqltype=CF_SQL_INTEGER)
hth
Charlie Hanlon
- Original Message
Roberto,
Yes, the value you use for the attribute 'cfsqltype' is directly related
to the datatype of the field 'regionID'. I am not the expert regarding the
performance issue, but I would assume you will take a hit if the list of IDs
grows too large.
Charlie Hanlon
- Original
=yes
separator=myDelimeter cfsqltype=_)
You're definately close to solving this.
hth
Charlie Hanlon
- Original Message -
From: Roberto Perez [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Friday, March 03, 2006 4:57 PM
Subject: Re: using WHERE with ValueList
by business_title and the sort
rank would be stored in 'tbl_business_titles'
hth
charlie hanlon
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233770
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription
-36.0 || -35.9 || -35.8 || -35.7 || -35.6 -35.5 -35.4 || -35.3
|| -35.2 || -35.1 || -35.0
The number, negative 35.6, should get rounded up to negative 36.
hth
charlie hanlon
- Original Message -
From: Ian Skinner [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Greetings All,
Anyone out there utilitizing Efflare's ImageCR3 and come accross the
following error:
Access violation at address 77FCB0C8 in module 'ntdll.dll'. Write of address
CC99
and could provide some insight into this.
thanks in advance,
charlie hanlon
cursor
in the keyword search on the left, and was able to tab over to the email
form input. Take a look at the location of your form /form tags and
make sure they are not crossing each other up..not alot of information
here, but hopefully it leads you to a discovery.
Charlie Hanlon
Was someone trying to tamper with my app and if so, what are the implications
of IDArray.
thanks in advance for some insight into this.
charlie hanlon
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231106
Archives: http
I may not have been clear. My global error handler sends the emails to my
address. My sites throw errors, I fix them. In this case, I noticed the
WHERE i.uniqueID = '' IDArray[index] '' within the error message that I
rec'd. I am assuming that the site visitor substituted IDArray[index]
(attributes.publishdate)#
/cfif
cfif isdate(trim(attributes.unpublishdate))
, unpublishdate = #CreateODBCDate(attributes.unpublishdate)#
/cfif
WHERE myPKid = cfqueryparam value=#val(id)# cfsqltype=CF_SQL_INTEGER
/cfquery
charlie hanlon
food service
-sensitive.
here is the example they provide:
a:link {color: #FF} /* unvisited link */
a:visited {color: #00FF00} /* visited link */
a:hover {color: #FF00FF} /* mouse over link */
a:active {color: #FF} /* selected link */
hth
charlie hanlon
- Original Message -
From
Larry,
First, this cfinput is inside of a cfform and not just a form tag,
otherwise, the 'required' attribute will not take affect. Second, you may
need to trim(SESSION.User.INSTITUT) the session variable before dropping
into the 'value' attribute.
hth
Charlie Hanlon
- Original
When using cfif fileexists(variables.myFileName), does the variable need
to be in quotes or surrounded by pounds signs?
thanks in advance,
Charlie Hanlon
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229772
I have had difficulty trusting the isDate() function also. I fell back to
using
cfif isdefined(whatsnew.event_date) and len(trim(whatsnew.event_date))
gt 0
take action
/cfif
Charlie Hanlon
- Original Message -
From: daniel kessler [EMAIL PROTECTED]
To: CF-Talk cf-talk
and will be not
displaying the data, is it better practice/more efficient to use cfloop
query= instead of cfoutput query=???
thanks in advance
charlie hanlon
developer
food service enablers, inc.
~|
Discover CFTicket - The leading ColdFusion
Robertthis should work, though there may be a more optimal way of
writing the select clause
cfquery name=getname datasource=name
select left(employee_fname,1)+employee_lname AS name
from employees
/cfquery
hth
Charlie Hanlon
- Original Message -
From: Orlini, Robert [EMAIL
this syntax on every cf tag that does have its respective closing tag. For
example, the cfparam tag
cfparam name=scope.myVar default= /
thanks in advance
charlie
Charlie Hanlon
Web Apps Developer
Food Service Enablers, Inc.
www.fsenablers.com
The People. The Platform. The Products.
Make
will be able to get the next and
previous ids out of the client.srchRsltsIDs variable.
hth
Charlie Hanlon
Web Apps Developer
Food Service Enablers, Inc.
www.fsenablers.com
The People. The Platform. The Products.
Make the Difference
- Original Message -
From: Les Irvin [EMAIL PROTECTED
Dan,
My assumption is that with the cfinclude template=/ , that the initial
/ signifies a directory mapping set-up in the ColdFusion administrator. If
the 'includes' folder is OK, then that folder is mapped in the adminstrator,
while the 'common' folder is not.
Charlie Hanlon
Web Apps
out from the host if there are any such
mappings
Charlie Hanlon
Web Apps Developer
Food Service Enablers, Inc.
www.fsenablers.com
The People. The Platform. The Products.
Make the Difference
- Original Message -
From: daniel kessler [EMAIL PROTECTED]
To: CF-Talk cf-talk
Sean
If 'recent releases do not define / as a mapping in the admin', then
what do they define the / as??
thanks
Charlie Hanlon
Web Apps Developer
Food Service Enablers, Inc.
www.fsenablers.com
The People. The Platform. The Products.
Make the Difference
- Original Message -
From
Try this code.
cfquery name=GetPromoters datasource=user020
SELECT u.userID,u.firstName,u.lastName,u.emailAddress,u.password
FROM tbl_020publicUsers u
WHERE (SELECT count(*)
FROM tbl_020eventDetails e
WHERE e.userID = u.userID) = 0
/cfquery
Charlie Hanlon
Web Apps Developer
Food
---
AND e.musicGenreID = m.musicgenreid
ORDER BY e.eventDate ASC
/cfquery
Try this. I think you are getting mulitple records because you're original
query did not join the two tables in you're 'From' clause.
rgds,
Charlie Hanlon
- Original Message -
From
the
tables in the 'Where' clause'.
thanks in advance for your clarification/confirmation...
rgds,
Charlie Hanlon
- Original Message -
From: John Paul Ashenfelter [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Wednesday, October 26, 2005 9:59 AM
Subject: Re: Simple SQL
On 10
cfif not logon.recordcount
script type=text/javascript language=JavaScript
alert(In-Valid Login Message);
/script
cfinclude template= display_login_page.cfm
/cfif
hth Elena
Charlie Hanlon
Web Apps Developer
Food Service Enablers, Inc.
www.fsenablers.com
The People
46 matches
Mail list logo
